APPLIED STAT.IN BUS.+ECONOMICS
APPLIED STAT.IN BUS.+ECONOMICS
6th Edition
ISBN: 9781259957598
Author: DOANE
Publisher: RENT MCG
bartleby

Concept explainers

bartleby

Videos

Question
Book Icon
Chapter 13, Problem 50CE

(a)

To determine

State the conclusion about the overall fit of the model referring F statistic.

State the conclusion about the overall fit of the model referring p-value.

(a)

Expert Solution
Check Mark

Answer to Problem 50CE

The conclusion about the overall fit of the model referring F statistic is at least one of the coefficients is not zero and the overall regression is significant.

The conclusion about the overall fit of the model referring p-value is at least one of the coefficients is not zero and the overall regression is significant.

Explanation of Solution

Calculation:

The given information is that, a regression model for a sample of 43 vehicles is fitted for predicting the City MPG (miles per gallon in city driving) based on the predictors Length (length of car in inches), Width (width of car in inches), and Weight (weight of car in pounds).

From the reported regression results, the value of F statistic is 27.90, the degrees of freedom for regression are 3, degrees of freedom for residual are 39 and the p-value is 8.35E-10 which is approximately 0.0000. The considered level of significance is α=0.05.

The formula for F statistic is,

Fcalc=MSRMSE

In the formula, MSR denotes the mean square regression and MSE denotes the mean square error.

Rejection rules based on F statistic:

  • • If the test statistic value is greater than the critical value, then reject the null hypothesis. The regression is significant.
  • • If the test statistic value is smaller than the critical value, then retain the null hypothesis. The regression is not significant.

Rejection rules based on p-value:

  • • If p-value is less than the level of significance then the null hypothesis is rejected. The predictor is significant.
  • • If p-value is greater than the level of significance then the null hypothesis is not rejected. The predictor is not significant.

Let β1 denote the coefficient for predictor X1 = Length (length of car in inches), let β2 denote the coefficient for predictor X2 = Width (width of car in inches), let β3 denote the coefficient for predictor X3 =Weight (weight of car in pounds).

Null hypothesis:

H0: All the coefficients are equal to zero (β1=β2=β3=0).

Alternative hypothesis:

H1: At least one of the coefficients is not zero.

Critical value:

The considered significance level is α=0.05.

The degrees of freedom for numerator are 3, the degrees of freedom for denominator are 39 from completed F table.

From the Appendix F: Critical values of F.05:

  • • Locate the value 3 in numerator degrees of freedom (df1) row.
  • • Locate the value 39 in denominator degrees of freedom (df2) column. This value is not in the column. Consider the smaller value than 39. The value is 30.
  • • The intersecting value that corresponds to the (3, 30) with level of significance 0.05 is 2.92.

Hence, the critical value for df=(3,39) with 0.05, level of significance is 2.92.

Conclusion referring F statistic:

The value of test statistic is 27.90.

The critical value is 2.92.

The test statistic value is greater than the critical value.

The null hypothesis is rejected.

The decision is that at least one of the coefficients is not zero and the overall regression is significant.

Conclusion referring p-value:

The p-value for overall regression is 0.000.

The level of significance is 0.05.

The p-value is less than the level of significance.

That is, p-value(=0.000)<α(=0.05).

The null hypothesis is rejected.

The decision is that at least one of the coefficients is not zero and the overall regression is significant.

(b)

To determine

Identify whether there is evidence that some predictors were unhelpful.

(b)

Expert Solution
Check Mark

Answer to Problem 50CE

There is evidence that the predictors length and width were unhelpful.

Explanation of Solution

Calculation:

From the reported results, the p-value for predictor length is 0.9725, the p-value for width is 0.7379 and p-value for predictor weight is 0.000. The level of significance considered is α=0.05.

For length:

Let β1 is the parameter for the predictor length.

Null hypothesis:

H0:β1=0

The predictor variable length is not related to City MPG.

Alternative hypothesis:

H1:β10

The predictor variable length is related to City MPG.

Conclusion:

The p-value for predictor length is 0.9725.

The level of significance is 0.05.

The p-value is greater than the level of significance.

That is, p-value(=0.9725)>α(=0.05).

The null hypothesis is not rejected.

