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

## Step by Step Answer:

**Related Book For**