Two Factor
Analysis of Variance: Independent Samples (With replications)
–Suppose in this exercise, two
factors are to be examined: (See Data Below)
•The effects of the marketing
approach on sales.
–Emphasis on convenience
–Emphasis on quality
–Emphasis on price
•
The
effects of the selected media on sales.
–Advertise on TV
–Advertise in newspapers
–Are these differences caused by
differences in the marketing approach?
–Are these differences caused by
differences in the medium used for advertising?
–Are there combinations of these two
factors that interactto affect the weekly sales?
Use
Excel (Two-Factor Analysis with replication) to test the above three hypotheses
using Alpha=.05. Data: (For the two-way ANOVA Problem )
Convenience |
Quality |
Price |
|
TV |
491 |
677 |
575 |
TV |
712 |
627 |
614 |
TV |
558 |
590 |
706 |
TV |
447 |
632 |
484 |
TV |
479 |
683 |
478 |
TV |
624 |
760 |
650 |
TV |
546 |
690 |
583 |
TV |
444 |
548 |
536 |
TV |
582 |
579 |
579 |
TV |
672 |
644 |
795 |
Newspaper |
464 |
689 |
803 |
Newspaper |
559 |
650 |
584 |
Newspaper |
759 |
704 |
525 |
Newspaper |
557 |
652 |
498 |
Newspaper |
528 |
576 |
812 |
Newspaper |
670 |
836 |
565 |
Newspaper |
534 |
628 |
708 |
Newspaper |
657 |
798 |
546 |
Newspaper |
557 |
497 |
616 |
Newspaper |
474 |
841 |
587 |