The American Association of Individual Investors (AAII) On-Line Discount Broker Survey polls members on their experience

[answerhappygod]

The American Association of Individual Investors (AAII) On-Line
Discount Broker Survey polls members on their experiences with
electronic trades handled by discount brokers. As part of the
survey, members were asked to rate their satisfaction with the
trade price and the speed of execution, as well as provide an
overall satisfaction rating. 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 computing a weighted average of the scores provided by
each respondent. The data file (broker) is enclosed. a. Find the
correlation coefficients between overall satisfaction and trade
price as well as overall satisfaction and speed of execution. Which
between speed or trade price would be more suitable to use to
predict overall satisfaction? b. Run a regression to predict
overall satisfaction based on trade price. Give your equation. c.
Use your equation to estimate overall satisfaction when trade price
is 2.9. Please show how u put it in excel