Perform the hypothesis test for each speculation in order to see if there is evidence to support the manager's belief. Use the Eight Steps of a Test of Hypothesis which are; establish a null and alternative hypothesis, determine the appropriate statistical test, set the value of alpha, the type 1 error rate, establish the decision rule, gather sample data, analyze the data, reach a statistical conclusion and make a business decision. You can use either the p-value or the critical values to draw conclusions. Be sure to explain your conclusion and interpret that to the claim in simple terms Compute 99% confidence intervals for the variables used in each hypothesis test, and interpret these intervals.

Please help me understand how to also do these type of problems in excel please

Sales (Y) - Calls (X1) - Time (X2) - 44 168 Years (X3) ~ Type 12.4 42 2 161 GROUP 45 13.2 GROUP 156 13.2 3 43 175 GROUP 13.6 5 43 GROUP 169 14.0 5 22 GROUP 170 14.3 4 42 154 GROUP 14.3 2 41 GROUP 152 4 10 48 14.5 162 14.5 GROUP 4 11 44 159 14.6 GROUP 40 2 GROUP 145 13 14.7 2 46 172 14.7 GROUP 14 3 26 150 2 GROUP 15 14.9 25 152 GROUP 15.0 3 16 39 150 17 15.3 GROUP 3 42 154 GROUP 15.3 18 35 GROUP 149 19 15.6 47 149 GROUP 20 15.8 50 GROUP 157 3 21 47 15.9 151 GROUP 16.6 2 22 44 192 GROUP 23 37 16.7 1 131 GROUP 16.9 2 24 41 164 17.8 GROUP 3 25 25 GROUP 155 17.9 1 GROUP 26 49 178 18.3 27 2 GROUP 67 166 18.9 28 1 49 GROUP 153 3 29 19.0 33 GROUP 139 19.3 3 30 44 3 GROUP 134 19.4 31 37 132 GROUP 3 32 10.0 36 131 NONE 33 11.7 3 39 NONE 140 0 34 12.4 25 130 NONE 35 12.8 2 37 142 13.9 7 NONE 36 39 NONE 160 4 37 14.3 49 131 NONE 38 14.6 1 25 143 NONE 15.4 39 1 50 144 NONE 2 40 50 15.8 148 NONE 0 41 16.0 22 NONE 139 16.9 4 42 42 NONE 140 17.5 3 43 67 155 17.9 NONE 1 44 37 NONE 159 45 18.1 0 36 NONE 131 18.5 0 46 38 NONE 135 47 18.5 3 22 145 19.0 NONE 2 48 35 131 21.6 NONE 49 43 NONE 160 50 10.9 44 168 ONLINE 11.0 5 ONLINE51 48 188 52 52 11.3 184 2 ONLINE 53 11.4 4 42 181 11.5 ONLINE 54 41 170 ONLINE 55 12.3 44 165 ONLINE 56 3 48 12.4 201 ONLINE 57 1 40 12.5 176 12.6 ONLINE 58 43 1 174 59 12.7 ONLINE 46 2 184 12.7 ONLINE 60 48 61 171 13.0 ONLINE 48 ONLINE 62 182 13.0 2 41 198 13.2 ONLINE 63 41 2 178 13.4 ONLINE 64 45 149 13.5 ONLINE 65 47 1 186 ONLINE 66 13.5 3 42 194 ONLINE 67 13.6 2 45 174 ONLINE 68 48 13.6 188 13.6 ONLINE 69 0 52 193 ONLINE 70 13.7 41 5 180 ONLINE 71 14.0 34 2 158 14.2 3 ONLINE 72 45 73 170 48 14.2 ONLINE 1 186 ONLINE 74 50 14.2 1 75 189 ONLINE 42 14.3 1 152 14.6 ONLINE 1 76 44 ONLINE 160 77 14.8 48 167 2 ONLINE 78 14.8 3 46 79 171 56 14.9 ONLINE 5 189 ONLINE 80 15.0 3 49 178 15.1 ONLINE 81 44 3 153 15.3 ONLINE 82 45 138 15.3 ONLINE 83 2 40 157 ONLINE 84 15.4 1 46 183 15.4 ONLINE 85 4 36 140 ONLINE 86 44 15.7 1 165 87 15.7 ONLINE 3 41 155 16.0 ONLINE 88 2 42 168 16.4 ONLINE 89 49 178 ONLINE 90 2 51 16.4 178 ONLINE 91 46 16.5 16.6 ONLINE 92 21 177 93 17.0 ONLINE 41 149 ONLINE 94 17.3 0 43 161 17.3 ONLINE 95 3 48 170 ONLINE 96 17.4 5 30 173 ONLINE 1 97 17.5 39 144 98 41 17.7 ONLINE 159 1 18.8 ONLINE 99 21 2 185 18.9 ONLINE 2 100 40 191 101 44 19.0 ONLINE 5 20.0 ONLINE ONLINE