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