Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An accountant wishes to undertake a cost analysis of electricity consumption of office heating for various maximum daily temperatures. He recorded the data over a

An accountant wishes to undertake a cost analysis of electricity consumption of office heating for various maximum daily temperatures. He recorded the data over a period of 8 random days, as shown below:

1 2 3 4 5 6 7 8
Temp(C) 26 31 25 26 14 20 16 34
Max Electricity Consumption 35 20 37 24 42 41 40 17

You may use the following Excel print-outs or summary statistics provided to answer the questions.

SUMMARY OUTPUT SUMMARY STATISTICS
Regression Statistics n = 8
Multiple R 0.895 = 24
R Square 0.801 = 32
Adjusted R Square 0.768 s2x = 48.29
Standard Error 4.862 s2y = 101.71
Observations 8 sxy = -62.7143
Coefficients Standard Error t Stat P-value
Intercept 63.172 6.575 9.607 0.000
temp(C) -1.299 0.264 -4.911 0.003

(i) Find the least squares regression line to predict the electricity consumption from the maximum temperature.

(ii) Predict the electricity consumption of the office when the maximum temperature is 30C. How confident are you in this prediction?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Geometry, Structure And Randomness In Combinatorics

Authors: Ji?í Matousek, Jaroslav Nešet?il, Marco Pellegrini

1st Edition

887642525X, 9788876425257

More Books

Students also viewed these Mathematics questions

Question

Explain why self-acceptance is important for high self-esteem.

Answered: 1 week ago