Explore BrainMass

Explore BrainMass

    Run a multiple regression for the attached using Excel

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

    See attached data file.

    Run a multiple regression for Example 11.2 (attached) using StatTools or Excel's regression option. Interpret results.

    Month MachHrs ProdRuns Overhead
    $1.00 $1,539.00 $31.00 $99,798.00
    $2.00 $1,284.00 $29.00 $87,804.00
    $3.00 $1,490.00 $27.00 $93,681.00
    $4.00 $1,355.00 $22.00 $82,262.00
    $5.00 $1,500.00 $35.00 $106,968.00
    $6.00 $1,777.00 $30.00 $107,925.00
    $7.00 $1,716.00 $41.00 $117,287.00
    $8.00 $1,045.00 $29.00 $76,868.00
    $9.00 $1,364.00 $47.00 $106,001.00
    $10.00 $1,516.00 $21.00 $88,738.00
    $11.00 $1,623.00 $37.00 $105,830.00
    $12.00 $1,376.00 $37.00 $88,730.00
    $13.00 $1,327.00 $49.00 $100,624.00
    $14.00 $1,178.00 $50.00 $98,857.00
    $15.00 $1,491.00 $37.00 $102,622.00
    $16.00 $1,667.00 $41.00 $108,059.00
    $17.00 $1,769.00 $34.00 $110,054.00
    $18.00 $1,104.00 $44.00 $91,892.00
    $19.00 $1,196.00 $46.00 $98,693.00
    $20.00 $1,794.00 $29.00 $110,530.00
    $21.00 $1,379.00 $38.00 $96,883.00
    $22.00 $1,448.00 $32.00 $99,593.00
    $23.00 $1,505.00 $32.00 $94,564.00
    $24.00 $1,420.00 $42.00 $105,752.00
    $25.00 $1,475.00 $27.00 $93,224.00
    $26.00 $1,118.00 $34.00 $75,398.00
    $27.00 $1,433.00 $58.00 $113,137.00
    $28.00 $1,589.00 $26.00 $85,609.00
    $29.00 $1,585.00 $32.00 $98,498.00
    $30.00 $1,493.00 $33.00 $101,803.00
    $31.00 $1,124.00 $36.00 $88,371.00
    $32.00 $1,536.00 $28.00 $102,419.00
    $33.00 $1,678.00 $41.00 $117,183.00
    $34.00 $1,723.00 $35.00 $107,828.00
    $35.00 $1,413.00 $30.00 $88,032.00
    $36.00 $1,390.00 $54.00 $117,943.00

    © BrainMass Inc. brainmass.com March 4, 2021, 10:44 pm ad1c9bdddf
    https://brainmass.com/business/strategy-and-business-analysis/run-a-multiple-regression-for-the-attached-using-excel-357805

    Attachments

    Solution Summary

    Regression is run on both variables and the output interpreted in everyday language suitable for a novice.

    $2.19

    ADVERTISEMENT