Question
We study the relation between weather and gas consumption in winter season of one building. Let x variable denote the daily average temperature (in oC),
We study the relation between weather and gas consumption in winter season of one building. Let x variable denote the daily average temperature (in oC), y variable denote the daily gas consumption (3m3). See the below data(excel with data attached): x: -3, -6, -2, 0, -14, -13, -11, -6, -4, -7, -4, -5, -17, 1, 2, -8, -9, -5, -7, 5, -10, -2, -6, 1, -8, -8, -10, -7, -18, 0 y: 33.8, 44.1, 38.8, 33.8, 62.1, 59.8, 47.2, 37.9, 38.8, 48.9, 37.2, 35.7, 61.5, 27.7, 29.9, 43.4, 46.7, 38.6, 42.4, 16.3, 46.9, 33.5, 44.9, 29.2, 47.1, 50.6, 51.8, 39.6, 65.8, 27.3 Apply excel to do the following, 3(6). Fit the data to least squares linear regression using the REGRESSION function in excel. Request to high-light yellow for cells: coefficient of determination, 1,0b1,b0, and residual value for temp = 5oC on the output. Residual plot are requested in the output.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started