Excel Worksheet 5-Math 243-Winter 2016 (Total: 22 points) Instructions: Read this very carefully. In one Excel le 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) How much oil wells in a given eld will ultimately produce is key information in deciding whether to drill more wells. Data was collected estimating the total amount of oil recovered from 64 wells in the Devonian Richmond Dolomite area of the Michigan Basin. The data is in the accompanying le. Give a 95% condence interval for the mean amount of oil recovered from all wells in this area. 2. Researchers did a study to compare how much men and women talk because it is commonly thought that women talk more then men. The study collected data from a simple random sample of women and a simple random sample of men. For each individual in these samples the researchers gave the estimated number of words spoken by her/him in a day. The data is in the accompanying le. (a) (4 points) Do the data provide good evidence that women talk more than men, on average? State the null and alternative hypotheses relative to this question. (b) (4 points) Find the t test statistic. (c) (4 points) What is the P -value for your t? (d) (4 points) Do the data support the researchers idea? Sex Words F F F F F F F F F F F F F F F F F F F F F F F F F F F M M M M M M M M M M M M M M M M M M M M 15357 13618 9783 26451 12151 8391 19763 25246 8427 6998 24876 6272 10047 15569 39681 23079 24814 19287 10351 8866 10827 12584 12764 19086 26852 17639 16616 28408 10084 15931 21688 37786 10575 12880 11071 17799 13182 8918 6495 8153 7015 4429 10054 3998 12639 10974 5255 Oil 21.7 53.2 46.4 42.7 50.4 97.7 103.1 51.9 43.4 69.5 156.5 34.6 37.9 12.9 2.5 31.4 79.5 26.9 18.5 14.7 32.9 196 24.9 118.2 82.2 35.1 47.6 54.2 63.1 69.8 57.4 65.6 56.4 49.4 44.9 34.6 92.2 37 58.8 21.3 36.6 64.9 14.8 17.6 29.1 61.4 38.6 32.5 12 28.3 204.9 44.5 10.3 37.7 33.7 81.1 12.1 20.1 30.5 7.1 10.1 18 3 2