Descriptive Statistics Profitability PivotChart Final Project Include any raw data you will be using and ideas of how you will lay out the information to t

Descriptive Statistics Profitability PivotChart Final Project Include any raw data you will be using and ideas of how you will lay out the information to turn it into a meaningful workbook that can be used for analysis.

The workbook structure should have an organized layout to outline what you hope to accomplish.

In class, I provided several examples of a “Data Set.” Examples include performance data from Soccer, Baseball, Football, Hockey, Home BudgetsExpenses, New Cars and descriptions, features. One example from Football might be, “passing yards, rushing yards, pass completion percentage from NFL Football. This data might be related to total team salaries, etc. Examples of data use in the sports world are plentiful and readily available.. Businesses often collect data that tracks customer service phone call statistics. Measurements might include how fast their customer service reps answer the phone and how long they spend collecting information from customers who call. Other business examples include auto dealerships that award bonuses to sales employees if revenues exceed a particular “goal” or exceed last month or last quarter revenues. One student found United States Agricultural Data that featured Milk Production on a state-by-state basis , made five or six charts – little paragraphs of explanation – it was interesting! These all make interesting business discussions and presentations!

One other data example from the sport of Hockey may present as, “shots on goal” and other scoring percentagesperformance statistics, a similar example may be presented from the sport of Soccer. A student budget with lodging expenses, tuition and loans, commuting expenses, and other factors may make up a ‘data set.”

For the first draft:

1) the student is to present an outline of the data set (SHOW ME YOUR DATA) and

2) Indicate the possible direction of how this “Microsoft Excel Study” will unfold. Write a PARAGRAPH OR MORE – tell me what it will look like or tell me how you will go about “working with/cleansing the data”)

The Final completed project will utilize Microsoft Excel to present the data in tables,charts, pivot tables, pivot charts, graphs of the student’s choice that make the facts and figures understandable to a student audience. Student is to include caption paragraphs andor explanatory detail as to what the chart, Graph, Pivot is indicating (TELL ME WHAT I AM SEEING) , what trend is present? What does the graph show? Students are encouraged to be wordy, no explanation is too long!

Final Project Data Step 1 SHOW INSTRUCTOR THE DATA

Pick a topic that you would like to research and find out more information by analyzing a specific data set in that area.

Begin preliminary research to see if you can find data that you have access to and would be able to work with in Excel.

Show Instructor the Data

