Question:The managers of a brokerage firm are interested in finding out
if the number of new...
Question
The managers of a brokerage firm are interested in finding out
if the number of new...
The managers of a brokerage firm are interested in finding out
if the number of new clients a broker brings into the firm affects
the sales generated by the broker. They sample 12 brokers and
determine the number of new clients they have enrolled in the last
year and their sales amounts in thousands of dollars. These data
are presented in the table that follows.
BrokerClientsSales
14872
21137
34264
43355
51529
61534
72558
83659
92844
103048
111731
122238
Please use Excel to conduct the Simple Linear Regression
Analysis on the data set above and show the summary output. Please
attach the output. (3 points)