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

Ask an Expert

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

Write your message here..

Related Questions

Package design ratings, Consider the sample of 60 package design ratings gi... Consider the sample of 60 package design ratings given in the table below.                                    A Sample of Package Design Ratings                 (Composite S

Find the backward induction equilibrium, A rightist incumbent (player I) an... 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

Half of market share, Your company has developed a new product .Your compan... Your company has developed a new product .Your company is a reputed company with 50% market share of same range of products. Your competitors also come with their new products equa

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

Assumptions in regression, Assumptions in Regression To understand the... Assumptions in Regression To understand the properties underlying the regression line, let us go back to the example of model exam and main exam. Now we can find an estimate o

Uses of arthematic mean, give me question on mean is the aimplest average t... give me question on mean is the aimplest average to understand and easy to compute

Perform clustering of the unlabeled data set, Perform clustering of the unl... Perform clustering of the unlabeled data set. You could use provided initial centroids set or generate your own. Also there could be considered next stopping criteria : - maxim

Residual, regression line drawn as Y=C+1075x, when x was 2, and y was 239, ... regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

Inverse cumulative distribution function, The Null Hypothesis - H0: β0 = ... The Null Hypothesis - H0: β0 = 0, H0: β 1 = 0, H0: β 2 = 0, Β i = 0 The Alternative Hypothesis - H1: β0 ≠ 0, H0: β 1 ≠ 0, H0: β 2 ≠ 0, Β i ≠ 0      i =0, 1, 2, 3

Statistics to support learning, Scenario: Many of the years 5 and year 6 l... Scenario: Many of the years 5 and year 6 learners' at Woodlands Park School were excited about being chosen for the cross-country team.  Every day, they were able to run laps of t