The predictor variable length is not related to City MPG.

The predictor length is not significant and is not helpful.

For width:

Let β2 is the parameter for the predictor width.

Null hypothesis:

H0:β2=0

The predictor variable width is not related to City MPG.

Alternative hypothesis:

H1:β20

The predictor variable width is related to City MPG.

Conclusion:

The p-value for predictor width is 0.7379.

The level of significance is 0.05.

The p-value is greater than the level of significance.

That is, p-value(=0.7379)>α(=0.05).

The null hypothesis is not rejected.

The predictor variable width is not related to City MPG.

The predictor width is not significant and is not helpful.

For weight:

Let β3 is the parameter for the predictor weight.

Null hypothesis:

H0:β3=0

The predictor variable weight is not related to City MPG.

Alternative hypothesis:

H1:β30

The predictor variable weight is related to City MPG.

Conclusion:

The p-value for predictor weight is 0.000.

The level of significance is 0.05.

The p-value is greater than the level of significance.

That is, p-value(=0.000)<α(=0.05).

The null hypothesis is rejected.

The predictor variable weight is related to City MPG.

The predictor weight is significant and is helpful.

(c)

To determine

Identify whether there is any suspect that the multicollinearity is a problem or not.

(c)

Expert Solution
Check Mark

Answer to Problem 50CE

There is suspect that mild multicollinearity might be a problem in the regression.

Explanation of Solution

Calculation:

The given information is that, the value of VIF for length is 2.669, for width is 2.552 and for weight is 2.836.

Variance inflation factor (VIF):

The general test of multicollinearity is done using the variance inflation factor. The formula for VIF for the predictor Xj is,

VIFj=11Rj2

In the formula, Rj2 is the coefficient of determination when predictor Xj is regressed against all the remaining predictors without including Y.

Detecting multicollinearity using variance inflation factor:

  • • If value of VIF is 1, there is no multicollinearity in the regression.
  • • If value of VIF is 2, there is mild multicollinearity in the regression.
  • • If value of VIF is 10, there is strong multicollinearity in the regression.
  • • If value of VIF is 100, there is severe multicollinearity in the regression.

VIF for length:

The value of VIF for length is 2.669; this value is greater than 2 indicating that there is suspect of mild multicollinearity in the regression.

VIF for width:

The value of VIF for length is 2.552; this value is greater than 2 indicating that there is suspect of mild multicollinearity in the regression.

VIF for weight:

The value of VIF for length is 2.836; this value is greater than 2 indicating that there is suspect of mild multicollinearity in the regression.

Hence, there is suspect that mild multicollinearity might be a problem.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
A regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X₁ = median age, X₂ = number of bankruptcies per 1.000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = high school graduation percentage. Click here for the Excel Data File (a) Using the sample size of 50 people, calculate the calc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 4 decimal places.) Predictor Intercept AgeMed Bankrupt FedSpend HSGrad% Answer is complete but not entirely correct. *calc 5.2526 -2.1764✔✔ 1.4101✔ Coefficient 4,198.5808 -27.3540 17.4893 -0.0124 -29.0314 SE 799.3395 12.5687 12.4033 0.0176 7.1268 -0.7045 -4.0736 p-value 0.0000 0.0348 0.2935 0.4848 0.0002
A regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X₁ = median age, X₂ = number of bankruptcies per 1,000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = high school graduation percentage. Click here for the Excel Data File (a) Using the sample size of 50 people, calculate the tcalc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 4 decimal places.) Predictor Intercept AgeMed Bankrupt FedSpend HSGrad% Coefficient t-value = 4,198.5808 -27.3540 17.4893 -0.0124 -29.0314 SE 799.3395 12.5687 12.4033 0.0176 7.1268 tcalc p-value (b-1) What is the critical value of Student's t in Appendix D for a two-tailed test at a = .01? (Round your answer to 3 decimal places.)
A regression model to predict Y, the state burglary rate per 100,000 people, used the following four state predictors: X1 = median age, X2 = number of bankruptcies per 1,000 population, X3 = federal expenditures per capita (a leading predictor), and X4 = high school graduation percentage. Click here for the Excel Data File (a) Using the sample size of 45 people, calculate the tcalc and p-value in the table given below. (Negative values should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your t-values to 3 decimal places and p- values to 4 decimal places.) Predictor Intercept AgeMed Coefficient SE tcalc p-value 4,641.0430 798.0634 -28.8630 12.4684 Bankrupt 20.1604 12.1079 FedSpend HSGrad% -0.0181 0.0181 -30.3196 7.1136 (b-1) What is the critical value of Student's tin Appendix D for a two-tailed test at a = .01? (Round your answer to 3 decimal places.) -value =

