Use StatCrunch or Excel  to execute the following tasks in t…

Use StatCrunch or Excel  to execute the following tasks in the questions which follow.  Answer the questions below by inserting values into the chart, embedding  (not linking) the result into the provided space, or providing a verbal response. Your explanations must demonstrate correct grammatical and mathematical notation. The data chart below can also be accessed as an Excel spreadsheet and uploaded into StatCrunch. Milk Production Data.xlsx Monthly Milk Production 2825       2072       2733       2069       2484    4285       2862       3353       1449       2029       1258       2982       2045       1677       1619       2597       3512       2444       1773       2284       1884       2359       2046       2364       2669       3109       2804       1658       2207       2159      2207    2882       1647       2051       2202       3223       2383       1732       2230       1147       2711       1874       1979       1319       2923       2281       1230       1665       1294       2936   

Refer to the results of #1 as needed. A) Determine the month…

Refer to the results of #1 as needed. A) Determine the monthly milk production values that correspond to z = -3, -2, -1, 0, 1, 2, and 3.  Copy and paste this table into the answer field and then enter your responses. Monthly Milk Production Z-score -3 -2 -1 0 1 2 3   B) Copy and paste the chart provided below into the answer field below. Refer to the your results in part A) to complete the chart. Insert the milk production values that are boundaries for the indicated classes based on the z-scores. Complete the frequency column by referring to the milk production values given at the start of the Case Study. Class Boundaries Class Z-scores Frequency –  to -3 -3 to -2 -2 to -1 -1 to 0 0 to 1 1 to 2 2 to 3 3 to C) Copy and paste the provided chart into the answer field below. Use the results of part B) to determine the percentage of values within 1, 2, and 3 standard deviations of the mean. Interval of Milk Production Interval of z scores Percentage within 1 standard deviation of the mean  – 1 to 1  within 2 standard deviations of the mean -2 to 2  within 3 standard deviation of the mean -3 to 3 D) Based on the results of part C) and the Empirical Rule, do you think the data is approximately normally distributed? Explain your answer.