3. Set up a contingency.r table for the appropriate variables given, and then determine the following probabilities: A. SPRSPEND and RESPGEND [variables 4 and 26]: Given that the random respondent is a female, what is the probability that she spends at least 515 during a trip to Springdale Mall? Is a male more likelv or less likelyr than a female to spend at least 515 during a visit to this area? B. DDWSPEND and RESPGEND [variables 5 and 26]: Given that the random respondent is a female, what is the probabilitv that she spends at least 515 during a trip to Downtown? Is a male more likelv or less likelv than a female to spend at least 515 during a visit to this area? C. WESSPEND and RESPG END [variables 6 and 25]: Given that the random respondent is a female, what is the probabilitv that she spends at least 515 during a trip to West Mall? Is a male more likelv or less likelv than a female to spend at least 515 during a visit to this area? Based on the preceding probabilities, rank the shopping areas where males and females are most likelv to least likelv to spend $15 or more during a shopping visit. Paper Requirements Write a report that uses the Written Assignment Requirements under the heading Expectations for {EU- Gioboi Written Assignments found in the CSU-Global Guide to Writing and APA. Items that should be included, at a minimum, are a title page, an introduction, a bodv which answers the questions posed in the problem. and a conclusion paragraph that addresses vour ndings and what vou have determined from the data and 1vour analvsis. As with all written assignments, vou should have in-text citations and a reference page. Please include anyI tables of calculations, calculated values, and graphs associated with this problem in the bodv ofvour assignment response. Note: You must submit vour Excel file with vour report. This will aid in grading with partial credit if errors are found in the report