Consider investing in your classmate's stock and assume that it is normally distributed. If you wanted to be 95% sure of what the daily change would be, what range for a daily change would you expect? Use Normal.xlsx. Use the charts below Calculate 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. Date Open High Low Close Volume Adj Close Daily Changes 11/22/2016 48.25 49.56 48 48.27 3847000 48.27 0.02 11/21/2016 47.75 48.49 47.46 48.14 2355100 48.14 0.389999 11/18/2016 48.43 48.46 47.5 47.57 2306100 47.57 -0.86 11/17/2016 47.68 48.93 47.52 48.57 3418500 48.57 0.89 11/16/2016 46.97 47.85 46.76 47.51 2639100 47.51 0.539997 11/15/2016 47.25 47.46 46.12 46.9 4164800 46.9 -0.349998 11/14/2016 49.43 50.2 47.01 47.16 6778200 47.16 -2.27 11/11/2016 49.3 51 46.57 49.7 15547100 49.7 0.400002 11/10/2016 51.06 52.33 50.76 51.76 4559500 51.76 0.699997 11/9/2016 49.56 50.82 48.94 50.18 2958100 50.18 0.619999 11/8/2016 50.26 51.04 49.95 50.32 2414200 50.32 0.060002 11/7/2016 49.87 51.77 49.64 50.3 3857700 50.3 0.43 11/4/2016 48.28 49.99 48.25 49.09 2536000 49.09 0.810001 11/3/2016 49.75 49.85 48.01 48.24 2972000 48.24 -1.509998 11/2/2016 49.99 51.18 49.57 49.73 2565100 49.73 -0.260002 11/1/2016 50.95 52.67 50.12 50.37 4161900 50.37 -0.580002 10/31/2016 50.23 51.28 50.01 50.78 3686800 50.78 0.549999 10/28/2016 48.21 50.88 48.15 50.12 5553100 50.12 1.91 10/27/2016 48.77 49.04 47.97 48.17 1828600 48.17 -0.600002 10/26/2016 48.38 49.15 48.34 48.56 1427400 48.56 0.18 10/25/2016 48.21 48.89 48.21 48.55 1495900 48.55 0.34 10/24/2016 49.14 49.37 48.51 48.84 1395200 48.84 -0.299999 3. Calculate the mean and standard deviation of the daily stock changes by running the Descriptive Statistics in Excel Data Analysis. Share the summary table. Column1 Mean 0.050454318 Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 0.187873072 0.26 #N/A 0.881202819 0.776518409 1.696674278 -0.71865996 4.18 -2.27 1.91 1.109995 22 4. Consider the mean, median and mode (if it exists). Is your daily stock change distribution right skewed (median < mean), left skewed (mean < median), or symmetric (mean median)? What other considerations would you look at to determine whether or not this distribution is approximately normally distributed? Per my numbers, Tom's daily stock change distribution is left skewed. The mean is less than the median