Solve question no7 based on q6

Question 6 (10 points) The accompanying data show spot speeds collected at a section of highway located in a residential area. Using the student's t test, determine whether there was a statistically significant difference in the average speeds at the 95% confidence level. Before 40 35 38 37 33 30 28 35 35 40 33 35 36 36 40 38 35 30 30 38 39 35 36 34 33 31 36 35 33 39 After 23 33 25 36 37 34 23 28 24 31 24 20 21 28 35 25 21 35 30 33 21 28 23 24 27 20 20 30 32 33 Using the data in Problem 6 for both before and after, determine (a) average speed (b) mode, (c) median speed, (d) draw the histogram frequency distribution (b) draw cumulative frequency curve (GIVE) and use it to determine (i) 85th-percentile speed (ii) 15th-percentile speed Time EBL EBT EBR WBL WBT WBR NBL NBT NBR SBL SBT SBR 0:00 6 24 5 10 32 13 15 5 16 12 7 7 0:15 8 30 6 5 16 7 8 3 8 15 8 4 0:30 5 18 3 6 19 8 9 3 10 9 5 4 0:45 2 7 1 4 13 5 6 2 6 4 2 3 1:00 1 3 1 1 5 2 2. 1 2 1 1 1 1:15 3 11 2 2 8 3 4 1 4 5 3 2 1:30 2 6 1 3 9 4 41 2 5 3 2 2 1:45 2 6 1 2 7 3 3 1 4 3 2 2 2:00 2 7 1 4 13 51 6 2 6 4 2 3 2:15 1 5 1 4 12 5 6 2 6 3 2 3 2:30 2 7 1 3 11 4 5 2 6 4 2 3 2:45 2 8 2 5 16 6 7 3 8 4 2 4 3:00 3 13 2 5 16 7 8. 3 8 6 4 4 1 5 1 4 13 5 6 2 6 2 1 3 3:15 3:30 2 8 2 4 61 7 2 7 4 2 15 10 3 2 3:45 3 13 2 3 4 5 2 5 6 4 3 2 2 7 3 3 1 4 3 2 4:00 4:15 11 28 5 14 7 5 7 22 9 10 4 11 8 5 4:30 7 26 5 7 10 11 4 12 13 7 6 25 27 4:45 11 44 8 8 11 13 5 14 22 12 6 5:00 11 44 8 10 32 13 15 5 16 12 7 22 19 5:15 10 38 7 12 40 16 19 7 20 11 9 5:30 12 9 19 62 25 29 11 31 23 13 14 47 58 5:45 15 11 23 76 30 35 13 38 29 16 17 6:00 21 82 16 30 99 39 46 17 50 41 23 23 6:15 19 27 89 36 42 45 49 28 21 25 99 27 107 15 16 20 95 38 44 48 30 22 6:30 6:45 28 35 301 1201 23 118 47 55 20 60 53 59 57 34 27 7:00 29 115 22 33 43 50 18 55 32 25 7:15 27 39 109 130 130 52 60 22 54 59 40 30 36 144 45 182 39 156 7:30 35 39 52 61 22 61 51 30 50 40 7:45 30 44 145 58 67 25 64 44 33 8:00 24 34 113 45 19 57 44 36 26 32 129 31 123 53 50 8:15 23 32 108 43 18 55 61 34 25 8:30 24 32 106 42 49 18 54 61 35 24 31 124 26 102 8:45 19 31 102 41 48 17 52 50 29 23 9:00 36 143 27 27 91 37 42 16 46 71 40 21 9:15 27 1071 20 40 133 53 62 23 68 53 30 31 9:30 32 127 24 32 108 43 50 18 55 63 35 25 28 112 21 38 128 51 59 22 65 55 31 29 9:45 10:00 33 132 25 36 120 48 56 20 61 65 37 27 10:15 31 122 23 24 79 32 37 13 49 50 28 15 10:30 30 119 23 29 98 39 45 17 60 48 27 18 10:45 32 127 24 27 90 36 42 15 56 51 29 17 11:00 29 118 22 37 122 49 57 21 75 48 27 23 11:15 31 125 24 27 92 37 43 16 56 51 29 171 11:30 34 135 26 30 101 41 47 17 62 55 31 191 11:45 31 122 23 30 100 40 46 17 62 50 28 19 12:00 36 143 27 32 105 42 49 18 65 58 33 20 12:15 36 144 27 28 94 38 44 16 58 58 33 18 12:30 36 145 28 25 84 34 39 14 52 59 33 16 12:45 28 112 21 32 106 42 49 18 65 46 26 20 13:00 30 120 23 31 104 41 48 18 64 49 28 20 13:15 29 118 22 27 89 35 41 15 55 48 27 17 13:30 27 107 20 30 99 40 46 17 61 43 25 19 13:45 29 114 22 36 119 48 55 20 74 46 26 22 14:00 28 113 21 41 136 54 63 23 65 46 26 26 14:15 32 128 24 41 136 54 63 23 64 52 29 26 14:30 33 132 25 40 134 39 62 23 55 54 30 25 14:45 39 155 29 37 122 36 57 21 61 48 36 23 15:00 36 143 27 45 149 49 69 25 74 43 33 28 15:15 40 162 31 37 125 37 58 21 65 46 37 23 15:30 46 128 35 44 146 41 68 25 64 46 42 28 15:45 50 132 38 38 127 40 59 22 55 52 46 24 16:00 47 155 35 43 143 42 66 24 61 46 43 27 16:15 49 143 37 46 154 38 71 26 74 49 45 29 16:30 47 146 36 44 147 40 68 25 52 48 44 28 16:45 41 149 31 45 152 38 70 26 49 39 38 29 17:00 43 150 33 39 130 46 60 22 55 43 39 24 17:15 42 155 32 43 156 44 73 31 58 36 39 34 17:30 40 149 31 40 158 40 64 28 50 40 37 31 17:45 50 161 38 44 147 46 56 25 59 44 45 28 18:00 39 155 29 41 137 55 63 23 37 63 36 26 18:00 39 155 29 41 137 55 63 23 37 63 36 26 18:15 34 135 26 42 139 56 65 24 33 55 31 26 18:30 34 135 26 32 106 42 49 18 37 55 31 20 18:45 31 122 23 30 99 40 46 17 31 50 28 19 19:00 31 125 24 36 119 48 55 20 35 51 29 22 19:15 27 108 20 35 116 47 54 20 25 44 25 22 19:30 25 101 19 28 93 37 43 16 19 41 23 18 19:45 19 78 15 23 76 30 35 13 47 31 18 14 20:00 26 103 20 19 65 26 30 11 40 42 24 12 20:15 21 82 16 21 71 28 33 12 43 33 19 13 20:30 17 68 13 18 59 24 28 10 37 28 16 11 20:45 17 67 13 16 53 21 25 9 33 27 15 10 21:00 17 67 13 18 59 24 28 10 37 27 15 11 21:15 18 70 13 15. 51 20 24 | 31 28 16 10 21:30 14 55 10 17 57 23 27 10 35 22 13 11 21:45 9 37 7 15 50 20 23 8 31 15 9 9 | 22:00 15 60 11 16 55 22 25 9 34 24 14 10 22:15 8 33 6 14 45 18 21 8 8 28 13 8 8 22:30 11 46. 9 12 41 16 19 7 25 18 10 8 22:45 8 31 6 9 32 13 15 5 19 13 7 6 23:00 8 34 6 13 44 17 20 71 27 14 8 8 23:15 11 45 8 71 24 10 11 4 15 18 10 5 23:30 6. 24 5 5 10 33 13 15 6 20 10 5 ON 23:45 6 26 5 9 31 12 14 5 19 101 6 6 Question 6 (10 points) The accompanying data show spot speeds collected at a section of highway located in a residential area. Using the student's t test, determine whether there was a statistically significant difference in the average speeds at the 95% confidence level. Before 40 35 38 37 33 30 28 35 35 40 33 35 36 36 40 38 35 30 30 38 39 35 36 34 33 31 36 35 33 39 After 23 33 25 36 37 34 23 28 24 31 24 20 21 28 35 25 21 35 30 33 21 28 23 24 27 20 20 30 32 33 Using the data in Problem 6 for both before and after, determine (a) average speed (b) mode, (c) median speed, (d) draw the histogram frequency distribution (b) draw cumulative frequency curve (GIVE) and use it to determine (i) 85th-percentile speed (ii) 15th-percentile speed Time EBL EBT EBR WBL WBT WBR NBL NBT NBR SBL SBT SBR 0:00 6 24 5 10 32 13 15 5 16 12 7 7 0:15 8 30 6 5 16 7 8 3 8 15 8 4 0:30 5 18 3 6 19 8 9 3 10 9 5 4 0:45 2 7 1 4 13 5 6 2 6 4 2 3 1:00 1 3 1 1 5 2 2. 1 2 1 1 1 1:15 3 11 2 2 8 3 4 1 4 5 3 2 1:30 2 6 1 3 9 4 41 2 5 3 2 2 1:45 2 6 1 2 7 3 3 1 4 3 2 2 2:00 2 7 1 4 13 51 6 2 6 4 2 3 2:15 1 5 1 4 12 5 6 2 6 3 2 3 2:30 2 7 1 3 11 4 5 2 6 4 2 3 2:45 2 8 2 5 16 6 7 3 8 4 2 4 3:00 3 13 2 5 16 7 8. 3 8 6 4 4 1 5 1 4 13 5 6 2 6 2 1 3 3:15 3:30 2 8 2 4 61 7 2 7 4 2 15 10 3 2 3:45 3 13 2 3 4 5 2 5 6 4 3 2 2 7 3 3 1 4 3 2 4:00 4:15 11 28 5 14 7 5 7 22 9 10 4 11 8 5 4:30 7 26 5 7 10 11 4 12 13 7 6 25 27 4:45 11 44 8 8 11 13 5 14 22 12 6 5:00 11 44 8 10 32 13 15 5 16 12 7 22 19 5:15 10 38 7 12 40 16 19 7 20 11 9 5:30 12 9 19 62 25 29 11 31 23 13 14 47 58 5:45 15 11 23 76 30 35 13 38 29 16 17 6:00 21 82 16 30 99 39 46 17 50 41 23 23 6:15 19 27 89 36 42 45 49 28 21 25 99 27 107 15 16 20 95 38 44 48 30 22 6:30 6:45 28 35 301 1201 23 118 47 55 20 60 53 59 57 34 27 7:00 29 115 22 33 43 50 18 55 32 25 7:15 27 39 109 130 130 52 60 22 54 59 40 30 36 144 45 182 39 156 7:30 35 39 52 61 22 61 51 30 50 40 7:45 30 44 145 58 67 25 64 44 33 8:00 24 34 113 45 19 57 44 36 26 32 129 31 123 53 50 8:15 23 32 108 43 18 55 61 34 25 8:30 24 32 106 42 49 18 54 61 35 24 31 124 26 102 8:45 19 31 102 41 48 17 52 50 29 23 9:00 36 143 27 27 91 37 42 16 46 71 40 21 9:15 27 1071 20 40 133 53 62 23 68 53 30 31 9:30 32 127 24 32 108 43 50 18 55 63 35 25 28 112 21 38 128 51 59 22 65 55 31 29 9:45 10:00 33 132 25 36 120 48 56 20 61 65 37 27 10:15 31 122 23 24 79 32 37 13 49 50 28 15 10:30 30 119 23 29 98 39 45 17 60 48 27 18 10:45 32 127 24 27 90 36 42 15 56 51 29 17 11:00 29 118 22 37 122 49 57 21 75 48 27 23 11:15 31 125 24 27 92 37 43 16 56 51 29 171 11:30 34 135 26 30 101 41 47 17 62 55 31 191 11:45 31 122 23 30 100 40 46 17 62 50 28 19 12:00 36 143 27 32 105 42 49 18 65 58 33 20 12:15 36 144 27 28 94 38 44 16 58 58 33 18 12:30 36 145 28 25 84 34 39 14 52 59 33 16 12:45 28 112 21 32 106 42 49 18 65 46 26 20 13:00 30 120 23 31 104 41 48 18 64 49 28 20 13:15 29 118 22 27 89 35 41 15 55 48 27 17 13:30 27 107 20 30 99 40 46 17 61 43 25 19 13:45 29 114 22 36 119 48 55 20 74 46 26 22 14:00 28 113 21 41 136 54 63 23 65 46 26 26 14:15 32 128 24 41 136 54 63 23 64 52 29 26 14:30 33 132 25 40 134 39 62 23 55 54 30 25 14:45 39 155 29 37 122 36 57 21 61 48 36 23 15:00 36 143 27 45 149 49 69 25 74 43 33 28 15:15 40 162 31 37 125 37 58 21 65 46 37 23 15:30 46 128 35 44 146 41 68 25 64 46 42 28 15:45 50 132 38 38 127 40 59 22 55 52 46 24 16:00 47 155 35 43 143 42 66 24 61 46 43 27 16:15 49 143 37 46 154 38 71 26 74 49 45 29 16:30 47 146 36 44 147 40 68 25 52 48 44 28 16:45 41 149 31 45 152 38 70 26 49 39 38 29 17:00 43 150 33 39 130 46 60 22 55 43 39 24 17:15 42 155 32 43 156 44 73 31 58 36 39 34 17:30 40 149 31 40 158 40 64 28 50 40 37 31 17:45 50 161 38 44 147 46 56 25 59 44 45 28 18:00 39 155 29 41 137 55 63 23 37 63 36 26 18:00 39 155 29 41 137 55 63 23 37 63 36 26 18:15 34 135 26 42 139 56 65 24 33 55 31 26 18:30 34 135 26 32 106 42 49 18 37 55 31 20 18:45 31 122 23 30 99 40 46 17 31 50 28 19 19:00 31 125 24 36 119 48 55 20 35 51 29 22 19:15 27 108 20 35 116 47 54 20 25 44 25 22 19:30 25 101 19 28 93 37 43 16 19 41 23 18 19:45 19 78 15 23 76 30 35 13 47 31 18 14 20:00 26 103 20 19 65 26 30 11 40 42 24 12 20:15 21 82 16 21 71 28 33 12 43 33 19 13 20:30 17 68 13 18 59 24 28 10 37 28 16 11 20:45 17 67 13 16 53 21 25 9 33 27 15 10 21:00 17 67 13 18 59 24 28 10 37 27 15 11 21:15 18 70 13 15. 51 20 24 | 31 28 16 10 21:30 14 55 10 17 57 23 27 10 35 22 13 11 21:45 9 37 7 15 50 20 23 8 31 15 9 9 | 22:00 15 60 11 16 55 22 25 9 34 24 14 10 22:15 8 33 6 14 45 18 21 8 8 28 13 8 8 22:30 11 46. 9 12 41 16 19 7 25 18 10 8 22:45 8 31 6 9 32 13 15 5 19 13 7 6 23:00 8 34 6 13 44 17 20 71 27 14 8 8 23:15 11 45 8 71 24 10 11 4 15 18 10 5 23:30 6. 24 5 5 10 33 13 15 6 20 10 5 ON 23:45 6 26 5 9 31 12 14 5 19 101 6 6