Reference no: EM13916519
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
|
Calculate the equivalent units for the period
: Calculate the Equivalent Units for the Period.The units in BWIP and EWIP are not 100% complete. This step allows BWIP and EWIP to be stated in terms of completed units, which are called equivalent units. This step must be completed before the cost pe..
|
|
Natural factors that might influence human population growth
: In spite of natural factors that might influence human population growth rates, population growth in some countries appears to be declining because ..? A. Humans have exceeded their carrying capacity
|
|
Depth of water and rate of water movement
: The characteristics that scientists use to distinguish different freshwater environments from each other are...? A. Depth of water and rate of water movement B. Temperature and water depth
|
|
If an organism is analogous to a house
: If an organism is analogous to a house, then an organ system would be most similar to the..?
|
|
Confidence interval for the mean amount of oil
: 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 Mic..
|
|
Factory cafeteria costs
: The factory administration costs are allocated based on direct labor hours, factory maintenance costs are allocated based on square footage occupied, and factory cafeteria costs are allocated based on the number of employees.
|
|
What are the types of equity accounts
: What are the types of equity accounts? What is the role of equity accounts in raising capital? Under what circumstances would you not pay a dividend?
|
|
Business-level strategy and one corporate-level strategy
: For the corporation that does not operate internationally, propose one business-level strategy and one corporate-level strategy that you would suggest the corporation consider. Justify your proposals.
|
|
Explain differences between mergers, acquisitions, takeovers
: Explain the differences between mergers, acquisitions, and takeovers. How do you determine which one to use when attempting to gain a competitive advantage over others in your field?
|