Conduct Quantitative Analysis

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

  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.

Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you have seen in the workforce. In this final section, you w questions and write a short essay. 1. From the created histogram, it appears that a large share of employees have a salary between $61,000–$140,000 or $141,000 may indicate a reasonable promotion rate for new employees. Is this distribution unimodal or bimodal? Please explain. 2. The line chart, as detailed in your "Graph Charts" Excel spreadsheet, shows sales generally increasing over the years, althou years were notably lower. Assuming that the sales are linear, please use the Forecast tool to find projected sales for 2019 and way to do this is to highlight the sales from the data page and apply the Forecast tool to this data. Your output will be a chart and a ne projected sales for average, upper, and lower range growth. 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statistics, describe you deviations. What does this tell you about the variables? 4. The company has a keen interest in the educational, race, and gender makeup of its workforce. Its emphasis is on a diverse, d From your "Graph Charts" spreadsheet, describe your pie chart findings for these characteristics of the workforce. Describe how the company was meeting expectations on these characteristics. 5. The company is conducting an analysis on how many positions to create to keep up with demand. Specifically, it wants to know number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your findings. FINAL ESSAY: Now that you have done all the work with data, you will write a short three- to four-paragraph summary of your analysis. This is have done a wonderful job with your analysis, you can never assume that the end user will be able to interpret the data the way understood. Supporting narrative is helpful. Never simply provide a "raw data" dump. Instead, seek to provide information! Structure your essay like this: a. Write a one-paragraph narrative summary of your findings, describing patterns of interest. Provide an explanation of the potential relevance of such patterns. a. b. c. Write a one-paragraph narrative summary of your findings, describing patterns of interest. Provide an explanation of the potential relevance of such patterns. Provide a description of how you would investigate further to determine if your results are "good or bad" for the company. Prepare your response in this workbook. (Simply expand this text box to accommodate your essay and other answers n, you will answer five 141,000–$190,000. This hough sales in the first two and 2020. Hint: An easy hart and a new sheet with the more narrow the describe your standard erse, dynamic workforce. ow you would determine if o know an estimate of the his is important. While you e way it should be any. answers.) Workforce Profile Analysis Section 1: Complete all Columns in Data Set Format for: Number Date mm/dd/yy Text Currency Currency Number Year Ending 12/31/2014 Emp # 1001 1002 1003 1004 1005 1006 1014 1015 1016 1018 1019 1020 1024 1036 1038 1043 1048 1049 1053 1054 1055 1056 1057 1058 Hire Date 03/15/99 12/15/99 09/07/12 06/13/12 10/25/08 08/05/06 06/03/09 07/08/13 09/23/08 01/15/11 05/03/12 05/21/07 08/17/11 09/25/00 08/21/12 06/18/09 09/19/13 02/23/04 05/31/13 09/08/09 06/15/01 06/04/01 9/30/2001 05/06/07 Role CEO CIO Sr Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staff Investigator Cyber Analyst Acctg/Fin Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst IT Staff Forensics Analyst Physical Security IT Staff Cyber Analyst Cyber Analyst Controller Cyber Analyst Cyber Analyst Cyber Analyst Salary $290.210 $279.723 $166.750 $131.924 $142.687 $150.307 $98.818 $81.250 $92.719 $72.836 $82.157 $98.317 $83.005 $107.822 $85.451 $76.168 $61.655 $88.421 $80.241 $85.293 $149.836 $106.663 $107.385 $98.059 Hrly Rate Yrs of Svc 1059 1060 1061 1062 1069 1070 1071 1072 1075 1079 1083 1084 1085 1088 1096 1097 1098 1101 1102 1104 1105 1106 1108 1109 1113 1114 1116 1117 1118 1119 1128 1130 1132 1133 02/14/12 02/02/09 03/04/13 07/08/09 02/03/11 08/21/09 01/09/05 08/08/05 01/14/10 10/15/03 08/27/09 4/30/2000 03/15/99 10/03/11 03/06/06 08/14/05 01/13/14 06/08/02 04/08/00 02/01/05 09/06/12 5/9/2002 06/15/07 02/22/07 05/02/12 09/08/00 12/30/08 04/05/00 05/27/09 08/15/12 06/07/10 03/15/99 07/10/09 02/12/09 Acctg/Fin Cyber Analyst Acctg/Fin Cyber Mgr Cyber Software Engineer Cyber Analyst Cyber Software Engineer Cyber Software Engineer Cyber Analyst Investigator Cyber Analyst Cyber Analyst Public and Business Office Team Sr Forensics Mgr Cyber Analyst Cyber Analyst Cyber Software Engineer Investigator IT Staff Cyber Analyst Investigator Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Quality Assurance Forensics Analyst Cyber Analyst Cyber Mgr Cyber Analyst Cyber Analyst Public and Business Office Team $126.589 $99.931 $112.238 $162.803 $179.938 $95.498 $166.238 $167.019 $84.317 $71.459 $85.396 $108.771 $135.671 $173.974 $100.502 $110.571 $162.245 $125.994 $88.900 $112.450 $92.633 $115.744 $127.403 $99.201 $82.124 $151.695 $112.235 $111.526 $136.360 $121.262 $174.104 $79.438 $85.822 $93.337 1136 1138 1139 1140 1141 1142 1145 1146 1147 1150 1153 1156 1167 1169 1175 1180 1185 1186 1188 1189 1190 1191 1196 1198 1201 1202 1210 1215 1216 1218 1220 1220 1224 1226 12/14/11 10/18/10 4/12/2008 07/10/09 06/18/09 06/17/09 02/16/09 11/05/09 09/15/04 04/26/13 02/05/12 05/21/11 11/15/11 01/22/09 09/25/02 01/24/05 04/16/09 08/14/05 05/16/09 02/12/10 5/9/2002 8/31/1999 09/08/09 09/17/10 08/01/08 03/15/99 09/10/06 05/06/07 07/12/06 07/23/09 10/16/02 04/15/00 09/23/13 06/02/07 Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Public and Business Office Team Cyber Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Acctg/Fin Cyber Analyst Cyber Software Engineer Physical Security Malware reverse engineer Cyber Analyst Sr Cyber Investigator Cyber Software Engineer Forensics Analyst $82.523 $124.017 $94.204 $85.934 $75.999 $86.901 $75.131 $74.680 $103.327 $80.808 $154.843 $83.395 $82.766 $90.871 $104.886 $102.469 $87.914 $100.636 $143.198 $110.520 $105.716 $59.147 $135.327 $123.484 $143.003 $125.123 $120.133 $166.673 $72.654 $164.504 $114.368 $143.377 $150.886 $127.435 1227 1228 1232 1233 1237 1246 1248 1254 1255 1257 1258 1259 1261 1262 1265 1266 1267 1269 1272 1276 1279 1280 1285 1288 1289 1290 1292 1295 1296 1297 1298 1299 1300 1301 05/03/00 04/25/06 07/12/10 05/31/13 08/08/07 07/27/00 07/25/09 02/02/09 03/14/09 08/09/09 03/11/10 07/09/03 04/13/13 06/02/09 03/04/13 07/08/11 2/5/2008 03/14/07 09/18/10 05/04/11 10/20/07 08/11/14 04/04/11 03/25/10 09/05/11 10/22/06 05/13/01 07/08/12 05/05/00 09/15/10 09/23/11 06/06/05 04/08/09 07/10/09 Investigator Cyber Analyst Physical Security Cyber Analyst Cyber Analyst Sr Cyber Investigator Forensics Analyst Cyber Analyst Forensics Analyst Cyber Software Engineer Cyber Analyst Sr Cyber Investigator Cyber Analyst Sr Cyber Investigator Acctg/Fin Cyber Software Engineer Cyber Analyst Malware reverse engineer IT Mgr IT Staff Cyber Analyst Acctg/Fin Advertising Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst Logistics Forensics Analyst Investigator Quality Assurance Sr Cyber Investigator Logistics Mgr Cyber Software Engineer $85.234 $120.320 $67.456 $80.577 $86.904 $142.315 $76.156 $79.755 $96.621 $135.463 $74.232 $130.234 $80.165 $148.014 $109.632 $115.825 $94.747 $176.577 $120.515 $85.469 $96.057 $79.442 $103.064 $120.708 $97.943 $100.078 $106.815 $85.670 $138.901 $112.765 $123.487 $169.628 $175.286 $80.637 1302 1303 1304 1308 1314 1315 1316 1317 1318 1319 1320 1323 1325 1329 1332 1339 1341 1343 1343 1346 1350 1356 1357 1358 1364 1365 1373 1374 1378 1379 1381 1387 1388 1389 06/17/09 04/03/10 06/30/01 4/30/2000 1/22/2008 02/15/07 02/07/08 08/12/08 06/18/09 09/01/12 05/07/11 02/05/05 03/15/99 09/20/09 04/12/11 05/01/12 03/07/04 04/15/10 12/18/07 06/12/10 06/21/12 09/19/10 03/15/99 04/08/05 3/16/2008 04/20/05 04/08/09 06/25/07 07/09/10 06/09/07 10/23/10 07/14/09 12/18/07 07/23/05 Cyber Analyst Cyber Software Engineer IT Staff Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Sr Cyber Investigator Forensics Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Sr Cyber Investigator Forensics Analyst Physical Security Cyber Analyst Forensics Analyst Forensics Analyst Cyber Analyst Sr Cyber Investigator Admin Sr Public and Business Office Team Mgr Advertising COO Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst Marketing Public and Business Office Team Forensics Analyst Cyber Analyst Cyber Analyst $86.882 $115.261 $88.698 $78.742 $84.765 $89.672 $128.913 $138.677 $86.351 $81.170 $147.380 $102.235 $143.413 $96.020 $76.789 $81.992 $78.325 $71.897 $104.860 $147.679 $61.387 $164.068 $99.741 $235.779 $94.576 $101.431 $88.873 $97.648 $103.968 $121.191 $132.181 $126.163 $145.130 $100.914 1391 1393 1394 1400 1402 1403 1404 1405 1411 1417 1418 1422 1423 1424 1425 1426 1427 1428 1429 1432 1434 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1456 1456 05/30/09 2/3/2001 04/30/00 06/16/05 08/17/11 12/01/10 10/15/11 08/13/07 03/05/09 04/15/07 07/04/11 05/30/09 09/08/13 03/15/99 01/14/10 02/15/13 03/15/99 10/20/07 06/30/10 10/15/09 01/21/07 01/08/12 09/12/06 06/15/02 08/02/11 08/08/10 12/15/05 10/18/10 09/05/12 05/03/11 01/22/09 11/06/06 06/25/07 05/07/04 Cyber Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineer Cyber Analyst Public and Business Office Team Forensics Analyst Forensics Analyst Malware Reverse Engineer Sr Cyber Investigator Quality Assurance Cyber Analyst Public and Business Office Team Cyber Mgr Cyber Analyst Public and Business Office Team Sr Cyber Investigator Cyber Analyst Sr Cyber Investigator Malware Reverse Engineer Cyber Analyst Admin Sr Cyber Investigator Marketing Public and Business Office Team Cyber Analyst Forensics Analyst Forensics Analyst Public and Business Office Team Admin Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator $87.084 $107.643 $118.640 $180.483 $82.812 $121.265 $118.097 $128.537 $161.333 $169.102 $133.981 $86.918 $112.485 $145.737 $84.512 $105.460 $144.505 $95.934 $127.692 $174.904 $99.797 $72.415 $149.372 $121.221 $104.415 $113.808 $127.574 $123.971 $123.836 $75.456 $90.705 $99.838 $97.522 $119.997 1461 1467 1466 1468 1471 1474 1476 1477 1478 1481 1484 1492 1496 1498 1499 1504 1505 1506 1507 1508 1513 1515 1517 1519 1519 1523 1525 1527 1529 1531 1533 1539 1541 1543 10/12/10 03/19/09 05/04/12 7/21/2001 07/10/09 03/25/09 05/23/11 03/15/03 01/15/12 09/06/03 03/04/09 10/25/2001 05/07/13 02/22/11 08/04/13 03/14/05 04/30/10 12/06/10 06/27/04 04/15/14 08/14/03 05/01/00 11/12/12 06/04/11 02/15/13 05/21/11 05/09/05 03/15/99 10/16/11 04/07/13 12/28/07 12/15/12 04/09/07 10/06/09 Advertising Cyber Analyst Public and Business Office Team Cyber Analyst Cyber Analyst Cyber Analyst Logistics Logistics Physical Security Cyber Analyst Physical Security Cyber Analyst Physical Security Cyber Analyst Sr Cyber Investigator Cyber Analyst Physical Security Cyber Analyst IT Staff Forensics Analyst Cyber Analyst Acctg/Fin Cyber Software Engineer Malware Reverse Engineer Cyber Analyst Acctg/Fin Forensics Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineer Cyber Analyst Forensics Analyst Sr Cyber Investigator Cyber Analyst $83.215 $99.634 $114.329 $126.291 $86.729 $89.331 $98.560 $113.388 $83.169 $104.158 $75.622 $105.936 $71.035 $93.574 $125.283 $72.104 $68.455 $83.609 $88.517 $115.182 $104.358 $106.230 $122.572 $163.010 $79.819 $60.767 $127.633 $99.872 $92.797 $162.412 $95.283 $78.102 $139.128 $85.002 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1565 1567 1568 1569 1571 1575 1579 1580 1584 1588 1589 1591 1593 1596 1597 1598 1607 1608 1609 1611 1612 1613 1616 02/19/14 11/14/08 5/30/1999 04/12/09 10/20/07 10/23/13 10/20/06 03/21/09 07/21/04 01/06/05 05/06/12 03/16/07 08/07/12 02/07/10 04/23/10 04/16/09 02/04/09 01/12/05 09/16/10 03/15/99 8/17/2002 04/15/13 7/12/2008 08/15/08 06/12/09 11/20/11 02/15/13 03/15/99 04/15/09 07/20/11 09/23/07 03/06/11 05/04/12 09/15/09 IT Staff Sr Cyber Investigator Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Physical Security Sr Cyber Investigator Quality Assurance Cyber Analyst Cyber Analyst Cyber Analyst Forensics Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineer Cyber Analyst Physical Security CFO Cyber Mgr Cyber Analyst Cyber Mgr Public and Business Office Team Cyber Analyst Cyber Analyst Physical Security Cyber Analyst Advertising $75.067 $128.317 $79.316 $88.398 $96.097 $142.458 $110.082 $96.466 $93.537 $92.946 $88.270 $88.712 $62.960 $137.771 $95.254 $87.917 $90.629 $102.580 $93.342 $110.239 $105.566 $101.233 $93.213 $77.891 $231.276 $170.293 $89.661 $175.375 $133.258 $83.266 $96.378 $67.800 $82.496 $115.027 1617 1619 1620 1622 1623 1625 1626 1629 1630 1636 1637 1638 1639 1640 1644 1654 1658 1659 1660 1661 1661 1665 1666 1667 1668 1669 1671 1672 1673 1679 1680 1687 1688 1693 08/09/06 11/3/2007 06/07/13 02/06/12 03/04/12 09/12/09 07/08/12 09/04/11 09/12/08 04/17/09 06/07/11 09/01/07 07/30/12 08/13/07 09/05/11 06/07/11 03/22/10 11/02/06 01/14/10 03/18/13 11/18/11 01/15/08 03/14/05 05/01/00 07/10/09 09/05/11 06/13/12 05/04/08 03/07/13 05/18/09 01/06/13 12/15/05 06/02/04 03/15/99 Cyber Software Engineer Cyber Analyst Forensics Analyst Physical Security Cyber Software Engineer Logistics Forensics Analyst Physical Security Physical Security Forensics Analyst Public and Business Office Team Cyber Analyst Cyber Analyst Malware Reverse Engineer Forensics Analyst Cyber Software Engineer Admin Cyber Analyst Cyber Analyst Public and Business Office Team Physical Security Cyber Software Engineer Cyber Analyst Advertising Cyber Analyst Malware Reverse Engineer Cyber Analyst Sr Forensics Mgr Marketing Acctg/Fin Malware Reverse Engineer Forensics Analyst Cyber Analyst Cyber Software Engineer $166.818 $95.641 $85.248 $73.047 $114.153 $90.346 $99.141 $65.550 $77.650 $85.671 $114.494 $96.787 $81.567 $137.045 $77.598 $129.709 $72.300 $99.925 $84.420 $102.300 $64.456 $86.096 $101.554 $105.089 $95.688 $161.882 $81.809 $146.546 $117.415 $116.109 $151.226 $97.541 $103.784 $143.678 1709 1723 1724 1726 1733 1735 1736 1737 1741 1742 1743 1744 1745 1748 1749 1750 1751 1754 1755 1756 1757 1760 1761 1764 1767 1770 1771 1773 1774 1775 1776 1777 1779 1782 09/20/05 06/02/12 11/10/2007 03/15/99 09/18/13 09/18/07 04/01/09 03/15/99 03/30/09 06/15/11 08/16/06 11/12/2007 06/10/10 08/25/10 08/14/00 06/22/10 08/13/09 05/06/03 05/13/01 07/01/09 2/16/2002 02/04/11 09/15/12 6/17/2001 05/20/05 03/06/04 03/14/05 06/07/05 10/25/13 11/13/09 03/15/99 09/07/10 06/01/05 03/04/04 Cyber Analyst Forensics Analyst Cyber Analyst Malware Reverse Engineer Cyber Mgr Forensics Analyst Cyber Analyst Investigator Cyber Analyst Eng Mgr Forensics Analyst Cyber Analyst Cyber Analyst Marketing Sr Cyber Investigator Forensics Analyst Cyber Analyst Sr Cyber Investigator Cyber Analyst Sr Forensics Mgr Cyber Analyst Malware Reverse Engineer Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Logistics Cyber Mgr Malware Reverse Engineer Cyber Analyst Cyber Analyst Cyber Analyst Cyber Analyst $110.522 $99.397 $95.495 $161.159 $165.780 $97.221 $109.130 $116.188 $89.191 $160.233 $98.486 $115.317 $114.196 $98.352 $142.777 $91.828 $115.536 $70.507 $106.888 $153.478 $105.840 $160.348 $81.049 $117.530 $111.360 $138.697 $101.899 $110.999 $148.455 $161.441 $110.198 $113.631 $121.084 $123.903 1783 1784 1785 1787 1789 1790 1791 1793 1794 1796 1797 1798 1799 1802 1803 1804 1809 1812 1813 1814 1815 1816 1819 1820 1821 1822 1824 1829 1830 1831 1835 1836 1840 1841 07/06/06 09/21/09 02/08/10 07/21/07 09/23/08 03/15/99 09/07/07 09/08/08 01/14/14 03/14/10 02/08/03 05/14/09 03/15/99 5/31/2008 09/30/00 08/19/09 10/16/2001 04/06/05 01/15/03 08/19/11 08/17/11 04/16/09 10/06/09 08/06/09 09/13/06 05/02/07 04/13/13 03/01/07 1/15/2000 08/16/12 06/07/13 08/12/06 2/16/2000 06/07/07 Cyber Software Engineer Forensics Analyst Physical Security Acctg/Fin Cyber Analyst Malware Reverse Engineer Physical Security Sr Public and Business Office Team Mgr Cyber Software Engineer Public and Business Office Team Mgr Sr Cyber Investigator Cyber Analyst Cyber Analyst Cyber Analyst Marketing Quality Assurance Cyber Analyst Forensics Analyst Cyber Analyst Sr Public and Business Office Team Mgr Cyber Analyst Cyber Analyst Cyber Analyst Physical Security Cyber Analyst Cyber Software Engineer Cyber Analyst Cyber Analyst Cyber Analyst Sr Cyber Investigator Sr Cyber Investigator Cyber Analyst Cyber Analyst Malware Reverse Engineer $156.972 $96.096 $82.456 $116.261 $92.802 $161.077 $70.788 $140.822 $110.323 $151.275 $150.084 $86.918 $109.647 $93.498 $111.282 $124.510 $106.946 $97.781 $103.922 $147.102 $83.244 $87.144 $84.804 $84.236 $100.130 $151.691 $80.089 $98.826 $108.928 $135.938 $135.556 $100.199 $108.792 $179.865 1842 1843 1844 1846 1848 1849 1850 1851 08/05/13 04/23/09 03/05/13 08/30/04 12/15/09 06/05/04 11/20/10 08/05/07 Sr Cyber Investigator Malware Reverse Engineer Cyber Software Engineer Cyber Analyst Malware Reverse Engineer Forensics Analyst Forensics Analyst Investigator $165.117 $180.113 $140.324 $103.369 $170.722 $98.344 $94.060 $118.068 Section 2: Complete Summary Tables for Graphing Roles Acctg/Fin Admin Advertising CEO CFO CIO Controller COO Cyber Analyst Cyber Mgr Cyber Software Engineer Eng Mgr Forensics Analyst Investigator IT Mgr IT Staff Logistics Logistics Mgr Malware Reverse Engineer Marketing # Race 1 2 3 4 Gender 1 2 Education Level 12 14 16 19 Physical Security Public and Business Office Team Public and Business Office Team Mgr Quality Assurance Sr Cyber Analyst Sr Cyber Investigator Sr Forensics Mgr Sr Public and Business Office Team Mgr TOTAL Marital Status 1 2 Region Key State PA IL NE Section 3: Complete Descriptive Statistics Descriptive Statistics Mean Median Mode Std Deviation Variance Kurtosis Skewness Max Min = Range Sum Count Salary Hrly Rate Yrs of Svc General Number General Number Number Number Text General Vested Yr 10 Ed 19 19 19 16 16 19 16 14 14 16 14 16 14 16 16 16 12 16 14 14 19 16 16 14 Age 56 45 29 24 35 41 40 26 35 32 24 38 26 51 32 27 20 41 20 30 45 50 50 38 Vested Race 3 3 1 3 3 3 4 3 3 3 3 3 3 2 2 3 1 3 3 1 3 3 1 3 Gender 1 1 1 1 1 1 2 1 1 2 2 1 1 1 1 1 2 1 1 1 2 1 1 1 Status 2 2 1 2 1 1 1 2 2 2 1 1 1 1 1 1 2 1 2 1 1 1 1 1 State PA PA IL NE PA IL IL PA NE PA NE NE IL NE PA IL IL PA PA IL PA PA IL IL Region 16 14 16 16 16 14 19 19 16 16 14 14 19 19 14 16 16 16 19 16 12 14 16 14 14 16 16 16 19 16 19 14 14 19 33 34 28 35 35 31 41 51 28 31 31 52 62 35 42 43 25 31 48 44 28 48 29 39 24 50 34 52 27 22 35 53 32 58 3 1 3 3 2 3 3 3 3 3 3 3 3 1 3 1 3 1 3 3 3 1 3 3 1 1 3 3 3 2 3 3 3 4 2 1 1 1 2 1 1 1 2 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 2 1 1 1 2 1 2 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 2 1 1 1 2 1 2 1 2 1 1 1 1 2 1 1 1 1 NE NE IL PA IL NE NE IL NE PA PA IL PA NE NE PA PA NE PA NE NE IL IL NE PA PA IL PA PA IL NE PA PA PA 14 16 16 14 14 14 14 14 16 16 19 16 14 14 16 16 14 16 19 16 14 14 16 16 16 16 16 19 14 16 16 16 16 16 24 24 35 32 24 32 24 29 45 21 30 26 24 34 48 45 33 43 38 40 48 53 30 22 35 48 40 43 40 34 48 55 30 29 1 4 4 2 3 1 2 1 3 1 3 3 3 3 3 1 1 3 3 2 1 1 3 1 3 3 3 2 1 1 3 1 2 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 1 2 2 1 2 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 1 1 IL PA PA IL IL PA IL NE IL IL IL IL PA PA NE NE PA NE IL PA IL IL IL PA IL PA NE PA PA PA NE IL PA IL 14 16 12 14 14 19 14 14 16 16 14 16 14 19 16 16 14 19 16 14 16 14 16 16 14 16 14 12 16 14 16 16 16 14 45 41 28 21 38 54 25 34 27 38 28 46 20 33 24 40 35 39 52 32 37 22 26 41 19 40 50 30 36 29 34 41 47 36 3 3 3 3 1 3 3 2 3 3 3 3 3 1 1 3 2 3 3 3 1 3 3 1 1 1 3 3 3 4 3 3 1 3 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 2 1 2 1 1 1 2 2 1 1 1 1 2 1 2 1 1 1 2 1 2 1 2 1 1 1 1 2 1 2 1 2 2 2 1 1 2 1 1 1 1 2 2 2 1 1 1 1 1 1 2 1 1 IL PA IL NE IL IL NE PA PA NE PA NE IL IL NE NE IL NE PA NE NE PA NE NE NE IL PA NE PA IL NE IL PA PA 14 16 14 14 14 14 16 16 14 14 19 14 16 16 14 16 14 16 16 14 12 19 16 19 14 14 14 14 16 16 16 14 16 16 32 31 43 51 35 39 34 35 27 22 31 44 57 25 24 24 32 22 36 31 23 48 52 39 35 44 33 38 28 36 52 26 36 43 3 3 2 3 1 3 4 3 4 4 1 4 3 1 3 3 3 1 1 3 3 3 3 3 3 1 4 3 3 1 3 1 1 3 1 1 2 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 2 2 2 2 1 1 2 2 1 2 1 1 2 1 1 2 1 2 1 1 1 1 1 2 2 1 PA NE IL NE IL IL PA PA IL PA NE IL PA PA PA NE PA IL IL PA NE NE PA PA PA IL PA PA PA NE IL NE IL IL 14 14 16 16 16 16 16 16 16 16 16 14 16 16 14 16 14 14 16 19 14 12 16 16 16 16 16 16 16 14 14 14 14 16 32 51 51 46 26 42 19 34 30 34 36 32 25 45 29 32 59 37 32 38 39 25 40 42 34 28 30 23 32 31 34 39 38 41 3 3 1 3 4 3 3 3 3 4 3 1 3 3 3 1 3 3 1 3 2 1 3 3 3 3 4 1 3 4 3 3 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 2 1 1 1 1 1 2 1 2 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 2 1 2 1 1 1 1 1 2 2 1 1 1 1 1 2 1 1 1 1 2 2 1 2 1 1 1 1 NE NE IL NE IL IL PA IL NE PA IL IL NE PA NE PA PA IL IL PA NE IL PA IL IL NE PA PA NE PA NE IL NE PA 16 14 16 16 14 14 14 16 12 16 14 16 12 14 16 12 12 14 14 16 14 14 16 16 14 14 16 14 14 16 14 14 16 14 28 34 33 50 32 34 32 44 23 47 35 49 19 27 28 44 28 28 43 18 47 36 26 33 19 35 30 54 24 32 36 21 36 30 3 1 3 1 3 3 3 3 1 3 1 1 1 1 4 1 3 1 1 1 3 3 1 3 4 2 3 3 3 3 3 3 3 3 1 1 1 1 1 1 2 2 1 1 2 1 1 1 2 1 2 2 1 1 1 2 2 1 2 1 1 1 1 1 1 1 1 1 2 1 2 2 1 1 1 1 2 1 1 2 2 1 1 1 1 1 1 2 1 2 2 2 2 2 2 1 1 2 1 2 1 2 IL NE IL NE PA NE IL PA PA NE PA IL NE IL NE PA PA IL NE IL PA NE IL IL NE IL NE PA NE PA PA IL IL IL 14 16 14 14 14 16 16 14 14 14 14 14 12 16 16 14 14 16 16 16 16 16 14 12 19 19 12 19 16 14 14 12 14 16 28 33 53 33 38 26 40 27 46 45 21 38 20 32 42 33 34 45 22 54 48 25 35 38 42 34 19 44 53 26 38 25 24 34 1 3 3 1 3 2 3 4 3 2 3 3 3 1 3 4 3 1 3 1 2 3 3 1 3 3 3 3 3 3 3 2 1 3 2 1 1 1 1 2 1 1 1 1 1 1 2 1 2 1 1 1 1 1 1 2 1 2 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 2 1 2 2 1 2 1 2 2 2 2 1 1 2 2 1 2 1 1 2 1 2 1 1 2 1 1 1 2 IL IL PA NE PA IL NE PA NE PA PA IL IL NE IL PA IL IL PA PA PA IL IL NE PA IL PA IL PA NE PA NE PA PA 19 14 14 12 16 16 16 12 12 16 16 14 16 16 16 16 16 14 14 16 12 14 16 16 14 16 16 16 16 16 16 14 16 19 48 36 18 21 28 31 21 24 36 24 37 38 23 42 19 35 33 40 28 28 23 40 44 35 32 32 23 38 35 39 24 30 46 54 3 3 1 3 2 3 3 1 3 4 4 3 1 3 3 3 1 1 1 3 1 3 3 3 4 3 3 3 3 3 1 1 3 3 1 1 2 2 1 1 2 1 1 1 1 1 1 1 1 2 2 1 2 2 2 1 1 1 1 2 1 1 2 1 1 1 1 1 1 1 2 2 1 1 2 1 1 1 1 2 2 1 2 1 2 2 1 1 2 1 1 1 2 1 1 1 1 1 2 1 1 1 NE NE NE PA IL IL NE IL IL NE PA IL PA PA PA NE PA NE PA IL NE PA PA IL PA PA IL IL IL PA IL NE IL PA 16 16 16 19 19 16 16 16 14 16 14 16 16 16 14 16 16 14 16 19 16 16 16 14 16 16 16 16 16 14 19 16 16 16 43 21 36 56 32 28 33 52 34 45 32 36 28 35 56 22 31 48 50 42 49 28 22 50 44 48 44 42 33 30 54 28 43 46 1 3 1 3 1 3 3 3 3 3 1 3 4 3 1 3 1 1 3 3 3 2 3 3 3 3 3 3 3 3 3 3 3 1 1 1 1 1 2 2 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 1 1 1 1 1 2 1 1 1 2 2 1 1 1 1 1 1 1 2 2 1 1 1 1 1 2 2 2 1 1 1 2 1 2 1 1 1 1 IL PA PA PA PA PA IL PA IL PA NE NE PA PA NE NE IL PA PA PA PA PA IL IL IL NE PA PA NE IL PA NE IL NE 19 16 12 16 14 19 12 19 16 19 19 14 16 16 16 16 16 14 16 16 14 14 14 12 14 16 16 14 14 16 16 14 14 19 50 25 32 45 35 54 40 50 24 43 44 32 54 35 45 46 50 30 47 53 26 33 30 32 40 36 20 39 52 29 29 41 52 45 3 4 3 3 3 1 3 3 3 3 2 1 3 4 3 1 1 1 1 1 3 3 2 3 3 3 1 1 3 1 4 1 3 2 1 1 2 1 1 1 2 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 1 1 1 2 1 1 2 1 1 1 1 1 2 1 1 1 1 1 2 2 1 1 1 1 1 1 1 1 1 2 1 1 1 1 1 1 1 2 1 1 1 1 1 1 2 IL IL PA IL PA IL IL IL PA PA NE PA PA NE PA PA NE PA IL PA NE NE IL NE PA NE NE PA IL PA NE NE IL PA 19 19 16 16 19 14 14 16 28 46 24 46 52 32 24 30 3 3 3 2 3 3 3 3 # % # % # % African-Am Asian Caucasian Hispanic TOTAL Male Female TOTAL n Level HS AA BA/BS Masters+ TOTAL 1 2 1 1 1 1 1 2 1 2 1 1 1 1 2 1 Sales Summary (Provided) Yr Sales 1999 $527.000 2000 $15.367.000 2001 $26.481.000 2002 $41.485.000 2003 $46.274.000 2004 $46.578.000 2005 $48.061.000 2006 $47.987.000 2007 $48.057.000 2008 $48.565.000 2009 $48.467.000 2010 $49.846.000 2011 $49.252.000 2012 $50.226.000 2013 $50.844.000 2014 $51.850.000 2015 $51.702.000 PA PA IL PA PA PA PA IL Status Married Single TOTAL # % Region Northeast Midwest C-Plains TOTAL # % Ed Age Frequency Table by Salary Ranges Bin Range / Upper Limit 20000 30000 40000 50000 60000 70000 80000 90000 100000 110000 120000 130000 140000 Labels Up to 20 21-30 31-40 41-50 51-60 61-70 71-80 81-90 91-100 101-110 111-120 121-130 131-140 Graph on next Tab 150000 160000 170000 180000 190000 200000 210000 141-150 151-160 161-170 171-180 181-190 191-200 210+
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.

Tutor Answer

Assignment_Assassin
School: University of Maryland

Hello,Attached find the completed...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Hot Questions
Related Tags
Study Guides

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