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!

Homework Answers

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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Suppose ACT Reading scores are normally distributed with a mean of 21.5 and a standard deviation...
Suppose ACT Reading scores are normally distributed with a mean of 21.5 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.
Suppose SAT Writing scores are normally distributed with a mean of 497 and a standard deviation...
Suppose SAT Writing scores are normally distributed with a mean of 497 and a standard deviation of 109. A university plans to award scholarships to students whose scores are in the top 8%. What is the minimum score required for the scholarship? Round your answer to the nearest whole number, if necessary.
PLEASE ONLY USE EXCEL AND SHOW FORMULAS W/THE ARGUMENTS. Consider the probability that no more than...
PLEASE ONLY USE EXCEL AND SHOW FORMULAS W/THE ARGUMENTS. Consider the probability that no more than 98 out of 125 DVDs will work correctly. Assume the probability that a given DVD will work correctly is 51% . Specify whether the normal curve can be used as an approximation to the binomial probability by verifying the necessary conditions. PLEASE ONLY USE EXCEL AND SHOW FORMULAS W/THE ARGUMENTS. THANK YOU!
The ACT college readiness assessment is a curriculum- and standards-based educational and career planning tool that...
The ACT college readiness assessment is a curriculum- and standards-based educational and career planning tool that assesses students academic readiness for college. Scores are based on a normal distribution with a mean of 23 and a standard deviation of 4. Little Flower University would like to offer an honors scholarship to students who score in the top 10% of this test. What is the minimum score that qualifies for this scholarship? James, Luke and Alexia score 24, 26 and 30...
Please use excel and show the work. Below is a frequency table for midterm exam scores...
Please use excel and show the work. Below is a frequency table for midterm exam scores Scores Number of students 90 and up 5 80-89 12 70-79 40 60-69 18 50-59 13 40-49 6 30-39 6 A.) Construct a frequency table that displays probabilities of occurrence for each class and cumulative probabilities. B.) What is the probability that a random student picked will have a score of at least 90? Less than 90?   c.) What is the probability that a...
Please use and show all formulas using excel. I cannot understand the answer if I can't...
Please use and show all formulas using excel. I cannot understand the answer if I can't see the formulas for each. Thank you very much. Common stock​ value: Constant growth   Seagate Technology is a global leader in data storage solutions and a​ high-yield dividend payer. From 2015 through 2019​, Seagate paid the following​per-share dividends: Year Dividend per share 2019 ​ $2.52 2018 2.25 2017 1.83 2016 1.19 2015 1.52 Assume that the historical annual growth rate of Seagate dividends is...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for...
PLEASE SOLVE IN EXCEL SHOW ALL WORK! MUST USE FORMULAS!! Thank you!! You are saving for retirement in 40 years. You deposit $20,000 in a bank account today that pays 3.5% interest, compounded semiannually. You leave those funds on deposit until you retire. You also contribute $5,000 a year to a pension plan for 20 years and then you stop making contributions to the fund. You leave your money in the pension fund until you retire. The pension plan grows...
**( Please show steps on excel and formulas used )** In this project, you’ll use the...
**( Please show steps on excel and formulas used )** In this project, you’ll use the web to research alternative wireless services and use spreadsheet software to calculate wireless service costs for a sales force. You would like to equip your sales force of 35, based in St. Louis, Missouri, with mobile phones that have capabilities for voice transmission, text messaging, Internet access, and taking and sending photos. Use the web to select two wireless providers that offer nationwide voice...
I would prefer to use technology over tables if possible- please show me how/what to enter...
I would prefer to use technology over tables if possible- please show me how/what to enter into Excel. Thank you!! 1. A) The combined SAT scores for the students at a local high school are normally distributed with a mean of 1507 and a standard deviation of 296. The local college includes a minimum score of 1773 in its admission requirements. What percentage of students from this school earn scores that fail to satisfy the admission requirement? (Where on the...
Please show formulas in excel Do heavier cars really use more gasoline? Suppose a car is...
Please show formulas in excel Do heavier cars really use more gasoline? Suppose a car is chosen at random. Let x be the weight of the car (in hundreds of pounds), and let y be the miles per gallon (mpg). x 29 46 33 47 23 40 34 52 y 29 22 24 13 29 17 21 14 Complete parts (a) through (e), given Σx = 304, Σy = 169, Σx2 = 12,244, Σy2 = 3837, Σxy = 6045, and...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT
Active Questions
  • A two-component mixture containing 70% of Mineral A and 30% of Mineral B is floated in...
    asked 14 minutes ago
  • A researcher wanted to investigate an effect of listening to hip-hop music on reading comprehension. She...
    asked 15 minutes ago
  • In the determination of the alkalinity of a wastewater sample, we have the following data Final...
    asked 16 minutes ago
  • A hungry 161 kg lion running northward at 82.7 km/hr attacks and holds onto a 39.2...
    asked 26 minutes ago
  • 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...
    asked 40 minutes ago
  • 1249) The solution of some second order linear DEQ is exp(-9x)[9sin(1x)+ 3cos(1x)] which can also be...
    asked 40 minutes ago
  • Create a stadium class. The class header file content (.h file) can go in this question,...
    asked 40 minutes ago
  • Describe research designs used in the area of psychopathology and identify at least two ethical concerns...
    asked 53 minutes ago
  • Dry ice is solid carbon dioxide. Instead of melting, solid carbon dioxide sublimes according to the...
    asked 1 hour ago
  • The patient recovery time from a particular surgical procedure is normally distributed with a mean of...
    asked 1 hour ago
  • In a certain school district, it was observed that 26% of the students in the element...
    asked 1 hour ago
  • Solve 8cos2(x)+2cos(x)−3=08cos2(x)+2cos(x)-3=0 for all solutions 0≤x<2π0≤x<2π and Solve 6sin2(w)−cos(w)−5=06sin2(w)-cos(w)-5=0 for all solutions 0≤w<2π0≤w<2π
    asked 1 hour ago