\f1_._|;6 PTS] The data provided (SPHG?11_Midtenn_Testhata.xlsx] include 25 patients discharged from a selected Pennsylvania hospital as part ofa retrospective chart review of antibiotic usage in hospitals. You may assume these data are a SRS from a larger population of interest. The data set [n=25 observations and 9 variables] is available with this test as an Excel le. Variables and corresponding units provided for each observation include: m: patient ID number [1-25] mm duration of hospital [days] Age: age [years] at the time discharged from the hospital Sex: 1=Male, Z=Female Temp: rst temperature following admission [degree Fahrenheit] WBC: rst white blood cell count [per 1000) following admission m: antibiotic status; received antibiotic [1=yes, 2=no] m: received bacterial culture [1=yes, 2=no] Service: 1=meda 2=surg 1a] Suppose investigators are interested in testing if the mean temperature is different from 98.6 degrees. Include all steps for hypothesis testing: State the null and alternative hypothesis in words [that apply to this scenario] symbols. Check any assumptions including addressing whether normality is needed or if ]_1: is met. Explain briey and proceed with hypothesis testing even if this assumption is not met D. Display any plot that you used to check assumptions. Calculate the test-statistic. Show a few interim steps as practical. Calculate the pvalue. State the degrees of freedom if appropriate. If you use software, state the command you used andfor include a portion ofthe output. [fyou used a table, state that. Interpret the p-value for a non-statistician in the context of the problem. [The p-value is a probability What is it the probability in THIS problem? Do NOT use the words \"null hypothesis.'] Do NOT simply state whether or not the result is statistically signicant. 1a} ANSWER: 1b] Compute and interpret a 90% condence interval for the mean temperature. Include your STATA output and command Q Your calculation by hand including the formula used. 1h) ANSWER: 1c] Investigators are interested in comparing the temperature of males vs. females. Construct two side-by- side boxplots to help the investigator compare the temperature of males and females