QUESTION 3 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 There are high leverage observations in the data set. unusual residuals based on the empirical rule. A B C D 2 Obs 1 3 4 2. Un 3 6 4. N 5 6 8 9 10 7 8 9 12 10 13 Y Buggy Whip Sales ($) Widget Sales ($) 654 687 514 483 567 505 506 425 464 367 699 769 596 554 542 575 556 562 482 419 658 612 552 475 638 491 477 472 693 589 548 603 712 726 579 504 450 356 696 759 675 668 624 630 588 465 691 746 14 un 12 13 14 16 17 7 15 18 19 20 16 17 18 19 20 21 22 23 22 24 25 23 26 24 A B. f C D 588 23 24 25 26 27 691 713 465 746 570 435 430 28 29 405 469 444 481 503 422 504 547 513 480 396 30 31 32 33 34 397 576 35 36 555 438 496 540 329 310 438 455 350 521 583 322 615 558 38 39 41 42 429 564 649 518 688 570 534 43 550 581 46 47 48 487 545 397 704 453 431 365 591 A 47 397 704 48 641 424 49 50 51 52 53 54 55 56 365 591 558 390 471 556 518 465 552 407 538 487 405 368 457 605 673 502 57 58 59 60 61 432 687 534 588 516 515 522 633 418 438 513 650 687 518 473 505 638 545 658 506 479 649 62 63 64 65 66 67 378 379 523 480 520 68 69 70 420 71 445 72 A B C 83 631 681 85 86 387 352 84 85 587 87 88 540 608 86 633 89 87 634 514 88 498 90 91 393 89 659 639 92 90 582 91 92 405 93 94 95 96 541 417 400 392 93 435 94 410 663 97 95 589 96 701 459 659 714 97 99 100 655 98 650 101 585 99 627 102 539 100 659 03 507 05 07