The manager of Water Operations at the City of London wanted to reduce the cost of pumping water by optimizing energy use. Water Operations had been consistently experiencing higher operational costs, and electricity bills accounted for up to 30 per cent of its direct costs. If the manager could predict the future cost of energy, she could schedule the operation of the water pumps to benefit from periods of low energy prices, potentially saving up to 25 per cent of the energy costs. The manager obtained the hourly Ontario electricity prices from 2003 to 2015, and wanted to use that data to evaluate how accurately she could predict future electricity prices. How should she proceed?

Student spreadsheet for case W19122