Question
UploadUS_Crimedata and compute the following numbers. Hint: First sort the data. Use custom sort and you will need to experiment with the features Sort by,
UploadUS_Crimedata and compute the following numbers.
Hint:First sort the data. Use custom sort and you will need to experiment with the features "Sort by," and "Then by". Click on Add Level (upper left corner in sort window) to get "Then by".Suggestion: sort by year and then by crime.
Answer questions 11 to 13.
11. The average burglary numbers for all the states in 1970 is:
- a. 77456
- b. 63564
- c. 43261
12. The standard deviation of all burglaries for all the states in 1970 is:
- a. 36843
- b. 63564
- c. 28195
13. The median of all burglaries for all the states in 1970 is:
- a. 63564
- b. 26407
- c. 20349
Using the sorting feature (now on your own) find the state (and the year) that had the highest number of recorded burglaries.
Answer questions 14 to 16.
14. The state is:
- a. Illinois
- b. Texas
- c. California
15. The year is:
- a. 1980
- b. 1992
- c. 2001
16. The highest recorded number of burglaries is:
- a. 456908
- b. 545138
- c. 589004
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Essentials of Business Analytics
Authors: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
2nd edition
1305627733, 978-1305861817, 1305861817, 978-0357688960, 978-1305627734
