Need Help In Statistical Analysis Assignment-Statistics paper help
Data
Advertising medium Agency Increase
Newspaper 1 $24.39
Newspaper 1 $22.68
Newspaper 1 $22.67
Newspaper 1 $23.95
Newspaper 1 $22.33
Newspaper 2 $22.25
Newspaper 2 $22.50
Newspaper 2 $25.61
Newspaper 2 $21.31
Newspaper 2 $24.40
Radio 1 $27.56
Radio 1 $20.35
Radio 1 $24.12
Radio 1 $22.98
Radio 1 $24.32
Radio 2 $23.35
Radio 2 $20.68
Radio 2 $27.12
Radio 2 $20.11
Radio 2 $25.50
Television 1 $26.64
Television 1 $22.91
Television 1 $24.84
Television 1 $25.07
Television 1 $28.58
Television 2 $23.51
Television 2 $26.03
Television 2 $27.24
Television 2 $24.15
Television 2 $22.09
Website 1 $24.41
Website 1 $24.21
Website 1 $26.88
Website 1 $27.58
Website 1 $25.81
Website 2 $27.02
Website 2 $30.16
Website 2 $29.56
Website 2 $32.45
Website 2 $29.21
Read Appendix A in your textbook. Use the suggested steps for good statistical reporting listed in Appendix A to write a 2-page (max), APA formatted report using the data and results from your answer to #36 from Ch. 19.
Click the Submit Assignment link in the upper-right corner to upload your assignment.
Rubric
Homework: Statistical Report Writing Rubric
Homework: Statistical Report Writing Rubric
Criteria
Ratings
Pts
This criterion is linked to a Learning OutcomeMBA_3.2 The report incorporates data and results from Problem #36 in Ch. 19.
2.0 pts
This criterion is linked to a Learning OutcomeMBA_3.2 The suggested steps for good statistical reporting listed in Appendix A are used.
3.0 pts
This criterion is linked to a Learning OutcomeThe paper is no more than 2 pages long, formatted based on APA guidelines.
1.0 pts
This criterion is linked to a Learning OutcomeMBA_3.2 The paper meets basic writing standards, including grammar, usage, spelling, punctuation, and organization.
1.0 pts
Total Points: 7.0
#36. A commuter airline wants to determine the combination of advertising medium (four levels) and advertising agency (two levels) that would produce the largest increase in ticket sales per advertising dollar spent. Each of the two advertising agencies has prepared advertisements in formats required for distribution by each of the media (including television, radio, newspaper, and Web site). Forty small towns of roughly the same size have been selected for this experiment. Furthermore, groups of five of these small towns have been assigned to receive an advertisement prepared and distributed by each of the eight agency–medium combinations. The dollar increases in ticket sales per advertising dollar spent, based on a one-month period, are listed in the file P19_36.xlsx. Test for any significant main effects and interactions at the 5% level, and briefly summarize your results