The following data obtained from a simple random sample of 15 shopperswill be used to answer several questions.TABLE 1.CustomerGenderAge123456789101112131415FFFMFFMMFMFFMMF321948276654384437712555613142Number ofShopping trips(per month)9614106812965987118Amount Spent($ per trip)92.00120.0079.0084.00144.0089.0068.0075.00106.0099.0087.0093.00102.0074.0093.002. The CEO of Giant Fish supermarket suspects that customers who shop morefrequently tend to spend less on each shopping trip. To investigate this trendhe would like you to conduct a simple linear regression using the number ofShopping Trips (per month) as the independent variable and the AmountSpent (per trip) as the dependent variable.A. Create the scatter plot and label the graph and both axes.B. Calculate the regression equation.C. Sketch the regression equation on the graph above.D. Determine the correlation coefficient and the coefficient of determinationand label each with the appropriate symbol.E. Describe the relationship (correlation) between the number of shoppingtrips per month and the amount spent per trip, using at least twodescriptors.F. Use the regression equation to predict the amount spent per trip for:i)a person who goes to the store 7 times per month .__________ii)a person who goes to the store 11 times per month.__________G. Which is greater, the predicted amount or the actual amount spent pertrip, for a person (customer # 13) who goes to the store 7 times permonth?H. Why can’t you predict the amount spent per trip for someone who goes tothe store twice per month?3. The owner of Giant Fish supermarket wants to know if the proportion ofgrocery shoppers who regularly shop at his store is the same on the east andwest sides of Columbus. Your survey 800 shoppers on the east side ofColumbus and find that 358 of them shop at Giant Fish regularly. You survey600 shoppers on the west side of Columbus and find that 289 shop at GiantFist regularly. Conduct a test to determine if proportion of shoppers whoregularly patronize Giant Fish supermarket is the same on the east and westsides of Columbus. Use an alpha of .05 to conduct the test.A) (10) Show All 5 Steps of Hypothesis Testing and interpret your decision.Hypotheses:The value of the test statistic is ______ and the p-value is _ ____Decision:Interpretation:B) Construct a 95% confidence interval for the proportion of people whoregularly shop at Giant Fish supermarket on the WEST side of Columbus.C) Interpret the interval4.The owner of Giant Fish supermarket is interested in the average of age ofshoppers in the store. Create and interpret a 95% confidence interval for theaverage age of customers in the Giant Fish supermarket.A. Interval:B. Interpretation:C. What is the point estimate for the average age of shoppers at Giant Fishsupermarket?D. What is the margin of error?E. The U.S. Supermarket Marketing Group reported that the average age ofsupermarket shoppers is 43.5 years. Are the shoppers at Giant Fish asignificantly different age than the national average?5. The owner of Giant Fish supermarket was reviewing some data from aresearch report on the type of advertisements in the local paper that aremost effective. Three types of ads (big headline, straight forward and boldprint) were randomly alternated over a period of weeks and the number ofpeople that reported that they read the ad was tallied. Do the data belowsupport the hypothesis that there is no difference in the effectiveness of theads, as measured by the mean number of people who reported reading thead? Use an alpha of .05.