PLEASE HELP.

I NEED THE SPSS WORKING ALSO PLEASE

PLEASE SHOW ALL SPSS WORKING.

2. The Minister of National Security in Trinidad and Tobago is interested in determining the factors that influence the number of crimes that are reported. You are tasked to develop a model using the appropriate variables. The following variables are utilized: X1 = total overall reported crime rate per 100,000 residents X2 = reported violent crime rate per 100,000 residents X3 = % of people 25 years+ with 4 yrs. of high school X4=% of 16 to 19-year-olds not in high school and not high school graduates. X5 =% of 18 to 24-year-olds in college X6 = % of people 25 yearst with at least 4 years of college X1 X2 X3 X4 X5 X6 74 11 20 31 43 72 11 18 16 70 71 18 11 25 72 9 68 8 478 494 643 341 773 603 484 546 424 548 506 819 184 213 347 565 327 260 325 102 38 226 137 369 16 19 24 15 14 11 12 15 68 12 62 29 32 24 28 25 58 21 77 13 69 7 9 66 60 13 9 81 4 4 36 541 109 66 9 12 491 11 16 514 12 11 809 29 245 118 148 371 37 37 35 42 21 81 67 65 64 64 62 10 457 12 14 10 27 437 7 15 16 387 98 15 15 608 22 31 50 24 27 22 8 14 59 56 46 54 54 45 57 57 61 20 13 11 8 26 18 218 254 697 827 693 448 12 23 11 9 570 432 619 357 623 547 792 799 439 867 912 462 859 805 652 776 60 18 19 12 10 942 52 1017 216 673 44 43 48 17 21 18 9 8 14 31 24 23 22 25 25 21 19 10 989 14 57 47 50 12 9 630 404 19 19 9 Using SPSS answer the following a. Determine the multiple regression equation for the data. [2 marks] b. Interpret the coefficient of determination. [2 marks] c. At the 10% significance level, determine if the model is useful for predicting the number of crimes that are reported in Trinidad and Tobago. In responding, construct and test any appropriate hypothesis. [4 marks] d. At the 10% significance level, does it appear that percent of people 25 years+ with 4 yrs. of high school, percent of 16 to 19-year- olds not in high school and not high school graduates or percent of 18 to 24-year-olds in college can be removed from the model as unnecessary? In responding, construct and test any appropriate hypothesis. [4 marks] Note: All SPSS input files and output tables should be provided 2. The Minister of National Security in Trinidad and Tobago is interested in determining the factors that influence the number of crimes that are reported. You are tasked to develop a model using the appropriate variables. The following variables are utilized: X1 = total overall reported crime rate per 100,000 residents X2 = reported violent crime rate per 100,000 residents X3 = % of people 25 years+ with 4 yrs. of high school X4=% of 16 to 19-year-olds not in high school and not high school graduates. X5 =% of 18 to 24-year-olds in college X6 = % of people 25 yearst with at least 4 years of college X1 X2 X3 X4 X5 X6 74 11 20 31 43 72 11 18 16 70 71 18 11 25 72 9 68 8 478 494 643 341 773 603 484 546 424 548 506 819 184 213 347 565 327 260 325 102 38 226 137 369 16 19 24 15 14 11 12 15 68 12 62 29 32 24 28 25 58 21 77 13 69 7 9 66 60 13 9 81 4 4 36 541 109 66 9 12 491 11 16 514 12 11 809 29 245 118 148 371 37 37 35 42 21 81 67 65 64 64 62 10 457 12 14 10 27 437 7 15 16 387 98 15 15 608 22 31 50 24 27 22 8 14 59 56 46 54 54 45 57 57 61 20 13 11 8 26 18 218 254 697 827 693 448 12 23 11 9 570 432 619 357 623 547 792 799 439 867 912 462 859 805 652 776 60 18 19 12 10 942 52 1017 216 673 44 43 48 17 21 18 9 8 14 31 24 23 22 25 25 21 19 10 989 14 57 47 50 12 9 630 404 19 19 9 Using SPSS answer the following a. Determine the multiple regression equation for the data. [2 marks] b. Interpret the coefficient of determination. [2 marks] c. At the 10% significance level, determine if the model is useful for predicting the number of crimes that are reported in Trinidad and Tobago. In responding, construct and test any appropriate hypothesis. [4 marks] d. At the 10% significance level, does it appear that percent of people 25 years+ with 4 yrs. of high school, percent of 16 to 19-year- olds not in high school and not high school graduates or percent of 18 to 24-year-olds in college can be removed from the model as unnecessary? In responding, construct and test any appropriate hypothesis. [4 marks] Note: All SPSS input files and output tables should be provided