Some association On-Line Discount Broker Survey polle members on their experiences with discount brokens. As part of the survey, members were asked to rate the quality of the speed of execution with their bre a. Choose the correct scatter diagram for the The correct scatter diagram in diagram A. ✔✔ Sabatin Sowed of Exce th the speed of execution as the independent variable b. Wha does the scatter diagram developed in part (a) indicate about the relationship between the two variables? The scatter diagram indicates aportive Check My Work Reset Problem air broker as well as provide an overall satisfaction rating for electronic trades. Possible responses (cor) were no opinion (0), unestified (0), 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 Exal Online file below. Construct a spreadsheet to answer the following questione. near relationship between a speed of execution rating and overall satisfaction rating for electronic trades. c. Develop the least square estimated regression equation Satisfaction- + - Speed (to 3 decimale) d. Provide an interpretation for the slope of the estimated regression equation (to 3 decimal) The slope of the estimated regression line is approximately So, a one unit incate in the speed of execution rating will increase the overall satisfaction rating by approximately points. a. Suppon 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.3 to the average speed of execution nating for the other 10 brokerage (3 decimal) 1 2 Scottrade, Inc. 3 Charles Schwab 4 Fidelity Brokerage Services 5 TD Ameritrade 6 E*Trade Financial 7 Vanguard Brokerage Services 8 USAA Brokerage Services 9 Thinkorswim 10 Wells Fargo Investments 11 Interactive Brokers 12 Zecco.com 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 A Brokerage 29 30 31 B Speed 3.6 3.3 3.9 3.7 2.7 2.8 3.5 2.5 2.3 4.0 2.5 C Satisfaction 3.4 3.1 3.2 3.5 3.0 3.7 3.7 2.5 2.6 3.9 2.3 D E Part a. Part c. Part e. G H Use the area below to draw a scatter diagram. Slope Intercept Speed of Brokerage Discussed Average Speed of Execution Estimation of the Overall Satisfaction Rating (to 3 decimals) 2.3 I Formula #N/A #N/A #N/A #N/A J K