Description
Instructions
Data Set 1 presents a sample of annual salaries for recently hired plant operators at a chemical manufacturing company. Use Excel's ToolPak (or any statistical package that you are comfortable with) to compute descriptive statistics for the data. Submit your statistical output from Excel, which should include values for the mean, median, mode, sample variance, and sample standard deviation, and a one-page Word document in which you present an analysis of your results.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
I've attached the answer, good luck!
Annual Salary
Sample of Annual Salaries of Plant Operators
74343
70532
67956
78024
80197
69444
81655
73438
79111
75337
71764
80550
Descriptive statistics
Annual Salary
Mean
75,195.92
Standard Error
1,352.86
Median
74,840.00
Mode
#N/A
Standard Deviation
4,686.46
Sample Variance 21,962,862.27
Kurtosis
(1.44)
Skewness
(0.09)
Range
13,699.00
Minimum
67,956.00
Maximum
81,655.00
Sum
902,351.00
Count
12
ries of Plant Operators
Surname 1
Name
Supervisor
Course
Date
Descript...