Solutions Statistics

The data below is on degree days and natural gas consumed by the Sanchez home for 16 consecutive mon

Question: The data below is on degree days and natural gas consumed by the Sanchez home for 16 consecutive months. There is a very strong linear relationship. Mr. Sanchez asks “If a month averages 20 degree-days per day (that’s 45degreesF), how much gas will we use? Use excel to find the least-squares regression line and answer his question.

Month	Nov.	Dec	Jan	Feb	Mar	Apr	May	June
Degree-days	24	51	43	33	26	13	4	0
Gas used	6.3	10.9	8.9	7.5	5.3	4	1.7	1.2

Month	July	Aug	Sept	Oct	Nov	Dec	Jan	Feb
Degree-days	0	1	6	12	30	32	52	30
Gas used	1.2	1.2	2.1	3.1	6.4	7.2	11	6.9