# Please Answer the following question with SPSS in APA 7 Format

**Question 1**

Capital asset pricing model (CAPM) is a widely accepted, though controversial, theory of asset pricing in the capital market. According to CAPM, the expected return of any asset in the capital market is a linear function of the expected return on the whole market and the expected return of the risk free rate. Mathematically the model is stated as per Equation 1

*E(R _{e}) = E(RFR) + β *E(R_{m} – RFR*

*)*(1)

Where,* E(R_{e}) *is the expected rate of return on a specific asset,

**is expected risk free rate,**

*E(RFR)**β*is sensitivity of the stock return with respect to the overall market return,

*E(R*_{m}– RFR*)*is the expected capital market risk premium.

Empirical verification of CAPM is done through running a regression model of historical returns of stocks against historical returns of the overall market.

In this part of your assignment you will be doing the following:

- Select the stock of a publicly traded company with at least 20 years of price history and download the stock’s last 20 years price history from yahoo finance or other sources.
- Select a broad stock market index, such as S&P 500 Index, Russell 3000 Index, etc. and download its last 20 years of price history.
- Use the adjusted closing prices of the stock and the index and calculate the annual rate of return of each.
- Consider the stock’s annual return as the dependent variable and the index’s annual return as the independent variable and run the following regression model:

undefined

undefined

*R*_{e}= α + β*R_{m}+ ε- Where,
*R*is the realized annual rate of return of your stock,_{e}*R*is the realized annual rate of return on the overall capital market, and is_{m}the error term.*ε* - After estimating the regression coefficients of Equation (2) through the OLS method, conduct a test of hypothesis and determine if the estimates of
and*α*are statistically significant at 5% level and report their*β**t*statistics and*p*values. - Determine if the
*F*value for the correlation coefficient is statistically significant at 5% level - What is your interpretation of the R-square value? Explain to what extent your regression estimates can predict future return of your stock against your index’s movements
- What is the estimate of
*RFR*? - Calculate the value of the error term for each year and construct the histogram of the error terms
- Using the Explore feature in SPSS, conduct a test for normality of the error terms and exhibit the normality plot
- Does the result of the test for normality of the error terms affect the validity of your regression model? Please explain
- Present an APA formatted write-up of your finding in one paragraph.

**Question 2**

To determine the effectiveness of a sleeping drug, 75 people were randomly selected; 25 were randomly assigned to take the drug, 25 were randomly assigned to take the placebo, and the other 25 did not receive any treatment. The time to fall asleep after going to bed were measured for the three groups and is reported in the table below:undefined

New Drug |
Placebo |
N0-Treatment |

12 |
44 |
32 |

17 |
32 |
33 |

34 |
28 |
21 |

11 |
30 |
12 |

5 |
22 |
15 |

42 |
12 |
14 |

18 |
3 |
55 |

27 |
12 |
67 |

2 |
42 |
72 |

37 |
13 |
1 |

50 |
27 |
44 |

32 |
54 |
60 |

12 |
56 |
36 |

27 |
32 |
38 |

21 |
37 |
49 |

10 |
28 |
66 |

4 |
22 |
89 |

33 |
22 |
63 |

63 |
24 |
23 |

22 |
9 |
6 |

41 |
20 |
9 |

19 |
4 |
56 |

28 |
13 |
28 |

29 |
42 |
39 |

8 |
67 |
59 |

You want to conduct a one-way ANOVA to examine if there is a statistically significant difference at 5% level between the average time to fall asleep of the three groups

- State the Null and Alternate hypotheses in the proper conventional format. Define any symbol that you use to state your hypothesis.
- Copy and paste your SPSS output in your Word document.
- Interpret the
*F*and*p*values in your SPSS report. - From the information in the SPSS output calculate the
*F*statistic manually and compare it with the*F*value in the SPSS output. - If appropriate conduct a
*post hoc*test to determine which two groups average time to fall asleep are statistically different. - What is the real-life implication of your step 5 results?
- Report the Levene statistic for the mean and median and interpret them.
- What are the assumptions of one-way ANOVA? Do the assumptions hold for the data used in this exercise?
- Present an APA formatted write-up of your complete results, one paragraph for the ANOVA results, one paragraph for the
*post hoc*results, and one paragraph for validity of the assumptions.

Please be sure to include in-text citations and peer reviewed references in your discussion post.

**Question 3**

Please prepare a professional PowerPoint presentation summarizing your findings for question 1 and question 2 of this assignment. The presentation will consist of your major findings, analysis, and recommendations in a concise presentation of 10 slides (minimum). You should use content from questions 1 and 2 as material for your PowerPoint presentation.