Question

1 Approved Answer

Posted on Jul 27, 2024

In your memo, discuss these various equations and state which of the equations you would recommend to be used and why. Provide a complete and

In your memo, discuss these various equations and state which of the equations you would recommend to be used and why. Provide a complete and detailed justification for your choice. Also, discuss the meaning of the regression coefficients of the equation that you choose.

image text in transcribed

ACCT 606 Master Buudget Pmject Group Final Excrl Natalic Michel File Home Insert Page Layout Formulas Data Revew View Help Power Pivot Search Autosum . A Paste DCopy - Femat Painter Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formattinglable- Styles Filter-Select B22 0 1 SUMMARY OUTPUT Regressioni Siatistics 4MultipleR SR Square 6 Adjusted R Square 0.97392719 0.94832967 0.93684737 7 Standard Error 7672.91079 8 Observations 12 10 ANOVA MS aneF 2 9724804626 4862402313 82.50943 1.620266-0G 13 Residual 9 52982040.3 58873560 14 Tola 11 10254666667 15 Coefficients Stondard Error t Stat P-volue Lower 93% Upper 95% Lower 95.0% Upper 95.0% 16 17 Intercept 10190.1232 19791.33635 2.03038198 0.07288908-1587.7765 81968.023-1587.7765 81968.023 1 Expenditures 5.926376 0.580561276 10.2080112 3.0139E- 4.613055152 7.23969605 4.61305515 7.23969685 301.685181 60.6000453 4.97825365 0.00076126 164.5970893 438.773273 164.597089 438.773273 Y = a + b1|*x1 + b2 * x2 Units Sold 40190.12-Expenditures" 5.93 + Dealers. 301.69 hibit1 Scenario 1 Adv & Dealers Dealers Table 1Sensitivity +90 :16 PM rP 5/29/2019 O Type here to search ACCT 606 Master Buudget Pmject Group Final Excrl AutoSave tf Natalic Michel Share Comments File Home Insert Page Layout Formulas Data Review View Help Power Pivot P Search AutoSum . A X Cut Calibn Paste DCopy - oeal Painler Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formattinglable- Styles Filter-Select 0 1 SUMMARY OUTPUT ADVERTISING EXPENDITURES sion Stotistics 4 Multiple R R Syuare 6 Adjusted R Square 0.786651414 0.89/801058 0.80604674 7 Standard Frror 14107.97889 8 Observations 12 10 ANOVA 12 Regression 1 8265140633 8265/40633 41.55881362 .3/964E-0b 13 Residual 10 1988926034 198892603.4 11 10254666667 0,0 100,000 15,0 , 50,o a00,0350,000 14 Total 15 Coefficients Standard Error t Stat Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1 Intercept 114473.263 23905.77966 4.788518283 0.000736231 61207.86654 167738.6595 61207.86654 167738.6595 18 .656150351.032503519 6.446612569 7.37964E-05 4.355589083 8.956711626 1.355589083 8.956711620 19 23 24 & Dealers Scenario 2 Adv Dealers Table 1Sensitivity - +17% :16 PM O Type here to search ACCT 606 Master Buudget Pmject Group Final Excrl AutoSave tf Natalic Michel File Home Insert Page Layout Formulas Data Review View Help Power Pivot P Search Share Comments AutoSum . A X Cut Calibn Paste DCopy - oeal Painler Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formattinglable- Styles Filter-Select 4 0 1 SUMMARY OUTPUT NUMBER OF DEALERS sion Stotistics 4 Multiple R R Syuare 6 Adjusted R Square 0.5916265 0.350081985 0.285090184 7 Standard Frror 25816.06593 8 Observations 12 10 ANOVA 150 100 12 Regression 1 35899/406 358991406/ 5.386556113 0.042/0/564 13 Residual 10 6664692600 666469260 11 10254666667 14 Total 15 Coefficients Standard Error tStot 128319.0461 59931.12548 2.141108566 0.057926608 -5215.823012 261853.9152 -5215.823012 261853.9152 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1 Intercept 18 Dealers 157.8853875197.2882361 2.320895511 0.04270756 18.29980359 897.470971 18.29980359 897.1709714 19 v & Dealers Scenario 3 Dealers Table Sensitivity - +100 :16 PM O Type here to search ACCT 606 Master Buudget Pmject Group Final Excrl Natalic Michel File Home Insert Page Layout Formulas Data Revew View Help Power Pivot Search Autosum . A Paste DCopy - Femat Painter Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formattinglable- Styles Filter-Select B22 0 1 SUMMARY OUTPUT Regressioni Siatistics 4MultipleR SR Square 6 Adjusted R Square 0.97392719 0.94832967 0.93684737 7 Standard Error 7672.91079 8 Observations 12 10 ANOVA MS aneF 2 9724804626 4862402313 82.50943 1.620266-0G 13 Residual 9 52982040.3 58873560 14 Tola 11 10254666667 15 Coefficients Stondard Error t Stat P-volue Lower 93% Upper 95% Lower 95.0% Upper 95.0% 16 17 Intercept 10190.1232 19791.33635 2.03038198 0.07288908-1587.7765 81968.023-1587.7765 81968.023 1 Expenditures 5.926376 0.580561276 10.2080112 3.0139E- 4.613055152 7.23969605 4.61305515 7.23969685 301.685181 60.6000453 4.97825365 0.00076126 164.5970893 438.773273 164.597089 438.773273 Y = a + b1|*x1 + b2 * x2 Units Sold 40190.12-Expenditures" 5.93 + Dealers. 301.69 hibit1 Scenario 1 Adv & Dealers Dealers Table 1Sensitivity +90 :16 PM rP 5/29/2019 O Type here to search ACCT 606 Master Buudget Pmject Group Final Excrl AutoSave tf Natalic Michel Share Comments File Home Insert Page Layout Formulas Data Review View Help Power Pivot P Search AutoSum . A X Cut Calibn Paste DCopy - oeal Painler Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formattinglable- Styles Filter-Select 0 1 SUMMARY OUTPUT ADVERTISING EXPENDITURES sion Stotistics 4 Multiple R R Syuare 6 Adjusted R Square 0.786651414 0.89/801058 0.80604674 7 Standard Frror 14107.97889 8 Observations 12 10 ANOVA 12 Regression 1 8265140633 8265/40633 41.55881362 .3/964E-0b 13 Residual 10 1988926034 198892603.4 11 10254666667 0,0 100,000 15,0 , 50,o a00,0350,000 14 Total 15 Coefficients Standard Error t Stat Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1 Intercept 114473.263 23905.77966 4.788518283 0.000736231 61207.86654 167738.6595 61207.86654 167738.6595 18 .656150351.032503519 6.446612569 7.37964E-05 4.355589083 8.956711626 1.355589083 8.956711620 19 23 24 & Dealers Scenario 2 Adv Dealers Table 1Sensitivity - +17% :16 PM O Type here to search ACCT 606 Master Buudget Pmject Group Final Excrl AutoSave tf Natalic Michel File Home Insert Page Layout Formulas Data Review View Help Power Pivot P Search Share Comments AutoSum . A X Cut Calibn Paste DCopy - oeal Painler Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formattinglable- Styles Filter-Select 4 0 1 SUMMARY OUTPUT NUMBER OF DEALERS sion Stotistics 4 Multiple R R Syuare 6 Adjusted R Square 0.5916265 0.350081985 0.285090184 7 Standard Frror 25816.06593 8 Observations 12 10 ANOVA 150 100 12 Regression 1 35899/406 358991406/ 5.386556113 0.042/0/564 13 Residual 10 6664692600 666469260 11 10254666667 14 Total 15 Coefficients Standard Error tStot 128319.0461 59931.12548 2.141108566 0.057926608 -5215.823012 261853.9152 -5215.823012 261853.9152 Lower 95% Upper 95% Lower 95.0% Upper 95.0% 1 Intercept 18 Dealers 157.8853875197.2882361 2.320895511 0.04270756 18.29980359 897.470971 18.29980359 897.1709714 19 v & Dealers Scenario 3 Dealers Table Sensitivity - +100 :16 PM O Type here to search