Conduct Quantitative Analysis

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

Use template

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:

  1. 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.)
  2. 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:

    • Quantitative Analysis
    • Data
    • Excel Summary Stats
    • Graphs–Charts
    • Histogram
    • Sorted Data
  1. Format to Be Printed

Format this workbook so that all the spreadsheets can be printed.