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 De

excel assignment help

Data

Don't use plagiarized sources. Get Your Custom Assignment on
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 De
From as Little as $13/Page

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

Leave a Comment

Your email address will not be published. Required fields are marked *