1 answer

Examine the following summary output from Excel to answer questions that follow. SUMMARY OUTPUT R Square...

Question:




Examine the following summary output from Excel to answer questions that follow. SUMMARY OUTPUT R Square Adjusted R Square St
Examine the following summary output from Excel to answer questions that follow. SUMMARY OUTPUT R Square Adjusted R Square Standard Emor 0 9397848 0.8831955 0 8520477 34997867 20 ANOVA MS 1389.222401 347 3056 28.35493 0.00007729 83 7275992 12.248507 Reidual Total 15 19 157295 Coeicients Standard tmor tSta 88 53136 04969034 0.0018124 -00161801 11.51700364 76869966 14-06 0.272030159 1.626648 0047719 0.001405434 12895335 00216742 0011211971 1441326 0.0170043 1945621-06 08455571 00311086 a. Write the regression model (equation) that incorporates all the variables b Should one include all the independent variables in the model? In other words is this model a good prediction equation? Justify Suppose that the model with only x1 and x2 has R-squared value of 0.79 Has the addition of the other variables improved euracy of the regression model? Be specific. Why?

Answers

a. The regression model is as follows

y=-0.4969004(X1) + 0.0018124(X2) - 0.0161601(X3) + 0.00000164(X4) + 88.531168

b. The R squared value i.e. the coefficient of Determination is 0.8832 indicating 88.32% of the variation of y-values around the mean are explained by the x-values. The more near to 100 %, the better is the equation.

Thus in this case, the model is a good prediction equation.

c. Here we look for adjusted R-squared value. Notice that 4 independent variables mean 4 predictors. They have adjusted R squared value as 0.852. Now, if we consider only first two variables, then the predictor is 2.

In this case, the adjusted R-squared is 0.79. So there is a reduction in adjusted R-squared with reduction in predictors. Thus, addition of two variables actually increase the accuracy.

Incase had the addition of variables lowered the adjusted R-squared, then we could have said that the original equation is more accurate.

.

Similar Solved Questions

