**PLEASE NOTE** - I\'m using Excel and it is CRUCIAL that I know the excel funct
ID: 3180998 • Letter: #
Question
**PLEASE NOTE** - I'm using Excel and it is CRUCIAL that I know the excel functions to discover the answers. PLEASE SHOW THEM!!!
THANK YOU SO MUCH!!!!
Trading volume on the New York Stock Exchange is heaviest during the first half hour (early morning) and last half hour (late afternoon) of the trading day. The early morning trading volumes (millions of shares) for 16 days in January and February are shown below. The probability distribution of trading volume is approximately normal. Label all answers appropriately.
a. Compute the mean and standard deviation to use as estimates of the population mean and standard deviation.
b. What is the probability that, on a randomly selected day, the early morning trading volume will be less than 180 million shares?
c. What is the probability that, on a randomly selected day, the early morning trading volume will exceed 200 million shares?
d. What is the probability that, on a randomly selected day, the early morning trading volume will be between 180 and 200 million shares?
e. How many shares would have to be traded for the early morning trading volume on a particular day to be among the busiest 5% of days? -- (I'm really struck on this one and the excel function)
Volume 160 165 177 179 180 184 194 200 201 208 209 210 210 212 217 245Explanation / Answer
In the Excel sheet below, please find all the answers. The first row indicated the question number, the second row contains the exact formula used, and the results follow in the third row.
(a) (b) (c ) (d) (e) Volume MeanAVERAGE(A3:A18) SD
STDEV(A3:A18) NORMDIST(180,B3,C3,TRUE) 1-NORMDIST(200,B3,C3,TRUE) E3-D3 NORMINV(1-0.05,B3,C3) 160 196.9375 21.81885652 0.218792 0.444188 0.225395 232.8263 165 177 179 180 184 194 200 201 208 209 210 210 212 217 245
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.