Regression Analysis Data File.xlsx - Make sure the addin called Analysis ToolPak is activated ted SUMMARY OUTPUT Regression Statistics Multiple R

Regression Analysis Data File.xlsx - Make sure the addin...

This preview shows page 1 - 13 out of 13 pages.

Make sure the addin called Analysis ToolPak is activated.
Image of page 1
Image of page 2
Image of page 3
SUMMARY OUTPUT Regression Statistics Multiple R 0.9923181961 R Square 0.9846954023 Adjusted R Squa 0.9816344828 Standard Error 628.98289133 Observations 7 ANOVA df SS MS F Significance F Regression 1 127270474.04 127270474.04 321.69921162 9.89287E-06 Residual 5 1978097.3879 395619.47759 Total 6 129248571.43 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept 408.19090616 379.52022114 1.0755445518 0.3312684125 -567.39688057 1383.7786929 Advertising 3.7900677201 0.211310935 17.935975346 9.89287E-06 3.246875669 4.3332597712 RESIDUAL OUTPUT Observation Predicted Sales Residuals tandard Residuals 1 11020.380522 -1020.3805224 -1.7771085257 2 1166.2044502 -66.204450177 -0.1153025663 3 1924.2179942 -24.217994195 -0.0421783864 4 2303.2247662 -303.2247662 -0.5281003561 5 12536.40761 463.59238955 0.807398779 6 7230.3128023 769.68719768 1.340497639 7 3819.2518542 180.74814576 0.3147934166
Image of page 4
Lower 95.0% Upper 95.0% -567.39688057 1383.7786929 3.246875669 4.3332597712 $- $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 -1500 -1000 -500 0 500 1000 Advertising Residual Plot Advertising Residuals $- $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 $- $5,000 $10,000 $15,000 Advertising Line Fit Plot Sales Predicted Sales Advertising Sales
Image of page 5
Advertising Sales $ 2,800 $ 10,000 $ 200 $ 1,100 $ 400 $ 1,900 $ 500 $ 2,000 $ 3,200 $ 13,000 $ 1,800 $ 8,000 $ 900 $ 4,000
Image of page 6
Image of page 7
Image of page 8
SUMMARY OUTPUT Regression Statistics Multiple R 0.72213429224 R Square 0.521477936029 Adjusted R Squar 0.441724258701 Standard Error 47.46341263476 Observations 15 ANOVA df SS MS F Significance F Regression 2 29460.02686608 14730.01343304 6.53860678902 0.012006372233 Residual 12 27033.30646726 2252.775538938 Total 14 56493.33333333 Coefficients Standard Error t Stat P-value Lower 95% Intercept 306.5261932837 114.2538935105 2.682851182272 0.019931590985 57.58834426365 AdExp 0.074130957489 0.025967317918 2.854779139032 0.014493626796 0.017553032057 Price -24.9750895178 10.83212511941 -2.30565002181 0.039788461179 -48.5762627006
Image of page 9
Image of page 10
Image of page 11
Image of page 12
Image of page 13

You've reached the end of your free preview.

Want to read all 13 pages?

Unformatted text preview: RESIDUAL OUTPUT Observation Predicted Sales Residuals 1 413.7953606485 -63.7953606485 2 363.8451816129 96.15481838711 3 329.1183496074 20.88165039265 4 440.3147858405 -10.3147858405 5 359.0884570287 -9.08845702874 6 415.736851855-35.736851855 7 416.5311629197 13.46883708025 8 420.970163078 49.02983692201 9 391.1589178695 58.84108213045 10 478.1745756496 11.82542435043 11 386.163899966-46.163899966 12 346.4420500569 -46.4420500569 13 455.6969950835 -15.6969950835 14 441.1090969052 8.890903094798 15 331.8541518786 -31.8541518786 Upper 95% Lower 95.0% Upper 95.0% 555.4640423038 57.58834426365 555.4640423038 0.13070888292 0.017553032057 0.13070888292-1.37391633509 -48.5762627006 -1.37391633509 $2,600 $2,800 $3,000 $3,200 $3,40-100-50 50 100 150 AdExp R Residuals $4.00 $4.50 $5.00 $5.50 -100-50 50 100 150 Price R Residuals $2,500 $3,000 $3,500 0 100 200 300 400 500 600 AdExp AdEx Sales $4.00 $4.50 $5.00 $5.50 $6.00 0 100 200 300 400 500 600 Price L Price Sales 00 $3,600 $3,800 $4,000 $4,200 $4,400 $4,600 Residual Plot AdExp $6.00 $6.50 $7.00 $7.50 $8.00 $8.50 Residual Plot Price $4,000 $4,500 $5,000 Line Fit Plot Sales Predicted Sales xp $6.50 $7.00 $7.50 $8.00 $8.50 Line Fit Plot Sales Predicted Sales ce Week Sales AdExp Price 1 350 $ 3,300 $ 5.50 Variable Definition 2 460 $ 3,300 $ 7.50 Sales Dependent V 3 350 $ 3,000 $ 8.00 AdExp Independent 4 430 $ 4,500 $ 8.00 Price Independent 5 350 $ 3,000 $ 6.80 6 380 $ 4,000 $ 7.50 7 430 $ 3,000 $ 4.50 8 470 $ 3,700 $ 6.40 9 450 $ 3,500 $ 7.00 10 490 $ 4,000 $ 5.00 11 340 $ 3,500 $ 7.20 12 300 $ 3,200 $ 7.90 13 440 $ 4,000 $ 5.90 14 450 $ 3,500 $ 5.00 15 300 $ 2,700 $ 7.00 Variable - Sales during period (units) Variable - Advertising Expenditures during period (dollars) Variable - Selling Price per Unit during period (dollars)...
View Full Document

  • Fall '18
  • Sharma

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors