Part 3: Frequency Distribution And Statistics Project
Part 3: Frequency Distribution And Statistics Project
- Construct the frequency distribution for the five-year monthly return on the assigned
company (Amazon), plot the histogram and polygon of the frequency distribution. - Calculate the following descriptive statistics:
- arithmetic mean, geometric mean, harmonic mean, median, mode, variance, standard deviation, coefficient of variation, skewness, and kurtosis.
Sheet1
^AMZN Adj Close AMZN_ROR % AMZN_ROR
151.94
146.09 4.00% 0.04
133.09 9.77% 0.10
127.12 4.70% 0.05
138.01 -7.89% -0.08
133.68 3.24% 0.03
130.36 2.55% 0.03
120.58 8.11% 0.08
105.45 14.35% 0.14
103.29 2.09% 0.02
94.23 9.61% 0.10
103.13 -8.63% -0.09
84.00 22.77% 0.23
96.54 -12.99% -0.13
102.44 -5.76% -0.06
113.00 -9.35% -0.09
126.77 -10.86% -0.11
134.95 -6.06% -0.06
106.21 27.06% 0.27
120.21 -11.65% -0.12
124.28 -3.28% -0.03
163.00 -23.75% -0.24
153.56 6.14% 0.06
149.57 2.67% 0.03
166.72 -10.28% -0.10
175.35 -4.93% -0.05
168.62 3.99% 0.04
164.25 2.66% 0.03
173.54 -5.35% -0.05
166.38 4.30% 0.04
172.01 -3.27% -0.03
161.15 6.74% 0.07
173.37 -7.05% -0.07
154.70 12.07% 0.12
154.65 0.04% 0.00
160.31 -3.53% -0.04
162.85 -1.56% -0.02
158.40 2.81% 0.03
151.81 4.34% 0.04
157.44 -3.58% -0.04
172.55 -8.76% -0.09
158.23 9.05% 0.09
137.94 14.71% 0.15
122.12 12.96% 0.13
123.70 -1.28% -0.01
97.49 26.89% 0.27
94.19 3.50% 0.04
100.44 -6.22% -0.06
92.39 8.71% 0.09
90.04 2.61% 0.03
88.83 1.36% 0.01
86.80 2.35% 0.02
88.81 -2.27% -0.02
93.34 -4.85% -0.05
94.68 -1.42% -0.01
88.75 6.68% 0.07
96.33 -7.86% -0.08
89.04 8.19% 0.08
81.99 8.59% 0.09
85.94 -4.59% -0.05
75.10 14.43% 0.14
-
Rating:
/5
Solution: Part 3: Frequency Distribution And Statistics Project