Methodology: The approach used to compute annual salary data descriptive statistics are show below: Step 1: Data>Data Analysis> Descriptive Statistics Step 2: Select input range> Output range> Summary Statistics Step 3: Output Analysis: Data set value was higher than -1 reflects that the distribution of data is symmetrical and the skewness is identified to be not substantial (Jelen 2013). Reference Jelen B. (2013). Excel 2013 in depth. US: Que Publishing. [...]
This will include an excel spreadsheet only do (Module 2 Descriptive Statistics) Two data sets are used during this course for three homework assignments: Module Two, Descriptive Statistics: 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. Specifically, the following critical elements must be addressed: I. Methodology II. Analysis Guidelines for Submission: For the Modules Two and Four assignments, submit both a 1-page Word document and an Excel spreadsheet. For the Module 6 assignment, submit only a 1-page Word document.