| Quiz 7 Final quiz. This quiz is posted on Friday December 11 and needs to be compleeted no later than |
| Thursday December 17 at 11:59 pm. No work received after this date will be graded. NO EXCUSES. |
| WILL BE ACCEPTED. Be sure to show all your work. This problem is expected to be submitted in |
| the form illustrated in class and shown on Chapter 14 Excel sheets |
| The American Association of Individual Investors on-line discount brokers survey polls members on |
| their experiences with discount brokers. As part of the survey, members were asked the quality of the |
| speed of execution with their brokers, as well as to provide an overall satisfaction rating for electronic |
| trades. Possible responses (scores) were no opinion (0), unsatisfied (1), somewhat satisfied (2), |
| satisfied (3), and very satisfied (4). For each broker summary scores were computed by calculating |
| a weighted average of the scores provided by each respondent. A portion of the survey follows: |
| Brokerage | Speed | Satisfaction |
| Scottrade, Inc. | 3.4 | 3.5 |
| Charles Schwab | 3.3 | 3.4 |
| Fidelity Brokerage Services | 3.4 | 3.9 |
| TD Ameritrade | 3.6 | 3.7 |
| E*Trade Financial | 3.2 | 2.9 |
| Vanguard Brokerage Services | 3.8 | 2.8 |
| USAA Brokerage Services | 3.8 | 3.6 |
| Thinkorswim | 2.6 | 2.6 |
| Wells Fargo Investments | 2.7 | 2.3 |
| Interactive Brokers | 4.0 | 4.0 |
| Zecco.com | 2.5 | 2.5 |
| Develop a scatter diagram for these data with the speed of execution as the dependent variable. |
| Develop a least squares estimated regression equation for the data. |
| Compute SSE,SST, and SSR |
| Compute the coefficient of determination (r2) and comment on the goodness of fit |
| Compute the sample correlation coefficient |
axxxd.gh
Quiz7.xlsx
