hello, i have monthly electricity demand for a year each month have just min and max vkues so for the whole year I have 24 vlues (min and max per month)?

hello, I have monthly electricity demand for a year each month have just min and max values so for the whole year I have 24 values (min and max per month) and at the same time, i have hourly temperature and humidity for the same year(8760 values). I am trying to extract daily demand (365 values. I thought I can match between the weather data and demand data cos one I took the demand average and get the monthly temperature from the yearly data, the demand strongly depends on the temperature. I am still needed help to get the next step. please if u have any ideas do and help me. many thanks in advance

[Azzi Abdelmalek]

This is not clear

Answer 1

[dpb]

About all you can do with that data, lacking even the daily demand what more the hourly, would be to average the weather data on a daily basis and then PRESUME the extremes in demand correlate to the days of maxima/minima in temperatures. With that assumption, you could then use that as an interpolating function to predict demand from the daily readings; how well it would actually correlate is, unfortunately, not even testable without access to more data.

For comparison purposes, given that the RH data are also available, you might try the correlation against the so-called "feels like" temperatures, the Heat Index for hot weather and Wind Chill for the cold--oh, excepting you don't have wind speed, do you? That's out, then, unless you can find additional weather record data to augment what you do have...

[ABDULLA RAHIL]

that is what i think i can do