write my assignment 8116

Part (a)You used the summatedrating to predict the cost of a restaurant meal (storedin Restaurants ). For those data, SSR = 6,951.3963 andSST = 15,890.11a. Determine the coefficient of determination, r2, and interpretits meaning.b. Determine the standard error of the estimate.c. How useful do you think this regression model is for predictingaudited sales?Part (b)You used the summatedrating of a restaurant to predict the cost of a meal. The dataare stored in Restaurants. Using the results of that problem,b1 = 1.2409 and Sb1 = 0.1421.a. At the 0.05 level of significance, is there evidence of alinear relationship between the summated rating of arestaurant and the cost of a meal?b. Construct a 95% confidence interval estimate of thepopulation slope, B1.(assume “Calories” is the “x” variable and “Fat” is the “y” variable)Use “Regression” function within the Data Analysis menu in Excel. Please find data needed in workbook