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 definition of probability, Statistical Definition of probabilit...

Statistical Definition of probability: Ques: (a) (i)  Distinguish Statistical Definition of probability from the Classical Definition.                  (ii) State the A

Probability of remaining paint free, In a three-cornered paint ball duel, A...

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

Confidence interval, for this proportion, use the +-2 rule of thumb to dete...

for this proportion, use the +-2 rule of thumb to determine the 95 percent confidence interval. when asked if they are satisfied with their financial situation, .29 said "very sat

Standard deviation and variance, Explanation of standard deviation and vari...

Explanation of standard deviation and variance Describe the importance of standard deviation and variance, what they calculate and why they are required. Importance of char

Initial centroids data set, Find unlabeled data set test.txt and initial ...

Find unlabeled data set test.txt and initial centroids data set centroids.txt in the archive, both files have the following format: [attribute1_value attribute2_value ...

Use of calculators in statistics, In recent years a number of calculators a...

In recent years a number of calculators are available for doing statistical calculations over and above the usual addition, subtraction, multiplication and division. The fx-82 mode

mathematical anxiety, A study was designed to investigate the effects of t...

A study was designed to investigate the effects of two variables - (1) a student's level of mathematical anxiety and (2) teaching method - on a student's achievement in a mathemati

Standard deviation for grouped data, Grouped data  For ...

Grouped data  For grouped data, the formula applied is  σ = Where f = frequency of the variable, μ= population mea

LINEAR PROGRAMMING FOR SOLVNG INEQUALITIES, To use Linear Programming for s...

To use Linear Programming for solving the following inequalities. Following Twin Conditions (as mandated by the Indian Regulatory Authority) Twin Condition I for TV Broadcasters

Utility index , If the economy does well, the investor's wealth is 2 and if...

If the economy does well, the investor's wealth is 2 and if the economy does poorly the investor's wealth is 1. Both outcomes are equally likely. The investor is offered to invest

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