Statistical analysis: data filtering

AI Thread Summary
The discussion focuses on analyzing the power usage of a building over four years, specifically examining the correlation between temperature and electricity consumption. The user aims to filter out this correlation to create a usage profile that reflects occupancy rather than temperature influences. They have identified an "equilibrium temperature" around 50 degrees, which serves as a baseline for expected energy usage. Despite efforts to subtract this baseline from the data, the results are not as expected. Assistance is requested to refine this analysis and improve data interpretation.
Messages
23,694
Reaction score
11,136
This may be too much work, so I understand if no one tackles the problem...

I'm doing an analysis of the power usage of a building. Sheet 2 of the attached spreadsheet shows typical data (we have 4 years of it). The top graph is the kWh used every 30 minutes of every day in January, 2003. The second graph is the temperature at those times. As you can see, there is a correlation between temperature and usage (the building has electric heat). For example, the light and dark blue diamonds for 1/1 and 1/10 show the highest temperature and lowest usage. What I would like to do is filter-out this correlation. This would leave me with a usage profile that reflects occupancy and pretty much nothing else. All of the lines for kWh would lay right on top of each other most of the time.

Sheet 1 shows some of my efforts to this point. The graph seems to show a corellation between kWh and temp (though, admittedly, not super-strong). Of note, there is something called an "equilibrium temperature." Its basically the temperature at which no heating or air conditioning is required. At this point, the usage will start going up again. So this would serve as a baseline - a minimum usage - for building the corellation. It appears to be at about 50 degrees.

Now, it looks like it should be possible to just construct this line and subtract it from the usage data. But it doesn't appear to be working. Any help would be greatly appreciated.
 

Attachments

Physics news on Phys.org
Hi, russ:
I don't think I can be of any real help here, but when I tried to open the zip-file, I got an "invalid/damaged" message.
It might be something with my computer, but in case it isn't, I thought you should know.
 
Strange - when I try to open it right from the web, it comes up empty, but when I download it, it works. Try downloading it - and thanks for picking up on that.
 
I was reading documentation about the soundness and completeness of logic formal systems. Consider the following $$\vdash_S \phi$$ where ##S## is the proof-system making part the formal system and ##\phi## is a wff (well formed formula) of the formal language. Note the blank on left of the turnstile symbol ##\vdash_S##, as far as I can tell it actually represents the empty set. So what does it mean ? I guess it actually means ##\phi## is a theorem of the formal system, i.e. there is a...

Similar threads

Back
Top