Question

(Use Excel) italy common for people to put on weight when they quit smoking While a small weight gain is normal c e weight gain can create new health concerns that brode the benefits of not smoking. The accompanying table shows a portion of the weight data for 50 women before quitting and six months after quitting Use Table 2 Weight Before Quilling 140 144 138 Weight After Quilling 155 142 163 146 129 149 136 127 158 145 118 150 119 125 131 127 126 124 141 131 139 140 140 140 130 136 143 123 145 126 165 132 124 144 136 117 148 137 133 133 163 140 147 142 123 137 140 124 129 123 134 130 123 125 136 133 147 136 131 134 127 122 128 133 138 129 143 150 136 134 140 118 127 126 131 126 Type here to search

Answer 1

Excel add-in (Mega Stat) procedure: Step 1: In EXCEL, Select Add-Ins > Mega Stat > Hypothesis Tests. Step 2: Choose Paired Observations. Step 3: Choose Data Input. Step 4: In Group 1, enter the column of Weight After quitting Step 5: In Group 2. enter the column of Weight Before quitting Step 6: Enter 0 Under Hypothesized difference. Step 7: Check t-test, enter Confidence level as 95.0. Step 8: Choose not equal in alternative. Step 9: Click OK Excel add-in (Mega Stat) output:

Hypothesis Test: Paired Observations 139.200 mean Weight After Quitting 132.200 mean Weight Before Quitting 7.000 mean difference (Weight After Quitting - Weight Before Quitting) 7.491 std. dev. 1.059 std. error 50 n 49df 4.871 confidence interval 95% lower 9.129 confidence interval 95 % upper 2.129 margin of error Confidence interval is 4.871 to 9.129. (6) The mean gain in weight due to quitting is inside from 5 pounds at the 5% significance level.