Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 + b1x1+ b2x2+ bx3+

y = calories x1 = protein (in grams) x2 = fat (in grams) x3 = 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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Corporate Finance

Authors: Richard Brealey, Stewart Myers, Alan Marcus

8th edition

77861620, 978-0077861629

Students also viewed these Mathematics questions

Question

Solve the following 1,4 3 2TT 5x- 1+ (15 x) dx 5X

Answered: 1 week ago