Help 2 Question 1: Contingency Tables A sample of shoppers was selected and asked questions regarding consumer behavior. One of the questions asked was "Do you enjoy shopping for clothing?" Information regarding the responses is below: Total Responses: 500 Males: 136 responded "yes" and 104 responded "no" Females: 224 responded "yes" and 36 responded "no" Construct a contingency table summarizing the above results and answer the following questions: a) What is the probability a shopper likes to shop for clothing? b) Given a shopper is male, what is the probability the shopper likes to shop for clothing? c) Given a shopper is male, what is the probability the shopper does not like to shop for clothing? d) Given a shopper is female, what is the probability a shopper does not like to shop for clothing? e) Include the excel spreadsheet with the data and in a word document your answers to the questions above. Question 2: Regression Analysis Assesse d Value 184400 Heatin g Area 2000 Age 3.42 177400 175700 185900 179100 170400 1710 1450 1760 1930 1200 175800 1550 185900 178500 179200 186700 179300 174500 1930 1590 1500 1900 1390 1540 183800 176800 1890 1590 11.50 8.33 0.00 7.42 32.0 0 16.0 0 2.00 1.75 2.75 0.00 0.00 12.5 8 2.75 7.17 Perform a regression analysis. Be sure to plot the data and plot and include various graphs that would help determine if the data is normally distributed (which is an assumption of ordinary least squared regression). Write-up a short summary of the results. Be sure to include the resulting model (equation) for the relationship determined by the regression analysis and an interpretation of the model. At the 0.05 significance level is there evidence of a relation between assessed value and heated area of house