Bakers Ltd is concerned at the possible relationship between the amount of fat (grams) and the number

Question:

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).

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 % % ~

Step by Step Answer:

Related Book For  book-img-for-question

Business Statistics Using Excel

ISBN: 9780199659517

2nd Edition

Authors: Glyn Davis, Branko Pecar

Question Posted: