Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please type the answers Question 2 18 points Dancer Company has noticed that utility bills are substantially higher when the average monthly temperature is colder.
please type the answers
Question 2 18 points 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 verge daily temperature and the cost of its monthly utility bills for natural gas and electricity Average Temperature Month Idegrees Farenhell Utility Cost 31 $1,700 January February March 1.6.20 April 44 410 May 46 275 June 50 233 53 220 50 210 August September 50 305 Question Completion Status: January $1,700 February 1,629 March 43 543 April 44 410 Mary June 50 July 55 220 August 60 210 September 50 305 October 40 530 November 30 750 December 10 870 Required 1. Use the high low method to find the equation for estimating the cost of utilities 2. Estimate the utility cost for the upcoming month of January if the crime avenge pertori 26 degrees 3. Using Excel find the regresion equation for estimating the cost of utilities. You may calculate the simple linear regression from the charting function, the Excel formulas, se the repression function in the analysis toolpak 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