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

Statistical errors, Statistical Errors              Statistical data ar...

Statistical Errors              Statistical data are obtained either by measurement or by observation. Hence to think of perfect accuracy is only a delusion or a myth, It is no

Gcnnv, Ask questiovdgngddndgdngngngngn #Minimum 100 words accepted#

Ask questiovdgngddndgdngngngngn #Minimum 100 words accepted#

What is the probability that they all hit the target, QUESTION ONE. (a) ...

QUESTION ONE. (a) The probability that, a bomber hits a target on a bombing mission is 0.70 Three bombers are sent to bomb a particular target. (i) What is the probability

Normal probability plots, The Null Hypothesis - H0:  The random errors will...

The Null Hypothesis - H0:  The random errors will be normally distributed The Alternative Hypothesis - H1:  The random errors are not normally distributed Reject H0: when P-v

Correlation coefficients, What type of correlation coefficient would you us...

What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A. Re

Dominant strategy equilibrium, Consider the following game: (a) If ...

Consider the following game: (a) If (top, left) is a Weakly Dominant Strategy Equilibrium, then what inequalities must hold among (a, ..., h)? (b) If (top, left) is a Na

Solve the normal distribution problem, Assume that the normal distribution ...

Assume that the normal distribution applies and find the critical z value(s). A = 0.04; H1 is mean ≠ 98.6 degrees Fahrenheit. Dteremine the value of Z. Find the value of the

Regression lines, Regression Lines It has already been discussed that t...

Regression Lines It has already been discussed that there are two regression lines and they show mutual relationship between two variable . The regression line Yon X gives   th

Probability distribution of the number of sales, A salesperson visits from ...

A salesperson visits from house to house to sell her knives. The probability that she makes a sale at a random house is .3. Given that she makes a sale, the sale is worth $100 with

Median, The median, as the name suggests, is the middle value of a series a...

The median, as the name suggests, is the middle value of a series arranged in any of the orders of magnitude i.e. ascending or descending order. As distinct from the arithmetic

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