Wind Power and Electricity Demand Modeling

Lab: Measuring Wind Power

Colby Weather Data (logged at 5 minute intervals) from the top of the Keyes building
Daily max/min temperature and wind speed from the top of the Keyes building
Degree Day calculations
State Electricity Demand worksheet
J2$ Excel Tutorial #4 – fitting a line to a dataset using LINEST
J2$ Excel Tutorial #5 – constructing a histogram of wind speed
— Remember to set the YouTube video resolution to 1080p —

Lab Report  Due in your Google Drive folder Friday, March 13th

  1. Determine the efficiency of your wind turbine by answering questions A and B in part 4 of Measuring Wind Power.
  2. Provide an assessment of potential wind energy on Colby’s campus using the Colby Weather Data and answering question C in part 4 of Measuring Wind Power.
  3. Using the NOAA degree day definitions and the daily max/min temperature data measured at the top of the Keyes building on campus, calculate heating and cooling degree days for each month in 2014 by averaging the daily heating and cooling degree days and summarize your results with an Excel bar chart and a brief interpretation of the temperature weather pattern for 2014 and the implications for home heating and cooling in Central Maine.
  4. Using the State Electricity Demand worksheet, and the “Template” spreadsheet, produce a plot of monthly electricity demand and a line of best fit through the data for your assigned state.
  5. Write a short essay (no more than 4 paragraphs) analyzing historical residential electricity demand for your assigned state using the “Template” spreadsheet in the State Electricity Demand worksheet.  Your essay should include: (i) an calculation of trend growth and an assessment of goodness of fit (using the R-squared statistic) of the best fit line; (ii) an assessment of effects of the Great Recession (Dec-07 to Jun-09) on electricity demand in your state; (iii) an assessment of seasonal effects on demand in your state, including an identification of a seasonal peak and trough in the data; and (iv) identification of any irregularities relative to trend growth or outlying observations for your state.
  6. Provide a one or two-sentence interpretation of the estimated price elasticity of demand for electricity in your assigned state and compare it with the estimate for your lab partner’s state.
  7. Repeat (4), (5) and (6) for the “Seasonal Controls” spreadsheet in the State Electricity Demand worksheet.
  8. Email your take-away impressions and results from the wind turbine construction exercise and wind power challenge to Professor Donihue.

Since we don’t have all of the data for 2014, calculate the annualized rate of growth for electricity demand in your state for the 12 year period of 2001 through 2013 as (((D13/D01)^(1/12))-1)*100; where D13 and D01 are total kWh electricity demand in 2013 and 2001, respectively.

Comments are closed.