excel assignment help
Data
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
Sheet2
Sheet3