Write a paragraph or two on how you plan to “cleanse” and display the data Demonstration Rubric
Levels of Achievement
Criteria:
Organization
Weight
33.00%
Novice
0%
Did not
submit
project
Appropriate 0%
Terminology
Did not submit
project
Weight
34.00%
Not Competent
Some Effort
Somewhat Proficient
Proficient
25%
50%
75%
90 – 100%
Jumps around various
steps, no perceived
outline being
followed, no
introduction or
summary
Made effort to
produce correct
letter or project
but,
In incorrect order or
not following any
discernable
business rules
Demonstrates
majority of
directions
followed, shows
good effort to
complete correctly
but, omits some
transitional steps
or jumps toward
conclusion. May
not have correct
letter format or
correct data file
included.
Contains evidence
of necessary step
completion,
directions carefully
followed, logical
flow including
every necessary
step of the
process. Includes
detailed intro and
summary of steps
taken in
demonstration.
25%
50%
75%
90 – 100%
Uses some of own
terminology or
unrecognized
incorrect terms
Uses non-standard
letter format
and/or nonstandard data file.
Some mistakes on
terminology but,
still easily
understood
Uses consistent
and appropriate
terminology for
steps taken.
Accuracy
0%
25%
50%
75%
90 – 100%
Weight
33.00%
Did not submit
project
Steps do not reproduce
letter or data file or
project that resembles
the answer key
Example shown in
class,
Steps do not
reproduce the
results shown in
the Answer Key
Minor changes
needed to get the
results displayed in
demonstration.
Easily followed and
results display
correctly, can be
reproduced on
multiple devices.
Company
FBI
CyberCoders
City
State
Los Angeles
CA
Fort Lauderdale FL
Required Education
Bachelor’s
Bachelor’s
The Rowland Group
Exclusive Staffing
Government
DODD
CyberCoders
Houston
Richmond
Columbus
Franklin County
Anoka
Bachelor’s
CPA
CPA
Bachelor’s
Bachelor’s
TX
VA
GA
OH
MN
Required Experience
Salary
0 $66,137.00
5 $80,000.00
3
2
2
4
0
$70,000.00
$87,000.00
$50,132.00
$55,515.00
$70,000.00
Company
Talis Group
ListenClear
CyberCoders
Cardinal Staffing Services
VanderHouwen
Accounting Principles
Extension Inc.
City
Louisville
Tulsa
Charles City
Tallahassee
Salem
Dublin
Milwaukee
State
KY
OK
IA
FL
OR
OH
WI
Required Education
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Required Experience
5
3
1
2
3
1
1
Salary
$60,000.00
$65,000.00
$50,000.00
$40,000.00
$55,000.00
$55,000.00
$50,000.00
Company
Advantage Behavioral Health Systems
RobertHalf Finance & Accounting
City
Athen
Hopkins
State
GA
MN
Required Education
Bachelor’s
Bachelor’s
Tennessee Department of Finance and Budget
Accounting Principles
Pinnacle Partners, Inc
Aerotak
Vaco Financial
Nashville
Pomona
Indianapolis
Des Moines
Birmingham
TN
CA
IN
IA
AL
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Required Experience
Salary
0 $38,000.00
0 $49,000.00
1
3
3
3
3
$47,000.00
$50,000.00
$50,000.00
$42,000.00
$55,000.00
Position
Budget Analyst
Forensic Accountant
Budget Analyst
Forensic Accountant
Company
Vaco Financial
FBI
Accounting Principles
CyberCoders1
Cardinal Staffing Services
Cost Accountant
Forensic Accountant Government
Advantage Behavioral
Health Systems
Budget Analyst
Cost Accountant
CyberCoders2
Budget Analyst
Aerotak
Budget Analyst
Pinnacle Partners, Inc
Cost Accountant
Talis Group
Forensic Accountant CyberCoders3
RobertHalf Finance &
Accounting
Budget Analyst
Forensic Accountant DODD
Cost Accountant
Accounting Principles
Cost Accountant
ListenClear
Cost Accountant
VanderHouwen
Tennessee Department of
Finance and Budget
Budget Analyst
Forensic Accountant The Rowland Group
Forensic Accountant Exclusive Staffing
Cost Accountant
Extension Inc.
Years Required
Salary
Analysis
0 BASIC
3 MODERATE
5 EXTENSIVE
Analysis
$38,000.00 BELOW EXPECTATIONS
$50,000.00 MEETS EXPECTATIONS
$70,000.00 EXCEEDS EXPECTATIONS
City
Birmingham
Los Angeles
Pomona
Fort Lauderdale
State
AL
CA
CA
FL
Required Education
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Tallahassee
Columbus
FL
GA
Bachelor’s
CPA
Athen
Charles City
Des Moines
Indianapolis
Louisville
Anoka
GA
IA
IA
IN
KY
MN
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Hopkins
Franklin County
Dublin
Tulsa
Salem
MN
OH
OH
OK
OR
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
Nashville
Houston
Richmond
Milwaukee
TN
TX
VA
WI
Bachelor’s
Bachelor’s
CPA
Bachelor’s
Average Salary:
Average Experience:
Required
Experience
3
0
3
5
Salary
$55,000.00
$66,137.00
$50,000.00
$80,000.00
2
2
$40,000.00
$50,132.00
0
1
3
3
5
0
$38,000.00
$50,000.00
$42,000.00
$50,000.00
$60,000.00
$70,000.00
0
4
1
3
3
$49,000.00
$55,515.00
$55,000.00
$65,000.00
$55,000.00
1
3
2
1
$56,418.29
2
$47,000.00
$70,000.00
$87,000.00
$50,000.00
Position Good
CPA
Experience
Rank Location? Required? Required?
Salary Rank?
OKAY
GREAT
OKAY
GREAT
NO
NO
NO
NO
NO
NO
NO
NO
MODERATE MEETS EXPECTATIONS
BASIC
MEETS EXPECTATIONS
MODERATE MEETS EXPECTATIONS
EXTENSIVE EXCEEDS EXPECTATIONS
GOOD
NO
NO
BASIC
BELOW EXPECTATIONS
GREAT
NO
YES
BASIC
MEETS EXPECTATIONS
OKAY
NO
NO
BASIC
BELOW EXPECTATIONS
GOOD
OKAY
OKAY
GOOD
GREAT
YES
YES
NO
NO
YES
NO
NO
NO
NO
NO
OKAY
YES
NO
BASIC
BELOW EXPECTATIONS
GREAT
GOOD
GOOD
GOOD
NO
NO
NO
NO
NO
NO
NO
NO
MODERATE
BASIC
MODERATE
MODERATE
MEETS EXPECTATIONS
MEETS EXPECTATIONS
MEETS EXPECTATIONS
MEETS EXPECTATIONS
OKAY
NO
NO
BASIC
BELOW EXPECTATIONS
GREAT
GREAT
GOOD
NO
NO
YES
NO
YES
NO
BASIC
MEETS EXPECTATIONS
MODERATE BELOW EXPECTATIONS
MODERATE MEETS EXPECTATIONS
EXTENSIVE MEETS EXPECTATIONS
BASIC
EXCEEDS EXPECTATIONS
MODERATE EXCEEDS EXPECTATIONS
BASIC
EXCEEDS EXPECTATIONS
BASIC
MEETS EXPECTATIONS
Overall Rank
Conclusion
4
7
4
6
5
Total
3
6
4
8
5
4
4
10
BEST OPTION
BEST OPTION
6
6
6
5
5
4
7
7
8
BEST OPTION
Sum of Required Experience
6
5
4
3
2
1
AL
State
CA
Position
FL
GA
Cost Accountant
Budget Analyst
Forensic Accountant
Budget Analyst
Forensic Accountant
Cost Accountant
Forensic Accountant
Budget Analyst
0
Budget Analyst
Row Labels
AL
Budget Analyst
CA
Budget Analyst
Forensic Accountant
FL
Cost Accountant
Forensic Accountant
GA
Budget Analyst
Forensic Accountant
IA
Budget Analyst
Cost Accountant
IN
Budget Analyst
KY
Cost Accountant
MN
Budget Analyst
Forensic Accountant
OH
Cost Accountant
Forensic Accountant
OK
Cost Accountant
OR
Cost Accountant
TN
Budget Analyst
TX
Forensic Accountant
VA
Forensic Accountant
WI
Cost Accountant
Grand Total
Sum of Required
Experience
3
3
3
3
0
7
2
5
2
0
2
4
3
1
3
3
5
5
0
0
0
5
1
4
3
3
3
3
1
1
3
3
2
2
1
1
45
IA
Cost Accountant
IN
KY
MN
Cost Accountant
Budget Analyst
Forensic Accountant
Forensic Accountant
Cost Accountant
OH
Cost Accountant
Forensic Accountant
Cost Accountant
Forensic Accountant
Budget Analyst
Budget Analyst
Cost Accountant
Position
Budget Analyst
Total
Cost Accountant
Forensic Accountant
Required Experience
0
2
4
Total
State
OK
OR
TN
TX
VA
WI
AL
CA
GA
IA
KY
MN
OK
OR
TX
VA
Position
Budget Analyst
Cost Accountant
Forensic Accountant
equired Experience
0
1
2
3
4
5
CA
FL
IA
IN
MN
OH
OR
TN
VA
WI
Position
Forensic Accountant
Cost Accountant
Forensic Accountant
Forensic Accountant
Forensic Accountant
Cost Accountant
Company
FBI
CyberCoders2
CyberCoders3
The Rowland Group
Exclusive Staffing
Extension Inc.
Lookup rank:
CyberCoders3
Top 3 Jobs
CyberCoders2
CyberCoders3
Extension Inc.
Salary
Top 3 Jobs
CyberCoders2
CyberCoders3
Extension Inc.
Apartment
Website
Website
Website
$50,000
$70,000
$50,000
City
Los Angeles
Charles City
Anoka
Houston
Richmond
Milwaukee
State
CA
IA
MN
TX
VA
WI
10
Monthly Income
$4,167
$5,833
$4,167
Monthly cost
$790
$900
$1,050
Required Education
Bachelor’s
Bachelor’s
Bachelor’s
Bachelor’s
CPA
Bachelor’s
Required Experience
0
1
0
3
2
1
Salary
Overall Rank
$66,137
7
8
$50,000
$70,000
10
$70,000
7
$87,000
7
$50,000
8
Monthly Income and Payment Scenarios
Revenue
Monthly Income
Expenses
Car
Rent
Utilities
Cell phone
Groceries
Credit cards
Insurance
Gym Membership
Entertainment
Miscellaneous
Savings Account
Income after Monthly
Payments
d Payment Scenarios
$5,833
$5,833
$631
$900
$200
$100
$275
$350
$250
$40
$125
$125
$1,500
$4,496
$1,337
Scenario Summary
Current Values:
Best Scenario
Okay Scenario Worst Scenario
Changing Cells:
$L$13
$5,833
$5,833
$4,167
$L$23
$900
$900
$790
Result Cells:
$L$35
$1,337
$1,337
-$219
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
$4,167
$1,050
-$479
Information
Where
What
Monthly payments
(Estimate)
Monthly payments
(Actual)
Yearly Income
Car
Apartment
Utilities
Website
Website
Website
2014 Chevy Impala 1 Bedroom in Champlin Electricity, water, heat
$631
$900
$200
$631
$900
$200
$70,000.00
Total
$18,995
Monthly payments
36 Months
$5,000 Down payment
$630.55
Incentive System
Reward_1
Manicure & Pedicure
Massage
Cell Phone
Website
AT&T, 1 phone
Groceries
Credit Card
Website
Website
Every 2 weeks
Visa
Insurance
Website
Auto
Gym Membership
Website
Anytime Fitness
Entertainment
No Source
Movies, sports
$100
$275
$350
$250
$40
$125
$100
$275
$350
$250
$40
$125
Reward_2
Eating at Stella’s
Eating at Melting Pot
Miscellaneous
No Source
Shopping
Savings
No Source
Bank
$125
$1,500
$125
$1,500
My Budget
Percentage of Income Spent
78%
Monthly Income and Expenses
$7,000
$6,000
Net Monthly Income
$5,833
$5,833
$5,000
$4,546
$4,000
Net Monthly Expenses
$4,546
$2,000
Balance
$1,000
$1,287
$0
Net Monthly Income
Monthly Income
Item
Fixed income
Other income
Total
$3,000
Monthly Expenses
Amount
$5,833
$0
$5,833
Item
Car
Rent
Utilities
Cell phone
Groceries
Credit cards
Insurance
Gym Membership
Entertainment
Miscellaneous
Savings Account
Total
Net Monthly Expenses
Goal Rewards
Amount
$631
$900
$200
$100
$275
$350
$250
$40
$125
$125
$1,500
$4,496
Reward Number
Goal met?
Reward
Reward_1
1 Manicure & Pedicure
2 Massage
YES
$50.00
Create Date
By Whom
Description
Mod. Date
By Whom
Mod. Description
Create Data
Sheet Name
Creator
Workbook Name
Last Version Backup Name
Purpose
Dashboard
IDs
Row ID
Order ID
50
293
Shipping
Customer
Customer Name
Customer Segment
Province
Region
Order Date
Barry French
Consumer
Nunavut
Nunavut
10/1/2012
Sales
Product
Product Category
Product Sub-Category
Product Name
Sales
Office Supplies
Binders and Binder Accessories
Cardinal Slant-D® Ring Binder, Heavy Gauge Vinyl
Ship Date
Order Priority High
Ship Mode
Regular Air
Returned?
Unit Price
Shipping Cost
Profit
% of Sales
$244.57
$8.69
$2.99
$46.71
10/3/2012
Days To Ship
2
Product Container
Small Box
% Of Year
0.00657% Order Quantity
3.55% Below
1.22% Below
19.10% Above
27
Product Base Margin 0.39
Discount
1%
Row ID
Order ID
Order Date
Order Priority
Critical
Days To Ship
Row ID
Order ID
Order Date
Order Priority
Days To Ship
1
49
50
80
85
86
97
98
103
107
127
128
134
135
149
160
161
175
176
203
204
213
214
229
230
231
249
250
256
330
331
332
362
363
381
406
413
414
415
440
3
293
293
483
515
515
613
613
643
678
807
807
868
868
933
995
998
1154
1154
1344
1344
1412
1412
1539
1539
1540
1702
1761
1792
2275
2277
2277
2532
2532
2631
2757
2791
2791
2791
2976
10/13/2010
10/1/2012
10/1/2012
7/10/2011
8/28/2010
8/28/2010
6/17/2011
6/17/2011
3/24/2011
2/26/2010
11/23/2010
11/23/2010
6/8/2012
6/8/2012
8/4/2012
5/30/2011
11/25/2009
2/14/2012
2/14/2012
4/15/2012
4/15/2012
3/12/2010
3/12/2010
3/9/2011
3/9/2011
8/4/2012
5/6/2011
12/23/2010
11/8/2010
10/21/2012
1/1/2011
1/1/2011
10/10/2011
10/10/2011
9/23/2010
7/19/2011
10/9/2009
10/9/2009
10/9/2009
12/9/2010
Low
High
High
High
Not Specified
Not Specified
High
High
High
Low
Medium
Medium
Not Specified
Not Specified
Not Specified
Medium
Not Specified
Critical
Critical
Low
Low
Not Specified
Not Specified
Low
Low
High
High
High
Low
Not Specified
Not Specified
Not Specified
High
High
Low
Critical
High
High
High
Not Specified
7
1
2
2
2
2
0
1
1
0
1
1
1
2
0
1
1
2
2
7
4
2
2
2
5
2
1
2
5
1
1
2
1
1
2
0
0
2
1
2
471
513
577
606
656
669
670
671
672
734
735
755
769
782
786
817
818
821
822
839
853
863
864
911
950
951
956
963
964
965
966
988
1017
1073
1154
1156
1157
1205
1226
1227
1228
1229
1230
1258
1259
1299
1300
1301
1337
1370
1371
1372
3232
3524
3908
4132
4612
4676
4676
4676
4676
5284
5316
5409
5506
5569
5607
5894
5894
5925
5925
6016
6116
6182
6182
6535
6884
6884
6916
6980
6982
6982
6982
7110
7430
7906
8391
8419
8419
8833
8995
8995
8995
8995
8995
9126
9127
9509
9509
9509
9763
9927
9927
9927
10/8/2012
5/2/2012
3/8/2010
5/28/2011
9/19/2010
8/31/2011
8/31/2011
8/31/2011
8/31/2011
7/8/2011
1/30/2009
1/8/2012
11/7/2010
4/29/2010
12/31/2011
8/12/2009
8/12/2009
11/12/2011
11/12/2011
1/20/2012
3/20/2009
7/21/2012
7/21/2012
6/12/2012
1/15/2009
1/15/2009
6/4/2010
2/18/2010
11/16/2011
11/16/2011
11/16/2011
8/7/2011
6/8/2010
10/17/2009
8/28/2011
9/29/2011
9/29/2011
5/4/2012
5/17/2011
5/17/2011
5/17/2011
5/17/2011
5/17/2011
11/17/2009
10/10/2011
10/7/2012
10/7/2012
10/7/2012
8/13/2011
8/16/2011
8/16/2011
8/16/2011
Critical
High
Medium
Not Specified
Medium
High
High
High
High
Not Specified
Critical
Low
Critical
Not Specified
Not Specified
High
High
Low
Low
High
Medium
Low
Low
Critical
Low
Low
Low
Not Specified
Not Specified
Not Specified
Not Specified
Low
Medium
Medium
High
Critical
Critical
Low
High
High
High
High
High
Medium
Not Specified
Not Specified
Not Specified
Not Specified
Medium
High
High
High
2
1
0
2
2
1
2
2
1
2
2
5
1
2
3
1
3
7
7
0
2
7
4
3
5
5
4
1
2
2
2
4
1
0
1
2
1
4
1
1
1
1
2
1
2
1
1
0
3
1
1
1
1380
1445
1457
1462
1463
1495
1496
1513
1544
1551
1589
1590
1594
1654
1655
1656
1675
1676
1710
1718
1727
1745
1751
1770
1771
1781
1782
1806
1807
1842
1843
1848
1855
1913
1928
1929
1930
1978
1979
2013
2058
2070
2071
2114
2115
2116
2117
2129
2130
2161
2206
2207
10022
10437
10499
10535
10535
10789
10791
10945
11137
11202
11456
11460
11495
11911
11941
11941
12096
12096
12289
12352
12419
12485
12544
12704
12704
12771
12771
12929
12929
13280
13280
13313
13346
13702
13795
13795
13795
14116
14116
14372
14726
14819
14819
15106
15106
15106
15108
15205
15205
15591
15907
15907
3/4/2009
8/18/2009
11/16/2010
5/27/2011
5/27/2011
8/23/2010
8/19/2011
1/3/2012
11/29/2012
3/17/2012
4/12/2010
8/24/2010
7/4/2011
11/10/2010
6/24/2010
6/24/2010
9/19/2012
9/19/2012
12/24/2011
3/23/2012
10/15/2011
8/7/2010
3/3/2009
2/9/2010
2/9/2010
1/17/2009
1/17/2009
8/30/2010
8/30/2010
9/11/2009
9/11/2009
7/16/2009
11/15/2012
9/10/2011
4/10/2011
4/10/2011
4/10/2011
10/9/2011
10/9/2011
10/23/2012
1/8/2012
1/25/2010
1/25/2010
1/27/2011
1/27/2011
1/27/2011
8/27/2009
3/17/2011
3/17/2011
6/6/2012
4/11/2011
4/11/2011
Low
Critical
Not Specified
Low
Low
Not Specified
Not Specified
Medium
High
Medium
Low
High
High
Critical
Critical
Critical
Medium
Medium
Low
Medium
Critical
Critical
Low
Low
Low
Critical
Critical
Critical
Critical
High
High
Not Specified
Low
Low
Not Specified
Not Specified
Not Specified
High
High
Critical
Low
Not Specified
Not Specified
Not Specified
Not Specified
Not Specified
High
Critical
Critical
Critical
High
High
0
2
1
2
7
1
2
2
1
1
7
2
1
2
1
1
0
2
4
1
2
1
7
0
2
0
2
1
1
1
1
1
5
4
3
3
1
2
1
2
0
2
1
2
0
2
2
2
1
2
2
3
2208
2209
2210
2221
2246
2247
2281
2283
2294
2295
2296
2297
2316
2317
2318
2323
2346
2347
2383
2384
2402
2445
2483
2487
2489
2490
2491
2520
2521
2522
2615
2624
2637
2643
2726
2727
2728
2768
2782
2796
2811
2812
2935
2936
2956
2999
3006
3052
3053
3089
3110
3135
15907
15937
15937
16039
16193
16193
16423
16451
16545
16545
16547
16547
16706
16706
16706
16741
16932
16932
17283
17286
17409
17764
18080
18113
18144
18144
18144
18308
18308
18308
18887
19010
19078
19138
19655
19686
19686
20007
20071
20160
20263
20263
21285
21285
21383
21607
21636
21889
21889
22151
22342
22469
4/11/2011
11/6/2012
11/6/2012
5/16/2012
4/9/2012
4/9/2012
8/5/2012
7/22/2009
5/9/2010
5/9/2010
2/18/2009
2/18/2009
6/27/2012
6/27/2012
6/27/2012
9/30/2010
4/15/2010
4/15/2010
9/14/2011
9/21/2010
8/17/2010
9/16/2009
6/22/2009
8/28/2012
6/7/2011
6/7/2011
6/7/2011
10/9/2009
10/9/2009
10/9/2009
12/5/2010
6/7/2009
7/27/2009
9/5/2011
1/11/2009
8/15/2010
8/15/2010
8/5/2009
9/17/2011
10/22/2011
11/14/2009
11/14/2009
7/3/2010
7/3/2010
1/30/2009
3/15/2012
8/10/2009
4/1/2010
4/1/2010
7/31/2010
5/29/2009
10/11/2010
High
Low
Low
High
Not Specified
Not Specified
Medium
Not Specified
Not Specified
Not Specified
Not Specified
Not Specified
High
High
High
Medium
Critical
Critical
Not Specified
High
Not Specified
Low
High
Not Specified
Critical
Critical
Critical
Not Specified
Not Specified
Not Specified
Not Specified
Low
Critical
Low
High
Medium
Medium
Not Specified
Medium
Low
Medium
Medium
Medium
Medium
Low
Not Specified
Low
Low
Low
High
Low
High
1
4
9
1
2
2
2
1
2
2
2
0
1
1
2
1
1
0
1
1
2
0
1
2
2
2
2
2
0
1
2
2
1
5
1
0
2
1
2
2
1
2
1
2
5
2
0
7
2
0
7
2
3138
3140
3244
3245
3284
3300
3355
3356
3357
3359
3371
3372
3373
3380
3381
3406
3418
3419
3434
3478
3479
3493
3552
3560
3591
3592
3602
3604
3605
3641
3643
3644
3649
3658
3666
3688
3689
3711
3716
3719
3720
3721
3722
3760
3805
3806
3807
3808
3821
3841
3860
3861
22501
22532
23264
23264
23488
23584
24007
24007
24007
24038
24097
24097
24097
24128
24128
24294
24387
24387
24515
24743
24743
24871
25318
25377
25634
25634
25733
25767
25767
26023
26051
26051
26116
26182
26272
26370
26370
26499
26531
26567
26567
26567
26567
26854
27109
27111
27111
27111
27264
27392
27553
27553
5/18/2010
2/8/2011
12/7/2010
12/7/2010
1/6/2009
3/12/2012
8/26/2010
8/26/2010
8/26/2010
6/20/2011
8/4/2010
8/4/2010
8/4/2010
11/23/2010
11/23/2010
8/2/2009
8/10/2011
8/10/2011
5/6/2010
6/28/2012
6/28/2012
3/23/2011
11/19/2011
11/26/2012
7/29/2010
7/29/2010
5/12/2012
3/3/2012
3/3/2012
8/20/2010
6/27/2010
6/27/2010
10/29/2012
1/16/2010
6/29/2012
8/8/2011
8/8/2011
2/21/2010
6/20/2011
9/4/2009
9/4/2009
9/4/2009
9/4/2009
6/21/2009
2/8/2012
3/11/2009
3/11/2009
3/11/2009
6/4/2011
3/2/2012
8/12/2011
8/12/2011
High
Critical
Critical
Critical
Critical
Critical
Low
Low
Low
High
High
High
High
High
High
Not Specified
Critical
Critical
Critical
Low
Low
Medium
Critical
Low
Not Specified
Not Specified
Low
High
High
High
Not Specified
Not Specified
Critical
Not Specified
Low
Not Specified
Not Specified
Medium
Medium
Critical
Critical
Critical
Critical
Not Specified
Critical
High
High
High
Low
Low
Medium
Medium
1
0
2
2
1
2
7
7
4
2
0
2
2
2
2
1
1
0
2
7
5
1
2
7
3
1
5
0
1
1
2
1
1
3
9
2
2
1
2
0
3
1
1
1
2
3
1
0
2
9
2
2
3863
3873
3874
3891
3892
3914
3915
3929
3936
3947
3948
3952
3963
3992
4017
4050
4051
4075
4082
4118
4119
4164
4193
4194
4202
4305
4306
4346
4347
4362
4369
4372
4390
4391
4392
4401
4404
4405
4411
4412
4413
4429
4430
4437
4446
4447
4459
4460
4524
4525
4532
4533
27555
27680
27680
27778
27778
27909
27909
28003
28035
28135
28135
28165
28289
28486
28675
28870
28871
29030
29095
29287
29287
29510
29795
29795
29861
30658
30658
30947
30947
31077
31111
31169
31270
31270
31270
31364
31393
31393
31492
31492
31492
31558
31558
31618
31684
31684
31781
31781
32193
32193
32229
32229
9/1/2009
1/26/2010
1/26/2010
9/2/2011
9/2/2011
2/7/2012
2/7/2012
3/19/2011
5/8/2011
9/25/2009
9/25/2009
7/9/2012
1/14/2010
8/26/2009
10/8/2009
11/10/2011
4/15/2012
1/2/2012
3/8/2011
7/2/2009
7/2/2009
4/15/2011
11/25/2011
11/25/2011
4/25/2012
3/26/2011
3/26/2011
7/14/2010
7/14/2010
10/23/2010
8/24/2009
6/9/2011
11/23/2012
11/23/2012
11/23/2012
5/1/2009
5/11/2012
5/11/2012
10/15/2010
10/15/2010
10/15/2010
7/23/2011
7/23/2011
7/11/2011
9/16/2012
9/16/2012
1/16/2009
1/16/2009
10/20/2010
10/20/2010
8/30/2010
8/30/2010
Critical
Critical
Critical
Critical
Critical
Critical
Critical
Critical
Not Specified
Critical
Critical
Not Specified
High
High
Critical
High
High
Medium
Not Specified
High
High
Critical
High
High
Critical
Medium
Medium
Low
Low
Not Specified
Not Specified
Low
Medium
Medium
Medium
Not Specified
Critical
Critical
Critical
Critical
Critical
Low
Low
Critical
Critical
Critical
Medium
Medium
Low
Low
High
High
2
1
1
2
2
2
3
2
2
2
…
Purchase answer to see full
attachment