You’ve summarized the data. Next, you will employ descriptive or summary statistics to analyze the workforce. Your summary tables answer the question, “how many?” Now you will calculate mean, median, and mode for the categories of data, and derive the deviation, variance, and dispersion, and distribution. This is where it gets interesting!
You will be working in Section 3 of the Data tab in the spreadsheet to complete the descriptive statistics for the five categories (salary, hourly rate, years of service, education, and age). Using Excel formulas, complete the table.
After you have used Excel formulas to find this information, you will next use the Toolpak to find your summary statistics.