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