Bakers Ltd is concerned at the possible relationship between the amount of fat (grams) and the number of calories in a popular pie (Table 8.22).

(a) Plot a scatter plot and comment on a possible relationship between calories and the amount of fat in the pies.

(b) Use the Excel data analysis regression tool to undertake the following tasks:

(i) State the least squares regression model equation (ii) Comment on model reliability (r and COD)

(iii) Is the independent variable significant (F or t-test)?

(iv) Check model assumptions (residual and normality checks).

Transcribed Image Text:

Pie ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Table 8.22 Amount of fat (grams) 19 31 34 35 39 39 43 2482 % % ~ 22 28 38 35 40 43 21 Calories 410 580 590 570 640 680 660 465 567 610 576 434 690 660 435 Pie ID 16 17 18 19 20 21 22 23 NH27X8 24 25 26 29 30 Amount of fat (grams) 33 31 37 39 23 43 22 30 34 35 41 34 43 45 29 Calories 597 583 589 640 456 660 448 577 594 590 638 560 660 680 587