An energy company is studying the relationship between the average daily temperature, (in degrees Celsius), and the amount of electricity consumed, (in megawatt-hours MWh). For a random sample of ten days, the records are shown in the table below.
Average daily temperature ( C ) 20 22 24 26 28 30 32 34 36 38 Electricity consumption ( MWh) 12.5 12.8 13.2 14.0 14.7 16.2 16.2 19.9 22.3 29.5
It is thought that the electricity consumption and average daily temperature can be modelled by one of the formulae
where , , and are constants.
In some regions, temperature is measured in degrees Fahrenheit instead of degrees Celsius. A temperature of degrees Celsius is equivalent to degrees Fahrenheit, where
| Average daily temperature ( C ) | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 |
|---|---|---|---|---|---|---|---|---|---|---|
| Electricity consumption ( MWh) | 12.5 | 12.8 | 13.2 | 14.0 | 14.7 | 16.2 | 16.2 | 19.9 | 22.3 | 29.5 |
- (a)
Draw a scatter diagram for these values, labelling the axes clearly.
- (b)
Find the value of the product moment correlation coefficient between
- (i)
and ,
- (ii)
and .
- (i)
- (c)
Using your answers in parts (a) and (b), explain which of and is the better model and find the equation of a suitable regression line for this model.
- (d)
Use the equation of your regression line to estimate the electricity consumption on a day with an average temperature of . Comment on the reliability of your estimate.
- (e)
Rewrite the equation of your regression line found in part (c) in terms of and , where is the average daily temperature in degrees Fahrenheit.
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 (average daily temperature, in C) covering values from at least 20 to 38, and a vertical axis for (electricity consumption, in MWh) covering values from at least 12.5 to 30. Label the axes as ' (C)' and ' (MWh)'.
2. Plot the points from the given table
Plot the 10 coordinate points on the grid:
, , , , ,
, , , , .
A scatter diagram showing 10 data points plotted correctly, with the horizontal axis labelled ' (C)' and the vertical axis labelled ' (MWh)'.
11(b)(i)
1. Use a graphing calculator to find the product moment correlation coefficient (PMCC) for the paired data.
By entering the and values into a graphing calculator, we obtain:
11(b)(ii)
1. Calculate the product moment correlation coefficient for $x^2$ and $y$ using a graphing calculator.
Enter the paired data for and into the graphing calculator:
From the calculator,
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 and :
- For and :
- From part (a): The scatter diagram of against exhibits an upward curve, which suggests a non-linear relationship.
- From part (b): The product moment correlation coefficient for and () is closer to than that for and (), showing a stronger positive linear correlation.
Therefore, is the better model.
2. Find the equation of the suitable regression line
Since is the chosen model, we find the linear regression line of on .
Using a graphing calculator, we input the squares of the temperature values () as the independent variable and the electricity consumption () as the dependent variable to find the least squares line .
From the calculator:
The equation of the regression line is:
is the better model.
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 on is .
When :
2. Comment on the reliability of the estimate.
Since lies within the given data range of to , the process is interpolation. Therefore, the estimate is reliable.
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 from part (c), we use the data points with :
,
The regression equation is .
Since represents the temperature in Celsius (), the conversion formula is . Making the subject:
2. Substitute the expression for $x$ into the regression equation to express $y$ in terms of $F$.
Substitute into the regression equation:
Rounding to 3 significant figures, we get:
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
- 1A teacher conducts a survey on 7 students to investigate the relationship between the number of hours () of "screen-t…
- 2The number of years () an employee has worked for the company and the corresponding salary increment, in dollars (…
- 3It is believed that the probability of a randomly chosen pregnant woman giving birth to a Down's Syndrome child is r…
- 4In an experiment, the time taken, minutes, for a 1-kg block of ice to melt completely under 7 pre-determined tempera…
- 5An electrical appliance supplier is investigating the potential impact of monthly advertisement expenditure, denoted as…