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

Calculation for continuous series or grouped data, Calculation for Continuo...

Calculation for Continuous Series or Grouped Data = where, m = mid-point of class   =

Critique 2, prepare a critical analysis of a quantitative study focusing on...

prepare a critical analysis of a quantitative study focusing on protection of human participants data collection data management and analysis problem statement and interpretation o

Draw a cumulative frequency polygon, The following data give the repair cos...

The following data give the repair costs (in RM) for 30 randomly selected cars from a list of cars involved in collisions. a)  By using RM 1 as the lower limit of the first

Standard erro, practical application of standard error

practical application of standard error

Regression, The 4 assumptions of regression: 1.       Variables are norm...

The 4 assumptions of regression: 1.       Variables are normally distributed 2.       Linear relationship between the independent and dependent variables 3.       Homosced

Correlation, prove that coefficient of correlation lies between -1 and+1

prove that coefficient of correlation lies between -1 and+1

Types of averages, The following are the various types of common averages u...

The following are the various types of common averages used in statistical analysis given in the form of a chart. Figure 1

Find relative maxima and minima, Q. Find relative maxima and minima? Wh...

Q. Find relative maxima and minima? When finding relative maxima and minima in the Chapters absolute extrema problem, don't forget to use the first or second derivative test to

Predict higpa using a logistic regression, In this problem, we use the CSDA...

In this problem, we use the CSDATA data set, which is available in 'CSDATA.txt'. We do ne an indicator variable, say HIGPA, to be 1 if the GPA is 3.0 or better and 0 other- wise. S

Carpal tunnel statistics, Cindy, the Assistant Vice President of Engineerin...

Cindy, the Assistant Vice President of Engineering/Administrative Services at Blue Cross Blue Shield Rhode Island (BCBSRI), has seen all of the OSHA statistics: In 2000, 1

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