Question

Please provide the solution in excel. Thank you.

Consider investing in your stock and assume that the daily change is normally distributed. Using your mean and standard deviation, determine the probability for the average of 9 daily changes of this stock to have: (how do I do this? It won't let me post the entire history. Here are the first 9 days )

1. A decrease of 0.5 point or more (X ≤ –0.5)?
2. An increase of more than 0.5 point (X > 0.5)?
3. A decrease of 1 point or more (X ≤ –1)?
4. An increase of more than 1 point (X > 1)?

Part 2C: If you wanted to be 95% sure what the daily change would be, what range for a daily change would you expect?

Date	Open	High	Low	Close	Adj Close	Volume	Daily Change
11/22/2019	$    52.96	$    53.19	$    52.75	$    53.03	$       53.03	$   9,113,300.00	$                0.07
11/21/2019	$    53.11	$    53.34	$    52.78	$    52.96	$       52.96	$   7,856,100.00	$              (0.15)
11/20/2019	$    53.10	$    53.40	$    53.01	$    53.22	$       53.22	$ 11,970,300.00	$                0.12
11/19/2019	$    53.15	$    53.31	$    52.87	$    53.08	$       53.08	$ 12,679,500.00	$              (0.07)
11/18/2019	$    52.68	$    53.44	$    52.67	$    53.03	$       53.03	$ 13,782,000.00	$                0.35
11/15/2019	$    52.64	$    52.68	$    52.38	$    52.67	$       52.67	$   8,982,400.00	$                0.03
11/14/2019	$    52.53	$    52.67	$    52.35	$    52.63	$       52.63	$   8,660,300.00	$                0.10
11/13/2019	$    52.18	$    52.45	$    51.96	$    52.41	$       52.41	$ 12,257,900.00	$                0.23
11/12/2019	$    51.91	$    51.91	$    51.58	$    51.71	$       51.71	$ 12,656,900.00	$              (0.20)

Coca Cola Daily Change
Mean	-0.09625
Standard Error	0.063183
Median	-0.025
Mode	-0.22
Standard Deviation	0.357417
Sample Variance	0.127747
Kurtosis	-0.296618
Skewness	-0.310166
Range	1.399998
Minimum	-0.82
Maximum	0.579998
Sum	-3.08001
Count	32
Confidence Level (95.0%)	0.128863

Answer 1