Item Name Menu Category Protein Total Fat Total Carbs Fiber Weight Watchers Calories Apple Slices Snacks and Sides 0 0 4 0 0 15 Bacon, Egg Cheese Bagel Breakfast 30 32 57 3 17 630 Bacon, Egg Cheese Bagel with Egg Whites Breakfast 30 26 55 3 15 580 Bacon, Egg Cheese Biscuit (Large Size Biscuit) Breakfast 19 30 43 3 14 520 Bacon, Egg Cheese Biscuit (Regular Size Biscuit) Breakfast 19 26 38 2 13 460 Bacon, Egg Cheese Biscuit with Egg Whites (Large Biscuit) Breakfast 20 25 42 3 13 470 Bacon, Egg Cheese Biscuit with Egg Whites (RegularBiscuit) Breakfast 20 20 36 2 11 410 Bacon, Egg Cheese McGriddles Breakfast 19 21 48 2 12 460 Bacon, Egg Cheese McGriddles with Egg Whites Breakfast 20 15 47 2 11 400 Baked Hot Apple Pie Desserts and Shakes 2 13 32 4 7 250 Big Breakfast with Egg Whites (Large Size Biscuit) Breakfast 26 41 55 4 19 690 Big Breakfast with Egg Whites (Regular Size Biscuit) Breakfast 26 37 50 3 17 640 Big Breakfast with Hotcakes (Large Size Biscuit) Breakfast 36 60 116 7 32 1150 Big Breakfast with Hotcakes (Regular Size Biscuit) Breakfast 36 56 111 6 30 1090 Big Breakfast with Hotcakes and Egg Whites (Large Biscuit) Breakfast 35 50 115 7 29 1050 Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit) Breakfast 35 46 110 6 27 990 Big Breakfast (Large Size Biscuit) Breakfast 28 52 56 4 22 800 Big Breakfast (Regular Size Biscuit) Breakfast 28 48 51 3 21 740 Big Mac Burgers and Sandwiches 25 29 46 3 15 550 Blueberry Pomegranate Smoothie (Large) Beverages 4 1 79 5 9 340 Blueberry Pomegranate Smoothie (Medium) Beverages 3 1 62 4 7 260 Blueberry Pomegranate Smoothie (Small) Beverages 2 1 50 3 6 220 Caramel Latte (Large) Beverages 15 14 62 1 12 430 Caramel Latte (Medium) Beverages 11 10 50 1 9 340 Caramel Latte (Small) Beverages 9 9 40 1 8 270 Caramel Mocha (Large) Beverages 16 17 66 1 13 480 Caramel Mocha (Medium) Beverages 12 14 55 1 11 390 Caramel Mocha (Small) Beverages 10 11 45 1 9 320 Cheeseburger Burgers and Sandwiches 15 12 33 2 8 300 Cherry Berry Chiller (Small) Beverages 1 0 49 0 5 200 Chicken McNuggets (10 piece) Chicken and Fish 22 30 30 2 13 470 Chicken McNuggets (20 piece) Chicken and Fish 44 59 59 3 26 940 Chicken McNuggets (4 piece) Chicken and Fish 9 12 12 1 5 190 Chicken McNuggets (6 piece) Chicken and Fish 13 18 18 1 8 280 Chicken Selects Premium Breast Strips (5 pc) Chicken and Fish 38 38 36 1 17 640 Chipotle BBQ Snack Wrap (Crispy) Burgers and Sandwiches 14 15 34 1 9 330 Chipotle BBQ Snack Wrap (Grilled) Burgers and Sandwiches 16 8 27 1 6 250 Chocolate Chip Cookie Desserts and Shakes 2 8 21 1 5 160 Chocolate McCaf Shake (12 fl oz cup) Beverages 12 16 91 1 15 560 Chocolate McCaf Shake (16 fl oz cup) Beverages 15 20 114 2 19 700 Chocolate McCaf Shake (22 fl oz cup) Beverages 19 23 141 2 23 850 Cinnamon Melts Breakfast 6 19 66 3 13 460 Coffee (Large) Beverages 0 0 0 0 0 0 Coffee (Medium) Beverages 0 0 0 0 0 0 Coffee (Small) Beverages 0 0 0 0 0 0 Daily Double Burgers and Sandwiches 23 24 33 2 12 440 Double Cheeseburger Burgers and Sandwiches 25 23 34 2 12 440 Double Quarter Pounder with Cheese Burgers and Sandwiches 48 43 42 3 20 750 Egg McMuffin Breakfast 18 12 32 4 8 300 Egg Nog McCafe Shake (16 fl oz cup) Medium Desserts and Shakes 14 19 111 0 18 680 Egg Nog McCafe Shake (22 fl oz cup) Large Desserts and Shakes 18 23 137 0 22 830 Egg White Delight Breakfast 18 7 32 5 7 250 Filet O Fish Burgers and Sandwiches 15 19 39 2 11 390 Frappe Caramel (Large) Beverages 11 27 96 0 18 670 Frappe Caramel (Medium) Beverages 9 23 79 0 15 550 Frappe Caramel (Small) Beverages 7 19 64 0 12 450 Frappe Chocolate Chip (Large) Beverages 12 31 111 1 21 760 Frappe Chocolate Chip (Medium) Beverages 9 26 91 1 17 630 Frappe Chocolate Chip (Small) Beverages 8 23 76 1 15 530 Frappe Mocha (Large) Beverages 11 26 98 1 18 670 Frappe Mocha (Medium) Beverages 9 22 80 1 15 550 Frappe Mocha (Small) Beverages 7 18 65 1 12 450 French Vanilla Latte (Large) Beverages 15 14 60 1 12 420 French Vanilla Latte (Medium) Beverages 11 10 48 1 9 330 French Vanilla Latte (Small) Beverages 9 9 38 1 7 260 Fruit Maple Oatmeal Breakfast 5 4 58 5 8 290 Fruit Maple Oatmeal without Brown Sugar Breakfast 5 4 49 5 7 260 Fruit 'n Yogurt Parfait Desserts and Shakes 4 2 30 1 4 150 Grilled Onion Cheddar Burgers and Sandwiches 15 13 33 2 8 310 Hamburger Burgers and Sandwiches 12 9 31 2 7 250 Hash Brown Breakfast 1 9 15 2 4 150 Hazelnut Latte (Large) Beverages 15 14 62 1 12 430 Hazelnut Latte (Medium) Beverages 11 10 50 1 9 330 Hazelnut Latte (Small) Beverages 9 9 40 1 8 270 Honey Mustard Snack Wrap (Crispy) Burgers and Sandwiches 14 15 33 1 9 330 Honey Mustard Snack Wrap (Grilled) Burgers and Sandwiches 16 8 27 1 6 250 Hot Caramel Sundae Desserts and Shakes 7 8 60 0 9 340 Hot Chocolate (Large) Beverages 17 20 73 1 15 540 Hot Chocolate (Medium) Beverages 14 16 61 1 12 440 Hot Chocolate (Small) Beverages 11 13 50 1 10 360 Hot Chocolate with Nonfat Milk (Large) Beverages 19 4 74 1 11 400 Hot Chocolate with Nonfat Milk (Medium) Beverages 14 4 61 1 9 340 Hot Chocolate with Nonfat Milk (Small) Beverages 12 4 50 1 7 280 Hot Fudge Sundae Desserts and Shakes 8 9 53 1 9 330 Hotcakes Breakfast 8 9 60 3 10 350 Hotcakes and Sausage Breakfast 15 24 61 3 14 520 Iced Caramel Mocha (Large) Beverages 13 16 65 1 12 460 Iced Caramel Mocha (Medium) Beverages 9 13 46 1 9 340 Iced Caramel Mocha (Small) Beverages 8 11 38 0 8 280 Iced Coffee Caramel (Large) Beverages 2 9 43 0 7 260 Iced Coffee Caramel (Medium) Beverages 1 7 29 0 5 180 Iced Coffee Caramel (Small) Beverages 1 5 22 0 4 130 Iced Coffee French Vanilla (Large) Beverages 2 9 41 0 7 240 Iced Coffee French Vanilla (Medium) Beverages 1 7 27 0 5 170 Iced Coffee French Vanilla (Small) Beverages 1 5 20 0 3 120 Iced Coffee Hazelnut (Large) Beverages 2 9 43 0 7 250 Iced Coffee Hazelnut (Medium) Beverages 1 7 29 0 5 180 Iced Coffee Hazelnut (Small) Beverages 1 5 21 0 4 130 Iced Coffee Regular (Large) Beverages 2 9 47 0 8 270 Iced Coffee Regular (Medium) Beverages 1 7 31 0 5 190 Iced Coffee Regular (Small) Beverages 1 5 23 0 4 140 Iced Coffee with Sugar Free French Vanilla Syrup (Large) Beverages 2 9 18 0 4 160 Iced Coffee with Sugar Free French Vanilla Syrup (Medium) Beverages 1 7 12 0 3 120 Iced Coffee with Sugar Free French Vanilla Syrup (Small) Beverages 1 5 9 0 2 80 Iced Mocha (Large) Beverages 14 16 70 2 13 480 Iced Mocha (Medium) Beverages 9 13 50 1 10 350 Iced Mocha (Small) Beverages 8 11 41 1 8 290 Iced Mocha with Nonfat Milk (Large) Beverages 14 6 71 2 11 390 Iced Mocha with Nonfat Milk (Medium) Beverages 10 5 50 1 8 290 Iced Mocha with Nonfat Milk (Small) Beverages 8 5 41 1 6 240 Iced Nonfat Caramel Mocha (Large) Beverages 14 6 65 1 10 370 Iced Nonfat Caramel Mocha (Medium) Beverages 10 5 47 1 7 270 Iced Nonfat Caramel Mocha (Small) Beverages 8 5 38 0 6 230 Kiddie Cone Desserts and Shakes 1 2 7 0 1 45 Kids Fries Snacks and Sides 1 5 13 1 3 100 Large French Fries Snacks and Sides 6 25 63 6 14 500 Latte (Large) Beverages 15 14 24 1 8 280 Latte (Medium) Beverages 11 10 18 1 6 210 Latte (Small) Beverages 9 9 15 1 5 170 Latte with Sugar Free French Vanilla Syrup (Large) Beverages 15 14 37 2 9 330 Latte with Sugar Free French Vanilla Syrup (Medium) Beverages 12 10 29 1 7 260 Latte with Sugar Free French Vanilla Syrup (Small) Beverages 9 9 24 1 6 210 Mac Snack Wrap Burgers and Sandwiches 14 19 26 1 9 330 Mango Pineapple Smoothie (Large) Beverages 5 2 78 4 9 340 Mango Pineapple Smoothie (Medium) Beverages 3 1 61 3 7 270 Mango Pineapple Smoothie (Small) Beverages 3 1 49 2 6 220 McCaf Caramel Hot Chocolate with Nonfat Milk (Large) Beverages 18 4 68 0 10 380 McCaf Caramel Hot Chocolate with Nonfat Milk (Medium) Beverages 14 4 57 0 8 310 McCaf Caramel Hot Chocolate with Nonfat Milk (Small) Beverages 11 4 46 0 7 260 McChicken Burgers and Sandwiches 14 16 40 2 10 360 McDouble Burgers and Sandwiches 23 19 33 2 11 390 McFlurry with M M'S Candies (12 fl oz cup) Desserts and Shakes 13 23 96 1 18 650 McFlurry with M M'S Candies (16 fl oz cup) Desserts and Shakes 20 33 139 2 25 930 McFlurry with OREO Cookies (12 fl oz cup) Desserts and Shakes 12 17 80 1 14 510 McFlurry with OREO Cookies (16 fl oz cup) Desserts and Shakes 15 23 106 1 19 690 McFlurry with Reese's Peanut Butter Cup (16 fl oz cup) Desserts and Shakes 21 32 114 2 23 810 McRib Burgers and Sandwiches 22 26 44 3 14 500 Medium French Fries Snacks and Sides 4 19 48 5 11 380 Mocha (Large) Beverages 16 17 72 2 14 500 Mocha (Medium) Beverages 13 14 60 2 11 410 Mocha (Small) Beverages 10 11 49 2 9 340 Mocha with Nonfat Milk (Large) Beverages 17 4 73 2 11 390 Mocha with Nonfat Milk (Medium) Beverages 13 4 60 2 9 330 Mocha with Nonfat Milk (Small) Beverages 11 4 49 2 7 270 Nonfat Caramel Latte (Large) Beverages 16 1 63 1 8 310 Nonfat Caramel Latte (Medium) Beverages 12 0 51 1 7 250 Nonfat Caramel Latte (Small) Beverages 10 0 41 1 5 200 Nonfat Caramel Mocha (Large) Beverages 17 4 67 1 10 370 Nonfat Caramel Mocha (Medium) Beverages 13 4 56 1 8 310 Nonfat Caramel Mocha (Small) Beverages 10 4 45 1 7 250 Nonfat French Vanilla Latte (Large) Beverages 16 1 60 1 8 300 Nonfat French Vanilla Latte (Medium) Beverages 12 0 49 1 6 240 Nonfat French Vanilla Latte (Small) Beverages 10 0 39 1 5 190 Nonfat Hazelnut Latte (Large) Beverages 16 1 63 1 8 310 Nonfat Hazelnut Latte (Medium) Beverages 12 0 51 1 7 250 Nonfat Hazelnut Latte (Small) Beverages 10 0 40 1 5 200 Nonfat Latte (Large) Beverages 16 1 25 1 4 170 Nonfat Latte (Medium) Beverages 12 0 19 1 3 130 Nonfat Latte (Small) Beverages 10 0 15 1 3 100 Nonfat Latte with Sugar Free French Vanilla Syrup (Large) Beverages 16 1 38 2 6 220 Nonfat Latte with Sugar Free French Vanilla Syrup (Medium) Beverages 12 0 30 1 4 170 Nonfat Latte with Sugar Free French Vanilla Syrup (Small) Beverages 10 0 24 1 4 140 Oatmeal Raisin Cookie Desserts and Shakes 2 6 22 1 4 150 Premium Bacon Ranch Salad (without chicken) Salads 9 7 10 3 4 140 Premium Bacon Ranch Salad with Crispy Chicken Salads 26 22 24 4 11 390 Premium Bacon Ranch Salad with Grilled Chicken Salads 30 9 10 4 6 230 Premium Caesar Salad (without chicken) Salads 7 4 9 3 3 90 Premium Caesar Salad with Crispy Chicken Salads 23 18 24 4 9 350 Premium Caesar Salad with Grilled Chicken Salads 27 5 10 4 5 190 Premium Crispy Chicken Classic Sandwich Burgers and Sandwiches 24 22 55 3 14 510 Premium Crispy Chicken Club Sandwich Burgers and Sandwiches 36 33 58 3 18 670 Premium Crispy Chicken Ranch BLT Sandwich Burgers and Sandwiches 32 27 57 3 16 590 Premium Grilled Chicken Classic Sandwich Burgers and Sandwiches 28 9 42 3 10 350 Premium Grilled Chicken Club Sandwich Burgers and Sandwiches 40 20 44 3 14 510 Premium Grilled Chicken Ranch BLT Sandwich Burgers and Sandwiches 36 14 43 3 12 440 Premium McWrap Chicken Bacon (Crispy) Burgers and Sandwiches 32 31 54 3 17 620 Premium McWrap Chicken Bacon (Grilled) Burgers and Sandwiches 35 18 40 3 12 460 Premium McWrap Chicken Ranch (Crispy) Burgers and Sandwiches 26 29 55 3 16 580 Premium McWrap Chicken Ranch (Grilled) Burgers and Sandwiches 30 16 41 3 11 420 Premium McWrap Chicken Sweet Chili (Crispy) Burgers and Sandwiches 23 22 57 2 14 520 Premium McWrap Chicken Sweet Chili (Grilled) Burgers and Sandwiches 26 9 43 2 9 360 Premium Southwest Salad (without chicken) Salads 6 5 20 6 4 140 Premium Southwest Salad with Crispy Chicken Salads 23 21 42 7 12 450 Premium Southwest Salad with Grilled Chicken Salads 27 8 28 7 8 290 Quarter Pounder Bacon Cheese Burgers and Sandwiches 37 29 48 3 16 600 Quarter Pounder Bacon Habanero Ranch Burgers and Sandwiches 37 31 46 3 16 610 Quarter Pounder Deluxe Burgers and Sandwiches 29 27 45 3 15 540 Quarter Pounder with Cheese Burgers and Sandwiches 30 26 41 3 14 520 Ranch Snack Wrap (Crispy) Burgers and Sandwiches 14 19 32 1 10 350 Ranch Snack Wrap (Grilled) Burgers and Sandwiches 16 12 25 1 7 270 Sausage Biscuit (Large Size Biscuit) Breakfast 11 31 39 3 13 480 Sausage Biscuit (Regular Size Biscuit) Breakfast 11 27 34 2 12 430 Sausage Biscuit with Egg (Large Size Biscuit) Breakfast 18 37 42 3 16 570 Sausage Biscuit with Egg (Regular Size Biscuit) Breakfast 18 33 36 2 14 510 Sausage Biscuit with Egg Whites (Large Size Biscuit) Breakfast 18 32 40 3 14 520 Sausage Biscuit with Egg Whites (Regular Size Biscuit) Breakfast 18 27 34 2 12 460 Sausage Burrito Breakfast 12 16 26 1 8 300 Sausage McGriddles Breakfast 11 22 44 2 11 420 Sausage McMuffin with Egg Whites Breakfast 22 22 31 5 11 400 Sausage McMuffin Breakfast 15 22 31 4 11 370 Sausage McMuffin with Egg Breakfast 21 27 32 4 12 450 Sausage, Egg Cheese McGriddles with Egg Whites Breakfast 21 26 46 2 14 500 Sausage, Egg Cheese McGriddles Breakfast 20 31 48 2 15 550 Side Salad Salads 1 0 4 1 1 20 Small French Fries Snacks and Sides 3 11 29 3 6 230 Snack Size Holiday Mint McFlurry Desserts and Shakes 8 14 56 0 10 380 Snack Size McFlurry with M M'S Candies Desserts and Shakes 9 15 64 1 12 430 Snack Size McFlurry with OREO Cookies Desserts and Shakes 8 11 53 1 9 340 Snack Size McFlurry with Reese's Peanut Butter Cup Desserts and Shakes 10 16 57 1 11 410 Snack Size McFlurry with Rolo Desserts and Shakes 10 16 84 1 14 510 Southern Style Chicken Biscuit (Large Size Biscuit) Breakfast 17 24 46 3 13 470 Southern Style Chicken Biscuit (Regular Size Biscuit) Breakfast 17 20 41 2 11 410 Southern Style Crispy Chicken Sandwich Burgers and Sandwiches 21 19 43 2 12 420 Spicy Chicken McBites Shareable Size Chicken and Fish 1 500 83 20 138 284 Spicy Chicken McBites Snack Size Chicken and Fish 0 150 25 6 41 85 Strawberry Banana Smoothie (Large) Beverages 5 1 74 4 9 330 Strawberry Banana Smoothie (Medium) Beverages 4 1 58 3 7 250 Strawberry Banana Smoothie (Small) Beverages 3 1 47 3 6 210 Strawberry McCaf Shake (12 fl oz cup) Desserts and Shakes 12 16 90 0 15 550 Strawberry McCaf Shake (16 fl oz cup) Desserts and Shakes 15 20 114 0 19 690 Strawberry McCaf Shake (22 fl oz cup) Desserts and Shakes 18 24 140 0 23 850 Strawberry Sundae Desserts and Shakes 6 6 49 0 7 280 Vanilla McCaf Shake (12 fl oz cup) Desserts and Shakes 11 15 86 0 14 530 Vanilla McCaf Shake (16 fl oz cup) Desserts and Shakes 14 19 109 0 18 660 Vanilla McCaf Shake (22 fl oz cup) Desserts and Shakes 18 23 135 0 22 820 Vanilla Reduced Fat Ice Cream Cone Desserts and Shakes 5 5 27 0 5 170 Wild Berry Smoothie (Large) Beverages 5 1 71 5 9 310 Wild Berry Smoothie (Medium) Beverages 4 1 57 4 7 250 To answer this question, use upper data For (a) (b), you need to take the following steps Create an R Script file where you write your codes Import the data set in to R Set up a linear regression model in R (according to what you're asked under items (a) (b)) Get the summary of your model (the outputs) a) Use the upper excel data to estimate the following regression model y a b 1 x 1 b 2 x 2 bx 3 y calories x 1 protein (in grams) x 2 fat (in grams) x 3 carbohydrate (in grams) Write the estimated model based on the regression report (Hint 1 instead of b1 , b2 , and b3 in the equation above, use the coefficients reported by R) (Hint 2 Copy and paste the regression report below, make sure that your output is readable ) b) There is data on Weight Watchers (WW) points for each meal in the given set of records WW is a weight loss program that assigns a numerical score to all meals and food items, and gives you a total number of points to target for a day WW claims that they their system is elaborate and does not directly count calories Among the 4 nutrients (fat, protein, carbohydrates, and fiber), which one costs the most in WW points and which the least How much is the difference (Hint compute a regression model, where dependent variable is WW points and the 4 nutrients are independent variables)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jun 20, 2024

Item_Name Menu_Category Protein Total_Fat Total_Carbs Fiber Weight_Watchers Calories Apple Slices Snacks and Sides 0 0 4 0 0 15 Bacon, Egg & Cheese Bagel Breakfast

Item_Name	Menu_Category	Protein	Total_Fat	Total_Carbs	Fiber	Weight_Watchers	Calories
Apple Slices	Snacks and Sides	0	0	4	0	0	15
Bacon, Egg & Cheese Bagel	Breakfast	30	32	57	3	17	630
Bacon, Egg & Cheese Bagel with Egg Whites	Breakfast	30	26	55	3	15	580
Bacon, Egg & Cheese Biscuit (Large Size Biscuit)	Breakfast	19	30	43	3	14	520
Bacon, Egg & Cheese Biscuit (Regular Size Biscuit)	Breakfast	19	26	38	2	13	460
Bacon, Egg & Cheese Biscuit with Egg Whites (Large Biscuit)	Breakfast	20	25	42	3	13	470
Bacon, Egg & Cheese Biscuit with Egg Whites (RegularBiscuit)	Breakfast	20	20	36	2	11	410
Bacon, Egg & Cheese McGriddles	Breakfast	19	21	48	2	12	460
Bacon, Egg & Cheese McGriddles with Egg Whites	Breakfast	20	15	47	2	11	400
Baked Hot Apple Pie	Desserts and Shakes	2	13	32	4	7	250
Big Breakfast with Egg Whites (Large Size Biscuit)	Breakfast	26	41	55	4	19	690
Big Breakfast with Egg Whites (Regular Size Biscuit)	Breakfast	26	37	50	3	17	640
Big Breakfast with Hotcakes (Large Size Biscuit)	Breakfast	36	60	116	7	32	1150
Big Breakfast with Hotcakes (Regular Size Biscuit)	Breakfast	36	56	111	6	30	1090
Big Breakfast with Hotcakes and Egg Whites (Large Biscuit)	Breakfast	35	50	115	7	29	1050
Big Breakfast with Hotcakes and Egg Whites (Regular Biscuit)	Breakfast	35	46	110	6	27	990
Big Breakfast (Large Size Biscuit)	Breakfast	28	52	56	4	22	800
Big Breakfast (Regular Size Biscuit)	Breakfast	28	48	51	3	21	740
Big Mac	Burgers and Sandwiches	25	29	46	3	15	550
Blueberry Pomegranate Smoothie (Large)	Beverages	4	1	79	5	9	340
Blueberry Pomegranate Smoothie (Medium)	Beverages	3	1	62	4	7	260
Blueberry Pomegranate Smoothie (Small)	Beverages	2	1	50	3	6	220
Caramel Latte (Large)	Beverages	15	14	62	1	12	430
Caramel Latte (Medium)	Beverages	11	10	50	1	9	340
Caramel Latte (Small)	Beverages	9	9	40	1	8	270
Caramel Mocha (Large)	Beverages	16	17	66	1	13	480
Caramel Mocha (Medium)	Beverages	12	14	55	1	11	390
Caramel Mocha (Small)	Beverages	10	11	45	1	9	320
Cheeseburger	Burgers and Sandwiches	15	12	33	2	8	300
Cherry Berry Chiller (Small)	Beverages	1	0	49	0	5	200
Chicken McNuggets (10 piece)	Chicken and Fish	22	30	30	2	13	470
Chicken McNuggets (20 piece)**	Chicken and Fish	44	59	59	3	26	940
Chicken McNuggets (4 piece)	Chicken and Fish	9	12	12	1	5	190
Chicken McNuggets (6 piece)	Chicken and Fish	13	18	18	1	8	280
Chicken Selects Premium Breast Strips (5 pc)	Chicken and Fish	38	38	36	1	17	640
Chipotle BBQ Snack Wrap (Crispy)	Burgers and Sandwiches	14	15	34	1	9	330
Chipotle BBQ Snack Wrap (Grilled)	Burgers and Sandwiches	16	8	27	1	6	250
Chocolate Chip Cookie	Desserts and Shakes	2	8	21	1	5	160
Chocolate McCaf Shake (12 fl oz cup)	Beverages	12	16	91	1	15	560
Chocolate McCaf Shake (16 fl oz cup)	Beverages	15	20	114	2	19	700
Chocolate McCaf Shake (22 fl oz cup)	Beverages	19	23	141	2	23	850
Cinnamon Melts	Breakfast	6	19	66	3	13	460
Coffee (Large)	Beverages	0	0	0	0	0	0
Coffee (Medium)	Beverages	0	0	0	0	0	0
Coffee (Small)	Beverages	0	0	0	0	0	0
Daily Double	Burgers and Sandwiches	23	24	33	2	12	440
Double Cheeseburger	Burgers and Sandwiches	25	23	34	2	12	440
Double Quarter Pounder with Cheese	Burgers and Sandwiches	48	43	42	3	20	750
Egg McMuffin	Breakfast	18	12	32	4	8	300
Egg Nog McCafe Shake (16 fl oz cup) Medium	Desserts and Shakes	14	19	111	0	18	680
Egg Nog McCafe Shake (22 fl oz cup) Large	Desserts and Shakes	18	23	137	0	22	830
Egg White Delight	Breakfast	18	7	32	5	7	250
Filet-O-Fish	Burgers and Sandwiches	15	19	39	2	11	390
Frappe Caramel (Large)	Beverages	11	27	96	0	18	670
Frappe Caramel (Medium)	Beverages	9	23	79	0	15	550
Frappe Caramel (Small)	Beverages	7	19	64	0	12	450
Frappe Chocolate Chip (Large)	Beverages	12	31	111	1	21	760
Frappe Chocolate Chip (Medium)	Beverages	9	26	91	1	17	630
Frappe Chocolate Chip (Small)	Beverages	8	23	76	1	15	530
Frappe Mocha (Large)	Beverages	11	26	98	1	18	670
Frappe Mocha (Medium)	Beverages	9	22	80	1	15	550
Frappe Mocha (Small)	Beverages	7	18	65	1	12	450
French Vanilla Latte (Large)	Beverages	15	14	60	1	12	420
French Vanilla Latte (Medium)	Beverages	11	10	48	1	9	330
French Vanilla Latte (Small)	Beverages	9	9	38	1	7	260
Fruit & Maple Oatmeal	Breakfast	5	4	58	5	8	290
Fruit & Maple Oatmeal without Brown Sugar	Breakfast	5	4	49	5	7	260
Fruit 'n Yogurt Parfait	Desserts and Shakes	4	2	30	1	4	150
Grilled Onion Cheddar	Burgers and Sandwiches	15	13	33	2	8	310
Hamburger	Burgers and Sandwiches	12	9	31	2	7	250
Hash Brown	Breakfast	1	9	15	2	4	150
Hazelnut Latte (Large)	Beverages	15	14	62	1	12	430
Hazelnut Latte (Medium)	Beverages	11	10	50	1	9	330
Hazelnut Latte (Small)	Beverages	9	9	40	1	8	270
Honey Mustard Snack Wrap (Crispy)	Burgers and Sandwiches	14	15	33	1	9	330
Honey Mustard Snack Wrap (Grilled)	Burgers and Sandwiches	16	8	27	1	6	250
Hot Caramel Sundae	Desserts and Shakes	7	8	60	0	9	340
Hot Chocolate (Large)	Beverages	17	20	73	1	15	540
Hot Chocolate (Medium)	Beverages	14	16	61	1	12	440
Hot Chocolate (Small)	Beverages	11	13	50	1	10	360
Hot Chocolate with Nonfat Milk (Large)	Beverages	19	4	74	1	11	400
Hot Chocolate with Nonfat Milk (Medium)	Beverages	14	4	61	1	9	340
Hot Chocolate with Nonfat Milk (Small)	Beverages	12	4	50	1	7	280
Hot Fudge Sundae	Desserts and Shakes	8	9	53	1	9	330
Hotcakes	Breakfast	8	9	60	3	10	350
Hotcakes and Sausage	Breakfast	15	24	61	3	14	520
Iced Caramel Mocha (Large)	Beverages	13	16	65	1	12	460
Iced Caramel Mocha (Medium)	Beverages	9	13	46	1	9	340
Iced Caramel Mocha (Small)	Beverages	8	11	38	0	8	280
Iced Coffee- Caramel (Large)	Beverages	2	9	43	0	7	260
Iced Coffee- Caramel (Medium)	Beverages	1	7	29	0	5	180
Iced Coffee- Caramel (Small)	Beverages	1	5	22	0	4	130
Iced Coffee- French Vanilla (Large)	Beverages	2	9	41	0	7	240
Iced Coffee- French Vanilla (Medium)	Beverages	1	7	27	0	5	170
Iced Coffee- French Vanilla (Small)	Beverages	1	5	20	0	3	120
Iced Coffee- Hazelnut (Large)	Beverages	2	9	43	0	7	250
Iced Coffee- Hazelnut (Medium)	Beverages	1	7	29	0	5	180
Iced Coffee- Hazelnut (Small)	Beverages	1	5	21	0	4	130
Iced Coffee- Regular (Large)	Beverages	2	9	47	0	8	270
Iced Coffee- Regular (Medium)	Beverages	1	7	31	0	5	190
Iced Coffee- Regular (Small)	Beverages	1	5	23	0	4	140
Iced Coffee with Sugar Free French Vanilla Syrup (Large)	Beverages	2	9	18	0	4	160
Iced Coffee with Sugar Free French Vanilla Syrup (Medium)	Beverages	1	7	12	0	3	120
Iced Coffee with Sugar Free French Vanilla Syrup (Small)	Beverages	1	5	9	0	2	80
Iced Mocha (Large)	Beverages	14	16	70	2	13	480
Iced Mocha (Medium)	Beverages	9	13	50	1	10	350
Iced Mocha (Small)	Beverages	8	11	41	1	8	290
Iced Mocha with Nonfat Milk (Large)	Beverages	14	6	71	2	11	390
Iced Mocha with Nonfat Milk (Medium)	Beverages	10	5	50	1	8	290
Iced Mocha with Nonfat Milk (Small)	Beverages	8	5	41	1	6	240
Iced Nonfat Caramel Mocha (Large)	Beverages	14	6	65	1	10	370
Iced Nonfat Caramel Mocha (Medium)	Beverages	10	5	47	1	7	270
Iced Nonfat Caramel Mocha (Small)	Beverages	8	5	38	0	6	230
Kiddie Cone	Desserts and Shakes	1	2	7	0	1	45
Kids Fries	Snacks and Sides	1	5	13	1	3	100
Large French Fries	Snacks and Sides	6	25	63	6	14	500
Latte (Large)	Beverages	15	14	24	1	8	280
Latte (Medium)	Beverages	11	10	18	1	6	210
Latte (Small)	Beverages	9	9	15	1	5	170
Latte with Sugar Free French Vanilla Syrup (Large)	Beverages	15	14	37	2	9	330
Latte with Sugar Free French Vanilla Syrup (Medium)	Beverages	12	10	29	1	7	260
Latte with Sugar Free French Vanilla Syrup (Small)	Beverages	9	9	24	1	6	210
Mac Snack Wrap	Burgers and Sandwiches	14	19	26	1	9	330
Mango Pineapple Smoothie (Large)	Beverages	5	2	78	4	9	340
Mango Pineapple Smoothie (Medium)	Beverages	3	1	61	3	7	270
Mango Pineapple Smoothie (Small)	Beverages	3	1	49	2	6	220
McCaf Caramel Hot Chocolate with Nonfat Milk (Large)	Beverages	18	4	68	0	10	380
McCaf Caramel Hot Chocolate with Nonfat Milk (Medium)	Beverages	14	4	57	0	8	310
McCaf Caramel Hot Chocolate with Nonfat Milk (Small)	Beverages	11	4	46	0	7	260
McChicken	Burgers and Sandwiches	14	16	40	2	10	360
McDouble	Burgers and Sandwiches	23	19	33	2	11	390
McFlurry with M&M'S Candies (12 fl oz cup)	Desserts and Shakes	13	23	96	1	18	650
McFlurry with M&M'S Candies (16 fl oz cup)	Desserts and Shakes	20	33	139	2	25	930
McFlurry with OREO Cookies (12 fl oz cup)	Desserts and Shakes	12	17	80	1	14	510
McFlurry with OREO Cookies (16 fl oz cup)	Desserts and Shakes	15	23	106	1	19	690
McFlurry with Reese's Peanut Butter Cup (16 fl oz cup)	Desserts and Shakes	21	32	114	2	23	810
McRib	Burgers and Sandwiches	22	26	44	3	14	500
Medium French Fries	Snacks and Sides	4	19	48	5	11	380
Mocha (Large)	Beverages	16	17	72	2	14	500
Mocha (Medium)	Beverages	13	14	60	2	11	410
Mocha (Small)	Beverages	10	11	49	2	9	340
Mocha with Nonfat Milk (Large)	Beverages	17	4	73	2	11	390
Mocha with Nonfat Milk (Medium)	Beverages	13	4	60	2	9	330
Mocha with Nonfat Milk (Small)	Beverages	11	4	49	2	7	270
Nonfat Caramel Latte (Large)	Beverages	16	1	63	1	8	310
Nonfat Caramel Latte (Medium)	Beverages	12	0	51	1	7	250
Nonfat Caramel Latte (Small)	Beverages	10	0	41	1	5	200
Nonfat Caramel Mocha (Large)	Beverages	17	4	67	1	10	370
Nonfat Caramel Mocha (Medium)	Beverages	13	4	56	1	8	310
Nonfat Caramel Mocha (Small)	Beverages	10	4	45	1	7	250
Nonfat French Vanilla Latte (Large)	Beverages	16	1	60	1	8	300
Nonfat French Vanilla Latte (Medium)	Beverages	12	0	49	1	6	240
Nonfat French Vanilla Latte (Small)	Beverages	10	0	39	1	5	190
Nonfat Hazelnut Latte (Large)	Beverages	16	1	63	1	8	310
Nonfat Hazelnut Latte (Medium)	Beverages	12	0	51	1	7	250
Nonfat Hazelnut Latte (Small)	Beverages	10	0	40	1	5	200
Nonfat Latte (Large)	Beverages	16	1	25	1	4	170
Nonfat Latte (Medium)	Beverages	12	0	19	1	3	130
Nonfat Latte (Small)	Beverages	10	0	15	1	3	100
Nonfat Latte with Sugar Free French Vanilla Syrup (Large)	Beverages	16	1	38	2	6	220
Nonfat Latte with Sugar Free French Vanilla Syrup (Medium)	Beverages	12	0	30	1	4	170
Nonfat Latte with Sugar Free French Vanilla Syrup (Small)	Beverages	10	0	24	1	4	140
Oatmeal Raisin Cookie	Desserts and Shakes	2	6	22	1	4	150
Premium Bacon Ranch Salad (without chicken)	Salads	9	7	10	3	4	140
Premium Bacon Ranch Salad with Crispy Chicken	Salads	26	22	24	4	11	390
Premium Bacon Ranch Salad with Grilled Chicken	Salads	30	9	10	4	6	230
Premium Caesar Salad (without chicken)	Salads	7	4	9	3	3	90
Premium Caesar Salad with Crispy Chicken	Salads	23	18	24	4	9	350
Premium Caesar Salad with Grilled Chicken	Salads	27	5	10	4	5	190
Premium Crispy Chicken Classic Sandwich	Burgers and Sandwiches	24	22	55	3	14	510
Premium Crispy Chicken Club Sandwich	Burgers and Sandwiches	36	33	58	3	18	670
Premium Crispy Chicken Ranch BLT Sandwich	Burgers and Sandwiches	32	27	57	3	16	590
Premium Grilled Chicken Classic Sandwich	Burgers and Sandwiches	28	9	42	3	10	350
Premium Grilled Chicken Club Sandwich	Burgers and Sandwiches	40	20	44	3	14	510
Premium Grilled Chicken Ranch BLT Sandwich	Burgers and Sandwiches	36	14	43	3	12	440
Premium McWrap Chicken & Bacon (Crispy)	Burgers and Sandwiches	32	31	54	3	17	620
Premium McWrap Chicken & Bacon (Grilled)	Burgers and Sandwiches	35	18	40	3	12	460
Premium McWrap Chicken & Ranch (Crispy)	Burgers and Sandwiches	26	29	55	3	16	580
Premium McWrap Chicken & Ranch (Grilled)	Burgers and Sandwiches	30	16	41	3	11	420
Premium McWrap Chicken Sweet Chili (Crispy)	Burgers and Sandwiches	23	22	57	2	14	520
Premium McWrap Chicken Sweet Chili (Grilled)	Burgers and Sandwiches	26	9	43	2	9	360
Premium Southwest Salad (without chicken)	Salads	6	5	20	6	4	140
Premium Southwest Salad with Crispy Chicken	Salads	23	21	42	7	12	450
Premium Southwest Salad with Grilled Chicken	Salads	27	8	28	7	8	290
Quarter Pounder Bacon & Cheese	Burgers and Sandwiches	37	29	48	3	16	600
Quarter Pounder Bacon Habanero Ranch	Burgers and Sandwiches	37	31	46	3	16	610
Quarter Pounder Deluxe	Burgers and Sandwiches	29	27	45	3	15	540
Quarter Pounder with Cheese	Burgers and Sandwiches	30	26	41	3	14	520
Ranch Snack Wrap (Crispy)	Burgers and Sandwiches	14	19	32	1	10	350
Ranch Snack Wrap (Grilled)	Burgers and Sandwiches	16	12	25	1	7	270
Sausage Biscuit (Large Size Biscuit)	Breakfast	11	31	39	3	13	480
Sausage Biscuit (Regular Size Biscuit)	Breakfast	11	27	34	2	12	430
Sausage Biscuit with Egg (Large Size Biscuit)	Breakfast	18	37	42	3	16	570
Sausage Biscuit with Egg (Regular Size Biscuit)	Breakfast	18	33	36	2	14	510
Sausage Biscuit with Egg Whites (Large Size Biscuit)	Breakfast	18	32	40	3	14	520
Sausage Biscuit with Egg Whites (Regular Size Biscuit)	Breakfast	18	27	34	2	12	460
Sausage Burrito	Breakfast	12	16	26	1	8	300
Sausage McGriddles	Breakfast	11	22	44	2	11	420
Sausage McMuffin with Egg Whites	Breakfast	22	22	31	5	11	400
Sausage McMuffin	Breakfast	15	22	31	4	11	370
Sausage McMuffin with Egg	Breakfast	21	27	32	4	12	450
Sausage, Egg & Cheese McGriddles with Egg Whites	Breakfast	21	26	46	2	14	500
Sausage, Egg & Cheese McGriddles	Breakfast	20	31	48	2	15	550
Side Salad	Salads	1	0	4	1	1	20
Small French Fries	Snacks and Sides	3	11	29	3	6	230
Snack Size Holiday Mint McFlurry	Desserts and Shakes	8	14	56	0	10	380
Snack Size McFlurry with M&M'S Candies	Desserts and Shakes	9	15	64	1	12	430
Snack Size McFlurry with OREO Cookies	Desserts and Shakes	8	11	53	1	9	340
Snack Size McFlurry with Reese's Peanut Butter Cup	Desserts and Shakes	10	16	57	1	11	410
Snack Size McFlurry with Rolo**	Desserts and Shakes	10	16	84	1	14	510
Southern Style Chicken Biscuit (Large Size Biscuit)	Breakfast	17	24	46	3	13	470
Southern Style Chicken Biscuit (Regular Size Biscuit)	Breakfast	17	20	41	2	11	410
Southern Style Crispy Chicken Sandwich	Burgers and Sandwiches	21	19	43	2	12	420
Spicy Chicken McBites Shareable Size	Chicken and Fish	1	500	83	20	138	284
Spicy Chicken McBites Snack Size	Chicken and Fish	0	150	25	6	41	85
Strawberry Banana Smoothie (Large)	Beverages	5	1	74	4	9	330
Strawberry Banana Smoothie (Medium)	Beverages	4	1	58	3	7	250
Strawberry Banana Smoothie (Small)	Beverages	3	1	47	3	6	210
Strawberry McCaf Shake (12 fl oz cup)	Desserts and Shakes	12	16	90	0	15	550
Strawberry McCaf Shake (16 fl oz cup)	Desserts and Shakes	15	20	114	0	19	690
Strawberry McCaf Shake (22 fl oz cup)	Desserts and Shakes	18	24	140	0	23	850
Strawberry Sundae	Desserts and Shakes	6	6	49	0	7	280
Vanilla McCaf Shake (12 fl oz cup)	Desserts and Shakes	11	15	86	0	14	530
Vanilla McCaf Shake (16 fl oz cup)	Desserts and Shakes	14	19	109	0	18	660
Vanilla McCaf Shake (22 fl oz cup)	Desserts and Shakes	18	23	135	0	22	820
Vanilla Reduced Fat Ice Cream Cone	Desserts and Shakes	5	5	27	0	5	170
Wild Berry Smoothie (Large)	Beverages	5	1	71	5	9	310
Wild Berry Smoothie (Medium)	Beverages	4	1	57	4	7	250

To answer this question, use upper data.

For (a)-(b), you need to take the following steps:

Create an R Script file where you write your codes.
Import the data set in to R.
Set up a linear regression model in R (according to what you're asked under items (a)-(b)).
Get the summary of your model (the outputs).

a) Use the upper excel data to estimate the following regression model.

y = a + b₁x₁+ b₂x₂+ bx₃+

y = calories x₁ = protein (in grams) x₂ = fat (in grams) x₃ = carbohydrate (in grams)

Write the estimated model based on the regression report. (Hint 1: instead of b1, b2, and b3in the equation above, use the coefficients reported by R) (Hint 2: Copy and paste the regression report below, make sure that your output is readable.)

b) There is data on Weight Watchers (WW) points for each meal in the given set of records. WW is a weight loss program that assigns a numerical score to all meals and food items, and gives you a total number of points to target for a day. WW claims that they their system is elaborate and does not directly count calories. Among the 4 nutrients (fat, protein, carbohydrates, and fiber), which one costs the most in WW points and which the least? How much is the difference? (Hint: compute a regression model, where dependent variable is WW points and the 4 nutrients are independent variables)