Before you can run an analysis,
you must access the input data source. You can download the crime
data directly from the FBI website, or you can copy the data from
the FBI Crime Data sample. Open FBI Crime data.xlsm, and copy the
data from the Original Data worksheet. Paste this data into a new
workbook.
To copy the data for
the Crime Analysis sample:
-
Open the FBI Crime data.xlsm
sample.
-
In the Original Data
worksheet, select the data in range A3:T23.
-
Copy the data from the
Original Data worksheet and paste the data into the Sheet1 worksheet
in a new workbook.
-
Rename this worksheet
Original
Data.
-
Save the new workbook
on your computer as
FBI Crime data.xlsm.