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.

Fallch x (1 unr x E Fallch x M Inbox x up Messa X Mail - X ACCT X Cours X Cenga x MindT X Excel ( X , Cenga X + X C D @ about:blank Email-school = Introduction to Soci.. Connect-Biol 1107 : D2L ] MATH MindTap - Cengage. He child support Rick Barker's Music. Digital Resources f.. Quesitons for Discu.. X Excel template - Saved Home Insert Data Review View Tell me what you want to do Comments File Formulas Help X Cut = Arial 10 A A General AutoSum ZP O [ Copy E Paste BIUDab YA $ * % " -00 Conditional Format Cell Insert Delete Format Clear Sort & Find & Format Painter Formatting . as Table ~ Styles v Filter ~ Select v Undo Font Alignment Number Tables Cells Editing Clipboard F2 fx A B C D E F G H I J K L M N O P Q Brokerage Speed Satisfaction Part a. Use the area below to draw a scatter diagram. Scottrade, Inc. 3.6 3.4 Charles Schwab 3.3 3.2 Fidelity Brokerage Services 3.9 3.5 TD Ameritrade 3.7 3.6 E*Trade Financial 3.0 3.0 Vanguard Brokerage Services 2.7 3.6 USAA Brokerage Services 3.7 3.7 9 Thinkorswim 2.6 2.6 10 Wells Fargo Investments 2.3 2.6 11 Interactive Brokers 4.0 4.1 12 Zecco.com 2.3 2.6 13 14 15 16 17 18 19 20 Part c. Formula & Data + Calculation Mode: Automatic Workbook Statistics Help Improve Office - 100% + 9 4 10:40