Question: Suppose X ~ N(56, 4). Write the Excel function to find the X values associated with the following percentages: a. Highest 20 percent b. Middle

Suppose X ~ N(56, 4). Write the Excel function to find the X values associated with the following percentages:

a. Highest 20 percent

b. Middle 60 percent

c. Lowest 30 percent

Step by Step Solution

★★★★★

3.37 Rating (147 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a NORMINV8564 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Essential Statistics Business Questions!

Q:

Suppose the volume of liquid soap (X) in a randomly chosen bottle of dish soap is normally distributed with = 600 ml and = 5 ml. Write the Excel function to calculate the following probabilities:...

Q:

Suppose the volume of liquid soap (X) in a randomly chosen bottle of dish soap is normally distributed with = 600 ml and = 5 ml. Write the Excel function to find the volume associated with the...

Q:

(a) Write the Excel function for the 10 percent trimmed mean of a data set in cells A1:A50. (b) How many observations would be trimmed in each tail? (c) How many would be trimmed overall?

Q:

6- 2 HW @ Suppose x ~ N ( 60, 5). Write the exel function to find the X values associated with the following percentages : a highest 13 percent, = NORNG . IN V ( 0 - 81, 60, 5) ( 2) I NORM . INV (81,...

Q:

5. To advertise or not to advertise X Suppose that two firms, Frankencakes and Thinley's, are the only sellers of crepes in some hypothetical market. The following payoff matrix gives the profit (in...

Q:

Excel File Edit View Insert Format Tools Data Window Help Mon Nov 8 6:52 PM ... AutoSave OFF A9FvG... CC6582 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert C...

Q:

W \"SCAM\"; _ CASE #2: Tuscan Lifestyles: Targeting Customers with RFH illtnalysis1 Sara Eleckman is increasingly confident that careful analysis ofthe Tuscan Lifestyles customer database will lead...

Q:

REGIONAL REALTY ASSOCIATION AUTHOR DATE PURPOSE ANALYSIS CORA WILKE 1/23/2016 ANALYSIS OF THE CLAIM BY LUKE LIBERTY REALTY No they should not advertise that they your get your price. On the analysis...

Q:

Algorithms in Artificial Intelligence (or, the old name: Introduction to Algorithmic Decision Making) Part 1 Based on slides by David Sarne and Lirong Xia Course Tentative Schedule Introduction...

Q:

Study Guide Healthcare Statistics By Jacqueline K. Wilson, RHIA About the Author Jacqueline K. Wilson is a Registered Health Information Administrator (RHIA) who has more than ten years of experience...

Q:

(a) Why might a marketing researcher prefer to use secondary data rather than primary data in a study? (b) Why might the reverse be true?

Q:

The economist for the Grand Corporation has estimated the company's cost function, using time series data, to be TC = 50 + 16Q - 2Q2 + 0.2Q3 where TC = Total cost Q = Quantity produced per period a....

Q:

2. A wave has a speed of 1.5 m/s and a frequency of 25 Hz. What is the wavelength of the wave in cm?

Q:

2. What are the requirements of a researcher undertaking in-depth interviews? Why are these requirements particularly important when conducting interviews with managers?

Q:

Of grocery shoppers who have a shopping cart, 70 percent pay by credit/debit card (event C1), 20 percent pay cash (event C2), and 10 percent pay by check (event C3). Of shoppers without a grocery...

Q:

A study showed that 60 percent of The Wall Street Journal subscribers watch CNBC every day. Of these, 70 percent watch it outside the home. Only 20 percent of those who don't watch CNBC every day...

Q:

A drug test for athletes has a 5 percent false positive rate and a 10 percent false negative rate. Of the athletes tested, 4 percent have actually been using the prohibited drug. If an athlete tests...

Q:

Consider the accompanying cash flow diagram, which represents three different interest rates applicable over the five-year time span shown. Calculate the equivalent amount P at the present time....

Q:

by java without comments please Create four classes: Chapter, Book, library and Main with the following specification: Class Chapter: Constructor: It initializes the value of all attributes based on...

Q:

calculate the IRR internal rate of return #1 Loan of 120,000 to be repaid in 2 years according to the French method at an interest rate of 12% nominal per year. This loan has a study fee of 1% and no...