Explanation with references to your simulation?Explanation with references to the calculations of the probabilities?Explanation from a common sense perspective?

M M9 Analysis Assignme The Math 122 Midterm Exam is coming up. Suppose the exam scores are normally distributed with a population mean of 76.9% and a standard deviation of 16.7%. Let's first create a simulation to observe the expected results for a class of Math 122 students. In Google Sheets, create 25 random samples of 24 students each. This means you should have 24 entries in each column, and you should be using columns A - Y. If you need a refresher for creating a random sample that is normally distributed, you can review the Technology Corner from Module 2 (Use NORMINV). After creating your random samples, copy all the numbers then use the "Paste Values" option in Google Sheets to lock the numbers in place. Save your file as an .xIsx, then attach it here (File > > Download > > Microsoft Excel). Use the Attach File (paper clip) icon for attaching the file. Edit " Insert Formats B I U Xz X A . A Now find the mean of each sample. This can be done by going to the A26 cell and typing: =AVERAGE(A1:424). You can then drag that formula over to the Y column to see the mean of each sample. What is the highest mean? Use =MAX(A26: Y26) What is the lowest mean? Use=MIN(A26:Y26) Note: While there are no points associated with the attachment or the highest/lowest mean, points will be deducted for not completing this portion or doing it incorrectly. These should be used to help you understand the remainder of the problem. What is the probability of a student getting a score of 90% or better? (Round to four decimal places.) What is the probability of a class of 24 students having a mean of 90% or better? (Round to six decimal places.) Explain, in your own words, why the answers to these two questions are drastically different. Your explanation should include each of the following: . references to your simulation references to your calculations common sense explanation