Question

# PLEASE USE EXCEL FOR SOLUTION AND SHOW FORMULAS WITH ARGUMENTS!! Suppose ACT Reading scores are normally...

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!

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

#### Earn Coins

Coins can be redeemed for fabulous gifts.

##### Need Online Homework Help?

Most questions answered within 1 hours.

##### Active Questions
• A two-component mixture containing 70% of Mineral A and 30% of Mineral B is floated in...
• A researcher wanted to investigate an effect of listening to hip-hop music on reading comprehension. She...
• In the determination of the alkalinity of a wastewater sample, we have the following data Final...
• A hungry 161 kg lion running northward at 82.7 km/hr attacks and holds onto a 39.2...
• Part A For the reaction 2Co3+(aq)+2Cl−(aq)→2Co2+(aq)+Cl2(g). E∘=0.483 V what is the cell potential at 25 ∘C...
• 1249) The solution of some second order linear DEQ is exp(-9x)[9sin(1x)+ 3cos(1x)] which can also be...