Explore BrainMass

Explore BrainMass

    Multiple regression analysis with Excel

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

    Do a multiple regression analysis for the following data in Excel where Selling Price is the dependent variable. Paste the results into a Word document. Below the output, write your hypotheses, decision and conclusion. Then highlight or circle the adjusted R2, the regression equation (or coefficients in Excel), the standard error of estimate and the p-value for the F-test. Thank you.

    selling price size in 1000s sq ft # of bedrooms # of bathrooms
    in $1000s

    48.5 1.1 3 1
    55 1.01 3 2
    68 1.45 3 2
    17.5 0.4 1 1
    19.6 1.28 3 1
    24.5 0.74 3 1
    34.8 0.78 2 1
    32 0.97 3 1
    28 0.84 3 1
    49.9 1.08 2 2
    59.9 0.99 2 1
    61.5 1.01 3 2
    60 1.34 3 2
    65.9 1.22 3 1
    67.9 1.28 3 2
    68.9 1.29 3 2
    69.9 1.52 3 2
    70.5 1.25 3 2
    76 1.66 3 2
    81.8 1.33 3 2
    84.5 1.34 3 2
    83.5 1.4 3 2
    86 1.15 2 2
    86.9 1.58 3 2
    86.9 1.58 3 2
    86.9 1.58 3 2
    87.9 1.71 3 2
    88.1 2.1 3 2
    85.9 1.27 3 2
    89.5 1.34 3 2
    87.4 1.25 3 2
    87.9 1.68 3 2
    88 1.55 3 2
    90 1.55 3 2
    96 1.36 3 2
    99.9 1.51 3 2
    95.5 1.54 3 2
    98.5 1.51 3 2

    © BrainMass Inc. brainmass.com June 3, 2020, 7:58 pm ad1c9bdddf
    https://brainmass.com/statistics/regression-analysis/multiple-regression-analysis-with-excel-118973

    Solution Summary

    The solution provides Multiple regression analysis with Excel

    $2.19

    ADVERTISEMENT