Some association On-Une 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 (I). somewhat satisfied (2) satisfied (3), and very satished (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. X Open spreadsheet a. Choose the correct scatter diagram for these data with the speed of execution as the independent variable. The correct scatter diagram is diagram A Satisfaction 4.5 13.5 b. What does the scatter diagram developed in part() indicate about the relationship between the two variables? The scatter diagram indicates a positive linear relationship between 2 speed of execution rating and yoverall satisfaction rating for electronic trades c. Develop the least squares estimated regression equation Satisfaction = Speed (to 3 decimals) d. Provide an interpretation for the slope of the estimated regression equation (to 3 decimals), The slope of the estimated regression line is approximately So, a one unit increase v the speed of execution rating will increase the overall satisfaction song by approximately points Suppose Wells Fargo Investments developed new software to increase their speed of execution rating of the new software is able to increase the speed of execution rating from the current value of 2.3 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) Some association On-Une 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 (I). somewhat satisfied (2) satisfied (3), and very satished (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. X Open spreadsheet a. Choose the correct scatter diagram for these data with the speed of execution as the independent variable. The correct scatter diagram is diagram A Satisfaction 4.5 13.5 b. What does the scatter diagram developed in part() indicate about the relationship between the two variables? The scatter diagram indicates a positive linear relationship between 2 speed of execution rating and yoverall satisfaction rating for electronic trades c. Develop the least squares estimated regression equation Satisfaction = Speed (to 3 decimals) d. Provide an interpretation for the slope of the estimated regression equation (to 3 decimals), The slope of the estimated regression line is approximately So, a one unit increase v the speed of execution rating will increase the overall satisfaction song by approximately points Suppose Wells Fargo Investments developed new software to increase their speed of execution rating of the new software is able to increase the speed of execution rating from the current value of 2.3 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)
