Required:

1-a. Prepare a scattergraph using the data given above. Plot cost on the vertical axis and activity on the horizontal axis.

Instructions:

1. On the graph below, use the point tool (January) to plot units shipped on the horizontal axis and the shipping expense on the vertical axis.

2. Repeat the same process for the plotter tools (February to July).

3. To enter exact coordinates, click on the point and enter the values of x and y.

4. To remove a point from the graph, click on the point and select delete option.

Required information Exercise 6A-4 High-Low Method; Scattergraph Analysis (L06-10] [The following information applies to the questions displayed below.) Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: Month January February March April May June July Units Shipped 4 7 5 6 8 9 Total Shipping Expense $ 1,800 $ 2,300 $ 1,700 $ 2,000 $ 2,300 $ 3,400 $ 1,200 1 January $5,000 February $4,500 $4,000 March $3,500 $3,000 $2,500 April Shipping Expenses $2,000 $1,500 May $1,000 $500 June $0 0 1 2 3 4 5 6 7 8 9 10 July 1-b. Is there an approximately linear relationship between shipping expense and the number of units shipped? O Yes