For this, problem, please include the excel procedure you usedto arrive at an answer (screenshots, explanation, actual file,etc.).

Brokerage	Overall Satisfaction with Electronic Trades	Satisfaction with Trade Price	Satisfaction with Speed of Execution
Scottrade, Inc.	3.5	3.4	3.4
Charles Schwab	3.4	3.2	3.3
Fidelity Brokerage Services	3.9	3.1	3.4
TD Ameritrade	3.7	2.9	3.6
E*Trade Financial	2.9	2.9	3.2
(Not listed)	2.7	2.5	3.2
Vanguard Brokerage Services	2.8	2.6	3.8
USAA Brokerage Services	3.6	2.4	3.8
Thinkorswim	2.6	2.6	2.6
Wells Fargo Investments	2.3	2.3	2.7
Interactive Brokers	4.0	3.7	4.0
Zecco.com	2.5	2.5	2.5
Firstrade Securities	4.0	3.0	3.0
Banc of America Investment Services	2.0	4.0	1.0

The American Association of Individual Investors (AAII) On-LineDiscount Broker Survey polls members on their experiences withelectronic trades handled by discount brokers. As part of thesurvey, members were asked to rate their satisfaction with thetrade price and the speed of execution, as well as provide anoverall satisfaction rating. Possible responses (scores) were noopinion (0), unsatisfied (1), somewhat satisfied (2), satisfied(3), and very satisfied (4). For each broker, summary scores werecomputed by computing a weighted average of the scores provided byeach respondent. A portion the survey results follow (AAII website, February 7, 2012).

A. Develop an estimated regression equation using trade priceand speed of execution to predict overall satisfaction with thebroker. Interpret the coefficient of determination.

B. Use the t test to determine the significance of eachindependent variable. What are your conclusions at the 0.05 levelof significance?

C. Interpret the estimated regression parameters. Are therelationships indicated by these estimates what you wouldexpect?

D. Finger Lakes Investments has developed a new electronictrading system and would like to predict overall customersatisfaction assuming they can provide satisfactory service levels(3) for both trade price and speed of execution. Use the estimatedregression equation developed in part (a) to predict overallsatisfaction level for Finger Lakes Investments if they can achievethese performance levels.

E. What concerns (if any) do you have with regard to thepossible responses the respondents could select on the survey