Question

In: Statistics and Probability

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

Suppose that the score in a qualifying exam for a certain profession is normally distributed with mean 80 and standard deviation 36. Use Excel to find the following probabilities:

b) Find the probability that a student gets a score between 50 and 100.

c) To get an A, a student must score in the top 8%. What is the minimum score needed to get an A?

d) Find the probability that the average score in a sample of 60 students 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.

Solutions

Expert Solution

Solution:

    We are given that: the score in a qualifying exam for a certain profession is normally distributed with mean 80 and standard deviation 36.

We have to use Excel functions to find following probabilities:

Part b) Find the probability that a student gets a score between 50 and 100.

That is: P( 50 < X < 100 ) = ........?

Following is the Excel function:

=NORM.DIST( x , mean , SD, Cumulative)

Since we have to find probability between two values, we do subtraction as:

=NORM.DIST( 100 , 80 , 36 , TRUE) - NORM.DIST( 50 , 80 , 36 , TRUE)

= 0.508414

= 0.5084

Thus : P( 50 < X < 100 ) = 0.5084

Part c) To get an A, a student must score in the top 8%. What is the minimum score needed to get an A?

That is find x value,such that:

P( X > x) = 8%

P( X > x) = 0.08

Since this 8% area is in right tail, we need to do 1 - 0.08 in excel command for probability.

=NORM.INV( 1 - 0.08 , 80 , 36 )

=130.58

=131

That is:

P( X > 131 ) = 8%

Part d) Find the probability that the average score in a sample of 60 students is between 50 and 100?

Sample Size = n = 60

Thus we have to find:

For finding probability of sample mean, we use Standard Error instead of Standard deviation.

Thus Standard Error is given by:

Thus we use following excel command:

=NORM.DIST( 100 , 80 , 4.6476 , TRUE) - NORM.DIST( 50 , 80 , 4.6476 , TRUE)

= 1.0000

That is:

Part e) Graph the distributions of the random variable in c) and d) and explain why the answers in b) and d) are different.

graph of part c)

graph of part d)

        There is difference between part b and part d, since in part b) we found probability of individual x value which uses standard deviation = 36 whereas in part d) we found probability for sample mean and we use standard error which is 4.6476

So due to increase in sample size, there is decrease in variation and hence probability of sample mean covering area between 50 and 100 is more than that of individual x value.


Related Solutions

Given the scores on a certain exam are normally distributed with a mean of 75 and...
Given the scores on a certain exam are normally distributed with a mean of 75 and a standard deviation of 5 a. Calculate the z-score for 80. Find the percentage of students with scores above 80 b. Calculate the z-score for 60. Find the percentage of students with scores below 60. c. Calculate the z-scores for 70 and 90. Find the percentage of students with scores between 70 and 90. d. What is the median? e. What test score value...
The score on an test from a certain statistics class, ?, is normally distributed with ?=80.8...
The score on an test from a certain statistics class, ?, is normally distributed with ?=80.8 and ?=8.3. NOTE: Assume for the purpose of this problem that the score is a continuous variable. A score can thus take on any value on the continuum. (In real life, scores are often treated as if they were continuous values but are actually discrete in most cases.) (a) Write the event ''a score over 65.8'' in terms of ?:  . (b) Find the probability...
Suppose the scores of students on an exam are normally distributed with a mean of 340...
Suppose the scores of students on an exam are normally distributed with a mean of 340 and a standard deviation of 57. Then according to the Empirical Rule approximately 99.7 of the exam scores lie between the integers    and    .
The Math 122 Midterm Exam is coming up. Suppose the exam scores are normally distributed with...
The Math 122 Midterm Exam is coming up. Suppose the exam scores are normally distributed with a population mean of 73.8% and a standard deviation of 11.3%. Let's first create a simulation to observe the expected results for a class of Math 122 students. In Excel, create 25 random samples of 23 students each. This means you should have 23 entries in each column, and you should be using columns A - Y. If you need a refresher for creating...
Suppose that the midterm score of a class is normally distributed with the mean of 68.2...
Suppose that the midterm score of a class is normally distributed with the mean of 68.2 points and the standard deviation of 11.3 points. Answer each question. (5 pts) Sketch the curve of the distribution representing the midterm score. Make sure to mark the mean and three standard deviations to either side of the mean. (10 pts) Find the probability that a randomly selected student has score at most 65.9 (10 pts) To be in the top 20% of the...
Suppose scores on a college entrance exam are normally distributed with a mean of 550 and...
Suppose scores on a college entrance exam are normally distributed with a mean of 550 and a standard deviation of 100. Find the score that marks the cut-off for the top 16% of the scores. Round to two decimal places. Question 5 options: 450.55 649.45 462.89 508.34 Question 6 (1 point) Suppose scores on a college entrance exam are normally distributed with a mean of 550 and a standard deviation of 100. Find the cut-off scores that define the middle...
Suppose the test scores for a college entrance exam are normally distributed with a mean of...
Suppose the test scores for a college entrance exam are normally distributed with a mean of 450 and a s. d. of 100. a. What is the probability that a student scores between 350 and 550? b. If the upper 3% scholarship, what score must a student receive to get a scholarship? c. Find the 60th percentile of the test scores. d. Find the middle 30% of the test scores.
Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean...
Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean equals 136 days and standard deviation equals 12 days. What is the probability a random sample of size 19 will have a mean gestation period within 8 days of the​ mean
Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean...
Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean mu equals μ=197 daysand standard deviation sigma equals sσ=14 days. Complete parts​ (a) through​ (f) below. ​(a) What is the probability that a randomly selected pregnancy lasts less than 192 ​days? The probability that a randomly selected pregnancy lasts less than 192 days is approximately 0.3604 ​(Round to four decimal places as​ needed.) Interpret this probability. Select the correct choice below and fill in...
Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean...
Suppose the lengths of the pregnancies of a certain animal are approximately normally distributed with mean mu equals 248 days and standard deviation sigma equals 24 days. Complete parts​ (a) through​ (f) below. ​(a) What is the probability that a randomly selected pregnancy lasts less than 239 ​days? The probability that a randomly selected pregnancy lasts less than 239 days is approximately nothing. ​(Round to four decimal places as​ needed.) Interpret this probability. Select the correct choice below and fill...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT