Explore BrainMass
Share

Explore BrainMass

    SPSS: Regression analysis question

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

    Wageweb conducts surveys of salary data and presents summaries on its website. Based on salary data as of October 1, 2002, Wageweb reported the average annual salary for sales vice presidents was $142,111, with an average annual bonus of $15,432. Assume the following data are a sample of the annual salary and bonus for 10 vice presidents.

    Data are in thousands of dollars.

    Using SPSS:

    1. Compute and interpret the coefficient of determination (r2)

    2. Develop a plot of the residuals against the independent variable and briefly interpret the plot

    Please see attached files for description of question and data files.

    This is a compute and interpret the coefficient of determination question and involves developing and interpreting a plot of residuals

    © BrainMass Inc. brainmass.com October 9, 2019, 6:59 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/spss-regression-analysis-question-104078

    Attachments

    Solution Preview

    Hi

    Please find attached response to your question.

    Regards

    The Regression Model is developed by assuming the relationship that Bonus is a function of Salary. The regression equation tested therefore is:

    Bonus = constant + beta * Salary + error

    Using Bonus as dependent variable and Salary as independent variable, regression is run in SPSS. The results are attached in the SPSS Output and also presented below:

    Model Summary(b)

    Model R R Square Adjusted R Square Std. Error of the Estimate
    1 .925(a) .855 .837 2.084
    a Predictors: (Constant), Salary
    b Dependent Variable: Bonus

    ANOVA(b)

    Model Sum of Squares df Mean Square F Sig.
    1 Regression 205.259 1 205.259 47.266 .000(a)
    Residual 34.741 8 4.343
    Total 240.000 9
    a Predictors: (Constant), Salary
    b Dependent Variable: Bonus

    Coefficients(a)

    Model Unstandardized Coefficients Standardized Coefficients t Sig.
    B Std. Error Beta
    1 (Constant) -10.164 3.862 -2.632 .030
    Salary .184 .027 .925 6.875 .000
    a Dependent Variable: Bonus

    The value of Rsq. (Coefficient ...

    Solution Summary

    This posting contains solution to following question on Regression analysis using SPSS.

    $2.19