I. Estimar parmetros de regresin y contestar las preguntas de forma manuscrita. Muestra tu trabajo.

Informacin:

El gobierno de los Estados Unidos est intentando desarrollar un modelo llamado CRIME para identificar los efectos de algunas variables sobre el crimen.

El economista jefe del gobierno cree que algunos de las variables relacionadas con el DELITO (Y) son:

a. POV = porcentaje de la poblacin en el estado que viva por debajo del nivel de pobreza en 1993. b. METRO = poblacin metropolitana como porcentaje de la poblacin estatal. c. POPDENS = poblacin por milla cuadrada. El economista jefe decide recopilar datos sobre las variables en una muestra de todos los estados, incluidos el Distrito de Columbia (D.C.). Los datos se muestran en el archivo denominado "Delito" adjunto.

(i) Suponga que solo se usa la variable POV para predecir el nivel de delincuencia. Estimar la pendiente (coeficiente) de la lnea de regresin para el porcentaje de poblacin en el estado que vive por debajo del nivel de pobreza nivel (POV) usando Anlisis de datos en Excel.

(ii) Identifique el intercepto para la pregunta (i)

I. Estimate regression parameters and answer the questions handwritten. Show your work. The U.S. Government is attempting to develop a model named CRIME to identify the effects of some variables on crime. The government's chief economist feels that some of the important variables related to CRIME (Y) are: a. POV= per cent of population in state living below the poverty level in 1993. b. METRO = metropolitan population as percentage of state population. c. POPDENS = population per square mile. The chief economist decides to collect data on the variables in a sample of all states, including the District of Columbia (D.C). The data are shown in the file named "Crime" attached. (i) Suppose that only the variable POV is used to predict crime level. Estimate the slope (coefficient) of the regression line for the per cent of population in state living below the poverty level (POV) using Data Analysis in Excel. (ii) Identify the intercept for question (i) crime = total crimes in 1993/100,000 population by state (including the District of Columbia) pov =% of population in state living below the poverty level in 1993 metro = metroplitan population as % of state population popdens = population per square mile I. Estimate regression parameters and answer the questions handwritten. Show your work. The U.S. Government is attempting to develop a model named CRIME to identify the effects of some variables on crime. The government's chief economist feels that some of the important variables related to CRIME (Y) are: a. POV= per cent of population in state living below the poverty level in 1993. b. METRO = metropolitan population as percentage of state population. c. POPDENS = population per square mile. The chief economist decides to collect data on the variables in a sample of all states, including the District of Columbia (D.C). The data are shown in the file named "Crime" attached. (i) Suppose that only the variable POV is used to predict crime level. Estimate the slope (coefficient) of the regression line for the per cent of population in state living below the poverty level (POV) using Data Analysis in Excel. (ii) Identify the intercept for question (i) crime = total crimes in 1993/100,000 population by state (including the District of Columbia) pov =% of population in state living below the poverty level in 1993 metro = metroplitan population as % of state population popdens = population per square mile