Conduct Quantitative Analysis

User Generated

Wnl202

Writing

CBR 600

Description

Need help with a spreadsheet. The Data page need to be complete in each column of the spreadsheet to arrive to the desired calculations.

I need some help because it deals with Excel and formulas that need help with. I have attached the specific information that the Prof is looking for also I attached the spreadsheet with the direction for help.

Unformatted Attachment Preview

Apply Quantitative Reasoning Now that you have completed your analysis, think about the patterns you have seen in the workforce. From the created histogram, it appears that a large share of employees have a salary between $61,000 - $140,000 or $141,000 $190,000. This may indicate reasonable promotion rate for new employees. Is this distribution unimodal or bimodal? Please exp 1. 2. The line chart, as detailed in your ‘Graph Charts’ Excel spreadsheet, shows sales generally increasing over the years, from 1 Sales have been steady since the first years, but investors want to know what the projected sales will be in 2017. One method determining this value is to calculate the average percentage growth, based on historical trends. For example, if sales were and $500 this year, the average percentage growth between these years was 150%.Figure it like this: ((500-200)/500)*100. Pleas calculate the average percentage growth for 1999 – 2015 and projected sales for 2017. 3. The standard deviation provides insight into the distribution of values around the mean. If the standard deviation is small, the the range between the lowest and highest value. That is, values will cluster close to the mean. From your descriptive statist your standard 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 workforce. From your "Graph Charts" spreadsheet, describe your pie chart findings for these characteristics of the workforce. you would determine if 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 of the number of positions per job title. From your Excel chart, identify the mode of the job title distribution. Describe your 6. 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 While you have done a wonderful job with your analysis, you can never assume that the end user will be able to interpret the it should be understood. Supporting narrative is helpful. Never simply provide a "raw data" dump. Instead, seek to provide in Structure your essay like this: 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. Create a tab for QR Analysis, create a text box, and paste your answers above questions in it. Move the tab to the first tab position. Prepare your response in this workbook. Create a tab for QR Analysis, create a text box, and paste your answers above questions in it. Move the tab to the first tab position. $141,000 lease explain. rom 1999 to 2014. method for were $200 last year 0)*100. Please mall, the more narrow tatistics, describe verse, dynamic kforce. Describe how s to know an estimate ur findings. sis. This is important. ret the data the way ovide information! any. answers to the answers to the Workforce Profile Analysis Section 1: Complete all Columns in Data Set Format for: Number Emp # 1001 1002 1003 1004 1005 1006 1014 1015 1016 1018 1018 1019 1024 1036 1038 1043 1048 1049 1053 1053 1055 1055 1055 1056 Date mm/dd/yy 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 Text 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 Currency 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 Currency Number Year Ending 12/31/2014 Hrly Rate Yrs of Svc 1059 1061 1062 1062 1069 1070 1071 1071 1075 1079 1083 1083 1084 1088 1096 1097 1098 1101 1102 1104 1105 1106 1108 1109 1113 1113 1116 1116 1117 1117 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 1138 1140 1141 1142 1145 1145 1145 1150 1153 1156 1167 1169 1175 1180 1185 1186 1188 1189 1190 1190 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 Engineers 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 1227 1232 1233 1237 1246 1248 1254 1255 1257 1257 1258 1261 1261 1265 1265 1267 1269 1272 1276 1279 1280 1285 1288 1289 1289 1292 1295 1296 1296 1296 1297 1299 1300 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 Engineers 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 1300 1308 1308 1308 1314 1315 1315 1317 1320 1320 1320 1323 1325 1329 1332 1339 1341 1343 1343 1346 1350 1356 1357 1357 1364 1364 1373 1373 1378 1379 1381 1387 1387 1387 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 1422 1424 1424 1424 1424 1426 1429 1432 1434 1442 1443 1444 1444 1445 1446 1447 1447 1448 1450 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 Engineers Cyber Analyst Public and Business Office Team Forensics Analyst Forensics Analyst Malware Reverse Engineers 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 Engineers 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 1466 1466 1468 1471 1474 1476 1477 1477 1481 1484 1492 1496 1498 1498 1504 1504 1505 1506 1507 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 Engineers Cyber Analyst Acctg/Fin Forensics Analyst Cyber Analyst Cyber Analyst Malware Reverse Engineers 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 1550 1552 1553 1553 1554 1554 1556 1557 1558 1560 1565 1568 1568 1569 1571 1575 1579 1580 1584 1588 1589 1591 1593 1596 1597 1598 1608 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 Engineers 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 1616 1619 1620 1622 1623 1625 1626 1629 1630 1636 1637 1638 1639 1640 1644 1654 1658 1659 1660 1661 1661 1667 1667 1668 1668 1669 1671 1672 1673 1679 1680 1687 1687 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 Engineers 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 Engineers Cyber Analyst Sr Forensics Mgr Marketing Acctg/Fin Malware Reverse Engineers 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 1723 1726 1733 1736 1736 1737 1741 1744 1744 1744 1745 1748 1749 1750 1750 1754 1756 1756 1757 1760 1760 1764 1767 1770 1771 1773 1774 1776 1776 1779 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 Engineers 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 Engineers Cyber Analyst Cyber Analyst Cyber Analyst Cyber Software Engineer Cyber Analyst Logistics Cyber Mgr Malware Reverse Engineers 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 1785 1785 1785 1787 1789 1793 1793 1793 1794 1796 1797 1800 1800 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 Engineers 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 Engineers $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 1841 1846 1846 1846 1848 1848 1850 1850 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 Engineers Cyber Software Engineer Cyber Analyst Malware Reverse Engineers Forensics Analyst Forensics Analyst Investigator $165,117 $180,113 $140,324 $103,369 $170,722 $98,344 $94,060 $118,068 $41,433,167 Section 2: Complete Summary Tables for Graphing Roles Race 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 Engineers Marketing 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 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 Text Number Number Number Number Number Text Text Vested Yr 10 Ed 20 19 17 17 14 14 16 14 15 16 15 16 14 16 16 16 12 19 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 16 14 16 16 16 19 16 12 14 16 14 16 16 16 16 18 17 18 16 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 16 14 16 14 16 14 14 14 16 16 20 16 16 14 16 14 14 14 19 16 14 14 16 16 16 16 16 19 14 17 16 14 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 16 14 12 16 14 14 16 14 16 14 19 18 16 16 16 19 14 16 19 16 14 16 16 16 14 17 14 12 16 12 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 16 14 16 19 14 14 16 15 16 16 16 14 14 16 12 16 14 16 16 14 12 19 16 19 14 14 14 14 17 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 18 16 16 16 16 16 17 16 14 16 16 20 16 14 14 16 16 14 12 16 16 16 17 16 16 16 14 14 12 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 14 14 14 12 14 12 12 12 16 19 18 14 16 16 16 17 16 16 12 16 16 14 17 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 16 16 14 14 14 16 16 16 12 12 17 14 12 16 16 14 14 14 16 16 14 16 14 12 19 16 16 19 14 16 14 12 16 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 17 12 16 16 17 12 12 16 16 14 16 16 17 16 16 12 16 12 16 14 16 16 14 18 16 16 16 16 17 14 12 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 14 17 19 20 17 16 16 14 16 19 16 17 16 14 16 16 14 14 16 14 16 17 14 16 16 14 16 17 14 19 17 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 16 16 12 16 14 19 14 19 16 19 14 14 14 14 16 16 14 14 14 16 16 14 14 12 14 16 16 14 14 17 18 14 14 16 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 18 14 16 19 14 19 16 12 28 46 24 46 52 32 24 30 3 3 3 2 3 3 3 3 # % # % # % African-Am Asian Caucasian Hispanic Male Female n Level HS AA BA/BS Masters+ 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 Region Northeast Midwest C-Plains Ed # % # % Age Frequency Table by Salary Ranges Bin Range/Up per 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+ Associated Learning Objectives 1.1.1: Present material in clear and/or logical order appropriate to task. Assessment Method: Score on Criteria - 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment. Required Performance: Meets Performance Requirements 1.1.2: Articulate thesis and purpose clearly. Assessment Method: Score on Criteria - 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment. Required Performance: Meets Performance Requirements 1.1.3: Support thesis and purpose fully. Assessment Method: Score on Criteria - 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment. Required Performance: Meets Performance Requirements 1.1.4: Transition smoothly and develop connections from point to point. Assessment Method: Score on Criteria - 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment. Required Performance: Meets Performance Requirements 1.1.5: Create coherent progress from introduction through conclusion. Assessment Method: Score on Criteria - 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment. Required Performance: Meets Performance Requirements 1.1.6: Complete assignment in accordance with instructions. Assessment Method: Score on Criteria - 1.1: Organize document or presentation clearly in a manner that promotes understanding and meets the requirements of the assignment. Required Performance: Meets Performance Requirements 1.2.1: Create meaningful topic sentence for each paragraph or point. Assessment Method: Score on Criteria - 1.2: Develop coherent paragraphs or points so that each is internally unified and so that each functions as part of the whole document or presentation. Required Performance: Meets Performance Requirements 1.2.2: Develop each paragraph's single topic to the appropriate depth. Assessment Method: Score on Criteria - 1.2: Develop coherent paragraphs or points so that each is internally unified and so that each functions as part of the whole document or presentation. Required Performance: Meets Performance Requirements 1.2.3: Supply relevant and original supporting detail. Assessment Method: Score on Criteria - 1.2: Develop coherent paragraphs or points so that each is internally unified and so that each functions as part of the whole document or presentation. Required Performance: Meets Performance Requirements 1.4.1: Identify target audience. Assessment Method: Score on Criteria - 1.4: Tailor communications to the audience. Required Performance: Meets Performance Requirements 1.4.2: Explain unfamiliar terms and material. Assessment Method: Score on Criteria - 1.4: Tailor communications to the audience. Required Performance: Meets Performance Requirements 1.4.3: Employ precise, appropriate language. Assessment Method: Score on Criteria - 1.4: Tailor communications to the audience. Required Performance: Meets Performance Requirements 1.4.4: Use audience-appropriate, consistent tone. Assessment Method: Score on Criteria - 1.4: Tailor communications to the audience. Required Performance: Meets Performance Requirements 1.4.5: Avoid language which indicates bias against individuals/groups their affiliations, orientations and beliefs. Assessment Method: Score on Criteria - 1.4: Tailor communications to the audience. Required Performance: Meets Performance Requirements 1.5.1: Demonstrate variation in sentence structure. Assessment Method: Score on Criteria - 1.5: Use sentence structure appropriate to the task, message and audience. Required Performance: Meets Performance Requirements 1.5.2: Express ideas clearly and concisely. Assessment Method: Score on Criteria - 1.5: Use sentence structure appropriate to the task, message and audience. Required Performance: Meets Performance Requirements 1.5.3: Eliminate sentence-level errors such as run-ons/comma splices and sentence fragments. Assessment Method: Score on Criteria - 1.5: Use sentence structure appropriate to the task, message and audience. Required Performance: Meets Performance Requirements 1.6.1: Adhere to standard usage rules of grammar. Assessment Method: Score on Criteria - 1.6: Follow conventions of Standard Written English. Required Performance: Meets Performance Requirements 1.6.2: Adhere to standard usage rules of word choice. Assessment Method: Score on Criteria - 1.6: Follow conventions of Standard Written English. Required Performance: Meets Performance Requirements 1.6.3: Adhere to standard usage rules of spelling. Assessment Method: Score on Criteria - 1.6: Follow conventions of Standard Written English. Required Performance: Meets Performance Requirements 3.1.1: Extract relevant information needed to solve the problem or situation. Assessment Method: Score on Criteria - 3.1: Identify numerical or mathematical information that is relevant in a problem or situation. Required Performance: Meets Performance Requirements 3.2.1: Perform accurate calculations which are sufficiently comprehensive to solve the problem. Assessment Method: Score on Criteria - 3.2: Employ mathematical or statistical operations and data analysis techniques to arrive at a correct or optimal solution. Required Performance: Meets Performance Requirements 3.2.2: Use appropriate and complete quantitative analysis techniques to arrive at a correct or optimal analysis. Assessment Method: Score on Criteria - 3.2: Employ mathematical or statistical operations and data analysis techniques to arrive at a correct or optimal solution. Required Performance: Meets Performance Requirements 3.3.1: Communicate key relevant mathematical information or results using appropriate mathematical vocabulary and, when appropriate, referencing mathematical symbols, definitions, theorems, and laws. Assessment Method: Score on Criteria - 3.3: Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data. Required Performance: Meets Performance Requirements 3.3.2: Draw logical inferences and conclusions from calculations, results, and analyses AND confirm /validate them. Assessment Method: Score on Criteria - 3.3: Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data. Required Performance: Meets Performance Requirements 3.3.3: Construct graphs, charts, and tables to represent relevant mathematical and statistical information and inform analysis and interpretation. Assessment Method: Score on Criteria - 3.3: Analyze mathematical or statistical information, or the results of quantitative inquiry and manipulation of data. Required Performance: Meets Performance Requirements 3.4.1: Prepare dataset for use using the chosen application or tool and execute functions that enable insight into data. Assessment Method: Score on Criteria - 3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decisionmaking. Required Performance: Meets Performance Requirements 3.4.2: Interpret initial results from operations to determine if refinements in choice of formula or search criteria is warranted. Assessment Method: Score on Criteria - 3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decisionmaking. Required Performance: Meets Performance Requirements 3.4.3: Generate required output to support the quantitative tasking. Assessment Method: Score on Criteria - 3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decisionmaking. Required Performance: Meets Performance Requirements 3.4.4: Complete assignment in accordance with detailed instructions. Assessment Method: Score on Criteria - 3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decisionmaking. Required Performance: Meets Performance Requirements 3.4.5: Complete assignment in accordance with instructions. Assessment Method: Score on Criteria - 3.4: Employ software applications and analytic tools to analyze, visualize, and present data to inform decisionmaking. Required Performance: Meets Performance Requirements
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
This is great! Exactly what I wanted.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags