Question: Use the normal distribution to compute a value for a random variable given probability - Excel Question A firm's marketing manager believes that total sales

Use the normal distribution to compute a value for a random variable given probability - Excel

Question

A firm's marketing manager believes that total sales for next year will follow the normal distribution, with a mean of$3.2

million and a standard deviation of$250,000

. Determine the sales level that has only a3%

chance of being exceeded next year.

  • Use Excel, and round your answer to the nearest dollar.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Mathematics Questions!

Q:

pplic X Q nursing and statistics - Sear X ) New tab x | + - Search x C Plus sign definition and me x O convert 5% to...

Q:

Set Student Name: 1. Answer true or false for each part, and if false, explain your answer. a. The point estimate for the population mean, , of an x distribution is x-bar, computed from a random...

Q:

Submission information: Your assignment submission must include both an Excel spreadsheet (electronically submitted) using the template provided and a printed report of your Excel spreadsheet. The...

Q:

CHAPTER 5 QUESTION 1 Data for Hermann Corporation are shown below: Per Unit Percent of Sales Selling price $ 110 100% Variable expenses 77 70% Contribution margin $ 33 30% Fixed expenses are $82,000...

Q:

61697 > Modules > Week 5 Assignment: Applications of the Normal Distribution - Excel Week 5 Assignment: Applications of the Normal Distribution - Excel Due Sunday by 11:59pm Points 10 Submitting an...

Q:

Question A firm s marketing manager believes that total sales for next year will follow the normal distribution with a mean of 3 2 million and a standard deviation of 250 000 Determine the sales...

Q:

Question A firm's marketing manager believes that total sales for next year will follow the normal distribution, with a mean of $3.2 million and a standard deviation of $250,000. Determine the sales...

Q:

1. A player throws a fair die and simultaneously flips a fair coin. If the coin lands heads, then she wins twice, and if tails, then one-half of the value that appears on the die. Determine her...

Q:

Normal distribution - Examples Example 1 The lengths of the sardines received by a certain cannery is normally distributed with mean 4.62 inches and a standard deviation 0.23 inch. What percentage of...

Q:

I am looking for some help on finding the answers for these. Thank you! M2 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign2.xls (where XX is your Group Name), and...

Q:

Suppose you wanted to machine a cast iron with BHN of 275. The process to be used was face milling and a HSS cutter was going to be used. What feed and speed values would you select?

Q:

The vent plate is supported at B by a pin. If it weighs 15 lb and has a center of gravity at G, determine the stiffness k of the spring so that the plate remains in equilibrium at ? = 30?.The spring...

Q:

1 . 5 Outline the arguments leading to the conclusion that all investors should choose the same portfolio of risky investments. What are the key assumptions?

Q:

Which of the following statements accurately describes important aspects of consolidation after the date of acquisition? Select one: a. The elimination entry is made only the first time the...