What’s the expected heating load as a function of temperature?

Click For Summary
SUMMARY

The expected heating load as a function of temperature can be modeled using linear equations derived from temperature data. Two models were proposed: the first, y = -0.1481*temp + 124.8, uses the average monthly temperature, while the second, y = -0.1466*temp + 124.74, utilizes daily temperatures. The discussion emphasizes the importance of examining standard errors and the underlying data, particularly highlighting anomalies such as those in April 2012.

PREREQUISITES
  • Understanding of linear regression models
  • Familiarity with Excel for data analysis
  • Knowledge of standard error calculations
  • Basic grasp of temperature data interpretation
NEXT STEPS
  • Explore advanced linear regression techniques in Excel
  • Investigate the impact of outliers on regression models
  • Learn about standard error and its significance in data analysis
  • Research historical temperature data analysis methods
USEFUL FOR

Students in statistics or engineering, data analysts, and anyone involved in heating load calculations or temperature data analysis.

Adam Bourque
Messages
10
Reaction score
1

Homework Statement


Excel Table gives Temperature of Month & Avg NOAAtemp for bill

Homework Equations


y = mx + b (Assuming)

The Attempt at a Solution


1) if we take temp of month as temp, linear model y=-0.1481*temp+124.8.
2) If we take temp for days of bill as temp, y=-0.1466*temp+124.74
 

Attachments

Physics news on Phys.org
Not very verbose, but interesting.
Do you have a question on this ? If not, I have one :
Did you look at the standard errors ?
And for that matter: did you look at he data ? What about April, 2012 ?
 
Last edited:

Similar threads

  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 9 ·
Replies
9
Views
2K
  • · Replies 7 ·
Replies
7
Views
4K
Replies
6
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
Replies
12
Views
4K
  • · Replies 8 ·
Replies
8
Views
2K
  • · Replies 11 ·
Replies
11
Views
3K
  • · Replies 2 ·
Replies
2
Views
3K