Instructions: Use the data table below. Assume the table is…

Instructions: Use the data table below. Assume the table is entered in Excel exactly as shown in cells A1:E13, with headers in row 1 and data in rows 2–13. Column A is Respondent ID; Column B is Plan; Column C is number of Purchases; Column D is Wait time in Minutes; Column E is a Satisfaction rating on 1-5 scale.   If Excel formula =COUNT(C2:C13) is used, what value is returned?

A small retailer studies whether weekly local advertising ex…

A small retailer studies whether weekly local advertising exposure x predicts customer inquiry count y. The x-values are not listed in increasing order, and one lower x-value has an unusually low y-value, so use regression computation rather than a visual estimate. Use the following data to compute the simple linear regression equation and then predict y when x = 27. x              y30           42.3510           18.9525           40.5015           21.8035           53.2020           33.65 Enter the slope [slope]____, intercept [intercept]____, and predicted ŷ for x = 27 [y-hat]____.(round each answer to 2 decimals)