(Use Excel) An investor wants to test whether the average return of Vanguard's Precious Metals and Mining...
Question:
(Use Excel) An investor wants to test whether the average return of Vanguard's Precious Metals and Mining Fund is greater than 12% based on data over the past 25 years. Assume returns are normally distributed with a population standard deviation of 30%.
a. State the null and the alternative hypotheses for the test.
b. Open the Metals data from the text website into an Excel spreadsheet. Use the function Z.TEST to calculate the p-value.
c. At α = 0.05 what is the statistical conclusion?
d. Is the return on Vanguard's Precious Metals and Mining Fund greater than 12%? P-56
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: