Online stock brokerages. how closely does the number off trading

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 scatter plot