Use the Chapter 5 Excel Data file which has been provided to calculate the Means, Standard Deviations, and Confidence Intervals (Mean +/- 1 Standard Deviation) for each of the components of the job. The Standard Deviation can be that of a sample (S) or a population (P). The Excel file has a Population formula and the PPT shows a Sample formula. I want you to use a Sample formula.

Next, identify the 3 most important aspects of the job which you would want to include in the job description and advertisement for the job.

Then write a job description and advertisement for the job.

B C D D E F G M Tasks SME 1 SME 2 SME 3 SME 4 SME 5 SME 6 SME 7 SMER Mean SD Mean - 1 SD Mean+ 1 SD 1. Speaks with customers who are interested in new products. . 4 3 4 4 5 2 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. Coordinates with supervisor to resolve customer problems. 4 4 5 4 4 4 5 4 4 4.25 0.43 3.82 4.68 4. Stays abreast of current sales and specials provided by the company 5 by checking company website. 2 1 1 3 4 2 2 5 1 1 2.50 1.32 1.18 3.82 5. Uses telephone system to answer customer calls promptly. 3 3 4 4 3 4 3 3 4 4 4 3.50 0.50 3.00 4.00 6. Uses computer to look up customer orders. 4 4 4 5 4 4 4 4 4 4 4 4.13 0.33 3.79 4.46 7. Uses telephone system to notify customers about products 8 received. 1 1 1 Z 2 1 2 2 1 1 1 1 1.3B 0.48 0.89 1.86 8. Uses e-mail system to notify customers about products received. 5 5 5 4 4. 3 3 3 3 4 5 4.00 0.87 3.13 4.87 9 2 2 4 2 2 3 2 2 2 2.3B 0.70 1.68 3.07 4 3 4 5 3 4 4 3.88 0.60 3.28 4.47 9. Cleans office kitchen area when it is their turn to do so. 10 10. Uses sit/stand desk correctly throughout the day to maintain own 11 personal health. 11. Provides customers with refunds, as appropriate, if there is any , , 12 problem with the product. 1 1 1 1 1 1 1 1 1 1.00 0.00 1.00 1.00 Sheet1 + + Ready O + 87% Comments Next, identify the 3 most important aspects of the job which you would want to include in the job description and advertisement for the job. So what are the three most important items? Then write a job description and advertisement for the job. B C D D E F G M Tasks SME 1 SME 2 SME 3 SME 4 SME 5 SME 6 SME 7 SMER Mean SD Mean - 1 SD Mean+ 1 SD 1. Speaks with customers who are interested in new products. . 4 3 4 4 5 2 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. Coordinates with supervisor to resolve customer problems. 4 4 5 4 4 4 5 4 4 4.25 0.43 3.82 4.68 4. Stays abreast of current sales and specials provided by the company 5 by checking company website. 2 1 1 3 4 2 2 5 1 1 2.50 1.32 1.18 3.82 5. Uses telephone system to answer customer calls promptly. 3 3 4 4 3 4 3 3 4 4 4 3.50 0.50 3.00 4.00 6. Uses computer to look up customer orders. 4 4 4 5 4 4 4 4 4 4 4 4.13 0.33 3.79 4.46 7. Uses telephone system to notify customers about products 8 received. 1 1 1 Z 2 1 2 2 1 1 1 1 1.3B 0.48 0.89 1.86 8. Uses e-mail system to notify customers about products received. 5 5 5 4 4. 3 3 3 3 4 5 4.00 0.87 3.13 4.87 9 2 2 4 2 2 3 2 2 2 2.3B 0.70 1.68 3.07 4 3 4 5 3 4 4 3.88 0.60 3.28 4.47 9. Cleans office kitchen area when it is their turn to do so. 10 10. Uses sit/stand desk correctly throughout the day to maintain own 11 personal health. 11. Provides customers with refunds, as appropriate, if there is any , , 12 problem with the product. 1 1 1 1 1 1 1 1 1 1.00 0.00 1.00 1.00 Sheet1 + + Ready O + 87% Comments Next, identify the 3 most important aspects of the job which you would want to include in the job description and advertisement for the job. So what are the three most important items? Then write a job description and advertisement for the job