Answer only part C & D complete to get 100% feedback!! Otherwise stay away. Table is only given for reference to solve part C & D.

N Mean Standard Dev SE(Mean) Median Variable Ratechange BMI (c) Use the results in the Parameter Estimate table conduct a t-test to test if the BMI is a significant predictor for ratechnage. Hint: set up HO and H1 first, and use the p-value for testing Slope to test if the slope is significantly different from 0.] (d) What is the R-square value and explain this R-square value. AEPL 92 60 75 100 75 85 RateChange 104 12 77 17 121 46 130 30 100 25 106 21 89 41 107 21 80 8 72 48 86 72 87 121 34 73 91 18 71 101 30 1 User_type Gender Height Weight BMI BEPL 2 student male 67 135 21.14 3 student male 73 190 25.06 4 student female 65 108 17.97 5 student female 70 150 21.52 6 student male 200 27.12 7 student male 71 178 24.82 8 student female 60 105 20.5 9 student female 66 135 21.79 10 student male 69 150 22.15 11 student male 69 160 23.63 12 student male 67 135 21.14 13 student male 78 164 18.95 14 student female 60 170 33.2 15 student female 65 130 21.63 16 student male 69 155 22.89 17 student male 72 165 22.38 18 student male 68 140 21.28 19 student male 75 171 21.37 20 student female 70 230 33 21 student female 67 143 22.39 22 student male 68 180 27.37 23 student female 65 130 21.63 24 student male 72 280 37.97 25 student female 65 130 21.63 26 student female 66 148 23.89 70 99 29 76 89 13 68 85 17 56 79 23 95 120 25 82 113 31 70 110 40 103 151 48 58 103 45 75 96 21 100 130 30 91 120 29 78 108 30 at 15 72 178 24.14 75 88 13 22 63 138 24.44 62 84 65 150 24.96 95 125 30 63 112 19.84 83 110 27 8 65 135 22.46 77 85 25.46 68 86 18 73 72 193 195 26.44 55 80 25 71 230 32.07 84 113 29 60 138 26.95 84 107 23 66 130 80 109 29 72 175 20.98 23.73 25 82 110 28 75 200 54 75 21 27 student male 28 student female 29 student female 30 student female 31 student female 32 student male 33 student male 34 student male 35 student female 36 student female 37 student male 38 student male 39 student female 40 student female 41 student male 42 student male 43 student female 44 student female 45 student female 46 student female 47 student male 48 student female 49 student female 50 student male 51 student female 63 145 25.68 90 29 70 165 95 18 61 77 77 94 67 23.67 22.71 33.96 145 90 13 69 230 130 36 55 62 14.41 80 110 30 65 120 19.97 70 107 37 69 165 24.36 60 82 22 67 120 18.79 83 114 31 71 165 23.01 97 27 70 108 70 265 38.02 127 19 67 150 23.49 72 109 37 72 148 20.07 80 113 33 64 145 24.89 75 94 19 D E F G H C 70.5 134 18.95 78 92 14 67 175 27.41 84 124 40 75 175 21.87 80 105 25 71 185 25.8 61 88 27 57 94 20.34 108 132 24 51 115.2 87 105 18 21.76 25.77 190 88 102 14 72 64 175 30.04 60 98 38 67 165 25.84 80 110 30 69 200 29.53 45 60 15 63 170 30.11 72 102 30 70 155 81 112 31 A B 52 student female 53 student female 54 student male 55 student male 56 student female 57 student female 58 student male 59 student female 60 student male 61 student male 62 student female 63 student male 64 student male 65 student female 66 student female 67 student female 68 student male 69 student male 70 student male 71 student male 72 student male 73 student female 74 student female 75 student female 76 student male 67 150 22.24 23.49 34.45 80 112 32 67 220 78 112 34 64 125 21.45 76 115 39 65.5 111 18.19 75 117 74 180 23.11 80 102 42 22 30 75 200 25 38 68 70 190 27.26 59 85 26 74 186 23.88 74 86 13 72 150 92 115 23 20.34 20.98 66 130 70 95 25 70 140 20.09 87 120 33 67 125 72 120 48 19.58 25.09 72 185 80 101 21 B C D E TI G H 70 165 23.67 70 97 27 61 127 56 95 39 23.99 23.67 70 165 60 83 23 72 130 17.63 78 115 37 70 170 24.39 76 92 16 72 190 25.77 83 12 95 90 64 145 24.89 65 25 73 195 25.72 108 121 13 68 165 25.09 68 103 35 71 215 29.98 66 102 36 53 65 16.27 114 150 36 68 140 21.28 80 117 37 77 student male 78 student female 79 student male 80 student female 81 student male 82 student male 83 student male 84 student male 85 student male 86 student male 87 student male 88 student female 89 student male 90 student male 91 student male 92 student female 93 student male 94 student male 95 student female 96 student male 97 student male 98 student male 99 student female 100 student female 101 student male 69 145 21.41 77 106 86 220 20.91 69 97 29 28 51 70 250 35.87 66 117 70 220 91 135 44 73 154 31.56 20.32 24.39 126 40 86 77 70 170 106 29 65.5 119 19.5 77 108 31 71 165 67 110 43 23.01 22.04 68 145 70 18 88 96 69 170 25.1 72 24 65 150 24.96 70 86 16 69.6 145 21.04 100 120 20 69 175 25.84 85 110 25 64 142 24.37 87 12 99 126 69 225 88 38 33.22 28.45 54 118 75 115 40 72 190 25.77 81 96 15 60 104 20.31 71 102 31 102 student female 103 student male 104 student female 105 student male 106 student female 107 student male 108 student female 109 student female 110 student female 111 student male 63 142 25.15 61 87 26 65 114 18.97 65 85 20 67 150 23.49 67 80 13 62 145 26.52 75 106 31 72 160 21.7 79 95 16 No Do Info inain N Mean Standard Dev SE(Mean) Median Variable Ratechange BMI (c) Use the results in the Parameter Estimate table conduct a t-test to test if the BMI is a significant predictor for ratechnage. Hint: set up HO and H1 first, and use the p-value for testing Slope to test if the slope is significantly different from 0.] (d) What is the R-square value and explain this R-square value. AEPL 92 60 75 100 75 85 RateChange 104 12 77 17 121 46 130 30 100 25 106 21 89 41 107 21 80 8 72 48 86 72 87 121 34 73 91 18 71 101 30 1 User_type Gender Height Weight BMI BEPL 2 student male 67 135 21.14 3 student male 73 190 25.06 4 student female 65 108 17.97 5 student female 70 150 21.52 6 student male 200 27.12 7 student male 71 178 24.82 8 student female 60 105 20.5 9 student female 66 135 21.79 10 student male 69 150 22.15 11 student male 69 160 23.63 12 student male 67 135 21.14 13 student male 78 164 18.95 14 student female 60 170 33.2 15 student female 65 130 21.63 16 student male 69 155 22.89 17 student male 72 165 22.38 18 student male 68 140 21.28 19 student male 75 171 21.37 20 student female 70 230 33 21 student female 67 143 22.39 22 student male 68 180 27.37 23 student female 65 130 21.63 24 student male 72 280 37.97 25 student female 65 130 21.63 26 student female 66 148 23.89 70 99 29 76 89 13 68 85 17 56 79 23 95 120 25 82 113 31 70 110 40 103 151 48 58 103 45 75 96 21 100 130 30 91 120 29 78 108 30 at 15 72 178 24.14 75 88 13 22 63 138 24.44 62 84 65 150 24.96 95 125 30 63 112 19.84 83 110 27 8 65 135 22.46 77 85 25.46 68 86 18 73 72 193 195 26.44 55 80 25 71 230 32.07 84 113 29 60 138 26.95 84 107 23 66 130 80 109 29 72 175 20.98 23.73 25 82 110 28 75 200 54 75 21 27 student male 28 student female 29 student female 30 student female 31 student female 32 student male 33 student male 34 student male 35 student female 36 student female 37 student male 38 student male 39 student female 40 student female 41 student male 42 student male 43 student female 44 student female 45 student female 46 student female 47 student male 48 student female 49 student female 50 student male 51 student female 63 145 25.68 90 29 70 165 95 18 61 77 77 94 67 23.67 22.71 33.96 145 90 13 69 230 130 36 55 62 14.41 80 110 30 65 120 19.97 70 107 37 69 165 24.36 60 82 22 67 120 18.79 83 114 31 71 165 23.01 97 27 70 108 70 265 38.02 127 19 67 150 23.49 72 109 37 72 148 20.07 80 113 33 64 145 24.89 75 94 19 D E F G H C 70.5 134 18.95 78 92 14 67 175 27.41 84 124 40 75 175 21.87 80 105 25 71 185 25.8 61 88 27 57 94 20.34 108 132 24 51 115.2 87 105 18 21.76 25.77 190 88 102 14 72 64 175 30.04 60 98 38 67 165 25.84 80 110 30 69 200 29.53 45 60 15 63 170 30.11 72 102 30 70 155 81 112 31 A B 52 student female 53 student female 54 student male 55 student male 56 student female 57 student female 58 student male 59 student female 60 student male 61 student male 62 student female 63 student male 64 student male 65 student female 66 student female 67 student female 68 student male 69 student male 70 student male 71 student male 72 student male 73 student female 74 student female 75 student female 76 student male 67 150 22.24 23.49 34.45 80 112 32 67 220 78 112 34 64 125 21.45 76 115 39 65.5 111 18.19 75 117 74 180 23.11 80 102 42 22 30 75 200 25 38 68 70 190 27.26 59 85 26 74 186 23.88 74 86 13 72 150 92 115 23 20.34 20.98 66 130 70 95 25 70 140 20.09 87 120 33 67 125 72 120 48 19.58 25.09 72 185 80 101 21 B C D E TI G H 70 165 23.67 70 97 27 61 127 56 95 39 23.99 23.67 70 165 60 83 23 72 130 17.63 78 115 37 70 170 24.39 76 92 16 72 190 25.77 83 12 95 90 64 145 24.89 65 25 73 195 25.72 108 121 13 68 165 25.09 68 103 35 71 215 29.98 66 102 36 53 65 16.27 114 150 36 68 140 21.28 80 117 37 77 student male 78 student female 79 student male 80 student female 81 student male 82 student male 83 student male 84 student male 85 student male 86 student male 87 student male 88 student female 89 student male 90 student male 91 student male 92 student female 93 student male 94 student male 95 student female 96 student male 97 student male 98 student male 99 student female 100 student female 101 student male 69 145 21.41 77 106 86 220 20.91 69 97 29 28 51 70 250 35.87 66 117 70 220 91 135 44 73 154 31.56 20.32 24.39 126 40 86 77 70 170 106 29 65.5 119 19.5 77 108 31 71 165 67 110 43 23.01 22.04 68 145 70 18 88 96 69 170 25.1 72 24 65 150 24.96 70 86 16 69.6 145 21.04 100 120 20 69 175 25.84 85 110 25 64 142 24.37 87 12 99 126 69 225 88 38 33.22 28.45 54 118 75 115 40 72 190 25.77 81 96 15 60 104 20.31 71 102 31 102 student female 103 student male 104 student female 105 student male 106 student female 107 student male 108 student female 109 student female 110 student female 111 student male 63 142 25.15 61 87 26 65 114 18.97 65 85 20 67 150 23.49 67 80 13 62 145 26.52 75 106 31 72 160 21.7 79 95 16 No Do Info inain