1 answer
The figure below shows an electron entering a parallel plate capacitor. Assuming the magnetic field has...
The figure below shows an electron entering a parallel plate capacitor. Assuming the magnetic field has the appropriate strength, which magnetic field will allow the electron to pass through the capacitor without being deflected? + + + + + + + + Select one: III b. c. d. x x x x x x x x X X X X...
1 answer
10 MR MC MR Demand MR > MC 0 10 20 30 4050 60 70 80 90 100 QUANTITY (Thousands of bats) P- ATC P>...
We were unable to transcribe this image10 MR MC MR Demand MR > MC 0 10 20 30 4050 60 70 80 90 100 QUANTITY (Thousands of bats) P- ATC P>ATC Because this market is a price-searcher market, you can tell that it is in long-run equilibrium by the fact that Furthermore, a price-searcher firm's ...
1 answer
Good to Go Auto Products distributes automobile parts to service stations and repair shops. The adjusted...
Good to Go Auto Products distributes automobile parts to service stations and repair shops. The adjusted trial balance data that follows is from the firm’s worksheet for the year ended December 31, 2019. Accounts Debit Credit Cash $ 98,300 Petty Cash Fund 500 Notes Receivable...
1 answer
An object 2.2 cm high is placed 43 cm from a concave mirror of radius 12...
An object 2.2 cm high is placed 43 cm from a concave mirror of radius 12 cm and radius of curvature 63 cm. Find the location, size, and orientation of the image. An object 2.2 cm high is placed 43 cm from a concave mirror of radius 12 cm and radius of curvature 63 cm. Find the location, size, and or...
1 answer
Describe three similarities and three differences between verbal and nonverbal communication You will need 250 words...
Describe three similarities and three differences between verbal and nonverbal communication You will need 250 words count in order to answer this question...
1 answer
If a consumer is spending a small portion of his or her income on a good,...
If a consumer is spending a small portion of his or her income on a good, then the demand for the good is likely to be inelastic. True False A consumer is in equilibrium when the slope of his or her indifference curve is equal to his or her budget constraint. True False T...
1 answer
QUESTION 17 3. Neat Clothes is now preparing quarterly financial statements for the three months ended...
QUESTION 17 3. Neat Clothes is now preparing quarterly financial statements for the three months ended June 30. What is the pay period ends on F adjustin 32 QUESTION 18 16 QUESTION 19 32,400 QUESTION 19 Mama's Pizza Shoppe borrowed $8,000 at 9% interest on May 1, 2018, with year ends June 30, 20...
1 answer
21. Find the derivative of each of the following functions by applying the product rule a....
21. Find the derivative of each of the following functions by applying the product rule a. f(x) = (x2 + 1][2x2 + 3x + 4) b. f(x) = x2 cos x c. f(x) = e* sin x 22. Find Find the derivative of each of the following functions by applying the quotient rule a. f(x) = 22+1 f(x) = (2x + 1] / [x - 3] b. f(x...
1 answer
6. Explain how human capital theory and signaling theory would answer each of the questions below...
6. Explain how human capital theory and signaling theory would answer each of the questions below. You should provide 2 distinct answers for each question. a) What happens to aggregate productivity in a country if more people go to college? (4 points) b) Will employers be willing to pay more for col...
1 answer
: Chapter 15 • Injuries as a Community & Public Health Problem • All answers are...
: Chapter 15 • Injuries as a Community & Public Health Problem • All answers are found in the textbook, do not use any other source 1. Of all injury deaths, 21% were classified as what (e.g., unintentional, homicide, etc.)? 2. Fatal crashes in which the driver is alcohol impaired is hi...
1 answer
Determine whether the sequence converges or diverges. If it converges, find the limit. (If an answer...
Determine whether the sequence converges or diverges. If it converges, find the limit. (If an answer does not exist, enter DNE.) an (2 2n! lim an...
1 answer
Find an equation of the tangent plane and parametric equations of the normal line to the...
Find an equation of the tangent plane and parametric equations of the normal line to the surface ?? − ?? 3 + ?? 2 = 2 at the point ?(−1, −1, 2)....
1 answer
Problem 4. (25 points) Suppose that the line l is represented by r(t) = (12 +...
Problem 4. (25 points) Suppose that the line l is represented by r(t) = (12 + 2t, 16 + 4t, 10 + 2t) and the plane P is represented by 3x + 4y +62 = 41. 1. Find the intersection of the line l and the plane P. Write your answer as a point (a, b, c) where a, b, and care numbers. Answer: 2. Find the cos...
1 answer
Real World Financials CODE EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection,...
Real World Financials CODE EDGAR, the Electronic Data Gathering, Analysis, and Retrieval system, performs automated collection, validation, indexing, and forwarding of submissions by companies and others who are required by law to file forms with the SEC. All publicly traded domestic companies use E...
1 answer
4) A disk-shaped space station 175 m in diameter spins uniformly about an axis perpendicular to...
4) A disk-shaped space station 175 m in diameter spins uniformly about an axis perpendicular to the plane of the disk through its center. How many rpm (rev/min) must this disk make so that the acceleration of all points on its rim is g/2?...
1 answer
Question 1 (1 point) Pensacola Inc. exchanged old equipment for new equipment in two exchange transactions....
Question 1 (1 point) Pensacola Inc. exchanged old equipment for new equipment in two exchange transactions. Each transaction has commercial substance. Old Equipment Cash Book Value Fair Value Received Equipment A $75,000 $80,000 $12,000 Equipment B $60,000 $56,000 $10,000 For Equipment A. Pensacola ...
1 answer
1,2,3 please type it out Part I: Case Study Dave is a 46-year-old attorney with a...
1,2,3 please type it out Part I: Case Study Dave is a 46-year-old attorney with a family history of heart disease (his father had a heart attack at the age of 56) whose recent blood tests reveal high blood LDL cholesterol and triglyceride levels. His doctor has advised him to eat less fat in his di...
1 answer
Describe one thing that you learned in this microbiology course that can now apply to your...
Describe one thing that you learned in this microbiology course that can now apply to your everyday life at work and or at home. Include in your answer the types of microbes involved in this aspect and how this knowledge will be beneficial...