Access the weekly stock prices for home depot in the data


Question: (Use Excel) Access the weekly stock prices for Home Depot in the data file on the text website (Home Depot). 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?

Request for Solution File

Ask an Expert for Answer!!
Management Theories: Access the weekly stock prices for home depot in the data
Reference No:- TGS02256505

Expected delivery within 24 Hours