Question

Using the data below. Answer the following questions. Use Total fat as the x-vable and calories as the y. Round to 2 decimal places.

What is the line of best fit?

Is this a good fit? How do you know?

Is the correlation positive or negative?

What does the r-squared mean in context of the problem?

If a sandwich has 32 grams of fat, how many total calories will it have?

Sandwich	Total Fat (g)	Total Calories
Hamburger	9	260
Cheeseburger	13	320
Quarter Pounder	21	420
Quarter Pounder with Cheese	30	530
Big Mac	31	560
Arch Sandwich Special	31	550
Arch Special with Bacon	34	590
Crispy Chicken	25	500
Fish Fillet	28	560
Grilled Chicken	20	440
Grilled Chicken Light	5	300

Answer 1

Solution: We can use excel to find the line of the best fit. The excel output is given below:

What is the line of best fit?

Answer: The line of best fit is:

Is this a good fit? How do you know?

Answer: This is a good fit, because the p value is less than significance level, which makes the above linear regression equation a significant one.

Is the correlation positive or negative?

Answer: The correlation is positive

What does the r-squared mean in context of the problem?

Answer: R-squared means that 95% of variation in total calories variable is explained by Total Fat variable.

If a sandwich has 32 grams of fat, how many total calories will it have?

Answer: Total Calories =