Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses

Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder. The only thing in the shop that uses natural gas is the furnace. Because of prevailing low temperatures, the furnace is used every month of the year (though less in the summer months and very little in August). Everything else in the shop runs on electricity, and electricity use is fairly constant throughout the year. For a year, Dancer has been recording the average daily temperature and the cost of its monthly utility bills for natural gas and electricity

Month degree Fahrenheit Utility Cost

January 31 1,760

Feb 41 1,629

March 43 543

April 44 410

May 46 275

June 50 233

July 53 220

Aug 60 210

Sept 50 305

Oct 40 530

Nov 30 750

Dec 10 870

Using Excel find the regression equation for estimating the cost of utilities. You may calculate the simple linear regression from the charting function, the Excel formulas, or the regression function in the analysis toolpak.

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

Applying IFRS Standards

Authors: Ruth Picker, Kerry Clark, John Dunn, David Kolitz, Gilad Livne, Jance Loftus, Leo Van Der Tas

4th Edition

1119159229, 9781119159223

More Books

Students also viewed these Accounting questions

Question

Describe five of G. Stanley Halls major achievements.

Answered: 1 week ago

Question

=+2. What is the difference between brand voice and tone?

Answered: 1 week ago