Chapter 13 Solutions

APPLIED STAT.IN BUS.+ECONOMICS

Ch. 13.3 - Prob. 11SECh. 13.3 - A regression model to predict Y, the state...Ch. 13.4 - A regression of accountants starting salaries in a...Ch. 13.4 - An agribusiness performed a regression of wheat...Ch. 13.5 - Prob. 15SECh. 13.5 - A regression model to predict the price of...Ch. 13.5 - Prob. 17SECh. 13.5 - Prob. 18SECh. 13.6 - Prob. 19SECh. 13.6 - Prob. 20SECh. 13.7 - Prob. 21SECh. 13.7 - Using the Metals data, construct a correlation...Ch. 13.8 - Prob. 23SECh. 13.8 - Which violations of regression assumptions, if...Ch. 13 - (a) List two limitations of simple regression. (b)...Ch. 13 - (a) What does represent in the regression model?...Ch. 13 - Prob. 3CRCh. 13 - Prob. 4CRCh. 13 - Prob. 5CRCh. 13 - Prob. 6CRCh. 13 - Prob. 7CRCh. 13 - Prob. 8CRCh. 13 - Prob. 9CRCh. 13 - (a) State the formula for the standard error of...Ch. 13 - (a) What is a binary predictor? (b) Why is a...Ch. 13 - Prob. 12CRCh. 13 - Prob. 13CRCh. 13 - (a) What is multicollinearity? (b) What are its...Ch. 13 - Prob. 15CRCh. 13 - (a) State the formula for a variance inflation...Ch. 13 - Prob. 17CRCh. 13 - Prob. 18CRCh. 13 - Prob. 19CRCh. 13 - Prob. 20CRCh. 13 - (a) Name two ways to detect autocorrelated...Ch. 13 - (a) What is a lurking variable? How might it be...Ch. 13 - Prob. 23CRCh. 13 - Instructions for Data Sets: Choose one of the data...Ch. 13 - Note: Exercises marked are based on optional...Ch. 13 - Prob. 27CECh. 13 - Note: Exercises marked are based on optional...Ch. 13 - Note: Exercises marked are based on optional...Ch. 13 - Prob. 30CECh. 13 - Prob. 31CECh. 13 - Prob. 32CECh. 13 - Prob. 33CECh. 13 - Prob. 34CECh. 13 - Prob. 35CECh. 13 - Note: Exercises marked are based on optional...Ch. 13 - Note: Exercises marked are based on optional...Ch. 13 - Note: Exercises marked are based on optional...Ch. 13 - Prob. 39CECh. 13 - Prob. 40CECh. 13 - Prob. 41CECh. 13 - In a model of Fords quarterly revenue TotalRevenue...Ch. 13 - In a study of paint peel problems, a regression...Ch. 13 - A hospital emergency room analyzed n = 17,664...Ch. 13 - Prob. 45CECh. 13 - A researcher used stepwise regression to create...Ch. 13 - A sports enthusiast created an equation to predict...Ch. 13 - An expert witness in a case of alleged racial...Ch. 13 - Prob. 50CECh. 13 - Prob. 51CECh. 13 - Prob. 52CECh. 13 - Which statement is correct concerning one-factor...Ch. 13 - Prob. 2ERQCh. 13 - Prob. 3ERQCh. 13 - Prob. 4ERQCh. 13 - Prob. 5ERQCh. 13 - Prob. 6ERQCh. 13 - Prob. 7ERQCh. 13 - Prob. 8ERQCh. 13 - Prob. 9ERQCh. 13 - Prob. 10ERQCh. 13 - Prob. 11ERQCh. 13 - Prob. 12ERQCh. 13 - Prob. 13ERQCh. 13 - Prob. 14ERQCh. 13 - Prob. 15ERQ
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY