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

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.
    It followed up with a survey of shoppers to determine if the ads had been successful. Respondents were asked if they had seen the Macy's "Gift HQ" ads, and several other questions.
    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:
    Awaregiftwrap
    Awarereturnpolicy
    Awaregiftcard
    Awaregiftreceipt
    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:
    MacysgiftHQ
    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
    SawMacysAds    Awaregiftwrap    Awarereturnpolicy    Awaregiftcard    Awaregiftreceipt
    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        SawMacysAds    Have you seen any Macy's advertising promoting them as the Gift Headquarters?    0=No, 1=Yes
    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,...