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