Use the Excel file (DT4-1.xlsx) to execute the following analyses: 1. Calculate the amount of sales by the experimental condition. (Recall that this is a cross-tabulation calculation.) Does there appear to be a pattern? Continuing from the scenario from the Marketing Application feature above, let's say you conducted an experiment to examine how an in-store sampling campaign may influence overall store sales. Column 1 shows the subject number. Column 2 indicates the sample con- dition for the independent variable of whether the subject received a doughnut sample or not. (1 = no sample; 2 = sample). Column 3 indicates the amount of overall sales the subject purchased in the store (in $). Column 4 indicates the subject's rating of hunger upon entering the store (ranging from1 = not at all hungry to 7 = extremely hungry). In-Store Doughnut Sampling Data Subject Number Sample Condition Overall Sales Subject's Rating of Hunger 65 2 1 100 3 1 99 4 2 80 3 23 2 140 7 2 110 8 2 45 2. 2 35 10 1 150 3. 11 1 60 4. 12 178 4 13 200 7 14 12 2 15 2 178 16 2 19 17 2 90 4 18 210 19 1 25 6. 20 1 43 706 User Numbt Sample Condi Overall Sal Subjects Rating of Hunger 65 1 3 100 3 3 99 4 80 3 5 1 23 5 6 140 110 8 45 9. 2 35 4 10 150 3 11 60 4 12 178 4 13 200 14 1 12 178 15 7 16 17 2 19 5 2 90 210 4 18 2 7 19 25 20 1 43 5 21 9. 15 2 22 1 23 89 24 2 260 7 25 190 1= Sample 2= No Sample 1= Not at all hungry 7 = Extremely hungry NNNN 1112 Subject Number Sample Condition Overall Sales Subject's Rating of Hunger 21 2. 22 15 3. 23 2 89 2. 2. 24 260 25 190 5. Your Task Use the Excel file (DT4-1.xlsx) to execute the following analyses: 1. Calculate the amount of sales by the experimental condition. (Recall that this is a cross-tabulation calculation.) Does there appear to be a patrern? 2. Determine whether the presence or absence of the sample impacted overall sales. (To do this, you will need to perform an F-test.) Is the result signifi- cant? What conclusion do you draw from this finding? 3. Calculate the correlations between hunger ratings and overall sales. Is the correlation significant? Is the correlation negative or positive? With this conclusion in hand, speculate on what potential role a person's hunger may play on the results of the experiment. (Hint: this is called moderation.) Draw a graph to show the possible relationship.