(Use Excel) Access the weekly stock prices for Home Depot in the data file on the text...
Question:
(Use Excel) Access the weekly stock prices for Home Depot in the data file on the text website (H om e D ep o t).
Assume that returns are normally distributed with a population standard deviation of $3.
a. State the null and the alternative hypotheses in order to test whether or not the average weekly price differs from $30.
b. Use the function Z.TEST to calculate the p -value.
c. At α = 0.05 can you conclude that the average weekly price does not equal $30?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Business Statistics Communicating With Numbers
ISBN: 9780071317610
1st Edition
Authors: Kelly Jaggia
Question Posted: