For this problem, use Excel to do the calculations and Word to interpret the results, Submit both your Excel output and your Word document. Remember that there are steps to tests of significance and 3 steps for finding confidence intervals. If Steps 1 and 3 for tests of significance are identical to steps 1 and 2 for confidence intervals, you cry need to state them once! A store sold herbal remedies. The manager wanted to know if a new herbal medicine was effective in increasing the number of hours of sleep. She randomly selected fourteen patients. She recorded the number of hours of sleep without the herbal medicine and then the number of hours of sleep with the herbal medicine. 1. Construct a 90% confidence interval for the mean difference in hours of sleep between without and with the herbal medicine. 2. Interpret the confidence interval. 3. State the point estimate. 4. Stale the margin of error. 5. Should the manager conclude that the herbal madicine is effective in increasing the Thber of hours of sleep PATIENT HOURS OF SLEEP WITHOUT MEDICINE HOURS OF SLEEP WITH MEDICINE Construct a yox confidence interval to the mean diference in hours of sleep bolwoon without and with the herbal medicine 2. Interpret the confidence interval 3. State the point estimate 4. State the margin of effor 5. Should the manager conclude that it herbal medicino is offective in increasing the number of hours of sleep PATIENI HOURS OF SIFIP WITHOUT MEDICINE 10 HOURS OF SLEEP WITH MEDICINE 2.9 B 3.4 25 D 5.1 1 5.2 H 5.0 1 4.4 42 M 4.3 29 45 For this problem, use Excel to do the calculations and Word to interpret the results. Submit both your Excel output and your Word document. Remember that there are 6 steps to tests of significance and 3 steps for finding confidence intervals. If Steps 1 and 3 for tests of significance are identical to steps 1 and 2 for conlidence intervals, you only need to state them once. A store sold herbal remedies. The manager wanted to know it a new herbal medicine was attective in increasing the number of hours of sleep. She randomly selected fourteen patients. She recorded the number of hours of sleep without the herbal medicine and then the number of hours of sleep with the herbal medicine. 1. Construct a 90% confidence interval for the mean difference in hours of sleep belween without and with the herbal medicine. 2. Interpret the confidence interval 3. State the point estimate. 4. Slate the margin of error. 2. Should the manager conclude that the herbal medicine is elfective in increasing the number of hours of sleep? the point estimate State the margin of error 5 should the manager conclude that the herbal medicine is effective in increasing the number of houts of sleep? PATIENT HOURS OF SLEEP WITHOUT MEDICINE HOURS OF SLEEP WITH MEDICINE 2.9 A B D E F G H 1 10 1.4 3.4 3.7 5.1 5.1 5.2 5.3 5.5 5.8 4.2 48 2.9 4.5 3.3 3.5 4.4 4.8 5.0 5.2 5.0 60 6.5 K 4.4 M N 3.1 4.7 For this problem, use Excel to do the calculations and Word to interpret the results, Submit both your Excel output and your Word document. Remember that there are steps to tests of significance and 3 steps for finding confidence intervals. If Steps 1 and 3 for tests of significance are identical to steps 1 and 2 for confidence intervals, you cry need to state them once! A store sold herbal remedies. The manager wanted to know if a new herbal medicine was effective in increasing the number of hours of sleep. She randomly selected fourteen patients. She recorded the number of hours of sleep without the herbal medicine and then the number of hours of sleep with the herbal medicine. 1. Construct a 90% confidence interval for the mean difference in hours of sleep between without and with the herbal medicine. 2. Interpret the confidence interval. 3. State the point estimate. 4. Stale the margin of error. 5. Should the manager conclude that the herbal madicine is effective in increasing the Thber of hours of sleep PATIENT HOURS OF SLEEP WITHOUT MEDICINE HOURS OF SLEEP WITH MEDICINE Construct a yox confidence interval to the mean diference in hours of sleep bolwoon without and with the herbal medicine 2. Interpret the confidence interval 3. State the point estimate 4. State the margin of effor 5. Should the manager conclude that it herbal medicino is offective in increasing the number of hours of sleep PATIENI HOURS OF SIFIP WITHOUT MEDICINE 10 HOURS OF SLEEP WITH MEDICINE 2.9 B 3.4 25 D 5.1 1 5.2 H 5.0 1 4.4 42 M 4.3 29 45 For this problem, use Excel to do the calculations and Word to interpret the results. Submit both your Excel output and your Word document. Remember that there are 6 steps to tests of significance and 3 steps for finding confidence intervals. If Steps 1 and 3 for tests of significance are identical to steps 1 and 2 for conlidence intervals, you only need to state them once. A store sold herbal remedies. The manager wanted to know it a new herbal medicine was attective in increasing the number of hours of sleep. She randomly selected fourteen patients. She recorded the number of hours of sleep without the herbal medicine and then the number of hours of sleep with the herbal medicine. 1. Construct a 90% confidence interval for the mean difference in hours of sleep belween without and with the herbal medicine. 2. Interpret the confidence interval 3. State the point estimate. 4. Slate the margin of error. 2. Should the manager conclude that the herbal medicine is elfective in increasing the number of hours of sleep? the point estimate State the margin of error 5 should the manager conclude that the herbal medicine is effective in increasing the number of houts of sleep? PATIENT HOURS OF SLEEP WITHOUT MEDICINE HOURS OF SLEEP WITH MEDICINE 2.9 A B D E F G H 1 10 1.4 3.4 3.7 5.1 5.1 5.2 5.3 5.5 5.8 4.2 48 2.9 4.5 3.3 3.5 4.4 4.8 5.0 5.2 5.0 60 6.5 K 4.4 M N 3.1 4.7