An energy company is studying the relationship between the average daily temperature, xx (in degrees Celsius), and the amount of electricity consumed, yy (in megawatt-hours MWh). For a random sample of ten days, the records are shown in the table below.
Average daily temperature ( x∘x^\circC )20222426283032343638
Electricity consumption ( yy MWh)12.512.813.214.014.716.216.219.922.329.5
It is thought that the electricity consumption and average daily temperature can be modelled by one of the formulae y=a+bx2,y=c+dx,y = a + b x^2, \qquad y = c + d x, where aa, bb, cc and dd are constants. In some regions, temperature is measured in degrees Fahrenheit instead of degrees Celsius. A temperature of CC degrees Celsius is equivalent to FF degrees Fahrenheit, where F=95C+32.F = \frac{9}{5}C + 32.

  1. (a)

    Draw a scatter diagram for these values, labelling the axes clearly.

  2. (b)

    Find the value of the product moment correlation coefficient between

    1. (i)

      xx and yy ,

    2. (ii)

      x2x^2 and yy .

  3. (c)

    Using your answers in parts (a) and (b), explain which of y=a+bx2y = a + b x^2 and y=c+dxy = c + d x is the better model and find the equation of a suitable regression line for this model.

  4. (d)

    Use the equation of your regression line to estimate the electricity consumption on a day with an average temperature of 37∘C37^\circ\text{C}. Comment on the reliability of your estimate.

  5. (e)

    Rewrite the equation of your regression line found in part (c) in terms of yy and FF, where FF is the average daily temperature in degrees Fahrenheit.

Work through it with AI →

It won't just hand you the answer — it asks where you're stuck.How the checker works

Worked solution

11(a)

1. Set up and label the axes appropriately

Draw a horizontal axis for xx (average daily temperature, in ∘^\circC) covering values from at least 20 to 38, and a vertical axis for yy (electricity consumption, in MWh) covering values from at least 12.5 to 30. Label the axes as 'xx (∘^\circC)' and 'yy (MWh)'.

2. Plot the points from the given table

Plot the 10 coordinate points on the grid:
(20,12.5)(20, 12.5), (22,12.8)(22, 12.8), (24,13.2)(24, 13.2), (26,14.0)(26, 14.0), (28,14.7)(28, 14.7),
(30,16.2)(30, 16.2), (32,16.2)(32, 16.2), (34,19.9)(34, 19.9), (36,22.3)(36, 22.3), (38,29.5)(38, 29.5).

Answer

A scatter diagram showing 10 data points plotted correctly, with the horizontal axis labelled 'xx (∘^\circC)' and the vertical axis labelled 'yy (MWh)'.

11(b)(i)

1. Use a graphing calculator to find the product moment correlation coefficient (PMCC) for the paired data.

By entering the xx and yy values into a graphing calculator, we obtain:
r=0.890557…r = 0.890557\dots
r≈0.891 (to 3 s.f.)r \approx 0.891 \text{ (to 3 s.f.)}

Answer

0.8910.891

11(b)(ii)

1. Calculate the product moment correlation coefficient for $x^2$ and $y$ using a graphing calculator.

Enter the paired data for x2x^2 and yy into the graphing calculator:
X=x2={400,484,576,676,784,900,1024,1156,1296,1444}X = x^2 = \{400, 484, 576, 676, 784, 900, 1024, 1156, 1296, 1444\}
Y=y={12.5,12.8,13.2,14.0,14.7,16.2,16.2,19.9,22.3,29.5}Y = y = \{12.5, 12.8, 13.2, 14.0, 14.7, 16.2, 16.2, 19.9, 22.3, 29.5\}

From the calculator,
r=0.922289…r = 0.922289\dots
r≈0.922 (to 3 s.f.)r \approx 0.922 \text{ (to 3 s.f.)}

Answer

0.9220.922

11(c)

1. Explain which model is better based on the scatter diagram from part (a) and PMCC from part (b)

From part (b), we have the calculated PMCC values:

  • For xx and yy: r≈0.891r \approx 0.891
  • For x2x^2 and yy: r≈0.922r \approx 0.922
  1. From part (a): The scatter diagram of yy against xx exhibits an upward curve, which suggests a non-linear relationship.
  2. From part (b): The product moment correlation coefficient for x2x^2 and yy (0.9220.922) is closer to 11 than that for xx and yy (0.8910.891), showing a stronger positive linear correlation.

