I need help preparing 3 scattergraphs and 3 simple regression analyses to estimate the overhead costs using each of the cost drivers in the attachment using Excel. I have to make sure I show(insert) the equation of the line and R-squared on each of the scattergraphs. The output of the simple regression table should be on a separate sheet and should type out the equation of the line below the table output.

Volume of liquid produced Number of Total Overhead costs for the plant Month January February March hectoliters Water used in hectoliters Batches 890 6,005 6,588 54 $57,266 980 58 61,020 7,336 1,094 65 64,622 April May 1,212 73 68,630 8,002 8,435 70,653 1,262 75 June 1,494 9,940 89 79,927 July August September 1,557 10,420 95 82,867 1,528 94 81,748 10,326 1,215 8,284 72 68,819 October 1,145 69 66,375 7,746 November December 1,072 64 63,767 7,168 1,032 62 62,545 6,933 January 872 5,902 50 56,837 February March 61,298 1,006 60 6,759 1,04 62 63,791 6,990 Volume of liquid produced Number of Total Overhead costs for the plant Month January February March hectoliters Water used in hectoliters Batches 890 6,005 6,588 54 $57,266 980 58 61,020 7,336 1,094 65 64,622 April May 1,212 73 68,630 8,002 8,435 70,653 1,262 75 June 1,494 9,940 89 79,927 July August September 1,557 10,420 95 82,867 1,528 94 81,748 10,326 1,215 8,284 72 68,819 October 1,145 69 66,375 7,746 November December 1,072 64 63,767 7,168 1,032 62 62,545 6,933 January 872 5,902 50 56,837 February March 61,298 1,006 60 6,759 1,04 62 63,791 6,990