please solve the following question for thumbs up
Question 5 (1 point) The following table represents data collected from 36 promotions used to sell a laptop. Data from three independent variables (Advertising Budget in thousands of dollars, X1, Price of the laptop. X2, and Price of the Competitor's laptop, X3) was recorded for each promotion along with the resulting sales, also in thousands of dollars. Use this data to construct a linear regression model. Provide the following information below: Promotion Adversiting (Sks) Price ($) Competition Price ($) Sales ($ks) 1 366 90.99 96.95 10541 2 377 90.99 93.99 8991 3 387 94.99 90.99 5905 4 418 96.99 97.95 8251 5 434 92.99 97.95 11461 6 450 95.95 93.95 6924 7 457 93.95 90.99 7347 8 466 91.95 96.95 10972 9 467 96.95 94.99 7811 10 468 92.95 96.95 10559 11 468 97.99 98.95 9825 12 475 91.95 90.99 9130 13 479 99.95 91.95 5116 14 479 96.99 95.95 7830 15 481 91.95 90.95 8388 16 490 96.99 96.99 8588 17 494 96.95 91.95 6945 18 502 98.95 95.95 7697 19 505 94.99 96.99 9655 20 529 93.99 97.95 11516 21 532 91.99 95.99 11952 533 92.99 97.99 13547 23 542 93.99 92.95 9168 24 544 90.95 95.95 11942 25 547 94.99 93.95 9917 26 554 89.95 90.95 10666 27 556 96.95 95.95 9717 560 91.99 97.95 13457 29 561 98.99 97.95 10319 30 566 93.95 91.99 9731 31 566 94.99 94.99 10279 32 582 98.99 91.99 7202 33 609 89.95 92.99 12103 34 612 92.95 92.99 11482 35 617 92.95 94.95 11944 36 623 94.99 91.99 9188 22 28 35 36 617 623 92.95 94.99 94.95 91.99 11402 11944 9188 50% fractal for Ad-$400K, Price $95.99, Competitor's Price - $96.99. R Squared using all three items) 1. 0.17 R squared using our Advertising $ and Competitor's Price 2. 0.395 3. 0.244 Rsquared for Competitor's Price only 4. 0.715 R squared using our Price and Competitor's Price 5. 0.562 Rsquared for Price only 6. 0.488 7. 0.953 R squared using our Advertising $ and Price 8. 8334 95% fractal for Ad=$500K, Price $89.99, Competitor's Price = $99.99. 9. 15079.2 10.4211.76 20% fractal for Ad=$250K, Price=$97.99, Competitor's Price - $95.99. Rsquared for Advertising Only Previous Page Next Page Page 20 Question 5 (1 point) The following table represents data collected from 36 promotions used to sell a laptop. Data from three independent variables (Advertising Budget in thousands of dollars, X1, Price of the laptop. X2, and Price of the Competitor's laptop, X3) was recorded for each promotion along with the resulting sales, also in thousands of dollars. Use this data to construct a linear regression model. Provide the following information below: Promotion Adversiting (Sks) Price ($) Competition Price ($) Sales ($ks) 1 366 90.99 96.95 10541 2 377 90.99 93.99 8991 3 387 94.99 90.99 5905 4 418 96.99 97.95 8251 5 434 92.99 97.95 11461 6 450 95.95 93.95 6924 7 457 93.95 90.99 7347 8 466 91.95 96.95 10972 9 467 96.95 94.99 7811 10 468 92.95 96.95 10559 11 468 97.99 98.95 9825 12 475 91.95 90.99 9130 13 479 99.95 91.95 5116 14 479 96.99 95.95 7830 15 481 91.95 90.95 8388 16 490 96.99 96.99 8588 17 494 96.95 91.95 6945 18 502 98.95 95.95 7697 19 505 94.99 96.99 9655 20 529 93.99 97.95 11516 21 532 91.99 95.99 11952 533 92.99 97.99 13547 23 542 93.99 92.95 9168 24 544 90.95 95.95 11942 25 547 94.99 93.95 9917 26 554 89.95 90.95 10666 27 556 96.95 95.95 9717 560 91.99 97.95 13457 29 561 98.99 97.95 10319 30 566 93.95 91.99 9731 31 566 94.99 94.99 10279 32 582 98.99 91.99 7202 33 609 89.95 92.99 12103 34 612 92.95 92.99 11482 35 617 92.95 94.95 11944 36 623 94.99 91.99 9188 22 28 35 36 617 623 92.95 94.99 94.95 91.99 11402 11944 9188 50% fractal for Ad-$400K, Price $95.99, Competitor's Price - $96.99. R Squared using all three items) 1. 0.17 R squared using our Advertising $ and Competitor's Price 2. 0.395 3. 0.244 Rsquared for Competitor's Price only 4. 0.715 R squared using our Price and Competitor's Price 5. 0.562 Rsquared for Price only 6. 0.488 7. 0.953 R squared using our Advertising $ and Price 8. 8334 95% fractal for Ad=$500K, Price $89.99, Competitor's Price = $99.99. 9. 15079.2 10.4211.76 20% fractal for Ad=$250K, Price=$97.99, Competitor's Price - $95.99. Rsquared for Advertising Only Previous Page Next Page Page 20
