Applied Statistics in Business and Economics with Connect Access Card with LearnSmart
Applied Statistics in Business and Economics with Connect Access Card with LearnSmart
5th Edition
ISBN: 9781259396656
Author: David Doane, Lori Seward Senior Instructor of Operations Management
Publisher: McGraw-Hill Education
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
Using the regression table I created, how should I perform a T-test for the predictors and assuming the Normality, Homoscedasticity, Independence of observations are satisfied?
In order to test for the significance of a regression model involving 10 independent variables and 100 observations, the numerator and denominator degrees of freedom (respectively) for the critical value of F are?
A researcher interested in explaining the level of foreign reserves for the country of Barbadosestimated the following multiple regression model using yearly data spanning the period 2001 to 2016: ??=?+????+????+????Where FR = yearly foreign reserves ($000’s), OIL = annual oil prices, EXP = yearly total exports ($000’s) and FDI = annual foreign direct investment ($000’s). The sample of data was processed using MINITAB and the following is an extract of the output obtained:Predictor Coef StDev t-ratio p-value Constant 5491.38 2508.81 2.1888 0.0491OIL 85.39 18.46 4.626 0.0006EXP -377.08 112.19 * 0.0057FDI -396.99 160.66 -2.471 ** S = 2.45 R-sq = 96.3% R-sq(adj) = 95.3%Analysis of VarianceSource DF SS MS F pRegression 3 1991.31 663.77 ? ??Error 12 77.4 6.45Total 15a) What is dependent and independent variables? b) Fully write out the regression equation [1] c) Fill in the missing values ‘*’, ‘**’, ‘?’and ‘??’

Chapter 13 Solutions

Applied Statistics in Business and Economics with Connect Access Card with LearnSmart

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 categorical 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 - 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
Recommended textbooks for you
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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