Suppose that the score in a qualifying exam for a certain profession is normally distributed with...

80.2K

Verified Solution

Question

Statistics

Suppose that the score in a qualifying exam for a certainprofession is normally distributed with mean 80 and standarddeviation 36. Use Excel to find the following probabilities:
b) Find the probability that a student gets a score between 50and 100.
c) To get an A, a student must score in the top 8%. What is theminimum score needed to get an A?
d) Find the probability that the average score in a sample of 60students is between 50 and 100?
e) Graph the distributions of the random variable in c) and d)and explain why the answers in b) and d) are different.
Please answer using excel functions.

Answer & Explanation Solved by verified expert

3.7 Ratings (601 Votes)

Solution We are given that the score in a qualifyingexam for a certain profession is normally distributed with mean 80and standard deviation 36We have to use Excel functions to find followingprobabilitiesPart b Find the probability that a studentgets a score between 50 and 100That is P 50 X 100 Following is the Excel functionNORMDIST See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member