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 : u = -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 : H = 0 Ha : H # 0