Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Math 122 Midterm Exam is coming up. Suppose the exam scores are normally distributed with a population mean of 72.1% and a standard deviation

image text in transcribed
The Math 122 Midterm Exam is coming up. Suppose the exam scores are normally distributed with a population mean of 72.1% and a standard deviation of 18.3%. 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 22 students each. This means you should have 22 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): Choose File No file chosen Now find the mean of each sample. This can be done by going to the A24 cell and typing: =AVERAGE(A1:A22). 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(A24:Y24) What is the lowest mean? Use=MIN(A24: Y24) 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 22 students having a mean of 90% or better? (Round to six decimal places.) 33 OCT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra And Trigonometry

Authors: Ron Larson

9th Edition

1285605705, 9781285605708

More Books

Students also viewed these Mathematics questions

Question

2. How do I perform this role?

Answered: 1 week ago