Purchase Solution

To estimate crimes in a City with 20 police

Not what you're looking for?

Ask Custom Question

To estimate crimes in a City with 20 police by determining the line of regression. See attached file for full problem description.

Use the "Correlation" tool in the DataAnalysis ToolPak for parts "c" and "d".
Use the Chart Wizard in the Insert, Chart menu options for part b.
X Y
Oxford
Starksdale
Danville
Athens
Holgate
Carey
Whistler
Woodville

#17 By referring to the problem above, show calculations and methods used,
and provide answers to the following questions in the body of your response:

a.) Estimate the number of crimes for a city with 20 police.
b.) Interpret the regression equation in "plain English"

Attachments
Purchase this Solution
Solution Summary

To estimate crimes in a City with 20 police by determining the line of regression. The chart menu options for Correlations are determined.

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

View More Free Quizzes
Related BrainMass Solutions

  • Correlation regression and determination

    Estimate the number of crimes for a city with 20 police h. Interpret the regression equation Please see the attachments The solution provides step by step method for the calculation of correlation regression and determination .

  • Using the correlation coefficient

    (Round your answers to 4 decimal places. Negative values should be indicated by a minus sign). formula304.mml = + X (b) Estimate the number of crimes for a city with 21 police officers. (Round your answer to 4 decimal places).

  • Scatter diagram, coefficient of correlation & determination

    The city council of Pine Bluffs is considering increasing the number of police in an effort to reduce crime.

  • Crime statistics

    245238 Statistics Do you think the crime statistics reported by the police are a valid measure of crime in a given city? Are they a reliable measure? The crime statistics reported by the police is a good baseline to measure crime in a given city.

  • Variance & Linear Regression

    a. If we want to estimate crimes on the basis of the number of police, which variable is the dependent variable and which is the independent variable?

  • Statistics Problem

    City Police Number of Crimes City Police Number of Crimes Oxford 15 17 Holgate 17 7 Starksville 17 13 Carey 12 21 Danville 25 5 Whistler 11 19 Athens 27 7 Woodville 22 6 a.

  • ANOVA, Regression, Chi-square, Hypothesis

    Vincent Mercy Monday 14 18 24 Tuesday 20 24 14 Wednesday 16 22 14 Thursday 18 20 22 Friday 20 28 24 3) The city council of Pine Bluffs is considering increasing the number of police in an effort to reduce crime.

  • Chi-square Test, Correlation & Regression Analysis

    d) Give a real life example of when you'd use Chi Square. 5) The city council of Pine Bluffs is considering increasing the number of police in an effort to reduce crime.

  • Probability, Normal distribution, Confidence Interval Problems

    The police department in your city was asked by the mayor?s office to estimate the cost of crime.

View More Related Solutions