A D D G I J K L M Tasks SME 1 SME 2 SME 3 SME 4 SME 5 SME 6 SME 7 SMES Mean SD Mean - 1 SD + Mean+ 1 SD 1 1. Speaks with customers who are interested in new products. 4 3 4 4 5 2 4 5 5 3.88 0.93 2.95 4.80 2 2. Works to solve customer complaints. 5 5 5 5 5 5 5 5 5 5.00 0.00 5.00 5.00 3 3. Coordinates with supervisor to resolve customer problems. 4 4 4 5 4 4 4 5 4 4.25 0.43 3.82 4.68 4 4. Stays abreast of current sales and specials provided by the company 5 by checking company website. 2 1 3 4 2 2 5 1 2.50 1.32 1.18 3.82 5. Uses telephone system to answer customer calls promptly. 3 3 4 3 4 3 4 4 3.50 0.50 3.00 4.00 6 6. Uses computer to look up customer orders. . 4 4 5 4 4 4 4 4 4.13 0.33 3.79 4.46 7 7. Uses telephone system to notify customers about products received. 1 1 2. 1 2 2 1 1 1.38 0.48 0.89 1.86 8 8. Uses e-mail system to notify customers about products received. 5 5 4 3 3 3 3 4 5 4.00 0.87 3.13 4.87 9 4 2 2 3 2 2 2.38 0.70 1.68 3.07 5 4 4 4 3 4 3.88 0.60 3.28 4.47 9. Cleans office kitchen area when it is their turn to do so. 2 2 2 10 10. Uses sit/stand desk correctly throughout the day to maintain own 4 3 11 personal health. 11. Provides customers with refunds, as appropriate, if there is any 1 1 1 12 problem with the product. 13 14 O Screen Shot 2022-03-27 at... 1 1 1 1 1 1 1.00 0.00 1.00 1.00 Q Search Questions You just learned how to calculate a mean and standard deviation (SD) using Microsoft Excel. Now, your job is to calculate the means and SDs for the remaining tasks in the data table. After doing so, respond to the following questions. 1. Which 3 tasks had the highest means? Which 3 tasks had the lowest means? 2. Which 3 tasks had the highest SD? Which 3 tasks had the lowest SD? What do these SDs indicate? 3. Based on the means and SDs, create a Confidence Interval. Which three tasks would you definitely want to include in the Job Description and in an advertisement for the position