Eliminate all of the insignificant variables, Applied Statistics

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.

Posted Date: 3/16/2013 5:39:04 AM | Location : United States







Related Discussions:- Eliminate all of the insignificant variables, Assignment Help, Ask Question on Eliminate all of the insignificant variables, Get Answer, Expert's Help, Eliminate all of the insignificant variables Discussions

Write discussion on Eliminate all of the insignificant variables
Your posts are moderated
Related Questions
Examining the Population Variance Business decision making does not limit itself to setting up the hypothesis to test for the equality of more than two means or proportions sim

Question: (a) Shale Oil, located in the island of Aruba, has a capacity of 600,000 barrels of crude oil per day.  The final products from the refinery include two types of unle

Analysis of Variance for the data: Draw a random sample of size 25 from the following data : (a) With Replacement and   (b) Without Replacement and obtain Mean and Varia

it is said that management is equivalent to decision making? do you agree? explain

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

A) The three images shown below were blurred using square masks of sizes n=23, 25, and 45, respectively. The vertical bars on the le_ lower part of (a) and (c) are blurred, but a c

The amounts of money won by the top ten finishers in a famous car race are listed below. $1,172,246    $163,659    $440,584    $350,634     $290,596 $186,731    $145,809     $143,2

A rightist incumbent (player I) and a leftist challenger (player C) run for senate. Each candidate chooses among two possible political platforms: Left or Right. The rules of the g

what are the challenges affecting population census in developing countries

In a three-cornered paint ball duel, A, B, and C successively take shots at each other until only one of them remains paint free. The three paint ballers have different probabiliti