Hypothesis Test Example Use Minitab or Excel to answer the following questions. Make sure to copy all output: 1. Followings Tables shows previous 11 month stock market returns (2 points each). Monthly Monthly SP500 DJIA Date Return Return 12/7/2007 -0.8628 0.7994 1/8/2008 -6.1163 4.6323 2/8/2008 -3.4761 -3.0352 3/8/2008 -0.5960 0.0285 4/8/2008 4.7547 4.5441 5/8/2008 1.0674 -1.4182 6/8/2008 8.5962 -10.1937 7/8/2008 -0.9859 0.2468 8/8/2008 1.2191 1.4548 9/8/2008 -9.2054 6.0024 10/8/2008 16.8269 -4.8410 1) Let consider we know the variance of monthly return for all stock were 25 percent in 2008, perform the following hypothesis for each index: Ho : H =-5 Ha : H # -5 2) Considering the population variance is unknown, perform a hypothesis test if the average stock return is 0 or not for each index: Ho : 1 = 0 Ha : p # 0 3) Perform following hypothesis based on all assumption we had in 2) Ho : H 2-3 Ha : H