Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please according data table answer follow blank questionsI had finished but I am not sure correctthanks. X Y Obs Buggy Whip Sales ($) Widget Sales

Please according data table answer follow blank questionsI had finished but I am not sure correctthanks.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
X Y Obs Buggy Whip Sales ($) Widget Sales ($ 654 687 514 483 567 505 506 425 464 367 699 769 596 554 10 8 542 575 11 9 556 562 12 10 482 419 13 11 658 612 14 12 552 475 15 13 638 491 16 14 477 472 17 15 693 589 18 16 548 603 19 17 712 726 20 18 579 504 21 19 450 356 22 20 696 759 23 21 675 668 24 22 624 630 25 23 588 465 26 24 691 746 27 25 713 570 28 26 435 405 29 27 430 469 30 28 504 444 31 29 547 481 32 30 513 503 33 31 480 422 34 32 396 329 35 33 397 310 36 34 576 438 37 35 555 455 38 36 438 350 39 37 496 521 40 38 540 583 41 39 429 322 42 40 564 615 43 41 649 558 44 42 518 534 45 43 688 550 46 44 570 581Use 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% condence 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. The intercept (was / was not) signicant. For the rest of your responses, assume that the intercept was signicant, even if it was not. Approximately % of the variation in Widget sales is explained by the regression. 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. V is 618 when the value of buggy whip sales is 618. 47 45 487 453 48 46 545 431 49 47 397 365 50 48 704 591 51 49 641 558 52 50 424 390 53 51 432 471 54 52 687 556 55 53 534 518 56 54 588 465 57 55 516 552 58 56 515 407 59 57 522 538 60 58 633 487 61 59 418 405 62 60 438 368 63 61 513 457 64 62 650 605 65 63 687 673 66 64 518 502 67 65 473 378 68 66 505 379 69 67 638 523 70 68 545 480 71 69 658 520 72 70 506 420 73 71 479 445 74 72 649 532 75 73 431 444 76 74 534 454 77 75 599 491 78 76 709 744 79 77 658 632 80 78 586 592 81 79 628 603 82 80 402 362 83 81 425 344 84 82 462 374 85 83 631 681 86 84 387 352 87 85 587 540 88 86 633 608 89 87 634 514 90 88 498 393 91 89 659 639 92 90 582 541 93 91 405 41794 92 392 400 95 93 410 435 96 94 663 709 97 95 589 459 98 96 701 659 99 97 655 714 100 98 650 585 101 99 627 539 102 100 659 507

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Algebra

Authors: Marvin L Bittinger

12th Edition

0321922913, 9780321922915

More Books

Students also viewed these Mathematics questions

Question

d. In what sports does the person consult?

Answered: 1 week ago

Question

mple 10. Determine d dx S 0 t dt.

Answered: 1 week ago