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