need help in this

The data in worksheet 2 of the Excel file represents the weights of 50 students before the Covid-19 pandemic began and their weight six months afterwards. You would like to determine whether there has been a significant increase in students' average weights over the six month period. Analyze the data at the 0.05 level of significance (alpha) and provide the observed test statistic. Round final answers to two decimal places and include a negative sign if appropriate (e.g.,- 1.11). A positive sign does not need to be included. Answer:Home Insert Draw Page Layout Formulas Data Review View 9 Tell me a Share 9 Comments )4. EEpv ab 5 3 W? \" ZvA /O ; [on v [El v ' Callb" (50W) /' cg Wrap Text General ' v v v 16% v i)? v EH3 v 1 v Z? V v Paste o (-.D .00 Conditional Format Cell Insert Delete Format Sort& Finds. Ideas 6 B I Q v H Merge&Centerv $ v A '00 '20 Formatting asTable Styles 0 V Filter Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes N0 M8 :I c ' A a c D E F a H | J K L M o P q R s T u v w x v z 1 1 union 2 Student weight (to nearest pound) 2 and-m Mm Before 3 1 150 150 4 2 169 122 5 3 177 93 6 4 115 124 7 5 219 113 s 6 113 170 I 9 7 216 190 10 3 144 200 11 9 140 140 11 10 113 14s 13 11 170 155 14 12 153 100 15 13 113 211 15 14 149 134 17 15 169 123 13 16 212 212 19 17 173 247 20 13 147 157 21 19 155 159 21 20 191 141 23 21 194 131 24 21 153 217 25 23 234 200 26 24 216 139 27 25 154 132 23 26 213 229 29 27 236 120 30 23 103 243 31 29 196 99 32 30 112 158 33 31 104 156 34 32 133 117 35 33 105 239 36 34 161 91 37 35 149 149 33 36 153 245 39 37 239 236 40 33 150 14s 41 39 103 119 42 440,961, 131 , , , , , , , , , , , , , , , ,, , , , , 4 p Question 1 Question 2 + E _J+ 100% Home Insert Draw Page Layout Formulas Data Review View 9 Tell me a Share 9 Comments )4. zEpv ab 3 3 W? \" ZvA /O ; [on v [El v ' Callb" (50W) /' cg Wrap Text General ' v v v 16% v i)? v EH3 v 3 v Z? V v Paste o (-D on Conditional Format Cell Insert Delete Format Sort& Finds. Ideas 6 B I Q v H Merge&Centerv $ v A , 0 9" Formatting asTable Styles 0" Filter Select Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? Yes No [ M8 :l )9: v A B c 0 E r G H | J K L M N o P Q R 5 T u v w x v 2 20 1a 147 157 11 19 155 153 22 20 131 141 13 21 134 131 14 12 153 117 25 23 234 100 16 14 116 189 27 15 154 132 23 26 213 223 13 17 136 110 30 23 103 243 31 23 136 93 31 30 212 15a 33 31 204 156 34 32 133 117 _ Sum _ 35 33 105 133 36 34 161 91 37 35 149 143 33 35 153 145 33 37 233 236 40 3a 150 14a 41 33 203 113 41 40 169 182 43 41 110 133 44 42 136 157 45 43 104 240 46 44 203 168 47 45 177 180 4a 46 137 14a 43 47 131 126 50 4a 103 166 51 4s 31 151 52 50 133 123 53 54 55 56 57 53 53 60 :1 7 , , , , , , , , 4 p Question 1 Question 2 + _J + 100%