Eliminate all of the insignificant variables, Applied Statistics

Assignment Help:

The file Midterm Data.xls has a tab labeled "Many vs. S&P" which presents historical price data for several assets, a volatility condition (VIDX = 1 if the NYSE volatility is greater than 0.04), Schlumberger, Westinghouse Air Brake, Ford and Eastman Kodak. Create a multiple regression model of the S&P 500 using the other asset prices as the independent (x) variables.

Answer the following questions based on the Excel output report. Support your answers with numbers from the output report. Use level of significance = 0.05.

• Write the estimated multiple regression equation. Note: Use actual variable names and numbers. If using symbols, define them before using in the equation.

• Clearly explain the meaning of b1 (the coefficient of Schlumberger). Note: Use actual variable names and numbers in answering your question. b1 is the slope is not a sufficient answer.

• Clearly explain the meaning of b2 (the coefficient of Westinghouse Air Brake). Note: Use actual variable names and numbers in answering your question. b2 is the slope is not a sufficient answer.

• Clearly explain the meaning of b3 (the coefficient of Ford). Note: Use actual variable names and numbers in answering your question. b3 is the slope is not a sufficient answer.

• Clearly explain the meaning of b4 (the coefficient of Eastman Kodak). Note: Use actual variable names and numbers in answering your question. b4 is the slope is not a sufficient answer.

• Clearly explain the meaning of b5 (the coefficient of Volatility). Note: Use actual variable names and numbers in answering your question. b5 is the slope is not a sufficient answer.

• Is the regression equation significant? Give reasons for your answer. (Hint: The answer to this question requires test of the hypothesis: Ho: 1 = 2 = 3 = 4 = 5 = 0 vs. Ha: At least one j is not equal to zero, where j = 1...5)

• Which variables in the current equation are significant and which are not significant? Give reason for your answer. (Hint: The answer to this question requires test of hypothesis: Ho: j = 0 vs. Ha: j 0 for j = 1...5).

• Eliminate all of the insignificant variables and show the final regression equation.

• Considering the original regression equation from a), if you already have an S&P 500 fund in your portfolio, what is the best new asset to place in the portfolio? (Remember, you want your portfolio to be as diverse as possible.) Are there any possible practical limitations to using some of these stocks in a portfolio.


Related Discussions:- Eliminate all of the insignificant variables

Calculate the damping ratio for each system, (i) Plot the step responses of...

(i) Plot the step responses of the following second order systems and state the nature of each system. For each case, find the poles and plot the location of the poles in the compl

Cartogram or mapograph, Cartogram or Mapograph:   Statistical maps are a...

Cartogram or Mapograph:   Statistical maps are also used to represent data like density of population indifferent states in the country or different countries in the world or th

Break-even analysis, a. How can break-even analysis be used in selecting a ...

a. How can break-even analysis be used in selecting a new plant site? b. What are potential advantages and disadvantage of locating a production facility in foreign country i

Estimate a linear probability model, Estimate a linear probability model: ...

Estimate a linear probability model: Consider the multiple regression model: y = β 0 +β 1 x 1 +.....+β k x k +u Suppose that assumptions MLR.1-MLR4 hold, but not assump

Simple regression, Simple Regression: The Teacher Preparation Researc...

Simple Regression: The Teacher Preparation Research Team conducted a study of college students who took the Praxis II-a teacher certification examination. Some variables from

Time series, Year Production 2006 8 2007 6 2008 10 2009 12 2010 11 2011 15 ...

Year Production 2006 8 2007 6 2008 10 2009 12 2010 11 2011 15 2012 14 2013 16 Determine the trend from data given above?

Probability function, Among the students doing a given course, there are fo...

Among the students doing a given course, there are four boys enrolled in the ordinary version of the course, six girls enrolled in the ordinary version of the course,and six boys e

Admixture in human populations, Admixture in human populations The inte...

Admixture in human populations The inter-breeding amongst the two or more populations which were previously isolated from each other for the geographical or the cultural reason

Principles of data analysis, For the data analysis project, you will addres...

For the data analysis project, you will address some questions that interest you with the statistical methodology we are learning in class.   You choose the questions; you decide h

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd