Share
Explore BrainMass

Run a multiple regression for the attached using Excel

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

Attachments

Solution Summary

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

$2.19