Excel Worksheet 5–Math 243–Fall 2015

Excel Worksheet 5–Math 243–Fall 2015
(Total: 22 points)
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. (6 points) 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) (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?