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**

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 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 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 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
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 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 followingper-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 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 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 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 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

Get Answers For Free

Most questions answered within 1 hours.

ADVERTISEMENT

asked 14 minutes ago

asked 15 minutes ago

asked 16 minutes ago

asked 26 minutes ago

asked 40 minutes ago

asked 40 minutes ago

asked 40 minutes ago

asked 53 minutes ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago

asked 1 hour ago