# 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(Re) = E(RFR) + β *E(Rm – RFR)(1)

Where, E(Re) is the expected rate of return on a specific asset, E(RFR) is expected risk free rate, β is sensitivity of the stock return with respect to the overall market return, E(Rm – 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:

1. 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.
2. 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.
3. Use the adjusted closing prices of the stock and the index and calculate the annual rate of return of each.
4. 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

1. Re = α + β*Rm + ε
1. Where, Re is the realized annual rate of return of your stock, Rm is the realized annual rate of return on the overall capital market, and is ε the error term.
2. 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.
3. Determine if the F value for the correlation coefficient is statistically significant at 5% level
4. 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
5. What is the estimate of RFR?
6. Calculate the value of the error term for each year and construct the histogram of the error terms
7. Using the Explore feature in SPSS, conduct a test for normality of the error terms and exhibit the normality plot
8. Does the result of the test for normality of the error terms affect the validity of your regression model? Please explain
9. 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.
• 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.

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Lets Write For You
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend