Overview
Using the provided probability distributions of job satisfaction scores for information-systems (IS) senior executives and middle managers, calculate the following:
A. The expected value of job satisfaction scores for both groups. B. The variance of job satisfaction scores for both groups. C. The standard deviation of job satisfaction scores for both groups. D. Compare the overall job satisfaction between senior executives and middle managers based on your results.
Show all steps, use proper probability formulas, and express your answers as simplified fractions or decimals.
Has to be in excel with formulas