Instructions: Read this very carefully. 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. How much oil wells in a given field 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 file. Give a 95% confidence 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 file.
(a) 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) Find the t test statistic.
(c) What is the P-value for your t?
(d) Do the data support the researchers idea?
Attachment:- Data.rar