(x1) (x ?) (x 3 ) (y) IN Month Units Produced Watts Usage Water Used Total Cost 3 January 27,500 18,333 4,000 $ 21,500.00 4 February 22,500 14,063 4,500 $ 20,500.00 5 March 25,000 15,152 4,700 $ 25,000.00 6 April 35,000 17,500 3,900 21,500.00 7 May 47,500 25,000 3,800 S 25,500.00 8 June 17,500 10,294 4,200 $ 18,500.00 9 July 30,000 15,000 4,700 $ 23,500.00 10 August 52,500 21,000 5,200 $ 28,500.00 11 September 37,500 28,846 5,400 26,000.00 12 October 62,500 23,148 5,100 29,000.00 13 November 67,500 27,000 6,000 S 31,000.00 14 December 57,500 28,750 4,900 $ 26,000.00 15 January 52,000 26,000 4,100 16 (Estimated production and usage) 17 18 Question 1: Of the three cost drivers, which best predicts total cost for January? How do you know? (6%) 19 20 Question 2: What is your prediction of January's total cost? (6%) 21 22 Question 3: Using your answer in Question 1, use the High Low Method to write the cost function. (8%) 23 24 Question 4: Using the Charts Function, make a scatter plot with a line of best fit displaying the cost function and r-squared value using your answer in question 1. (10%) 25 26