please provide results in excel The Association of Individual Investors (AII) 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 A portion the survey results follow Brokerage Satisfaction with Trade Price Satisfaction with Speed of Execution Overall Satisfaction with Electronic Trades AA 3 3 3 1 3 4 BB 3 2 3 3 3 3 CC 3 1 3 3 4 DD 2 9 3 5 3 7 EE 2 8 3 2 2 9 FF 2 4 3 2 2 7 GG 2 6 3 8 2 8 HH 2 4 3 8 3 6 II 2 6 2 6 2 6 JJ 2 3 2 7 2 3 KK 3 7 4 4 LL 2 5 2 5 2 5 MM 3 3 3 NN 4 1 2 (a) Develop an estimated regression equation using trade price and speed of execution to predict overall satisfaction with the broker Letx 1 represent satisfaction with Trade Price Letx 2 represent satisfaction with speed of execution If required, round your answers to four decimal places For subtractive or negative numbers use a minus sign even if there is a sign before the blank (Example 300) x 1 x 2 What is the coefficient of determination If required, round your answers to four decimal places Interpret the coefficient of determination The input in the box below will not be graded, but may be reviewed and considered by your instructor (b) Use thettest to determine the significance of each independent variable What are your conclusions at the 0 05 level of significance The input in the box below will not be graded, but may be reviewed and considered by your instructor (c) Interpret the estimated regression parameters Are the relationships indicated by these estimates what you would expect The input in the box below will not be graded, but may be reviewed and considered by your instructor (d) Lakes Investments has developed a new electronic trading system and would like to predict overall customer satisfaction assuming they can provide satisfactory levels of service levels (3) for both trade price and speed of execution Use the estimated regression equation developed in part (a) to predict overall satisfaction level for Lakes Investments if they can achieve these performance levels If required, round your answer to one decimal places (e) What concerns (if any) do you have with regard to the possible responses the respondents could select on the survey The input in the box below will not be graded, but may be reviewed and considered by your instructor

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 13, 2024

please provide results in excel The Association of Individual Investors (AII) On-Line Discount Broker Survey polls members on their experiences with electronic trades handled by

please provide results in excel

The Association of Individual Investors (AII) 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. A portion the survey results follow.

Brokerage	Satisfaction with Trade Price	Satisfaction with Speed of Execution	Overall Satisfaction with Electronic Trades
AA	3.3	3.1	3.4
BB	3.2	3.3	3.3
CC	3.1	3.3	4
DD	2.9	3.5	3.7
EE	2.8	3.2	2.9
FF	2.4	3.2	2.7
GG	2.6	3.8	2.8
HH	2.4	3.8	3.6
II	2.6	2.6	2.6
JJ	2.3	2.7	2.3
KK	3.7	4	4
LL	2.5	2.5	2.5
MM	3	3	3
NN	4	1	2

(a)	Develop an estimated regression equation using trade price and speed of execution to predict overall satisfaction with the broker.
Letx₁represent satisfaction with Trade Price.
Letx₂represent satisfaction with speed of execution.
If required, round your answers to four decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)
=+x₁+x₂
What is the coefficient of determination?
If required, round your answers to four decimal places.
Interpret the coefficient of determination.
The input in the box below will not be graded, but may be reviewed and considered by your instructor.


(b)	Use thettest to determine the significance of each independent variable. What are your conclusions at the 0.05 level of significance?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.


(c)	Interpret the estimated regression parameters. Are the relationships indicated by these estimates what you would expect?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.


(d)	Lakes Investments has developed a new electronic trading system and would like to predict overall customer satisfaction assuming they can provide satisfactory levels of service levels (3) for both trade price and speed of execution. Use the estimated regression equation developed in part (a) to predict overall satisfaction level for Lakes Investments if they can achieve these performance levels.
If required, round your answer to one decimal places.

(e)	What concerns (if any) do you have with regard to the possible responses the respondents could select on the survey?
The input in the box below will not be graded, but may be reviewed and considered by your instructor.