Great Deal! Get Instant \$10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

# Macy Assignment using a pivot table from the excel sheet attached.ANSWER EACH QUESTION ON A SEPARATE WORKSHEET, AND COPY AND PASTE

Macy Assignment using a pivot table from the excel sheet attached.
ANSWER EACH QUESTION ON A SEPARATE WORKSHEET, AND COPY AND PASTE

Answered Same Day Mar 21, 2024

## Solution

Komalavalli answered on Mar 21 2024
Assignment
Data Analysis Assignment
Macy's, the department store, ran advertising that aimed to position the store as the "Gift Headquarters", i.e., a place where people could buy gifts during the holiday season.
Your task is to analyze the data and determine if Macy's ads succeeded in their objective. For all tests, show your work; no credit will be given otherwise.
ANSWER EACH QUESTION ON A SEPARATE WORKSHEET, AND COPY AND PASTE THEM INTO A WORD DOCUMENT BEFORE UPLOADING (do not upload this Excel file).
A summary of the variables in the data is provided in the tab "Variables".
1. Use data in the tab "Macy's data for crosstabs" to create pivot tables between SawMacysAds and each of the following:
Awarereturnpolicy
Conduct a Chi-Square test in each case to determine if the variables in the crosstab are independent.
Based on the results of your tests, are those who saw the ads more likely or less likely to be aware of each service compared to those who did not see the ads, or is there no difference? Explain what evidence your conclusions are based on.
2. Use data in the tab "Macy's data for 2-sample test" to conduct a 2-sample t-test (assuming unequal variances) between people who saw Macy's ads and those did not, for each of the following:
RecommendMacys
Based on the results of your tests, what were the differences, if any, between people who saw the ads and those who did not? Explain what evidence your conclusions are based on.
3. Based on your answers to the above questions, would you say that the Macy's "Gift HQ" ad campaign was effective? Explain why or why not.
Macy's data for crosstabs
0    1    1    1    0        The variables are coded as shown below.
1    1    1    0    1        Variable Name    Question    Values
0    1    1    1    1        Awaregiftwrap    Which of the following services are you aware is provided by Macy's? Gift Wrap    0=No, 1=Yes
0    1    1    0    0        Awarereturnpolicy    Which of the following services are you aware is provided by Macy's? Return/Exchange Policy    0=No, 1=Yes
1    1    1    1    1        Awaregiftcard    Which of the following services are you aware is provided by Macy's? Elecronic Gift Card    0=No, 1=Yes
1    1    1    1    1        Awaregiftreceipt    Which of the following services are you aware is provided by Macy's? Gift Receipt    0=No,...
SOLUTION.PDF