- Home >
- Mathematics >
- Conduct Quantitative Analysis

# Conduct Quantitative Analysis

*label*Mathematics

*timer*Asked: Jan 28th, 2019

*account_balance_wallet*$40

### Question Description

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:

**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:

- Quantitative Analysis
- Data
- Excel Summary Stats
- Graphs–Charts
- Histogram
- Sorted Data
**Format to Be Printed**

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

Studypool values your privacy. Only questions posted as Public are visible on our website.

## Tutor Answer

### Freakonomics

by Stephen J. Dubner and Steven D. Levitt

### What Happened

by Hillary Clinton

### The Restless Wave

by John McCain

### Fahrenheit 451

by Ray Bradbury

### Siddhartha

by Hermann Hesse

### The President is Missing

by James Patterson, Bill Clinton

### The Scarlet Letter

by Nathaniel Hawthorne

### The Goldfinch

by Donna Tartt

### How to Win Friends and Influence People

by Dale Carnegie

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors