[SOLVED] Data Distributions
Data DistributionsCalculate the daily change in the closing stock prices by taking the difference between the closing and opening price for the day. This is the daily stock change.Run the Descriptive Statistics->Summary Table in Excel Data Analysis on the daily stock change. Share the summary table.Calculate the 1st and 3rd quartiles of the daily stock change. Share these along with the min, median, and max from 3) as your 5-Number Summary.Create a Box & Whiskers Plot using your 5-Number Summary. (For Help, refer to M305M1s LiveBinder).Is your daily stock change distribution right skewed (median < mean), left skewed (mean < median), or symmetric (mean ? median)?Identify normal probability distributions.Would you consider your daily stock change to be normally distributed? Why or Why Not?Part 2B: Solve problems using the Central Limit Theorem and Apply the sampling distribution of the meanConsider investing in your stock and assume that the daily change is normally distributed. See Example and use Excel template found in LiveBinder. Using your mean and standard deviation, determine the probability for the average of 9 daily changes of this stock to have:A decrease of 0.5 point or more (X ? 0.5)?An increase of more than 0.5 point (X > 0.5)?A decrease of 1 point or more (X ? 1)?
