Question

Required Information [The following information applies to the questions displayed below) Archer Company is a wholesaler of custom-built alr-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: Units Shipped Month January February March April May Total Shipping Expense $ 2,400 $ 2,900 $ 2,300 $ 2.600 $ 2,900 $ 3.900 $ 1,800 June als 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. Shipping Expenses ES Units Shipped

Answer 1

Scatter Plot is used to show a relation ship between two variables

Here in the present case we try to show the relationship between units shipped and total shipping expenses from January to July.

It is so simple to plot.Just use the data given as X,Y co-ordinates

Scattergraph of Archer Company • Series1 4500 June-3900$ 4000 3500 Feb-2900$ May-2900$ 3000 April-2600$ Jan-2400$ March-2300$ Shipping Expenses July --1800$ 1500 1000 500 Units Shipped

In this case units shipped is taken on the X-axis(Horizontal) and Shipping Expenses on the Y-axis(Vertical)

Co-ordinates in the question are

Month	On the X-axis	On Y-axis
January	3	2400$
February	6	2900$
March	4	2300$
April	5	2600$
May	7	2900$
June	8	3900$
July	1	1800$

I hope this was helpful.Please share you Feedback.Thank You.