Carrer N 0 PP DHE IH NE + m . L HI to NE way - TH 5 TH M - TH w 1 I In ME U it TH w le IT RE 11 TH 1 tinantis 11 1 IR M 56 31 * RE MW th 18 - 3 IN 60 NAMED AirPoonData General Paste FF Merge & Center $ % ) Conditional Format Formatting as Table 26 A K M N MGTS 312 Independent Lab 6 Questions Restaurant Bertucci's Black Angus Steakhouse Bonefish Grill Bravol Cucina Italiana Buca di Beppo Bugaboo Creek Steak House Carrabba's Italian Grill Charlie Brown's Steakhouse Fornaio Joe's Crab Shack Johnny Carino's Italian Lone Star Steakhouse & Saloon Long Horn Steakhouse Olive Garden Outback Steakhouse Red Lobster Romano's Macaroni Grill The Old Spaghetti Factory Uno Chicago Grill Type Italian Seafood/Steakhouse Seafood/Steakhouse Italian Italian Seafood/Steakhouse Italian Seafood/Steakhouse Italian Seafood/Steakhouse Italian Seafood/Steakhouse Seafood/Steakhouse Italian Seafood/Steakhouse Seafood/Steakhouse Italian Italian Italian D Price (s) Score 16 77 24 79 26 85 18 R44 17 81 18 77 23 86 17 75 28 83 15 71 12 81 17 76 81 81 20 80 18 78 18 82 12 79 16 76 (3) On the Restaurant worksheet, use "Score" as you dependent variable and Price and Type as your independent valables to compute a regression. (To two decimal places) On average, the restaurant's score increases by it is italian (compared to if it was Seafood/Steakhouse), ceteris paribus keeping all else equal (4) On the Restaurant worksheet useScore" as you dependent variable and Price and Type as your independent variables to computea regression. (To three decimal places) The calculated adjusted R-squared is 15) On the Restaurant worksheet useScore" as you dependent variable and Price and Type as your independent variables to computea regression. To two decimal places) The predicted score of an Italian restaurant with an average meal price of $25 is 7 17 E M N 0 P MGTS 312 Independent Lab 6 Questions (6) Create a regression on the Butler worksheet using Time" as your dependent variable and "Miles" and "Deliveries" as your independent variables. (To two decimal places) The calculated coefficients for the intercept, Miles variable and Deliveries variable are and respectively. B C D Assignment Mlles Deliveries Time 1 100 4 9.3 2 50 3 4.8 3 100 4 8.9 100 6.5 5 50 4.2 6 80 6.2 7 75 3 7.4 B 65 4 6 0 9 90 3 7.6 1 10 90 2 6.1 11 80 3 7.2 12 70 6.5 14 13 50 2 8.1 15 16 17 18 19 20 21 NNN MMN (7) Create a regression on the Butler worksheet using "Time" as your dependent variable and "Miles and "Deliveries" as your independent variables. To two decimal places) The predicted time to make 3 deliveries for a total of 70 miles is NN Carrer N 0 PP DHE IH NE + m . L HI to NE way - TH 5 TH M - TH w 1 I In ME U it TH w le IT RE 11 TH 1 tinantis 11 1 IR M 56 31 * RE MW th 18 - 3 IN 60 NAMED AirPoonData General Paste FF Merge & Center $ % ) Conditional Format Formatting as Table 26 A K M N MGTS 312 Independent Lab 6 Questions Restaurant Bertucci's Black Angus Steakhouse Bonefish Grill Bravol Cucina Italiana Buca di Beppo Bugaboo Creek Steak House Carrabba's Italian Grill Charlie Brown's Steakhouse Fornaio Joe's Crab Shack Johnny Carino's Italian Lone Star Steakhouse & Saloon Long Horn Steakhouse Olive Garden Outback Steakhouse Red Lobster Romano's Macaroni Grill The Old Spaghetti Factory Uno Chicago Grill Type Italian Seafood/Steakhouse Seafood/Steakhouse Italian Italian Seafood/Steakhouse Italian Seafood/Steakhouse Italian Seafood/Steakhouse Italian Seafood/Steakhouse Seafood/Steakhouse Italian Seafood/Steakhouse Seafood/Steakhouse Italian Italian Italian D Price (s) Score 16 77 24 79 26 85 18 R44 17 81 18 77 23 86 17 75 28 83 15 71 12 81 17 76 81 81 20 80 18 78 18 82 12 79 16 76 (3) On the Restaurant worksheet, use "Score" as you dependent variable and Price and Type as your independent valables to compute a regression. (To two decimal places) On average, the restaurant's score increases by it is italian (compared to if it was Seafood/Steakhouse), ceteris paribus keeping all else equal (4) On the Restaurant worksheet useScore" as you dependent variable and Price and Type as your independent variables to computea regression. (To three decimal places) The calculated adjusted R-squared is 15) On the Restaurant worksheet useScore" as you dependent variable and Price and Type as your independent variables to computea regression. To two decimal places) The predicted score of an Italian restaurant with an average meal price of $25 is 7 17 E M N 0 P MGTS 312 Independent Lab 6 Questions (6) Create a regression on the Butler worksheet using Time" as your dependent variable and "Miles" and "Deliveries" as your independent variables. (To two decimal places) The calculated coefficients for the intercept, Miles variable and Deliveries variable are and respectively. B C D Assignment Mlles Deliveries Time 1 100 4 9.3 2 50 3 4.8 3 100 4 8.9 100 6.5 5 50 4.2 6 80 6.2 7 75 3 7.4 B 65 4 6 0 9 90 3 7.6 1 10 90 2 6.1 11 80 3 7.2 12 70 6.5 14 13 50 2 8.1 15 16 17 18 19 20 21 NNN MMN (7) Create a regression on the Butler worksheet using "Time" as your dependent variable and "Miles and "Deliveries" as your independent variables. To two decimal places) The predicted time to make 3 deliveries for a total of 70 miles is NN