Excel Worksheet 7-Math 243-Fall 2016 (Total: 26 points) Instructions: In one Excel file create two sheets. Label one sheet \"Problem 1\" and label the second sheet \"Problem 2.\" Your solutions to the two problems should be recorded on the corresponding sheet. Additionally, you should clearly label each part of the problems with (a), (b), etc., and every computation should be labeled. For example, in the cell next to the mean of the data, you should have typed the word mean or average. Be sure to do your computations using Excel. Do not do computations using Table A, Table C, or on a calculator and then type the answers into Excel. 1. (6 points) The data in the file facebookfriends.xls gives the number of friends for a simple random sample of Facebook users. Use a 95% confidence interval to estimate the mean number of Facebook friends. 2. Makers of generic drugs must show that they do not differ significantly from the \"reference\" drugs they imitate. One aspect in which drugs might differ is their extent of absorption in the blood. The data in the file DrugAbsorption.xls was taken from 20 healthy nonsmoking male subjects for one pair of drugs. This is a matched pairs design. Numbers 1 to 20 were assigned at random to the subjects. Subjects 1 to 10 received the generic drug first, and Subjects 11 to 20 received the reference drug first. In all cases, a washout period separated the two drugs so that the first had disappeared from the blood before the subject took the second. (a) (4 points) Make a histogram of the differences (use class size of 500) to see that they appear to follow a reasonably Normal distribution with no outliers. (b) (4 points) Consider the question: Do the drugs differ significantly in absorption? State the null and alternative hypotheses relative to this question. (c) (4 points) Find the t test statistic. (d) (4 points) What is the P -value for your t? (e) (4 points) Do the drugs differ significantly in absorption at significance level = 0.05? Friends 99 148 158 126 118 112 103 111 154 85 120 127 137 74 85 104 106 72 119 160 83 110 97 193 96 152 105 119 171 128 Subj Ref Generic 15 4108 1755 3 2526 1138 9 2779 1613 13 3852 2254 12 1833 1310 8 2463 2120 18 2059 1851 20 1709 1878 17 1829 1682 2 2594 2613 4 2344 2738 16 1864 2302 6 1022 1284 10 2256 3052 5 938 1287 7 1339 1930 14 1262 1964 11 1438 2549 1 1735 3340 19 1020 3050