Part 2B:Solve Problems Using the Central Limit Theorem andApply the Sampling Distribution of the Mean:

Consider investing in your stock and assume that the daily change is normally distributed. Usingyour mean and standard deviation, determine the probability for the average of 9 daily changes of this stock to have:

Mean= -0.43

Standard Deviation = 2.19

1. A decrease of 0.5 point or more (X -0.5)?
2. An increase of more than 0.5 point (X > 0.5)? 0.90
3. A decrease of 1 point or more (X -1)?
4. An increase of more than 1 point (X > 1)?
5. In your own words, explain if these are high or low likelihoods for change.

The below Excel template is supposed to be used for this problem. I need help in how to input the information into the Excel template.

Mean -0.43 standard deviation 2.19 sample size standard error 0.73000 Probability value is less than a given x X -0.5 z score 0.09589 P(average of sample is x) 0.27792 Probability value is outside a range of values for x Upper x lower x P(average of sample is > upper x) or P(average of sample is