Statistical analysis: data filtering

  • #1
russ_watters
Mentor
19,660
5,932

Main Question or Discussion Point

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

Answers and Replies

  • #2
arildno
Science Advisor
Homework Helper
Gold Member
Dearly Missed
9,970
132
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.
 
  • #3
russ_watters
Mentor
19,660
5,932
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.
 

Related Threads on Statistical analysis: data filtering

Replies
3
Views
20K
  • Last Post
Replies
2
Views
3K
Replies
1
Views
569
  • Last Post
Replies
6
Views
4K
  • Last Post
Replies
6
Views
3K
  • Last Post
Replies
1
Views
3K
Replies
3
Views
3K
Replies
8
Views
3K
  • Last Post
Replies
7
Views
1K
  • Last Post
Replies
0
Views
1K
Top