1. Go to the tab labeled Torque Height. This tab shows the results of the model...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1. Go to the tab labeled Torque Height. This tab shows the results of the model using Torque and Height to predict AvgMPG that was built in Assignment 3. a. - Copy the Residuals to a new sheet. L Residuals Price Power.hp Displacement. Cylinders Seats Doors - From the Assignment 3 Data tab, copy the numeric variables that were not used (all variables from Price to Wheelbase, excluding Torque and Height). -Construct a correlation table (matrix). Paste a copy into your assignment. N P R S T U V M Residuals Price Power.hp Displacement. Cylinders Seats Doors Length.in Width.in Wheelbase.in 1 -0.07827 1 -0.07237 0.787583 -0.24027 0.486223 0.706689 -0.2644 0.649338 0.779014 0.861046032 -0.05134 0.006184 0.093484 0.290306801 0.243976 0.096772 -0.05572 -0.03639 0.069919158 0.037588 0.686332 -0.0564 0.376743 0.511701 0.642509584 0.580845 0.57837 0.393665 Width.in -0.08456 0.455772 0.545444 0.541495674 0.52482 0.501787 0.271759 0.761262 Wheelbase.in -0.07421 0.35897 0.49955 0.618887868 0.542884 0.485363 0.34096 0.93773 0.714677 1 Length.in 1 1 1 1 1 1 1 b. You should find that Cylinders has the highest correlation with residuals. - Copy Torque, Height, Cylinders and AvgMPG into a new sheet. - Use Regression to fit the model Avg MPG = intercept + coeff1* Torque + coeff2 * Height + coeff3*Cylinders. - Request Residuals and Residual Plot for this model. - Copy the Regression Summary Output into your assignment. Do not copy the Residual Output or the Residual Chart. Regression Statistics Multiple R R Square Adjusted R Standard E Observatic 19 ANOVA Regression Residual Total 0.818061022 0.669223835 0.66823546 2.866093871 Intercept Cylinders df 1008 3 1004 1007 SS 16685.98029 8247.352051 24933.33234 Coefficients Standard Error 46.05266389 0.807016742 -1.132628334 0.085378116 Torque.lbf -0.018146138 0.001093939 Height.in -0.160509205 0.012569662 C. Write out the estimated regression formula. d. In Assignment #3, it was suggested that the strong correlation among Power, Torque, Displacement and Cylinders would give rise to issues of multicollinearity, if more than one was included in the model. Comment on the degree to which the coefficient for Torque has changed after Cylinders was added. Did it shift by much more than would have been expected based upon the standard error of the estimate in Assignment 3? The standard error reflects of how much error there might have been in the estimate. e. Has including Cylinders improved the "performance" of the model predictions? This is not simply an opinion. Back up your conclusion using model performance measures. 1. Go to the tab labeled Torque Height. This tab shows the results of the model using Torque and Height to predict AvgMPG that was built in Assignment 3. a. - Copy the Residuals to a new sheet. L Residuals Price Power.hp Displacement. Cylinders Seats Doors - From the Assignment 3 Data tab, copy the numeric variables that were not used (all variables from Price to Wheelbase, excluding Torque and Height). -Construct a correlation table (matrix). Paste a copy into your assignment. N P R S T U V M Residuals Price Power.hp Displacement. Cylinders Seats Doors Length.in Width.in Wheelbase.in 1 -0.07827 1 -0.07237 0.787583 -0.24027 0.486223 0.706689 -0.2644 0.649338 0.779014 0.861046032 -0.05134 0.006184 0.093484 0.290306801 0.243976 0.096772 -0.05572 -0.03639 0.069919158 0.037588 0.686332 -0.0564 0.376743 0.511701 0.642509584 0.580845 0.57837 0.393665 Width.in -0.08456 0.455772 0.545444 0.541495674 0.52482 0.501787 0.271759 0.761262 Wheelbase.in -0.07421 0.35897 0.49955 0.618887868 0.542884 0.485363 0.34096 0.93773 0.714677 1 Length.in 1 1 1 1 1 1 1 b. You should find that Cylinders has the highest correlation with residuals. - Copy Torque, Height, Cylinders and AvgMPG into a new sheet. - Use Regression to fit the model Avg MPG = intercept + coeff1* Torque + coeff2 * Height + coeff3*Cylinders. - Request Residuals and Residual Plot for this model. - Copy the Regression Summary Output into your assignment. Do not copy the Residual Output or the Residual Chart. Regression Statistics Multiple R R Square Adjusted R Standard E Observatic 19 ANOVA Regression Residual Total 0.818061022 0.669223835 0.66823546 2.866093871 Intercept Cylinders df 1008 3 1004 1007 SS 16685.98029 8247.352051 24933.33234 Coefficients Standard Error 46.05266389 0.807016742 -1.132628334 0.085378116 Torque.lbf -0.018146138 0.001093939 Height.in -0.160509205 0.012569662 C. Write out the estimated regression formula. d. In Assignment #3, it was suggested that the strong correlation among Power, Torque, Displacement and Cylinders would give rise to issues of multicollinearity, if more than one was included in the model. Comment on the degree to which the coefficient for Torque has changed after Cylinders was added. Did it shift by much more than would have been expected based upon the standard error of the estimate in Assignment 3? The standard error reflects of how much error there might have been in the estimate. e. Has including Cylinders improved the "performance" of the model predictions? This is not simply an opinion. Back up your conclusion using model performance measures.
Expert Answer:
Answer rating: 100% (QA)
a To copy the residuals to a new sheet select the residuals column in the Torque Height tab and use CtrlC to copy Then go to a new sheet and use CtrlV to paste the residuals To copy the numeric variab... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Calculate the Return on Invested Capital Cash Receivables Inventory Total current assets Net fixed assets Total assets Sales Cost of goods sold: Materials Labor Heat, light, and power Indirect labor...
-
Provide code and screenshots 1.Create ASP.Net applications. 2. Use Web server controls. 3. Create interactive web forms. 4. Create database-driven web applications. 5. Utilize validator controls. 6....
-
Payroll Assignment - (50 Marks) The following employees are working in the ABC Clinic, they are paid biweekly. Calculate the gross income, net income, and the total remittance that ABC is to report...
-
Andre is puzzled reading Transat A.T. (Air Transat) Inc.'s financial statements. He notices that the numbers have all been rounded to the nearest thousand. He thought financial statements were...
-
In Exercises 9596, find all values of x satisfying the given conditions. f(x) = 1 - 2x, g(x) = 3x 2 + x - 1, and (f g)(x) = -5.
-
Determine whether each of the following is true or false. In each case, assume \(P\) is located at \(t=0\) and \(F\) is located at \(t=n\), and the \(A\) s are spread uniformly over the planning...
-
A tabular analysis of the transactions made during August 2014 by Colaw Company during its first month of operations is shown below. Each increase and decrease in stock- holders equity is explained....
-
Annual sales (in millions of units) of a certain brand of tablet computers are expected to grow in accordance with the function f ( t ) = 0.18 t 2 + 0.16 t + 2.64 (0 t 4) per year, where t is...
-
Consider the following behavior tree: A B X X is either a Sequence or Selector node (you do not know which). A, B, C, and D, are arbitrary subtrees. Let O be an optional behavior, whose introduction...
-
A TK 1 , 0 0 0 - face - value bond has a current market price of TK 9 3 5 , an 8 percent coupon rate, and 1 0 years remaining until maturity. Interest payments are made semiannually. What is the...
-
Are you someone who is affected by the hostile media effect or do you know someone who is? How do you react when you see balanced news reports that include political views that you don't like? Are...
-
How do lambda expressions contribute to the principles of declarative programming and functional purity, enabling the specification of computations through function composition and the application of...
-
In the context of software testing and quality assurance, discuss strategies for designing effective test cases and test suites that exercise different branches and conditions within "if" statements,...
-
The cost - volume - profit analysis ( CVP ) is based on the assumption that there are linear relationships among all cost and revenue variables. This linearity suggests practical and conceptual...
-
Explain how Johnston thinks participation affects corruption.
-
A test car is driven a fixed distance of n miles along a straight highway. (Here n Z+.) The car travels at one mile per hour for the first mile, two miles per hour for the second mile, four miles...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-4. Ivan and Irene paid the following in 2012 (all by check or can otherwise be...
-
Walter, a single taxpayer, purchased a limited partnership interest in a tax shelter in 1985. He also acquired a rental house in 2012, which he actively manages. During 2012, Walter's share of the...
-
Galinha-Esquina SA grows and processes chickens. Each chicken is disassembled into five main parts. Information pertaining to production in July 2022 is as follows: Joint costs of production in July...
-
What is a joint cost?
-
Terms a Split-off point b Joint cost c Separable cost d By-product e Joint product f Product Definitions 1 Product with low sales value compared with the sales value of the main or joint product(s)....
Study smarter with the SolutionInn App