Conduct Quantitative Analysis

Anonymous
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

Use template

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

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.

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.

• 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.

Set up Your Spreadsheet 1. Open the spreadsheet. 2. Save as and re-name it: LASTNAME_Workforce_Composition_Analysis_Semester_Year 3. Format the spreadsheet for landscape with Narrow Margins. 4. Enter your name, date, and page number in the Footer area of the sheet. 5. Format the entire spreadsheet for Calibri 11 font. 6. The gray box at the top of the spreadsheet indicates what cell formatting to use for each column. Format columns accordingly. Note: There are three sections to the spreadsheet on the Data tab, separated by gray bands where you will work: Section 1: Data, Section 2: Summary Tables, and Section 3: Descriptive Statistics. Used with permission from Microsoft. Excel screen showing how the cells in each column should be formatted.

Assignment_Assassin
School: University of Maryland

Hello,Attached find the completed...

flag Report DMCA
Review

Anonymous
awesome work thanks

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