math

Question 1: Problem 2.13 from the text.  Use excel to construct your scatter plot.  Write your answers to the questions in a word document.  Include the scatter plot you created in your word document.

Online Stock Brokerages. How closely does the number off trading accounts relate to the total assets of the 10 largest online stock brokerages? The table below presents data on these brokerages. The number of accounts is in the thousands, and assets are in billions of dollars

Brokerage	Accounts (1000)	Assets ($Billions)
Ameritrade	428	19.5
Charles Schwab	2500	219.0
Datek	205	5.5
Discover	134	5.9
DLJ Direct	590	11.2
E* Trade	909	21.1
Fidelity	2300	160.0
National Discount Brokers	125	6.8
Suretrade	130	1.3
TD Warehouse	615	38.3

(a) Does the wording of the wording of initial question in this exercise indicate which variable should be treated as the response?

(b) Construct a scatterplot with Assets on the vertical axis and Accounts on the horizontal axis

(c) Comment on the form, direction, and strength of the relationship between Assets and Accounts

(d) Two brokerages stand out from the rest of the data. Identify these two brokerages by putting their names near their respective data points in the scatterplot