Use excel and the attached data set to run a regression and make any necessary additional calculations to fill in the blank spaces. use a 95% confidence level (.05 alpha) for all calculations requiring that information. do not use any rounded values in any of your calculations. round all your answers to 4 decimal places. do not include any leading zeros in your responses for numbers that cannot be greater than 1. if the value is discrete, enter it as a whole number.
There are high leverage observations in the data set. There are unusual residuals based on the empirical rule. The prediction interval margin of error is when the value of the independent variable is 450. when the value of buggy whip sales is 618. ✓is The intercept (was / was not) significant For the rest of your responses, assume that the intercept was significant, even if it was not. Approximately % of the variation in widget sales is explained by the regression. fx 4 A B с D E F G H 1 2 Obs х Buggy Whip Sales 654 Y Widget Sales 687 3 1 4 2 483 514 567 3 505 5 6 4 506 425 7 5 464 8 6 367 769 554 575 9 699 596 542 7 10 8 11 9 556 562 10 12 13 14 482 658 552 419 612 11 12 475 491 15 13 638 477 16 14 472 17 15 589 693 548 18 16 603 726 19 17 712 18 20 21 22 504 356 19 579 450 696 675 20 21 23 24 22 23 25 759 668 630 465 746 570 405 24 26 27 624 588 691 713 435 430 504 25 26 28 29 27 469 28 444 30 31 481 32 33 34 29 30 31 547 513 480 503 422 329 310 32 396 397 35 33 36 34 35 37 576 555 438 496 438 455 350 38 36 37 521 39 40 38 540 583 322 41 42 39 40 429 564 615 43 41 649 42 43 518 688 558 534 550 44 45 46 47 44 570 581 45 453 487 545 46 48 49 431 365 47 397 704 50 48 591 558 51 49 641 50 424 390 52 53 54 51 432 471 556 52 687 55 53 534 518 465 56 54 588 57 55 516 552 407 58 59 56 57 515 522 633 538 60 58 487 61 59 418 405 62 438 368 60 61 63 457 513 650 64 62 605 65 63 673 687 518 64 502 66 67 65 378 473 505 66 379 68 69 70 67 638 68 69 71 72 545 658 506 479 523 480 520 420 445 70 73 71 72 649 532 74 75 76 73 431 444 74 534 454 77 75 599 491 78 76 709 744 77 632 79 80 658 586 78 592 81 79 628 603 80 82 83 402 425 462 362 344 81 82 374 83 631 681 84 85 86 87 84 387 587 352 540 85 88 86 633 608 89 87 90 88 634 498 659 514 393 639 91 89 92 90 582 541 91 405 417 93 94 400 92 93 95 435 94 709 96 97 392 410 663 589 701 655 95 459 659 96 98 99 100 97 714 98 650 585 101 99 100 627 659 539 507 102
