Answer all five parts complete to get 100% feedback!! Otherwise stay away.

yes i know but i cant attach excel file here. pls solve.

i try to put excel file but i can not.

[NOTE: From (a), we know this is an INDEPENDENT sample problem. ] Let's use uz for the population average of Female BMI, and uz as the population average of Male BMI. (1) Set H: Hj: (2) For independent sample tests, we will use t-test using computer software, regardless sample size. Is this a right-side, two-side or left side test: (3) Use StatCrunch to perform the hypothesis test to test if the average BMI for Female is significantly different from the average BMI for Male using a = 1%. [On Statcrunch, go to Stat. T Stats. Two sample. With Data, enter Sample 1, Sample 2. Check Calculation options Pool Variance. Check Hypothesis test for Mi Hz?, Enter Ho value in this case, it is 0, choose the type of test (Two-side, rght or left side test), Compute.] Copy and paste output here. (4) Use this output to make your decision (NOTE: Use p-value): (5) Interpret the result using the problem context: Histogram of BMI 15 20 35 40 25 30 male female 25 20 15 Frequency 10 5 15 20 25 30 35 40 BMI Pane variable: Gender H --- J G AEPL 69 75 104 77 92 60 75 100 75 85 70 48 121 130 100 106 78 89 86 97 60 67 68 78 A B D E F 1 User_type Gender Height Weight BMI BEPL 2 student male 73 195 25.72 3 student male 67 135 21.14 4 student male 73 190 25.06 5 student female 65 108 17.97 6 student female 70 150 21.52 7 student male 72 200 27.12 8 student male 71 178 24.82 9 student male 67 210 32.89 10 student female 60 105 20.5 11 student female 66 135 21.79 12 student female 67 135 21.14 13 student male 69 150 22.15 14 student male 69 160 23.63 15 student male 67 135 21.14 16 student male 78 164 18.95 17 student female 60 170 33.2 18 student female 65 130 21.63 19 student male 69 155 22.89 20 student male 66 138 22.27 21 student male 72 165 22.38 22 student male 68 140 21.28 23 student male 75 171 21.37 24 student female 70 230 33 25 student female 67 143 22.39 26 student male 68 180 27.37 Act14 Inden Sample Fxercise(n=13 87 121 91 73 71 101 70 99 76 79 68 85 80 85 56 69 95 120 82 113 70 110 103 151 58 103 E F H 65 130 75 96 21.63 29.95 65 180 45 53 130 72 280 100 65 130 37.97 21.63 23.89 91 140 66 148 78 108 72 178 24.14 75 88 63 138 24.44 62 84 71 164 22.87 61 119 55 150 24.96 95 125 63 112 19.84 83 110 65 135 22.46 72 85 73 68 86 27 student female 28 student female 29 student male 30 student female 31 student female 32 student male 33 student female 34 student male 35 student female 36 student female 37 student female 38 student male 39 student male 40 student male 41 student female 42 student female 43 student female 44 student male 45 student male 46 student female 47 student female 48 student male 49 student male 50 student female 51 student female 193 195 25.46 26.44 72 55 80 71 230 32.07 84 93 50 95 18.55 87 94 60 138 84 107 26.95 20.98 66 130 80 109 72 175 23.73 82 110 75 200 25 54 75 63 145 25.68 61 90 70 165 23.67 77 95 67 145 22.71 77 90 69 230 33.96 94 130 55 62 14.41 60 120 65 120 19.97 70 107 69 165 24.36 60 72 67 120 83 114 18.79 23.01 165 70 97 71 70 265 108 127 38.02 23.49 67 150 62 109 72 148 20.07 80 113 64 145 75 94 70.5 134 24.89 18.95 27.41 78 92 67 175 84 124 75 175 80 105 185 61 88 71 57 94 21.87 25.8 20.34 30.81 108 52 student female 53 student female 54 student male 55 student female 56 student female 57 student male 58 student female 59 student female 60 student female 61 student male 62 student male 63 student female 64 student male 65 student female 66 student male 67 student female 68 student male 69 student male 70 student female 71 student male 72 student male 73 student female 74 student female 75 student female 76 student male 132 74 240 60 120 61 115.2 21.76 87 105 72 190 88 102 64 175 40 98 25.77 30.04 25.84 29.53 67 165 80 110 69 200 45 60 63 170 30.11 72 102 70 155 22.24 81 112 67 150 23.49 80 112 67 220 34.45 78 112 64 125 76 115 65.5 111 21.45 18.19 23.11 65 117 74 180 80 102 75 200 25 38 68 70 190 27.26 59 85 74 186 23.88 74 83 84 21.02 72 138 72 150 92 115 20.34 24.37 75 195 84 86 66 130 20.98 70 95 124 72 240 32.55 70 70 140 87 120 67 125 72 120 20.09 19.58 25.09 23.67 72 185 80 101 70 165 70 97 77 student male 78 student male 79 student male 80 student female 81 student male 82 student male 83 student female 84 student male 85 student female 86 student female 87 student male 88 student male 89 student female 90 student male 91 student male 92 student female 93 student male 94 student male 95 student female 96 student female 97 student male 98 student male 99 student male 100 student male 101 student male 61 127 23.99 95 46 76 72 165 22.38 85 70 165 23.67 60 83 72 130 17.63 58 115 75 315 85 145 70 170 39.37 24.39 20.98 76 92 66 130 63 59 65 19.47 81 150 72 117 190 145 25.77 83 95 64 24.89 65 90 73 195 25.72 108 121 68 165 25.09 68 103 71 215 29.98 66 102 " 53 65 16.27 114 150 68 140 80 117 69 145 21.28 21.41 20.91 77 106 86 220 69 97 70 250 35.87 66 117 70 220 31.56 135 91 72 51.5 52 13.78 144 73 154 20.32 86 126 106 70 170 24.39 77 77 65.5 119 19.5 108 71 165 23.01 67 110 68 145 22.04 70 88 102 student male 103 student female 104 student male 105 student male 106 student male 107 student female 108 student female 109 student male 110 student male 111 student female 112 student male 113 student male 114 student male 115 student female 116 student male 117 student female 118 student male 119 student female 120 student male 121 student female 122 student male 123 student female 124 student male 125 student female 126 student female 69 170 25.1 72 96 65 150 24.96 70 86 66 170 27.44 85 130 145 21.04 100 120 69.6 69 175 25.84 85 110 64 142 24.37 87 99 126 69 225 33.22 88 54 118 28.45 75 115 96 72 190 25.77 81 60 104 71 102 20.31 25.15 63 142 61 87 65 114 18.97 65 85 67 150 23.49 67 80 26.52 75 95 106 98 17.68 21.7 79 95 127 student female 62 145 128 student female 64 103 129 student male 72 160 130 student male 67 160 131 student female 67 135 KI Act14 IndepSample Fxercise(n=13 25.06 62 123 21.14 91 144 [NOTE: From (a), we know this is an INDEPENDENT sample problem. ] Let's use uz for the population average of Female BMI, and uz as the population average of Male BMI. (1) Set H: Hj: (2) For independent sample tests, we will use t-test using computer software, regardless sample size. Is this a right-side, two-side or left side test: (3) Use StatCrunch to perform the hypothesis test to test if the average BMI for Female is significantly different from the average BMI for Male using a = 1%. [On Statcrunch, go to Stat. T Stats. Two sample. With Data, enter Sample 1, Sample 2. Check Calculation options Pool Variance. Check Hypothesis test for Mi Hz?, Enter Ho value in this case, it is 0, choose the type of test (Two-side, rght or left side test), Compute.] Copy and paste output here. (4) Use this output to make your decision (NOTE: Use p-value): (5) Interpret the result using the problem context: Histogram of BMI 15 20 35 40 25 30 male female 25 20 15 Frequency 10 5 15 20 25 30 35 40 BMI Pane variable: Gender H --- J G AEPL 69 75 104 77 92 60 75 100 75 85 70 48 121 130 100 106 78 89 86 97 60 67 68 78 A B D E F 1 User_type Gender Height Weight BMI BEPL 2 student male 73 195 25.72 3 student male 67 135 21.14 4 student male 73 190 25.06 5 student female 65 108 17.97 6 student female 70 150 21.52 7 student male 72 200 27.12 8 student male 71 178 24.82 9 student male 67 210 32.89 10 student female 60 105 20.5 11 student female 66 135 21.79 12 student female 67 135 21.14 13 student male 69 150 22.15 14 student male 69 160 23.63 15 student male 67 135 21.14 16 student male 78 164 18.95 17 student female 60 170 33.2 18 student female 65 130 21.63 19 student male 69 155 22.89 20 student male 66 138 22.27 21 student male 72 165 22.38 22 student male 68 140 21.28 23 student male 75 171 21.37 24 student female 70 230 33 25 student female 67 143 22.39 26 student male 68 180 27.37 Act14 Inden Sample Fxercise(n=13 87 121 91 73 71 101 70 99 76 79 68 85 80 85 56 69 95 120 82 113 70 110 103 151 58 103 E F H 65 130 75 96 21.63 29.95 65 180 45 53 130 72 280 100 65 130 37.97 21.63 23.89 91 140 66 148 78 108 72 178 24.14 75 88 63 138 24.44 62 84 71 164 22.87 61 119 55 150 24.96 95 125 63 112 19.84 83 110 65 135 22.46 72 85 73 68 86 27 student female 28 student female 29 student male 30 student female 31 student female 32 student male 33 student female 34 student male 35 student female 36 student female 37 student female 38 student male 39 student male 40 student male 41 student female 42 student female 43 student female 44 student male 45 student male 46 student female 47 student female 48 student male 49 student male 50 student female 51 student female 193 195 25.46 26.44 72 55 80 71 230 32.07 84 93 50 95 18.55 87 94 60 138 84 107 26.95 20.98 66 130 80 109 72 175 23.73 82 110 75 200 25 54 75 63 145 25.68 61 90 70 165 23.67 77 95 67 145 22.71 77 90 69 230 33.96 94 130 55 62 14.41 60 120 65 120 19.97 70 107 69 165 24.36 60 72 67 120 83 114 18.79 23.01 165 70 97 71 70 265 108 127 38.02 23.49 67 150 62 109 72 148 20.07 80 113 64 145 75 94 70.5 134 24.89 18.95 27.41 78 92 67 175 84 124 75 175 80 105 185 61 88 71 57 94 21.87 25.8 20.34 30.81 108 52 student female 53 student female 54 student male 55 student female 56 student female 57 student male 58 student female 59 student female 60 student female 61 student male 62 student male 63 student female 64 student male 65 student female 66 student male 67 student female 68 student male 69 student male 70 student female 71 student male 72 student male 73 student female 74 student female 75 student female 76 student male 132 74 240 60 120 61 115.2 21.76 87 105 72 190 88 102 64 175 40 98 25.77 30.04 25.84 29.53 67 165 80 110 69 200 45 60 63 170 30.11 72 102 70 155 22.24 81 112 67 150 23.49 80 112 67 220 34.45 78 112 64 125 76 115 65.5 111 21.45 18.19 23.11 65 117 74 180 80 102 75 200 25 38 68 70 190 27.26 59 85 74 186 23.88 74 83 84 21.02 72 138 72 150 92 115 20.34 24.37 75 195 84 86 66 130 20.98 70 95 124 72 240 32.55 70 70 140 87 120 67 125 72 120 20.09 19.58 25.09 23.67 72 185 80 101 70 165 70 97 77 student male 78 student male 79 student male 80 student female 81 student male 82 student male 83 student female 84 student male 85 student female 86 student female 87 student male 88 student male 89 student female 90 student male 91 student male 92 student female 93 student male 94 student male 95 student female 96 student female 97 student male 98 student male 99 student male 100 student male 101 student male 61 127 23.99 95 46 76 72 165 22.38 85 70 165 23.67 60 83 72 130 17.63 58 115 75 315 85 145 70 170 39.37 24.39 20.98 76 92 66 130 63 59 65 19.47 81 150 72 117 190 145 25.77 83 95 64 24.89 65 90 73 195 25.72 108 121 68 165 25.09 68 103 71 215 29.98 66 102 " 53 65 16.27 114 150 68 140 80 117 69 145 21.28 21.41 20.91 77 106 86 220 69 97 70 250 35.87 66 117 70 220 31.56 135 91 72 51.5 52 13.78 144 73 154 20.32 86 126 106 70 170 24.39 77 77 65.5 119 19.5 108 71 165 23.01 67 110 68 145 22.04 70 88 102 student male 103 student female 104 student male 105 student male 106 student male 107 student female 108 student female 109 student male 110 student male 111 student female 112 student male 113 student male 114 student male 115 student female 116 student male 117 student female 118 student male 119 student female 120 student male 121 student female 122 student male 123 student female 124 student male 125 student female 126 student female 69 170 25.1 72 96 65 150 24.96 70 86 66 170 27.44 85 130 145 21.04 100 120 69.6 69 175 25.84 85 110 64 142 24.37 87 99 126 69 225 33.22 88 54 118 28.45 75 115 96 72 190 25.77 81 60 104 71 102 20.31 25.15 63 142 61 87 65 114 18.97 65 85 67 150 23.49 67 80 26.52 75 95 106 98 17.68 21.7 79 95 127 student female 62 145 128 student female 64 103 129 student male 72 160 130 student male 67 160 131 student female 67 135 KI Act14 IndepSample Fxercise(n=13 25.06 62 123 21.14 91 144