Question

Campus Crime Data
Number of Crimes	Number of Police	Total Enrollment	Protection Cost	Private School
64	12	1,131	549071	1
138	21	12,954	1101952	0
141	32	16,009	1430951	0
84	22	1,682	1110683	1
86	35	2,888	2155041	1
141	45	17,407	2273268	0
135	42	3,028	2402603	1
174	50	4,306	3292910	1
201	75	34,511	5016214	0
203	84	37,240	4971815	0
125	36	2,918	2272159	1
234	109	39,414	5187901	0
143	45	4,000	4284809	1
148	50	20,950	5137337	0
152	48	4,277	1931503	1
158	52	26,519	2500614	0
174	69	27,687	2833399	0
84	26	2,810	626119	1
173	58	27,619	1430961	0
193	56	4,563	4356393	1

1. Refer to the Campus Crime dataset in the EXCEL file. This data comes from a study of 20 campuses selected at random from a list of four-year schools in the continental U.S. Variables include:

• Number of Crimes reported during the most recent reporting year.
• Number of Police on the school’s police force during the most recent reporting year.
• Total Enrollment at the school during the most recent reporting year.
• Total Expenditure ($) on police protection by the school during the most recent reporting year.
• An indicator of whether the school is public or private (1 = Private, 0 = Public)

Further information that may be relevant is that there are 629 public and 1845 private four year institutions in the continental US, enrolling 6.838 million and 4.162 million, respectively during the most recent reporting year.

1. (For part A, assume that you only have columns A and E in the dataset). In an appropriate way, report an interval estimate of the total number of crimes on 4-year college campuses across the U.S. during the most recent reporting year. Briefly also discuss why your method is appropriate.
2. (For part B, you should use any part of the data you determine to be relevant). In an appropriate way, report an interval estimate of the total number of crimes on 4-year college campuses across the U.S. during the most recent reporting year. Briefly also discuss why your method is more appropriate than the method you used in (a).
3. Compare and contrast your estimates from (a) and (b). Identify the differences and explain why the estimates are different.
4. (For part D, again use any part of the data you deem relevant). Estimate the protection cost per police officer for all 4-year colleges across the nation. Briefly also discuss why your method is appropriate.
5. (For part E, again use any part of the data you deem relevant). Estimate the protection cost per enrolled student for all 4-year colleges across the nation. Briefly also discuss why your method is appropriate.

Answer 1