STA1000 Quantitative analysis



STA1000 Quantitative Analysis

Question 1

Largest

Smallest

Mean

4.174667

4.398667

Standard Deviation

2.044974

2.348403

Chebyshev's theorem = 1 - 1/k2 = 1 - 1/1.52 = 0.5555

So, the minimum proportion of observations that will lie within 1.5 standard deviations of the mean is at least 55.55%.

The results obtained from the COUNTIF command shows that there are 12 observations that lie outside the x ?1.5s and x ?1.5s range i.e. 12/75*100 = 16% of the data is outside 1.5s. So, this confirms the Chebyshev's theorem results of having at least 55.55% data inside the 1.5s range.

COUNTIF Command

 

Largest

Smallest

Max

6

6

Min

6

5

Yes, the dividend yields are normally distributed because the results in part ...