Question

4.

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.

Broker​Clients​Sales

​1​48​72

​2​11​37

​3​42​64

​4​33​55

​5​15​29

​6​15​34

​7​25​58

​8​36​59

​9​28​44

​10​30​48

​11​17​31

​12​22​38

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)

Please use the regression analysis results you get from the information above to answer the following questions. Confidence level is 95%

11. What is the coefficient of determination? (3 points)

Answer 1

Regression Equation: Sales=17.175+1.127*Clients

11.)coefficient of determination (R²)=0.8536