A Regression Analysis Exercise 2 2 4 Acompany had the following delivery costs last year. It wants to estimate future delivery costs Use regression analysis to calculate the fixed cost per month and variable cost per delivery. 6 Then write the formula below. Enter fixed cost in the yellow cell and variable costs in the blue cell Show the fixed cost to the nearest dollar and the variable cost to the nearest cent 7 Total Delivery No. of Month Deliveries Cost January February 2,000 S 3,650 10 11 1,875 2,600 985 12 March 1,500 2,500 13 April May 4,000 14 800 1,400 15 June 600 1,500 16 July August September 2,800 4,800 2,125 2,200 17 1,200 18 1,350 19 October 725 1,600 3,050 20 November 1.850 21 December 2,200 3,400 22 Fixed Cost per month 23 24 Variable Cost per delivery 25 26 Cost Formula: 27 28 29 How much delivery cost will the company incur in a month in which it has deliveries? Show your work. Round to the nearest dollar. 30 2,500 31 32 33 2.500 deliveries: 34 Fxed cost Variable cost as 36 Total cost 37 38 39 40 41 42 43 44 45 1- Regression 2- Regression 3- High-Low Select destination and press ENTER or choose Paste