I need to understand this homework before I take the test. I am stumped on a few of the problems.
Homework 4 Applied statistical analysis with real crime data Chapter 10 Data Analysis Page 198 – 199 (5 points) Question 1 or Question 2 (any one) Enter the data provided under Question 1 or 2 in page 199. Identify DV and IV Use the formula to calculate Pearson’s r with Excel (page 189) In the function bar type in =CORREL(B2:B11, C2:C11) (assuming you enter data in the b2 to b11 and c2to c11 cells) Explain the calculated ‘r’ statistics, its strength, direction and the relationship with DV and IV (explain well enough to earn full points) Chapter 11 Page 221 Question 7 Use the explanation provided under page 214 to 217 for Excel analysis Use explanation provided under page 213 – 214 to help explain the following questions Do the analysis for any two of section 7 (a, b and c) (10 points each) 1. Explain dependent and independent variables 2. Explain Intercept Coefficient – which is ‘a’ – which is intercept 3. Explain X variable Coefficient – which is ‘b’ – which is slope 4. Write the regression model or equation (page 214) 5. Explain r square – F value and its significance – Explain percent of variation in IV on DV 6. Explain t statistics and its significance and interpret ‘a’ and ‘b’ 7. Explain what you understand from this analysis 8. Explain Scatter plot (Insert ’Scatter’) (Select two columns – DV and IV and then insert Scatter) – Can you find a pattern? If so explain (Bonus question for 2 extra points) 9. Explain what is unexplained variance (which is 100 – r square) I will post the Data too to make it easy for the students. This homework help students to understand how to connect real world messy and large crime data in applying to understand the pattern, relationship and significance. Copy and paste the Excel output in your word document. Homework 4 Applied statistical analysis with real crime data Chapter 10 Data Analysis Page 198 – 199 (5 points) Question 1 or Question 2 (any one) Enter the data provided under Question 1 or 2 in page 199 . Identify DV and IV Use the formula to calculate Pearson’s r with Excel (page 189) In the function bar type in =CORREL(B2:B11, C2:C11) (assuming you enter data in the b2 to b11 and c2to c11 cells) Explain the calculated ‘r’ statistics , its strength, direction and the relatio nship with DV and IV (explain well enough to earn full points) Chapter 11 Page 221 Question 7 Use the explanation provided under page 214 to 217 for Excel analysis Use explanation provided under page 213 – 214 to help explain the following questions Do t he analysis for any two of section 7 (a, b and c) (10 points each) 1. Explain dependent and independent variables 2. Explain Intercept Coefficient – which is ‘a’ – which is intercept 3. Explain X variable Coefficient – which is ‘b’ – which is slope 4. Write the regression model or equation (page 214) 5. Explain r square – F value and its significance – Explain percent of variation in IV on DV 6. Explain t statistics and its significance and interpret ‘a’ and ‘b’ 7. Explain what you understand from this analysis 8. Explain S catter plot (Insert ’Scatter’) (Select two columns – DV and IV and then insert Scatter) – Can you find a pattern? If so explain (Bonus question for 2 extra points) 9. Explain what is unexplained variance (which is 100 – r square) I will post the Data too to make it easy for the students. This homework help students to understand how to connect real world messy and large crime data in applying to understand the pattern, relationship and significance. Copy and paste the Excel output in your word document . Homework 4 Applied statistical analysis with real crime data Chapter 10 Data Analysis Page 198 – 199 (5 points) Question 1 or Question 2 (any one) Enter the data provided under Question 1 or 2 in page 199. Identify DV and IV Use the formula to calculate Pearson’s r with Excel (page 189) In the function bar type in =CORREL(B2:B11, C2:C11) (assuming you enter data in the b2 to b11 and c2to c11 cells) Explain the calculated ‘r’ statistics, its strength, direction and the relationship with DV and IV (explain well enough to earn full points) Chapter 11 Page 221 Question 7 Use the explanation provided under page 214 to 217 for Excel analysis Use explanation provided under page 213 – 214 to help explain the following questions Do the analysis for any two of section 7 (a, b and c) (10 points each) 1. Explain dependent and independent variables 2. Explain Intercept Coefficient – which is ‘a’ – which is intercept 3. Explain X variable Coefficient – which is ‘b’ – which is slope 4. Write the regression model or equation (page 214) 5. Explain r square – F value and its significance – Explain percent of variation in IV on DV 6. Explain t statistics and its significance and interpret ‘a’ and ‘b’ 7. Explain what you understand from this analysis 8. Explain Scatter plot (Insert ’Scatter’) (Select two columns – DV and IV and then insert Scatter) – Can you find a pattern? If so explain (Bonus question for 2 extra points) 9. Explain what is unexplained variance (which is 100 – r square) I will post the Data too to make it easy for the students. This homework help students to understand how to connect real world messy and large crime data in applying to understand the pattern, relationship and significance. Copy and paste the Excel output in your word document. Savannah Robinson ID#1910136 November 13, 2020 Homework 4 Applied statistical analysis with real crime data Chapter 10 Data Analysis Page 198 – 199 (5 points) 1. Use Excel to conduct an analysis of the following table. We are interested in examining the relationship between the UCR violent crime rate per 100,000 population in 2016 in the Top Ten Gun Owning States in 2015. Specify the independent and dependent variables and state the research hypothesis. Calculate, state, and interpret the direction of the correlation, then create a scatterplot. The independent variable is the percentage of gun owners in 2015 (X). The dependent variable is the UCR Violent Crime Rate per 100,000 in 2016 (Y). The research hypothesis is the higher number of gun owners in a state in 2015 the higher crime rate will be. Question 1 or Question 2 (any one) Enter the data provided under Question 1 or 2 in page 199. Identify DV and IV Use the formula to calculate Pearson’s r with Excel (page 189) In the function bar type in =CORREL(B2:B11, C2:C11) (assuming you enter data in the b2 to b11 and c2to c11 cells) Explain the calculated ‘r’ statistics, its strength, direction and the relationship with DV and IV (explain well enough to earn full points) Chapter 11 Page 221 Question 7 7. The Percentage of People in Poverty, Average 96–97 (IV) and a. Violent Crime Rate per 100,000, 1997 (DV) b. Murder/Non-negligent Homicide per 100,000, 1997 (DV) c. Aggravated Assault per 100,000, 1997 (DV) Directions: Using the same variables from the Data Analysis exercises in chapter 10, identify dependent (DV) and independent variables (IV) and conduct a regression analysis on the following topics and variables from State Data Set II. The aim is to predict the values of the dependent variable from those of the independent variable. Interpret the a, b, and r 2 values fully. What predictions can you make using these equations? The Independent Variable (IV) is the percentage of people in poverty (average 96-96). The Dependent variables are violent crime rate per 100,000 (1997), murder/non-negligent homicide per 100,000 (1997), and aggravated assault per 100,000 (1997). Use the explanation provided under page 214 to 217 for Excel analysis Linear Regression Using Excel Using the same data set from the SPSS example above, we will conduct a linear regression analysis in Excel. We are hypothesizing that the variable “burglary,” our Y variable, depends on the variable “poverty,” our X variable. 1. Open data set “Linear Regression Using Excel.” 2. At the top of your document, choose “Data” and then select “Data Analysis.” 3. A pop-up screen, “Data Analysis,” (Figure 11.9) will appear. 4. Click on the “Regression” option and select “OK.” 5. A pop-up screen for “Regression” will appear. Populate input Y (dependent variable) range as column details related to “burglary” as AA2:AA51 and then input X (independent variable) range as column details related to “poverty” rate as AD2:AD51. Then you can select the options indicated in Figure 11.10. 6. “Regression” output will appear on a separate sheet (in a new window) as shown in Figure 11.11. Excel can generate a graph—called a Y line fit (shown in Figure 11.11 on p. 217). Therefore, our regression model is Ŷ = 451.5615 + 33.08X Use explanation provided under page 213 – 214 to help explain the following questions Do the analysis for any two of section 7 (a, b and c) (10 points each) 1. Explain dependent and independent variables The Independent variable is Percentage of People in Poverty, Average 96–97 for all three. The dependent variable would be : Violent Crime Rate per 100,000, 1997 in a; Murder/Non-negligent Homicide per 100,000, 1997 in b; and, Aggravated Assault per 100,000, 1997 in c. 2. Explain Intercept Coefficient – which is ‘a’ – which is intercept For Violent Crime: 274.031327638872 is the value of a. We round it to it to 274.03. Recall that a is the y-intercept or the predicted y when x=0. In this example violent crime would still be 274/100,000 even if poverty was 0, or eliminated. For