Problem Set 2- Aanyra Maddox
docx
keyboard_arrow_up
School
Georgia State University *
*We aren’t endorsed by this school
Course
MATH2058
Subject
Statistics
Date
Feb 20, 2024
Type
docx
Pages
4
Uploaded by ConstableHorse436
Statistical Analysis in Criminal Justice
Problem Set # 2 Name: Aanyra Maddox
Purpose
In these problems, you will:
Demonstrate your ability to evaluate and use an Excel spreadsheet.
Develop and interpret charts and graphs.
Instructions
Use the Excel data in the folder “Excel Data for Class & Problem Sets” to answer the following questions. You must upload your own Excel Workbook as your Problem Set in ICollege. Please insert a new sheet into the Workbook and label it PS2. Do all your work in this sheet PS2.
Your homework must be completed independently, or it is considered academic dishonesty
Problems
1. In a sample of police officers, the number of times they pulled over a person for making an illegal turn last month: 2, 10, 15, 7, 0, 15, 10, 12, 15, 9, 10 37, 9
Present these data in a cumulative frequency distribution. Do this by hand. Also, do this Excel by using the =countif function as we did in class. You must submit your Excel workbook in ICollege with Sheet 1 labeled cumulative frequency distribution.
2. Based on your cumulative frequency distribution:
a.
how many police officers pulled over 9 people last month? 2
b. what percentage of police officers pulled over more than 10 people last
month? 38.46 %
c. what proportion of police officers pulled over 15 people last month? 0.23
d. what proportion of police officers pulled over fewer than 12 people last month? 0.62
3. You hypothesize that those with mental health disorders will be more likely to take prescription drugs than those without mental disorders. You collect data and create a cross-tab to reflect what you found. Using this crosstab: Mental Health Disorder
Take Prescription Drug
Yes
No
Yes
37
91
No
22
12
a. What proportion of the sample has a mental health disorder? 0.36
b. Of those who take prescription drugs, what percentage has a mental
disorder? 28.91%
c. What percentage of the sample does not take prescription drugs? 20.99%
d. Of those without a mental health disorder, what proportion takes prescription drugs? 0.88
e. What is the independent variable? Mental health disorder
Is it located in the columns or rows? Columns
4.
There were 990 people shot dead by the police in 2015. Below are data
reflecting the race of the VICTIM who was by the police. Based on the following information, create an appropriate chart to depict the data. Be sure to label all of the relevant parts of your chart and make it look pretty! Retrieved from https://www.washingtonpost.com/graphics/national/police-
shootings/
Race
f
White
494
Black
258
Hispanic
172
Other
38
Unknown
28
494
258
172
38
28
Race of individuals shot by police in 2015
White Black
Hispanic
Other
Unknown
5. Based on this graph, answer the following:
a.
What type of graph is this? Line Graph
b.
What year was the number of data breaches the highest? 2017
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
c.
Write two sentences to describe what is interesting about this chart.
Write so that a person who did not know anything about the topic could understand. -
One thing I found interesting about this chart is that as the years passed there was a gradual increase in data breaches. Another thing I found interesting was even though data breaches decreased in 2018, the records that were exposed increased
. d.
In what year was the number of records exposed the highest? 2018
6. Using the report found at https://www.bjs.gov/content/pub/pdf/bwclea16.pdf
answer the following questions. 1. Using to Table 1, describe the size of local police and sheriff’s offices
that have at least some BWC in use.
- The sizes of local police and sheriff’s offices that have more of “at least some BWCs in use” are larger. 2. What is the most common reason why BWCs are acquired by departments? (i.e., what table did you look at?)
- According to Table 3, the most common reason why BWCs are acquired by departments is to improve officer safety.
3. Do most police agencies that have BWC also have a BWC policy? How do you know? (i.e., what table did you look at?)
- According to Table 5, police agencies that have BWCs have a large percentage of BWC policies.
4. Other than what has been asked about in this question, identify one FACT that you find interesting from this report and EXPLAIN why you find it interesting.
- One fact that I found interesting was that privacy concerns were the most common obstacle associated with using cameras or video in agencies with BWCs. I found this interesting because I was confused as to why privacy was such a huge concern. Having a body
camera is extremely important and it can help the officer. I also feel as they are working, everything is public, they are in the public and helping the public, so what is it that is so private to them?
Related Documents
Related Questions
Make a two-way table from the accompanying table, for gender and eye color. Put the labels Male and Female on the top and the labels Brown, Blue, and Hazel on the side, and then tally the data. Complete parts (a) through (f) below.
LOADING...
Click the icon to view the data table.
Question content area bottom
Part 1
a. Arrange the data as a two-way table and report how many students are in each cell. For each cell, make a tally mark using the capital letter I for each person who has both of the characteristics belonging to that cell. Type a 0 if there are no students with the given characteristics.
Male
Female
Total
Brown
enter your response here
enter your response here
Blue
enter your response here
enter your response here
Hazel
enter your response here
enter your response here
Total
Part 2
b. Sum the numbers of students in each row and each column, and put these sums…
arrow_forward
Hi. Attached is the table for reference and the questions are right below. Please answer subparts #4-6. Thank you.
arrow_forward
Continue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File.
Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts.
Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.
Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control?
Group of answer choices
No. The X-bar and R Charts are both out of control.
No. The X-bar Chart is in control, but the R Chart is out of control.
No. The R Chart is in control, but the X-bar Chart is out of control.
Yes. The X-bar and R Charts are both in control.
arrow_forward
. Primary Data Source and Secondary Data Source ?
arrow_forward
On December 17, 2007 baseball writer John Hickey wrote an article for the Seattle P-I about increases to ticket prices for Seattle Mariners
games during the 2008 season. The article included a data set that listed the average ticket price for each MLB team, the league in which the team
plays (AL or NL), the number of wins during the 2007 season and the cost per win (in dollars). The data for the 16 National League teams are shown
below.
league
price
wins
cost/win
team
Arizona Diamondbacks
NL
19.68
90
35.40
Atlanta Braves
NL
17.07
84
32.89
Chicago Cubs
NL
34.30
85
65.33
cincinnati Reds
NL
17.90
72
40.32
Colorado Rockies
NL
14.72
90
26.67
Florida Marlins
NL
16.70
71
38.13
Houston Astros
NL
26.66
73
59.11
Los Angeles Dodgers
20.09
82
34.64
NL
Milwaukee Brewers
NL
18.11
83
35.37
N.Y. Mets
NL
25.28
88
46.56
Philadelphia Phillies
26.73
89
48.69
NL
Pittsburgh Pirates
NL
17.08
68
40.67
San Diego Padres
NL
20.83
89
38.15
San Francisco Giants
NL
24.53
71
56.00
St. Louis Cardinals
NL
29.78
78…
arrow_forward
Kevin Horn is the national sales manager for National Textbooks Inc. He has a sales staff of 40 who visit college professors
all over the United States. Each Saturday morning he requires his sales staff to send him a report. This report includes,
among other things, the number of professors visited during the previous week. Listed below, ordered from smallest to
largest, are the number of visits last week.
38
59
40 41 45 48 48 50
59 59 62 62 62 63
Click here for the Excel Data File
a. Determine the median number of calls.
Median
Q1
Q3
50
64
51 51 52 52 53 54 55 55 55 56 56 57
65 66 66 67 67 69 69 71 77 78 79 79
b. Determine the first and third quartiles. (Round Q1 to 2 decimal places and Q3 to nearest whole number.)
arrow_forward
The accompanying table gives the number of people diagnosed with AIDS in 2010 in 6 regions and the population of that region. Note that the "Rank Cases" column ranks the regions in order of the highest number of AIDS patients to the lowest number of AIDS patients; using 1 for the largest value and 6 for the smallest. Use the table to answer the following questions.
LOADING...
Click the icon to view the data table.
Find the population of the remaining regions in thousands and add them to the table.
Region
AIDS
Rank Cases
Population
Population
(thousands)
A
73,138
1
19,245,825
19,246
B
69,773
2
36,559,898
36,560
C
54,755
3
18,207,130
nothing
D
38,544
4
23,900,845
nothing
E
20,810
5
12,431,007
nothing
F
6,068
6
591,888
nothing
(Round to the nearest whole number as needed.)
arrow_forward
Please help with (d)
arrow_forward
The average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for typical Cheyenne residences.
Average Monthly Gas
Number of
Bill for Last Year
Age
Square Footage
Rooms
$70.20
16
2537
6
$81.33
2
3437
8
$45.86
27
976
6
$59.21
11
1713
7
$117.88
16
3979
11
$57.78
2
1328
7
$47.01
27
1251
6
$52.89
4
827
5
$32.90
12
645
4
$67.04
29
2849
5
$76.76
1
2392
7
$60.40
26
900
5
$44.07
14
1386
5
$26.68
20
1299
4
$62.70
17
1441
6
$45.37
13
562
4
$38.09
10
2140
4
$45.31
22
908
6
$52.45
24
1568
5
$96.11
27
1140
10…
arrow_forward
ANSWER and EXPLAIN FOR BETTER UNDERSTANDING The Following Problem USING EXCEL. Kindly ATTACH THE EXCEL FILE ON GDRIVE LINK:
https://drive.google.com/drive/folders/1GPsTMNYrbI6tyc1Gx7ehjxahvv-PeEj5?usp=sharing
arrow_forward
I need help with this problem please.
arrow_forward
Create a side-by-side boxplot for vitamin D level vs. NewAge and a side-
by-side boxplot for vitamin D level vs. country.
Create a scatterplot to show the relationship between vitamin D level
and Age.
Compare these two side-by-side boxplots and the scatterplot and explain
your findings.
• Note: Write appropriate captions for the tables, graphs, and outputs.
arrow_forward
Need help on letters A-G (all questions). Thank you.
arrow_forward
Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited.
Data Set: Cereals
The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g).
Exercise 1:
A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market).
N = Nabisco, K = Kellog’s, Q = Quaker Oats…
arrow_forward
How to interpret scatterplots Positive, Negative, or little or No Relationship?
arrow_forward
I filled out 1 and 2 to reduce the complexity of the question. Looking for 3,4, and 5 and a brief explanation for each. Please use type and not handwriting
(Context) Your boss is very interested in the variability of waste and wants to know more. You provide her with the following statistics you gathered to help her better understand the waste variability. Do you best to explain these things in your report, or visually try to represent them to help your boss grasp these difficult concepts:
1.) The Mean
497.25
2.) The Standard Deviation
26.42
*3.) Using the Empirical Rule, you show her where 68%, 95%, and 99.7% of all weekly observations (pounds of waste) will fall.
68% =
95% =
99.7% =
Your boss is super interested and wants to know more! She wants to know:
*4.) The probability of having more than 540 pounds of waste in a given week.
Probability =
*5.) The probability of having less than 450 pounds of…
arrow_forward
PLEASE ANSWER THIS QUESTION WITHIN 30 MINUTES
arrow_forward
Now monitor the process. An additional ten days of data have been collected, see table labeled “1st 10 Days of Monitoring Reservation Processing Time” in the Data File.
Develop Xbar and R charts for the 1st 10 days of monitoring. Plot the data for the 1st 10 days on the Xbar and R charts.
Is the process in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart.
Based on the X-bar and R Charts that you developed for the 1st 10 days of data, is the process in control?
Group of answer choices
No. The X-bar and R Charts are both out of control.
No. The X-bar Chart is in control, but the R Chart is out of control.
No. The R Chart is in control, but the X-bar Chart is out of control.
Yes. The X-bar and R Charts are both in control.
arrow_forward
can a cause and effect relationship be determined?
arrow_forward
complete screenshot please
arrow_forward
Contingency tables can be formatted in different ways. For this question you will need to
access the article Atrazine Exposure in Public Drinking Water and Preterm Birth by Rinsky et. al.
Click HERE to access the article.
For this question you will need to examine the table located on page 78 of the article.
Notice that this table is different from the contingency tables you examined in the notes.
The columns summarize a single variable but the rows are comprised of many variables. You
can think of this table as combination of contingency tables. Where the variable along the
top is always the same.
What symbol should be used to denote the proportion of mothers in the study who
received adequate prenatal care?
Op
O
F
Ор
arrow_forward
Here is a set of 20 values in order:
1, 2, 5, 10, 11, 12, 14, 15, 15, 16, 18, 19, 20, 21, 22, 24, 25, 28, 32, 45
Do not use software for this question. Using your pencil, paper, and perhaps your calculator, determine the values for the 5 Number Summary for this set of data and type your answer into the essay text box.
arrow_forward
What should the APA Results section look like?
arrow_forward
How can you identify and remedy the following: errors in data entry outliners, and missing data?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
Related Questions
- Make a two-way table from the accompanying table, for gender and eye color. Put the labels Male and Female on the top and the labels Brown, Blue, and Hazel on the side, and then tally the data. Complete parts (a) through (f) below. LOADING... Click the icon to view the data table. Question content area bottom Part 1 a. Arrange the data as a two-way table and report how many students are in each cell. For each cell, make a tally mark using the capital letter I for each person who has both of the characteristics belonging to that cell. Type a 0 if there are no students with the given characteristics. Male Female Total Brown enter your response here enter your response here Blue enter your response here enter your response here Hazel enter your response here enter your response here Total Part 2 b. Sum the numbers of students in each row and each column, and put these sums…arrow_forwardHi. Attached is the table for reference and the questions are right below. Please answer subparts #4-6. Thank you.arrow_forwardContinue monitoring the process. A second ten days of data have been collected, see table labeled “2nd 10 Days of Monitoring Reservation Processing Time” in the Data File. Develop Xbar and R charts for the 2nd 10 days of monitoring. Plot the data for the 2nd 10 days on the Xbar and R charts. Is the reservation process for the 2nd 10 days of monitoring in control? If the control chart indicates an out-of-control process, note which days, the pattern, and whether it is the Xbar or R chart. Based on the X-bar and R Charts that you developed for the 2nd 10 days of data, is the process in control? Group of answer choices No. The X-bar and R Charts are both out of control. No. The X-bar Chart is in control, but the R Chart is out of control. No. The R Chart is in control, but the X-bar Chart is out of control. Yes. The X-bar and R Charts are both in control.arrow_forward
- . Primary Data Source and Secondary Data Source ?arrow_forwardOn December 17, 2007 baseball writer John Hickey wrote an article for the Seattle P-I about increases to ticket prices for Seattle Mariners games during the 2008 season. The article included a data set that listed the average ticket price for each MLB team, the league in which the team plays (AL or NL), the number of wins during the 2007 season and the cost per win (in dollars). The data for the 16 National League teams are shown below. league price wins cost/win team Arizona Diamondbacks NL 19.68 90 35.40 Atlanta Braves NL 17.07 84 32.89 Chicago Cubs NL 34.30 85 65.33 cincinnati Reds NL 17.90 72 40.32 Colorado Rockies NL 14.72 90 26.67 Florida Marlins NL 16.70 71 38.13 Houston Astros NL 26.66 73 59.11 Los Angeles Dodgers 20.09 82 34.64 NL Milwaukee Brewers NL 18.11 83 35.37 N.Y. Mets NL 25.28 88 46.56 Philadelphia Phillies 26.73 89 48.69 NL Pittsburgh Pirates NL 17.08 68 40.67 San Diego Padres NL 20.83 89 38.15 San Francisco Giants NL 24.53 71 56.00 St. Louis Cardinals NL 29.78 78…arrow_forwardKevin Horn is the national sales manager for National Textbooks Inc. He has a sales staff of 40 who visit college professors all over the United States. Each Saturday morning he requires his sales staff to send him a report. This report includes, among other things, the number of professors visited during the previous week. Listed below, ordered from smallest to largest, are the number of visits last week. 38 59 40 41 45 48 48 50 59 59 62 62 62 63 Click here for the Excel Data File a. Determine the median number of calls. Median Q1 Q3 50 64 51 51 52 52 53 54 55 55 55 56 56 57 65 66 66 67 67 69 69 71 77 78 79 79 b. Determine the first and third quartiles. (Round Q1 to 2 decimal places and Q3 to nearest whole number.)arrow_forward
- The accompanying table gives the number of people diagnosed with AIDS in 2010 in 6 regions and the population of that region. Note that the "Rank Cases" column ranks the regions in order of the highest number of AIDS patients to the lowest number of AIDS patients; using 1 for the largest value and 6 for the smallest. Use the table to answer the following questions. LOADING... Click the icon to view the data table. Find the population of the remaining regions in thousands and add them to the table. Region AIDS Rank Cases Population Population (thousands) A 73,138 1 19,245,825 19,246 B 69,773 2 36,559,898 36,560 C 54,755 3 18,207,130 nothing D 38,544 4 23,900,845 nothing E 20,810 5 12,431,007 nothing F 6,068 6 591,888 nothing (Round to the nearest whole number as needed.)arrow_forwardPlease help with (d)arrow_forwardThe average monthly residential gas bill for Black Hills Energy customers in Cheyenne, Wyoming is (Wyoming Public Service Commission website). How is the average monthly gas bill for a Cheyenne residence related to the square footage, number of rooms, and age of the residence? The following data show the average monthly gas bill for last year, square footage, number of rooms, and age for typical Cheyenne residences. Average Monthly Gas Number of Bill for Last Year Age Square Footage Rooms $70.20 16 2537 6 $81.33 2 3437 8 $45.86 27 976 6 $59.21 11 1713 7 $117.88 16 3979 11 $57.78 2 1328 7 $47.01 27 1251 6 $52.89 4 827 5 $32.90 12 645 4 $67.04 29 2849 5 $76.76 1 2392 7 $60.40 26 900 5 $44.07 14 1386 5 $26.68 20 1299 4 $62.70 17 1441 6 $45.37 13 562 4 $38.09 10 2140 4 $45.31 22 908 6 $52.45 24 1568 5 $96.11 27 1140 10…arrow_forward
- ANSWER and EXPLAIN FOR BETTER UNDERSTANDING The Following Problem USING EXCEL. Kindly ATTACH THE EXCEL FILE ON GDRIVE LINK: https://drive.google.com/drive/folders/1GPsTMNYrbI6tyc1Gx7ehjxahvv-PeEj5?usp=sharingarrow_forwardI need help with this problem please.arrow_forwardCreate a side-by-side boxplot for vitamin D level vs. NewAge and a side- by-side boxplot for vitamin D level vs. country. Create a scatterplot to show the relationship between vitamin D level and Age. Compare these two side-by-side boxplots and the scatterplot and explain your findings. • Note: Write appropriate captions for the tables, graphs, and outputs.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman

MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc

Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning

Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning

Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON

The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman

Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman