# Question: Using data from the past 25 years an investor wants

Using data from the past 25 years, an investor wants to test whether the average return of Vanguard’s Precious Metals and Mining Fund is greater than 12%. 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 conclusion? Is the return on Vanguard’s Precious Metals and Mining Fund greater than 12%?

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 conclusion? Is the return on Vanguard’s Precious Metals and Mining Fund greater than 12%?

## Relevant Questions

An entrepreneur examines monthly sales (in $1,000s) for 40 convenience stores in Rhode Island. Access the convenience store sales data on the text website (Convenience_Stores).a. State the null and the alternative hypotheses ...A television network is deciding whether or not to give its newest television show a spot during prime viewing time at night. For this to happen, it will have to move one of its most viewed shows to another slot. The network ...Consider the following hypothesis test:H0: µ ≥ 75HA: µ < 75A random sample of 100 observations yields a sample mean of 80. The population standard deviation is 30. Calculate the p-value. What is the conclusion to the ...Consider the following sample data:a. Construct a scatter plot and verify that estimating a simple linear regression model is appropriate in this problem.b. Calculate b1 and b0. What is the sample regression equation?c. ...The following table lists Major League Baseball’s (MLB’s) leading pitchers, their earned run average (ERA), and their salary (in millions of dollars) for 2008. The entire data set, labeled MLB_Pitchers, can be found on ...Post your question