Marketing > Research Paper > University of South Carolina - MKTG 352Assignment 5 (recent) quantitative Data Analyses Task 2 (All)

University of South Carolina - MKTG 352Assignment 5 (recent) quantitative Data Analyses Task 2

Document Content and Description Below

Assignment 5 : Quantitative Data Analyses Task 2 (please highlight or bold your answers) Please use the “DanoPizza_assign4.xlsx” data file to answer the following questions. These data are from a comprehensive, large scale marketing research study on two research questions: (a) consumer behavior and satisfaction of Dano’s Pizza, and (b) effectiveness of a recent promotion program of Dano’s Pizza. As a result, the data file includes (1) survey questions regarding dining habits, satisfaction, and demographic information of consumers of Dano’s Pizza, and (2) records on consumers’ spending on Dano’s Pizza after receiving coupons from social media or coupons from mails. The questions that correspond to each variable can be seen by clicking on the “variable view” sheet of the data file and looking at the “labels”. 1. t-Tests: Dano’s Pizza, used to provide coupons, only through mails (a traditional channel used by most of the firms), but recently it started to offer coupons through social media (e.g., Facebook) as well. However, Dano’s Pizza distributes 80% of its coupons through mail. Before distributing coupons through social media more aggressively, Dano’s Pizza wants to find out if it is effective to promote itself through social media. To answer this question, Dano’s Pizza needs to know consumers’ response to the coupons provided through social media relative to their response to the coupons provided through mails, and relative to when no coupon is provided at all. Explore these issues by applying t-tests on the data at your disposal. Throughout the assignment, you will have to decide the appropriate t- test for different situations. Use the excel manuals to do these questions. a. Begin by investigating whether offering coupons to consumers through social media could stimulate them to spend more money on Dano’s Pizza than when no coupon is offered. According to the existing records of Dano’s Pizza, the average monthly spending per person is $12 when no coupon is offered. Use the spent_social (dollar spent in Dano’s Pizza one month after receiving coupons in social media) and perform one sample t-test. Please show the statistical output in a table form below

[Show More]

Last updated: 3 years ago

Preview 1 out of 6 pages

Buy Now

Instant download