Forum 9

We have developed a new drug used to reduce fever and want to test its efficacy.Ten ER patients who are running a fever agree to take the new drug instead of the traditional treatment.Their temperatures are taken before the drug is administered and 30 minutes after taking the drug. The results are recorded in the Excel file below. Use the data to construct and interpret a 99% confidence interval for the mean change in temperatures of patients after taking this drug using Excel. Be sure to include any explanation necessary along with a sentence that explains what the interval means.

For your second post, describe a situation of interest to you where you could collect data to compute a confidence interval for one or two samples. For instance, I'm interested in the differences in grades for those who take this course in theonlineformat vs. those who attend this course on campus. So to describe how I could find a confidence interval I would tell how I would collect final grades from severalonlinecourses and find the average overall grade and standard deviation, then do the same for several residential courses. I would use those statistics to calculate a confidence interval to describe the difference in scores for the two formats.

Off Forum 9C - Excel Ajay Chaudhary AC X File Home Insert Draw Page Layout Formulas Data Review View Help Share Comments Calibri 11 E General Conditional Formatting B A A E $ ~ % Format as Table Cells Editing Analyze Sensitivity Paste Cell Styles * Data Clipboard Font Alignment Number Styles Analysis Sensitivity B1 X V Second Temp C D E F G H J K L M N - A B First Temp Second Temp 101.2 100.1 W N - 102.3 101 .02.1 39.2 102.7 99 101.9 99.2 100.8 98.6 103.1 100.7 102.5 99.2 103.5 100.1 11 101.7 98.9 12 13 14 15 16 17 38 Sheet1 + + 100%