For Project 4, we are just asking for the sales figures for
2019 and 2020, which is given. Disregard Step 2 in the steps to completion and
use the attached documents instead.
Step 1: Refresh Your Math, Statistics and Excel Skills
Step 2: Set Up Your Spreadsheet
Step 3: Add Data
In Section 1 on the Data page, complete each column of the spreadsheet to arrive at the desired calculations.
When you're ready, move on to the next step, where you will use functions to summarize the data.
Step 4: Use Functions to Summarize the Data
With this step complete, you’re ready to begin your analysis.
Step 5: Analyze the Workforce
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.
Step 6: Use the Analysis Toolpak
you will now use the Analysis Toolpak to do those same functions. This is a handy feature to know. Remember that there may be some minor differences in the answers depending on the version.
You should now have Tab 2 complete: Excel Summary Stats. Next, you’ll create charts and a histogram for Tabs 3 and 4
Step 7: Create Charts and a Histogram
In this step, you will build Tab 3: Graphs—Charts and Tab 4: Histogram. After you complete these tabs, you’ll be ready to sort the data.
Step 8: Copy and Sort the Data
In this step, you will create Tab 5: Sorted Data. When you’re finished, you’ll be ready to conduct your quantitative analysis.
Step 9: Conduct Quantitative Analysis
Apply your quantitative reasoning skills to answer five questions that demonstrate your interpretation of the data. The questions are located on the QR Questions_Responses tab in your workbook.
After you have answered the five questions, please finish the project by writing a short essay. Your short essay will include:
- a one-paragraph narrative summary of your findings, describing patterns of interest
- an explanation of the potential relevance of such patterns
- a description of how you would investigate further to determine if your results could be perceived as good or bad for the company.
Prepare your responses in your workbook on the QR Questions_Responses tab.
Step 10: Submit Your Completed Workbook and Analysis
You’re now ready to submit your workbook and analysis for review and feedback. Review the requirements for the final deliverable to be sure you have:
- Excel Workbook with Six Tabs
- Tab 1: Data – completed data sheet (Steps 1–6 above)
- Tab 2: Excel Summary Stats (Step 6)
- Tab 3: Graphs – Charts (Step 7)
- Tab 4: Histogram (Step 7)
- Tab 5: Sorted Data (Step 8)
- Quantitative Analysis (Step 9; see detail below and move to first position upon completion.)
- Quantitative Analysis: Answers to Questions and Short Essay
Prepare your response in this workbook. Create a tab for Quantitative Analysis, create a text box, and paste your answers to the questions in it. Move the Quantitative Analysis tab to the first tab position.
Your final workbook tabs:
Format to Be Printed
- Quantitative Analysis
- Excel Summary Stats
- Sorted Data
Format this workbook so that all the spreadsheets can be printed.