Question: please help me answer this question Q1 (20 points) The stock screeners are automated tools used by investment companies to help clients select a portfolio
please help me answer this question


Q1 (20 points) The stock screeners are automated tools used by investment companies to help clients select a portfolio of stocks to invest in. The table below lists the annualized percentage return on investment (as compared to the Standard & Poor's 500 Index) for 13 randomly selected stock screeners provided by the American Association of Individual Investors (AAII). The data is also provided in excel file SCREEN.xst 9.0 -.1 -1.614.6 16.0 7.7 19.9 9.8 3.2 24.817.610'7 9.1 a. compute the mean and standard deviation of the annualized percentage return on investment b. Find a 90% confidence interval for the average annualized percentage return on investment of all stock screeners provided by AAII. Interpret the result. c. A positive annualized return reflects a stock portfolio that performed better than the S&P 500. On average, do the AAII stock screeners perform better than the S&P 500? Please use results from a to explain. d. Conduct a hypothesis test to support the claim that AAII stock screeners perform better than the S&P 500. Report the P-value. A B 1 RETURN 9 W -0.1 -1.6 14.6 16 7.7 19.9 9.8 10 3.2 11 24.8 12 17.6 13 10.7 14 9.1 15 16 Sheet1 Sheet
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
