Energy Monitoring Worksheet
Today’s lecture will be spent entirely in the computer lab. At the end of lab, submit this worksheet.
Part 1: Weather (3) 1. Open the following link: http://climate.weatheroffice.gc.ca/climateData/canada_e.html 2. Click “customized search” button 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:
Part 1: Weather (3) 1. Open the following link: http://climate.weatheroffice.gc.ca/climateData/canada_e.html 2. Click “customized search” button 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: