The following data has been generated using descriptive statistics Excel functio
ID: 3313209 • Letter: T
Question
The following data has been generated using descriptive statistics Excel function on data showing stock returns, how would i go about expanding on this in words for a statistically minded audience?
Mean
0.465416667
Standard Error
0.338384083
Median
0.555
Mode
0.81
Standard Deviation
8.452831688
Sample Variance
71.45036355
Kurtosis
2.721801431
Skewness
0.135911008
Range
76.8
Minimum
-34.55
Maximum
42.25
Sum
290.42
Count
624
Mean
0.465416667
Standard Error
0.338384083
Median
0.555
Mode
0.81
Standard Deviation
8.452831688
Sample Variance
71.45036355
Kurtosis
2.721801431
Skewness
0.135911008
Range
76.8
Minimum
-34.55
Maximum
42.25
Sum
290.42
Count
624
Explanation / Answer
The given data is on stock return.There are 624 observations of which minimum stock return is -34.55 and maximum value os 42.24,i.e,Range=42.25-(-34.55)=76.8
sum of stock returns is 290.42 and average value of stock return is 0.465416667 ,middle most value is 0.555 and the stock return value 0.81 has the highest frequency means no. of observations is highest in 0.81.
the observations are deviated from the mean which is expected value by 8.452831688 from this we can say that observations are closed to the mean.
Here the error in estimating the mean from the sample is 0.338384083.
measure of skewness is 0.135911008 which is positive and approximately 0 so we can say that the distribution is symmetric and also mean,median and mode are approximately 0 and hence equal which also implies the symmetry of the data.
kurtosiis measures the peakedness of the data.here the kurtosis value is 2.721801431 which is positive i.e there is high concentration of values in the neighbourhood of the measure of central tendency.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.