Therefore, y=a+bx2y = a + bx^2 is the better model.

2. Find the equation of the suitable regression line

Since y=a+bx2y = a + bx^2 is the chosen model, we find the linear regression line of yy on x2x^2.
Using a graphing calculator, we input the squares of the temperature values (x2x^2) as the independent variable and the electricity consumption (yy) as the dependent variable to find the least squares line y=a+bx2y = a + bx^2.

From the calculator:
a≈4.8291a \approx 4.8291
b≈0.014074b \approx 0.014074

The equation of the regression line is:
y=4.83+0.0141x2(to 3 s.f.)y = 4.83 + 0.0141x^2 \quad \text{(to 3 s.f.)}

Answer

y=a+bx2y = a + bx^2 is the better model.
y=4.83+0.0141x2y = 4.83 + 0.0141x^2

11(d)

1. Estimate the electricity consumption when the average temperature is $37^\circ\text{C}$.

From part (c), the equation of the regression line of yy on x2x^2 is y=0.01407x2+4.830y = 0.01407 x^2 + 4.830.

When x=37x = 37:
y=0.01407(37)2+4.830y = 0.01407(37)^2 + 4.830
y=0.01407(1369)+4.830y = 0.01407(1369) + 4.830
y=24.09183≈24.1 MWhy = 24.09183 \approx 24.1\text{ MWh}

2. Comment on the reliability of the estimate.

Since x=37∘Cx = 37^\circ\text{C} lies within the given data range of 20∘C20^\circ\text{C} to 38∘C38^\circ\text{C}, the process is interpolation. Therefore, the estimate is reliable.

Answer

24.1 MWh24.1\text{ MWh}

The estimate is reliable as it involves interpolation.

11(e)

1. Determine the regression equation for $y$ on $x^2$ (required from part c) and express the Celsius temperature $x$ in terms of the Fahrenheit temperature $F$.

To formulate the regression line y=a+bx2y = a + bx^2 from part (c), we use the data points with w=x2w = x^2:
wˉ=874\bar{w} = 874, yˉ=17.13\bar{y} = 17.13
b=SwySww=157431118568≈0.014074b = \frac{S_{wy}}{S_{ww}} = \frac{15743}{1118568} \approx 0.014074
a=yˉ−bwˉ=17.13−(0.014074)(874)≈4.8291a = \bar{y} - b\bar{w} = 17.13 - (0.014074)(874) \approx 4.8291
The regression equation is y=4.829+0.01407x2y = 4.829 + 0.01407x^2.

Since xx represents the temperature in Celsius (C=xC = x), the conversion formula is F=95x+32F = \frac{9}{5}x + 32. Making xx the subject:
F−32=95xF - 32 = \frac{9}{5}x
x=59(F−32)x = \frac{5}{9}(F - 32)

2. Substitute the expression for $x$ into the regression equation to express $y$ in terms of $F$.

Substitute x=59(F−32)x = \frac{5}{9}(F - 32) into the regression equation:
y=4.8291+0.014074(59(F−32))2y = 4.8291 + 0.014074 \left( \frac{5}{9}(F - 32) \right)^2
y=4.8291+0.014074(2581)(F−32)2y = 4.8291 + 0.014074 \left( \frac{25}{81} \right) (F - 32)^2
y=4.8291+0.0043439(F−32)2y = 4.8291 + 0.0043439 (F - 32)^2
Rounding to 3 significant figures, we get:
y=4.83+0.00434(F−32)2y = 4.83 + 0.00434(F - 32)^2

Answer

y=4.83+0.00434(F−32)2y = 4.83 + 0.00434(F - 32)^2

AI analysis — may contain mistakes.

Worked this one out on paper? Snap your steps and Gigle's AI math checker will circle the step where it went wrong.

More questions on this topic

  1. 1A teacher conducts a survey on 7 students to investigate the relationship between the number of hours (hh) of "screen-t…
  2. 2The number of years (xx) an employee has worked for the company and the corresponding salary increment, in dollars (yy…
  3. 3It is believed that the probability pp of a randomly chosen pregnant woman giving birth to a Down's Syndrome child is r…
  4. 4In an experiment, the time taken, TT minutes, for a 1-kg block of ice to melt completely under 7 pre-determined tempera…
  5. 5An electrical appliance supplier is investigating the potential impact of monthly advertisement expenditure, denoted as…