Question: Please help me to solve this calculation in EXCEL 1. the average stock price for companies making up the S&P 500 was $30, and the

Please help me to solve this calculation in EXCEL

1. the average stock price for companies making up the S&P 500 was $30, and the standard deviation was $8.20 (BusinessWeek, Special Annual Issue, Spring 2018). Assume the stock prices are normally distributed.

a.What is the probability that a company will have a stock price of at least $40?

b.How high does a stock price have to be to put a company in the top 10%?

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!

Random Variables and Probability Distributions 1. The demand for a product of Carolina Industries varies greatly from month to month. Based on the past three years of data, the following shows the...

Suppose that the average stock price for companies making up the S&P 500 is $30. The standard deviation is $8.20. Assume that the stock prices are normally distributed . (a). What is the probability...

18. The average stock price for companies making up the S&P 500 is $30, and the standard deviation is $8.20 (BusinessWeek, Special Annual Issue, Spring 2003). Assume the stock prices are normally...

Statistics 3. The average stock price for companies making up the S&P 500 is $30, and the standard deviation is $8.20. Assume the stock prices are normally distributed. a. What is the probability a...

Exhibit computation: The average stock price for companies making up the S&P 500 was $30, and the standard deviation was 8.20 dollars (BusinessWeek, Special Annual Issue). Assume the stock prices are...

3. The average stock price for companies making up the S&P 500 is $30, and the standard deviation is $8.20. Assume the stock prices are normally distributed a. What is the probability a company will...

Military radar and missile detection systems are designed to warn a country of an enemy attack. A reliability question is whether a detection system will be able to identify an attack and issue a...

The average stock price for companies making up the S&P 500 is $30, and the standard deviation is $8.20 (BusinessWeek, Special Annual Issue, Spring 2003). Assume the stock prices are normally...

A chain of length L and mass m is held vertically so that the bottom link just touches the floor. It is then dropped. (a) Show that the acceleration of the top end of the chain is g. (b) If the chain...

As a staff assistant to Vaughan Beals when he first took over, you have been charged to design a strategy to bring a mystique to the Harley-Davidson name. How would you propose to do this? Be as...

What are the monthly payments on a 1 5 - year $ 1 5 0 , 0 0 0 mortgage, at 6 . 5 % ?

Q. State whether the following statements are true or false : 1. An import is a product made or grown abroad but sold domestically. 2. Low income countries are often called developing countries. 3....

4. Based on a message you have recently received, analyse it in relation to its three components: a. the information component, b. its relational component and c. its hierarchical component.

3. Give an example of a problem or phenomenon in everyday life where information is presented in an emotional way.

6. How can a message directly influence the interpreter?