Please see attached file. Assignment is to answer 5 questions that are attached in 1 file using a data sheet that is attached in another file

Please see attached file. Assignment is to answer 5 questions that are attached in 1 file using a data sheet that is attached in another file


Answer the following 5 questions using the data sheet provided. 1-Calculate the appropriate univariate statistics to understand the distribution of age. Based on these measures, which of the following statements best describes the distribution of age? ( ) The mode of age was 16 and the standard deviation was 1.17. ( ) The mean age is 15.10 and the standard deviation is 1.17. ( ) The mean age of the sample was 15.10 and the variation ratio was 84.9. ( ) The mode of age is 15. Twenty-eight percent of the sample were in the modal category. Therefore, the variation ratio is 72%. 2- Calculate the appropriate univariate statistics to understand the distribution of offense level. Based on these measures, which of the following statements best describes the distribution of offense level? ( ) The average offense level was 2.31 and the variation ratio was 97.69. ( ) The average offense level was 2.31 and the standard deviation was 1.30. ( ) The mode of offense level was 1. Forty percent of the sample was in the modal category. Therefore, the variation ratio is 40%. ( ) The mode of offense level was felony. Forty percent of the sample was in the modal category. Therefore, the variation ratio is 60%. 3- Please fill in the answers (DO NOT USE DECIMAL PLACES or CAPITAL LETTERS). The median number of days in detention was __________ , the mean was _______  , and the standard deviation was ___________  . This means that the number of days in detention had a ____________ skew. 4- What is the modal violent offense level? What is the variation ratio? ( ) 6; 65.95% ( ) noncriminal; 34.05% ( ) 4; 89.95% ( ) noncriminal; 65.95% 5- N = ____. ( ) 8 ( ) juvenile offenders ( ) 326 ( ) 327 Sheet1 IDYearIntake DateRelease DateAge RaceSexOffense LevelViolence Offense LevelNumber of OffensesDays in Detention 12320117/24/1110/11/1113BM11277 12420102/2/102/25/1016BM12223 12520118/16/119/6/1114BM11220 12620118/16/118/23/1115BM1227 12720113/18/113/25/1114BM1227 128201010/17/1011/18/1015BF11131 12920118/28/118/29/1113BF1211 130201112/21/113/28/1216WM11197 13120104/30/106/1/1015BF11131 13220103/31/104/27/1016BM11127 13320119/29/1110/4/1113BM1235 134201012/14/095/4/1014BM113140 13520102/2/104/23/1016BM12381 13620116/24/118/10/1114BM12446 13720116/24/118/16/1116BM11452 13820119/18/1111/15/1116BM11557 13920113/24/115/24/1116BM11160 14020104/26/105/25/1016HM11129 14120105/27/109/22/1016BM111115 142201011/6/092/8/1017BM12192 14320104/26/105/18/1016WM12122 14420112/1/117/5/1116BM111154 14520111/9/111/25/1114WM11116 14620111/5/111/25/1114BF11120 14720112/23/113/29/1112BM11136 14820109/11/1011/8/1015BF12157 14920102/9/103/3/1016BM12124 15020102/9/102/27/1016WF12118 151201012/1/1012/13/1012BM12112 15220104/30/107/27/1014BM11187 153201112/17/101/19/1116BM12132 15420116/22/116/26/1116BM1214 155201012/17/101/19/1116BM12132 15620106/28/108/24/1016WM12156 15720106/3/1011/19/1016BM111166 15820117/13/117/14/1113WM1211 15920118/8/118/25/1115WM12117 16020116/2/1110/11/1114BM111129 16120116/2/117/15/1116BM12143 16220104/28/105/21/1016BM12123 16320107/8/107/13/1015BM1215 16420107/13/109/24/1015BM11171 16520108/23/1012/1/1016BM11198 16620102/9/104/16/1016BM11167 16720107/27/108/24/1016WF12127 16820108/4/108/24/1014BM11120 16920101/8/104/12/1016BM11194 17020106/20/106/30/1015BM12110 171201112/14/102/24/1116BM11170 172201012/14/102/24/1116BM12170 17320119/19/119/26/1116BM1237 174201112/30/102/22/1115BM12152 175201112/30/102/7/1115BM12137 176201012/30/102/22/1115BM11152 177201012/30/102/7/1115BM11137 17820118/18/1110/11/1116BM11153 17920103/25/105/25/1016WF11160 180201112/14/102/1/1116BM11147 181201012/14/102/1/1116BM12147 182201112/16/111/6/1216BM12120 18320109/7/109/27/1016BM12120 18420105/19/106/18/1013BM12129 18520119/16/119/27/1114BM12111 186201111/16/1111/18/1116WM1212 18720114/28/114/29/1116BF1211 18820108/3/108/5/1016BM1212 18920105/2/107/27/1014BM11185 190201012/26/091/6/1016BM12110 191201011/30/091/11/1013BM11141 19220114/9/114/11/1113BM1112 19320115/24/117/22/1115BM12158 194201012/22/094/12/1016BM111110 19520105/12/107/30/1016BM11178 19620111/3/111/25/1115BM11122 19720114/1/115/19/1115BM11148 19820115/19/115/19/1115WM1210 199201111/14/1111/23/1114BM1219 20020115/31/116/24/1116BM12124 20120102/25/103/30/1015BM12135 202201010/20/1010/29/1016BM1219 20320103/22/103/23/1015BM1211 20420112/26/113/2/1115BM1216 205201111/16/104/19/1113WM111153 206201011/16/104/19/1113WM111153 20720106/17/109/30/1014BM111103 20820118/31/119/8/1114BM1218 20920115/21/117/1/1116BM11140 21020115/24/116/3/1113BM1219 21120113/18/114/4/1114BM12116 21220115/21/115/24/1113BM1213 21320115/24/116/3/1112BM1219 21420116/30/117/11/1116BM12111 21520115/21/115/24/1115BM1213 21620115/21/115/24/1114BM1213 21720116/30/118/15/1114HM11145 21820116/30/118/16/1114BM11146 21920101/8/101/15/1016BM1217 22020108/10/109/9/1015BM11129 221201012/30/091/7/1016BM1217 222201012/30/091/7/1015BM1217 223201011/30/1012/9/1017BM1219 224201010/18/1011/1/1015BM12113 22520106/16/106/18/1015BM1212 226201012/30/091/5/1013BM1215 22720108/24/108/26/1016BM1212 22820106/16/106/29/1015BM12113 22920118/16/118/22/1114BM1216 23020118/16/119/20/1113BM12134 231201010/17/1010/26/1015BM1219 23220103/2/105/10/1015WF11168 23320114/21/114/27/1116BM1216 23420119/4/1111/15/1116BM12171 23520108/20/108/24/1016BM1214 23620108/16/109/7/1015BM12121 237201010/16/1011/12/1015BM12126 23820108/24/109/28/1015BM12134 239201012/26/091/12/1016BM12116 24020103/5/103/31/1015BM12126 24120106/1/108/4/1015WM11163 24220105/28/106/1/1016BM1113 243201012/1/091/13/1015BM11142 244201112/19/111/10/1213BM11121 245201110/29/1111/15/1115BM11116 246201110/6/1110/24/1113BF12118 24720116/5/116/8/1115WM1213 248201111/9/101/5/1115BM11156 24920113/23/114/14/1116WM11121 250201011/9/101/5/1115BM11156 25120116/16/116/20/1114BM1214 25220118/26/119/12/1115BM12116 25320117/28/118/1/1114BF3513 25420114/11/114/12/1116BF3511 25520112/4/112/8/1116BF3514 25620116/21/118/23/1115WF35162 25720103/7/103/8/1016BM3511 258201012/30/092/13/1015BM35143 25920112/5/112/8/1114WF3513 26020109/7/109/9/1015BM3512 261201012/27/1012/30/1014BM2413 26220111/11/111/11/1114BM2310 26320113/24/114/11/1116BM23217 264201112/13/103/18/1115BF23295 265201012/13/103/18/1115BF23295 26620115/17/115/19/1114WM2312 26720116/9/116/10/1116BM2311 268201012/11/1012/21/1016BF23110 26920109/26/1011/9/1016BF23143 27020104/12/104/27/1016BM23115 27120119/9/1110/13/1116BM23134 27220109/26/109/27/1016BM2311 27320114/24/114/26/1112BM2312 27420107/9/107/21/1012BM23112 27520106/18/106/23/1015BM2415 276201110/27/1110/31/1114WM2414 27720119/12/119/13/1116BM2411 27820104/13/104/15/1015BF2412 279201111/15/1111/17/1116WM2412 28020119/22/119/23/1114BM2411 281201112/13/1112/15/1116WM2412 28220116/24/116/29/1114BF2415 28320112/1/112/3/1116BM2412 284201010/13/101/4/1113BM23181 28520114/5/115/3/1116BM23128 28620111/27/112/7/1116BM23110 28720112/21/112/22/1116WM2411 288201110/13/101/4/1113BM23181 28920118/30/1111/9/1117WM23169 29020117/6/117/21/1116BM24115 29120117/31/118/3/1114BM2413 29220113/10/113/10/1116BF2410 293201110/22/1110/24/1116BM2412 29420116/21/116/22/1113BM2411 295201010/3/1010/8/1014BM2315 29620108/9/108/18/1016BF2319 297201110/4/1110/10/1116WM2316 298201112/1/1112/6/1114BF2315 299201112/10/1112/13/1116BM2313 300201112/1/1112/6/1116BF2315 301201111/9/101/25/1113WM23176 30220113/24/113/24/1116BF2410 30320114/29/115/3/1114BF2414 304201112/1/1112/6/1114BF2415 30520112/28/113/29/1116BF24129 30620113/10/113/15/1116BF2415 30720116/17/116/20/1113BF2413 308201112/1/1112/6/1114BF2415 30920104/16/105/20/1016BM23134 31020101/18/101/29/1014BF23111 311201011/9/101/25/1113WM23176 31220107/2/107/12/1017BM23110 31320107/19/107/20/1017BM2311 31420104/20/104/27/1015BM2317 315201012/9/1012/22/1014BF23113 31620119/11/1110/27/1114BM23146 31720115/18/115/19/1114WM2311 318201112/29/101/20/1115BM24121 319201012/29/101/20/1115BM24121 32020117/19/117/21/1116BF2412 321201112/9/1112/10/1115BM2411 32220118/1/118/9/1115BM2418 32320114/15/114/19/1115BF2314 32420114/15/114/19/1114BF2314 32520111/30/113/29/1116WF23159 32620117/18/119/13/1113BM23155 327201110/2/1110/25/1114BM23123 328201110/26/1111/8/1115BM23112 329201110/22/1110/25/1115BM2313 33020108/3/108/8/1016BM2315 331201010/5/1010/12/1015BM2417 33220108/9/108/10/1016BF2411 33320106/14/106/21/1016BF2417 33420106/30/107/11/1016BF24111 33520114/10/114/15/1113BM2415 33620115/25/116/3/1115WM2318 33720106/15/107/12/1015BF23127 338201110/13/1112/13/1113BM46160 33920118/25/118/29/1117BM4614 340201110/14/1110/21/1117BM4617 34120117/28/118/23/1113BM46125 342201112/3/101/12/1117BM46139 34320112/26/113/1/1116WF4615 34420112/27/113/1/1114BF4614 34520114/11/114/15/1114BF4614 34620113/19/114/13/1116BM46124 34720117/14/117/25/1115WM46111 34820119/13/119/27/1115WM46114 34920116/16/116/29/1115WM46113 350201112/5/1112/13/1116BF4618 35120116/8/116/9/1116BF4611 35220116/10/117/21/1116BF46141 35320113/17/113/27/1116BM46110 35420111/18/112/3/1116BM46115 35520111/24/112/21/1115BM46127 356201111/2/1111/7/1117BM4615 357201112/21/102/1/1115WM46140 35820117/28/118/23/1116BM46125 35920118/25/119/13/1114BM46118 360201111/12/1111/15/1113BF4613 361201112/10/101/5/1116BM46125 362201110/13/1110/16/1116BM4613 36320111/28/112/1/1115BM4613 36420112/22/113/14/1115BM46122 36520111/7/111/11/1115BM4614 36620115/5/115/9/1117BM4614 36720115/5/115/9/1117WF4614 368201110/29/1111/4/1116BM4615 36920116/9/116/13/1115BM4614 37020113/17/113/18/1115BM4611 37120109/28/1010/21/1016BM46123 372201012/3/101/12/1117BM46139 37320101/5/101/25/1016BM46120 37420106/29/107/1/1016BM4612 37520108/24/108/31/1016WF4617 37620109/7/109/30/1016BF46123 37720109/9/109/13/1014WM4614 37820104/14/104/21/1017BM4617 37920102/2/102/15/1016BM46113 38020103/9/103/24/1016BM46115 38120105/26/105/27/1016BM4611 38220109/21/109/27/1015BM4616 38320101/5/101/12/1016BM4617 38420104/26/105/11/1015BM46115 385201012/8/1012/21/1016BM46113 386201010/6/1010/18/1015BM46112 38720108/19/109/8/1015BM46119 38820104/20/104/29/1015WM4619 389201012/2/1012/8/1015WM4616 39020109/7/109/29/1015WM46122 391201012/21/102/1/1115WM46140 39220108/19/108/23/1015BM4614 39320107/15/107/21/1015BM4616 394201010/21/1010/26/1013BM4615 39520107/29/107/31/1014WM4612 396201010/28/1011/3/1014WM4615 39720102/10/102/23/1016BM46113 39820102/2/102/2/1016BM4610 399201011/9/1011/14/1016BM4615 400201012/10/101/5/1116BM46125 401201010/14/1011/9/1015BM46125 402201012/2/091/25/1016BM46153 40320101/8/101/12/1016BM4614 40420104/15/105/7/1011BM46122 40520101/12/102/15/1011BM46133 40620107/1/107/9/1015BM4618 40720107/29/108/25/1016BM46126 40820107/1/107/6/1016BM4615 40920109/14/1010/7/1016BM46123 41020105/25/106/1/1017WF4616 41120106/3/107/7/1016BM46134 41220105/11/106/16/1015WM46135 41320107/27/108/11/1015WM46114 41420108/12/109/16/1016BM46134 415201011/22/1012/2/1017BM46110 41620115/16/117/20/1113BM46164 41720114/14/114/19/1116WF4615 41820113/15/115/3/1116BF46148 41920115/5/116/14/1115BM46139 420201111/22/1112/5/1116BM46113 42120112/16/113/24/1115BM46138 42220115/26/116/3/1115WF4617 42320111/26/112/10/1115WF46114 42420114/14/116/22/1116BM46168 425201112/14/1112/22/1113BM4618 42620113/29/114/12/1115BM46113 42720117/1/117/5/1115WM4614 42820114/18/115/2/1116BF46114 429201110/12/1110/18/1113BM4616 430201112/29/111/9/1216WM46110 43120114/27/116/28/1116BM46161 43220115/20/115/25/1116WM4615 43320114/26/114/28/1117WM4612 434201111/10/1111/13/1115BM4613 43520117/22/117/29/1117WM4617 43620117/20/1111/1/1115BM461101 43720116/25/116/28/1114BM4613 43820117/10/118/3/1114BM46123 439201112/6/111/3/1216BM46127 44020118/11/118/16/1116BM4615 44120105/10/105/24/1016BM46114 442201011/30/092/2/1016WM46162 443201010/25/1010/26/1016BM4611 444201010/25/1011/30/1016BF46135 44520103/25/105/4/1015BM46139 44620109/17/109/21/1014BM4614 447201011/29/1012/21/1015BM46122 44820102/4/102/22/1015WF46118