Some association On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (l), 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 results is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
Some association On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (l), 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 results is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
100%
Some association On-Line Discount Broker Survey polls members on their experiences with discount brokers. As part of the survey, members were asked to rate the quality of the speed of execution with their broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (scores) were no opinion (0), unsatisfied (l), 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 results is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions.
Transcribed Image Text:ATH
2.5
Speed of Execution
b. What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
The scatter diagram indicates a positive ŵ
x = speed of execution rating and
y = overall satisfaction rating for electronic trades.
c. Develop the least squares estimated regression equation.
Satisfaction:
-2.5
=
3.5
Check My Work
+
Speed (to 3 decimals)
d. Provide an interpretation for the slope of the estimated regression equation (to 3 decimals).
So, a one unit
The slope of the estimated regression line is approximately
rating by approximately
points.
4.5
linear relationship between
Reset Problem
increase
e. Suppose Wells Fargo Investments developed new software to increase their speed of execution rating. If the new software is able to increase their speed of execution rating
from the current value of 2.2 to the average speed of execution rating for the other 10 brokerage firms that were surveyed, what value would you predict for the overall
satisfaction rating?
(to 3 decimals)
in the speed of execution rating will increase the overall satisfaction
Transcribed Image Text:Excel template - Saved
File
5
123456789
។
Home
Insert
A
Brokerage
Arial
X ✓ fx
10
11
12 Zecco.com
13
14
15
16
17
18
19
20
21
Scottrade, Inc.
Charles Schwab
Fidelity Brokerage Services
TD Ameritrade
E*Trade Financial
Vanguard Brokerage Services
USAA Brokerage Services
Thinkorswim
Wells Fargo Investments
Interactive Brokers
Draw Page Layout
✓ 10 V
B
B
Speed Satisfaction
3.6
3.3
3.9
3.6
3.0
2.7
3.5
2.4
2.2
4.1
2.4
3.3
3.1
3.5
3.4
3.3
3.8
3.6
2.5
2.6
3.8
2.5
Formulas
D
O Search (Option + Q)
E
Data
F
Review
G
View
V ab
H
I
He
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 11 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman