Question

PLEASE USE EXCEL FOR SOLUTION AND SHOW FORMULAS WITH ARGUMENTS!!

Suppose ACT Reading scores are normally distributed with a mean of 21.6 and a standard deviation of 6.3. A university plans to award scholarships to students whose scores are in the top 9%. What is the minimum score required for the scholarship? Round your answer to the nearest tenth, if necessary.

PLEASE USE EXCEL AND SHOW FORMULAS W/ARGUMENTS. THANK YOU!

Answer 1

First, enter the mean value in cell E3 and standard deviation value in cell E4

Calculating z score by using function Normsinv(probability), where probability = 1-0.09 = 0.91................{0.09 is used for top 9%}

this provides, NORMSINV(0.91) = 1.341 (rounded to 3 decimals)

Then use the formula

where z is calculated z score calculated in E6 , mu is the mean entered in E3 and sigma standard deviation entered in E4

x is required minimum score

this implies

x = (1.341*6.3) +21.6

= 8.4483 + 21.6

= 30.0

So, required minimum score is 30.0