Explore BrainMass
Share

Explore BrainMass

    Regression Analysis - Using PHStat or Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    [1] A research analyst for an oil company wants to develop a model to predict miles per gallon based on highway speed. An experiment is designed in which a test car is driven at speeds ranging from 10 miles per hour to 75 miles per hour. The results are in the data set (SPEED.xls).
    a) Set up a scatter diagram for speed and miles per gallon.
    b) Apply simple regression analysis, and then interpret the meaning of the slope b1 in this problem.
    c) Interpret the meaning of the regression coefficient b0 in this problem.
    d) Determine the coefficient of determination, r2, and interpret its meaning.
    e) How useful do you think this regression model is for predicting mileage?

    © BrainMass Inc. brainmass.com April 4, 2020, 1:26 am ad1c9bdddf
    https://brainmass.com/statistics/correlation-and-regression-analysis/regression-analysis-phstat-excel-613800

    Attachments

    Solution Preview

    [1] A research analyst for an oil company wants to develop a model to predict miles per gallon based on highway speed. An experiment is designed in which a test car is driven at speeds ranging from 10 miles per hour to 75 miles per hour. The results are in the data set (SPEED.xls).
    Answers
    a) Set up a scatter diagram for speed and miles per gallon.

    b) Apply simple regression analysis, and then interpret the meaning of the slope b1 in this problem.
    The estimated regression equation is given by,
    MPG = 12.7464 + 0.0391 * Speed
    Slope, b1 = 0.0391
    For an increase in the speed by 10 miles per hour, the mileage increase by 3.91 miles per gallon.
    Details
    Coefficients Standard Error t Stat P-value
    Intercept 12.7464 2.4988 5.1011 0.0000
    Speed 0.0391 0.0531 0.7356 0.4686

    c) Interpret the meaning of the regression coefficient b0 in this problem.
    b0 = 12.7464
    If the speed of the car is zero, the mileage of the car will be 12.7464 MPG.
    d) Determine the coefficient of determination, r2, and interpret its meaning.
    Coefficient of determination, r2 = 0.0204
    Interpretation: 2.04% of the variation in MPG can be explained by the estimated regression model.
    Details
    Regression Statistics
    Multiple R 0.1428
    R Square 0.0204
    Adjusted R Square -0.0173
    Standard Error 5.6658
    Observations 28

    e) How useful do you think this regression model is for predicting mileage?
    The significance of the regression model is tested using F-test.
    F-statistic = 0.5411
    P-value = 0.4686
    Clearly the F-statistic is insignificant at a significance level 0.05, as the p-value is greater than 0.05.
    Hence we can conclude that the regression model is not significant in predicting MPG.
    Details
    ANOVA
    df SS MS F Significance F
    Regression 1 17.3697 17.3697 0.5411 0.4686
    Residual 26 834.6289 32.1011
    Total 27 851.9986

    The model adequacy is measured using the R2 value. Here R2 = 0.0204. Thus only 2.04% variability in MPG can be explained by the regression model.
    Hence the regression model is not appropriate for predicting mileage.

    [2] Refer to the data set given in [1].
    a) We want to assume a quadratic relationship between speed and mileage. Is there any indication in your work in [1] where this assumption might work as the next model to the approach in [1]? Explain.
    From the scatter plot it is clear that the assumption of linearity is not valid and hence a linear model is not appropriate.
    b) At the 0.05 level of significance, determine whether the quadratic model is a better fit than the linear regression model.
    The significance of the regression model is tested using F-test.
    F-statistic = 141.4596
    P-value = 0.0000
    Clearly the F-statistic is significant at the significance level 0.05, as the p-value is less than 0.05.
    Hence we can conclude that the quadratic model is a better fit than the linear regression model.
    Details
    ANOVA
    df SS MS F Significance ...

    Solution Summary

    The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included.

    $2.19

    ADVERTISEMENT