solve this excel sheet with the formulas
+ Excel File Edit View Insert Format Tools Data Window Help ... AutoSave O 5 C ... Advanced Excel Assignment 2 - CountIF, SumIF, AveragelF, and Pivot Tables.xlsx - ReadOnly v Home Insert Draw Page Layout Formulas Data Review View Automate Tell me
Q
Wed Nov 1 2:48 PM
Q gp Comments Share v O. Find & Sensitivity Select
X v Paste
Calibri (Body)
11 A A B 1 Uv v A
=
= ^18 I I
2 wrap Text v
General
^ %$ 9 88 Conditional Format Cell Formatting as Table Styles
insert v v Delete v v Format v 10
G9
V fix
8
E
F
H
M
N
Instructions Use the data in the table below the instructions
Points Possible
Use the countif function to count the number of data breaches in California. Again in South Carolina dog due ade eq epeq qenppaae po aqnu eo awns og uogun guns p an Use the averageif function to average the number of employees because of Theft and because of Improper Disposal, No decimal places. Create a pivot table (row is State, column is Breach Type, body is Sum of Number of Affected Individuals). Entered your name. Did not reference the state, but retyped it instead
12
Data Breaches
PIVOT TABLE Starts In This Cell
12
Question
13 14
(based upon the condition specified in the next column)
Condition CA Sc Paper Laptop Theft Improper Disposal
Answer
15
any data breaches happened in.
16
17
What is the sum of total number of affected individuals by Location of Breach for.
18 19 10
21 22
Affected Name of Covered Entity 5257|L. Douglas Carlson, M.D. 857David1 Cohen, MD 6145 Michele Del Vicario, MD 25 952Joseph F. Loper, MD 26 5166 Mark D. Lurie, MD 17 5900 City of Hope National Medical Center 7300University of California, San Francisco 8000 Cardiology Consultants/Baptist Health Care Corporation 3500 Advanced Neuro5pinal Care 12580Shands at UF 12 554North Carolina Baptist Hospital 33 S080Laboratory Corporation of AmericaDy west,In 2600 Mount Sinai Medical Center 5450 John Muir Physician Network 36 3594 Massachusetts Eye and Ear Infirmary 37 2850 South Carolina Department of Health and Environmental Control Exercise 2 + Ready AccessibilityInvestigate
State
Date of Breach Location of Breach 9/27/09Computer Theft 9/27/09 Desktop Computer 9/27/09 Desktop Computer 9/27/09Desktop Computer 9/27/09 Desktop Computer 9/27/09 Laptop 11/30/09Laptop 12/19/09Desktop Computer Theft 12/30/09 Network Server doydrn ot/t/t dedot/st/2 do;de1ot/1/2 3/9/10Laptop
Type of Breach
2/1/10Laptop 2/17/10Paper
Improper Disposal
85%
9O
:
M
V
@
1