All answers must be in excel formula format.

D E F G H J K L M N 0 P Q R S T Enter formulas or descriptions in these fields To create a scattergraph only chart, perform the following steps 1 Scattergraph only Insert chart here 1. Select the data, bottles sold and operating cost 2. Select insert, next to home 3. Select charts 4. Select charts, scattergraph B 1 Chapter 5 Lab Problem PB5-1, page 251 2 3 4 5 6 7 8 9 Given Data: 10 Bottles Operating 11 Month Sold Cost 12 January 1000 $8,000 13 February 1100 $7,700 14 March 1300 $9,900 15 April 2000 $14,000 16 May 2400 $17,250 17 June 3000 $20,000 18 19 20 21 22 23 24 25 Bottles sold 9600 26 27 28 29 30 31 32 33 34 35 36 37 38 2 Don't do 3 High Low Analysis Units Dollars High Low Difference Variable cost O per Unit: *Use the min max functions to determine the high low units High Low Units Total Cost Total Variable Total Fixed 4 Operating cost of 9600 bottles sold Using High-low B D E F - J M N G 4 Operating cost of 9600 bottles sold K Using High-low 37 5 Least squares regression Operating cost of 9600 Bottles using least squares Slope Intercept RSO 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 6 Regression Chart Insert chart here Regression Chart building 1. Select the data, bottles sold and operating cost 2. Select insert, next to home 3. Select charts 4. Select charts, scattergraph 5. Select Quick Layout 6 Select regression, the 9th chart A B C 4 5 6 7 8 9 Given Data: 10 11 Month 12 January 13 February 14 March 15 April 16 May 17 June 18 19 20 21 22 23 24 25 Bottles sold Bottles Sold 1000 1100 1300 2000 2400 3000 Operating Cost $8,000 $7,700 $9,900 $14,000 $17,250 $20,000 9600 PB51 Estimating Cost Behavior Using Scattergraph, High-Low, and Least-Squares Regression Methods @ LO 5-2, 25-3, 05-4 Odie Company manufactures a popular brand of cat repellant known as Cat-B-Gone, which it sells in gallon-size bottles with a spray attachment. The majority of Odie's business comes from orders placed by homeowners who are trying to keep neighborhood cats out of their yards. Odie's operating information for the first six months of the year follows: Month Number of Bottles Sold Operating Cost January 1,000 $ 8,000 February 1,100 7,700 March 1,300 9.900 April 2,000 14.000 May 2,400 17,250 June 3,000 20,000