Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Statistical analysis: data filtering

  1. Jan 20, 2005 #1


    User Avatar

    Staff: Mentor

    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.

    Attached Files:

  2. jcsd
  3. Jan 20, 2005 #2


    User Avatar
    Science Advisor
    Homework Helper
    Gold Member
    Dearly Missed

    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.
  4. Jan 21, 2005 #3


    User Avatar

    Staff: Mentor

    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.
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook