The data reported in the Excel file CrimeSeverity comprises two variables, namely, Severity Index (which represents...

 

Transcribed Image Text:

The data reported in the Excel file CrimeSeverity comprises two variables, namely, Severity Index (which represents the non-violent crime severity index obtained from Statistics Canada's CANSIM database) and Methamphetamine (which represents the Google Trends search index in Canada using methamphetamine as the keyword). The yearly data covers the period from 2004 (the first available Google Trends data) to 2018. (a) Draw a scatterplot of the relationship between the Severity Index and methamphetamine search index and comment on the relationship between the two variables. (b) Use GRETL to compute the correlation between the Severity Index and methamphetamine search index and comment on the relationship between the two variables. (c) Run a simple linear regression of the severity index (the dependent variable) on the methamphetamine search index (the independent variable). Based on this regression results, do you think that the search index is a useful predictor of the severity index? Hint: you could look at the estimated slope coefficient as well as goodness-of-fit as measured by R-squared. (d) Interpret the R-squared value you obtained in part (c). Hint: R-squared is the percentage of the variation in the dependent variable explained by variation in the independent variable(s). A A B с 1 RefYear SeverityIndex Google Trends 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1 2 3 4 5 6 7 8 xgpn12134 15 9 10 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 K < > > 107.22 102.41 100 94.31 88.85 85.26 80.53 74.5 73.01 66.92 65.38 68.44 70.1 70.67 72.16 Sheet1 + 15.16 26.33 22.83 15.67 14.58 13 12.83 12.58 14.33 17.41 17.5 17 17.5 16 17 D E F G H 1 J K L M N O P Q || < R S T U V W X Y Z AA AB S中,周 A 88 The data reported in the Excel file CrimeSeverity comprises two variables, namely, Severity Index (which represents the non-violent crime severity index obtained from Statistics Canada's CANSIM database) and Methamphetamine (which represents the Google Trends search index in Canada using methamphetamine as the keyword). The yearly data covers the period from 2004 (the first available Google Trends data) to 2018. (a) Draw a scatterplot of the relationship between the Severity Index and methamphetamine search index and comment on the relationship between the two variables. (b) Use GRETL to compute the correlation between the Severity Index and methamphetamine search index and comment on the relationship between the two variables. (c) Run a simple linear regression of the severity index (the dependent variable) on the methamphetamine search index (the independent variable). Based on this regression results, do you think that the search index is a useful predictor of the severity index? Hint: you could look at the estimated slope coefficient as well as goodness-of-fit as measured by R-squared. (d) Interpret the R-squared value you obtained in part (c). Hint: R-squared is the percentage of the variation in the dependent variable explained by variation in the independent variable(s). A A B с 1 RefYear SeverityIndex Google Trends 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 1 2 3 4 5 6 7 8 xgpn12134 15 9 10 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 K < > > 107.22 102.41 100 94.31 88.85 85.26 80.53 74.5 73.01 66.92 65.38 68.44 70.1 70.67 72.16 Sheet1 + 15.16 26.33 22.83 15.67 14.58 13 12.83 12.58 14.33 17.41 17.5 17 17.5 16 17 D E F G H 1 J K L M N O P Q || < R S T U V W X Y Z AA AB S中,周 A 88