# Energy Monitoring Worksheet

Topics: Linear equation, Regression analysis, Statistics Pages: 3 (581 words) Published: February 20, 2013
Today’s lecture will be spent entirely in the computer lab. At the end of lab, submit this worksheet. Part 1: Weather (3)
3. Search by station name
a. Enter “Hamilton” in the text field
b. Years: 2006 to 2011
4. Click “Search”
5. For “Hamilton A” station, select ‘daily’ in the “data interval drop-down box. 6. Click “Go”
You now have access to all heating degree and cooling degree-day data for Hamilton, Ontario. Find the sum of heating-degree day and cooling-degree day data for each month for 2006. 7. In MS Excel, setup and fill-in the following table: (3) Year| 2006|

Month| HDD| CDD|
January| | |
February| | |
March| | |
April| | |
May| | |
June| | |
July| | |
August| | |
September| | |
October| | |
November| | |
December| | |

Part 2: Natural Gas Consumption (7)
1. Copy and paste your table into a new worksheet.
2. Remove the CDD column and replace it with the following data: Year| 2006| |
Month| HDD| CDD| Total Natural Gas (m3)|
January| | | 506210|
February| | | 421019|
March| | | 452097|
April| | | 360415|
May| | | 285237|
June| | | 169547|
July| | | 155738|
August| | | 122305|
September| | | 126511|
October| | | 241150|
November| | | 263930|
December| | | 330708|

3. Graph the Natural gas consumption vs heating degree days (Y vs. X). Submit this graph along with the completed worksheet.

Question 1: What trend does the graph illustrate? (2)

4. After the graph is complete, right-click on one of the data points on the graph. Select ‘Add trendline” 5. Choose “Linear” for the trend/regression type. Then at the bottom of the window, select “display equation on chart” and “Display R-squared value on chart”.

Question 2: What...