Reference no: EM13154642
Product Pie Weight Calories/slice Fat grams/slice Cost/Slice($) to make Avg. #Slices Sold per day Profit/Slice
Pepperoni Mushroom Olive 31 305 9 1.51 134 0.49
Garlic Chicken 29 382 16 1.53 87 0.47
Hawaiian 31 338 14 1.51 134 0.49
Vegetarian 21 327 9 1.2 132 0.80
Vegen 26 309 10 1.23 12 0.77
Cheese 25 313 11 1.28 111 0.72
Stuffed Crust 47 349 13 1.23 130 0.77
Thai 29 332 10 0.9 56 1.10
Mexican 26 364 17 0.85 76 1.15
Tomato Basil 22 393 19 0.8 52 1.20
Deb currently has a product line of 10 specialty pizzas. The data above shows overall population data for each line of pizza weight in ounces, cost of a slice to make in dollars, calories per slice, and fat grams per slice.
Deb knows that many of her customers are weight conscious. She'd like to know if there a relationship between fat grams per slice and calories per slice. Is there?
What is the coefficient of correlation? Is it significant at .01? How do you know?
How much of the variation in calories can be explained by the number of fat grams per slice?
Build a predictive model for number of calories using fat grams. If a pizza has 15 grams of fat, how many calories should it have, using your model?
Can you think of any other correlations that might help Deb in her business planning? Are there any variables that seem to be missing?