2-2: Preparing for Data Analysis (Excel)
For this assignment, you will continue to use the workbook titled Labor Hours that you created for your Module One assignment. You will be looking at data related to employees who are full-time staff members and those who you hire as-needed on a contract basis.
You will use the IF function to isolate the data for each status (full-time or contract), and then you will use a pivot table and a pie chart to demonstrate different ways of displaying the data. Finally, you will program a spreadsheet to calculate mean, median, and mode, and you will provide a summary about these measures of central tendency.
Previous answers to this question
This is a preview of an assignment submitted on our website by a student. If you need help with this question or any assignment help, click on the order button below and get started. We guarantee authentic, quality, 100% plagiarism free work or your money back.
Get The Answer