A magazine publishes restaurant ratings for various locations around the world. The magazine rates the restaurants for food, decor, service, and the cost per person. Develop a regression model to predict the cost per person, based on a variable that represents the sum of the three ratings. The magazine has compiled the accompanying table of this summated ratings variable and the cost per person for 25 restaurants in a major city. Assuming a linear relationship, use the least-squares method to compute the regression coefficients b0 and b1. ExcelFileEditViewInsertFormatToolsDataWindowHelp25% IWed 4:59 PMAutoSaveA data-12 15_2021-4_59 PM vOFFHomeInsertDrawPage LayoutFormulasDataReviewViewTell meA ShareCommentsInsert vCalibri11A Aab2 Wrap Text vGeneralDelete v$ v % 9Conditional FormatFind &.0000 20AnalyzeDataPasteUMerge & Center vCellSort &SensitivityFormatting as TableStylesFormat vFilterSelectOpen recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off?YesNoA1fx Summated_RatingACDFGHJKLMQUVW1Summated_RatingCost ($_per_person)254403674946762656166447614153439.61401051341151341250401352371475851561511652351750371855301944222057392154462263642362612452292571452668462728293031323334353637+Ready100%16,382DEC415囲P. OB.ACost ($)90-0+90Rating

The data shows the summated ratings variable and the cost per person for 25 restaurants in a major city.A regression model to predict the cost per person, based on a variable that represents the sum of the three ratings. That is, x be the sum of the three ratings, and y be the cost per person. The sums are, x y x2 xy 54 40 2916 2160 67 49 4489 3283 67 62 4489 4154 65 61 4225 3965 66 44 4356 2904 61 41 3721 2501 53 43 2809 2279 61 40 3721 2440 51 34 2601 1734 51 34 2601 1734 50 40 2500 2000 52 37 2704 1924 75 85 5625 6375 61 51 3721 3111 52 35 2704 1820 50 37 2500 1850 55 30 3025 1650 44 22 1936 968 57 39 3249 2223 54 46 2916 2484 63 64 3969 4032 62 61 3844 3782 52 29 2704 1508 71 45 5041 3195 68 46 4624 3128 Sum = 1462 Sum = 1115 Sum = 86990 Sum = 67204 The coefficient b1 is, b1=n∑xy-∑x∑yn∑x2-∑x2=25×67204-1462×111525×86990-14622=4997037306=1.3394628≈1.3395 Thus, the coefficient b1 is 1.3395. The coefficient b0 is, b0=∑y-b1∑xn=1115-1.3394628146225=-843.294613625=-33.7318 Thus, the coefficient b0 is -33.7318.