You will need to upload your written document, your ad concepts and (if applicable) your presentation with recorded audio. Overview of Final Project: You will be compiling what you have learned through this course by creating a new product or service for an existing business or a developing business. This can be real or imaginative. Then develop a corresponding integrated marketing communication (IMC) plan.Your IMC plan should be comprehensive, including:Your idea/product/service/companyA strategic plan summary (3 pages maximum)A timeline for the plan (6-12 months campaign/execution)A proposed local media buy with rationale. A proposed regional/national media buy with rationaleA promotional component – with details of each and rationale (this can include special events/news releases/pitched stories)A print ad – rough mock up is acceptable – grading is on conceptA 30 second radio spot or television spot that you create. If radio ad you must record the audio and include in your presentation. If television ad you must record and create a video to include in the presentation. You should also submit the script for the ad. Grading is based on concept.A general budget for each area completed in an excel document (you may import your table into your word document).Your plan will be graded on comprehensiveness and creativity with your ability to apply the course material. You will submit a written plan and orally present the highlights to the class in VoiceThread. Prepare for a 10 minute presentation (5-10 slides).Total project points = 200 pts:Commercial and Ad concept = 25 ptsBudget = 25 ptsPresentation = 50 pts (points award in the DB post)Paper = 100 pts

Question 1Capital 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 1E(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: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:undefinedundefinedRe = α + β*Rm + ε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.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% levelWhat 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 movementsWhat is the estimate of RFR?Calculate the value of the error term for each year and construct the histogram of the error termsUsing the Explore feature in SPSS, conduct a test for normality of the error terms and exhibit the normality plotDoes the result of the test for normality of the error terms affect the validity of your regression model? Please explainPresent an APA formatted write-up of your finding in one paragraph.Question 2To 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:undefinedNew DrugPlaceboN0-Treatment12443217323334282111301252215421214183552712672427237131502744325460125636273238213749102866422893322636324232296412091945628132829423986759You 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 groupsState 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 3Please 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.