Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 10.4, Problem 34E
Oil wells are expensive to drill, and dry wells are a great concern to oil exploration companies. The domestic oil and natural gas producer Aegis Oil, LLC describes on its website how improvements in technologies such as three-dimensional seismic imaging have dramatically reduced the number of dry (nonproducing) wells it and other oil exploration companies drill. The following sample data for wells drilled in 2005 and 2012 show the number of dry wells that were drilled in each year.
- a. Formulate the null and alternative hypotheses that can be used to test whether the wells drilled in 2005 were more likely to be dry than wells drilled in 2012.
- b. What is the point estimate of the proportion of wells drilled in 2005 that were dry?
- c. What is the point estimate of the proportion of wells drilled in 2012 that were dry?
- d. What is the p-value of your hypothesis test? At α = .05, what conclusion do you draw from your results?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A statistical program is recommended.
Jensen Tire & Auto is in the process of deciding whether to purchase a maintenance contract for its new computer wheel alignment and balancing machine. Managers feel that maintenance expense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars).
Weekly Usage(hours)
AnnualMaintenanceExpense
13
17.0
10
22.0
20
30.0
28
37.0
32
47.0
17
30.5
24
32.5
31
39.0
40
51.5
38
40.0
#1) Develop the estimated regression equation that could be used to predict the annual maintenance expense (in hundreds of dollars) given the weekly usage (in hours). (Round your numerical values to two decimal places.)
#2) The expected expense of a machine being used 34 hours per week is $ hundred.
A car dealership would like to test the hypothesis that a difference exists in the city gas mileage (miles per gallon when driven in the city) of three cars, Honda Insight, Hyundai Ioniq, and Toyota Camry. The following data represent the miles per gallon for a random sample of Honda Insight, Hyundai Ioniq, and Toyota Camry cars.
Honda Insight
Hyundai Ioniq
Toyota Camry
40
35
35
36
37
34
37
37
31
38
34
36
38
34
33
36
36
35
Use Excel to perform a one-way ANOVA and state your conclusion using a = 0.05.
A random sample of sale prices of homes in Lexington, Kentucky, yielded the following summary information:Construct a box plot for the data and comment on a home in Lexington, Kentucky, that had a sale price of $426,000.
Select one:
A. This sale price falls between an inner and an outer fence. It can be considered a potential outlier.
B. This value falls outside an outer fence of the box plot and is considered an outlier.
C. This value falls outside of the upper quartile, but cannot be considered an outlier.
D. This sale price would be expected since it falls inside the inner fences of the box plot.
Chapter 10 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 10.1 - The following results come from two independent...Ch. 10.1 - 2. Consider the following hypothesis test.
The...Ch. 10.1 - 3. Consider the following hypothesis test.
The...Ch. 10.1 - 4. Condé Nast Traveler conducts an annual survey...Ch. 10.1 - 5. The USA Today reports that the average...Ch. 10.1 - Hotel Price Comparison. Suppose that you are...Ch. 10.1 - Consumer Reports uses a survey of readers to...Ch. 10.1 - Increases in Customer Satisfaction. Will improving...Ch. 10.2 - The following results are for independent random...Ch. 10.2 - Consider the following hypothesis test:
The...
Ch. 10.2 - Consider the following data for two independent...Ch. 10.2 - Prob. 12ECh. 10.2 - Annual Cost of College. The increasing annual cost...Ch. 10.2 - Are nursing salaries in Tampa, Florida, lower than...Ch. 10.2 - Hotel prices worldwide are projected to increase...Ch. 10.2 - Effect of Parents’ Education on Student SAT...Ch. 10.2 - Comparing Financial Consultant Ratings....Ch. 10.2 - Researchers at Purdue University and Wichita State...Ch. 10.3 - Consider the following hypothesis test.
The...Ch. 10.3 - The following data are from matched samples taken...Ch. 10.3 - Prob. 21ECh. 10.3 - The price per share of stock for a sample of 25...Ch. 10.3 - Credit Card Expenditures. Bank of America’s...Ch. 10.3 - Domestic Airfare. The Global Business Travel...Ch. 10.3 - Prob. 25ECh. 10.3 - PGA Tour Scores. Scores in the first and fourth...Ch. 10.3 - Price Comparison of Smoothie Blenders. A personal...Ch. 10.4 - Consider the following results for independent...Ch. 10.4 - Prob. 29ECh. 10.4 - Corporate Hiring Outlook. A Businessweek/Harris...Ch. 10.4 - Impact of Pinterest on Purchase Decisions. Forbes...Ch. 10.4 - Mislabeled Fish. Researchers with Oceana, a group...Ch. 10.4 - Minnesota had the highest turnout rate of any...Ch. 10.4 - Oil wells are expensive to drill, and dry wells...Ch. 10.4 - In a test of the quality of two television...Ch. 10.4 - Winter visitors are extremely important to the...Ch. 10.4 - Prob. 37ECh. 10 - Prob. 38SECh. 10 - SUV Lease Payments. Statista reports that the...Ch. 10 - Prob. 40SECh. 10 - Kitchen Versus Bedroom Remodeling Costs. The...Ch. 10 - Effect of Siblings on SAT Scores. In Born...Ch. 10 - Country Financial, a financial services company,...Ch. 10 - Prob. 44SECh. 10 - Prob. 45SECh. 10 - News Access Via Computer. The American Press...Ch. 10 - For the week ended January 15, 2009, the bullish...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- What is meant by the sample space of an experiment?arrow_forwardList the sample space of each experiment. Picking a one-digit numberarrow_forwardThe walking speeds of random travelers at Los Angeles International Airport and Dallas/Fort Worth International Airport are summarized below. Direction of Travels Departure Arrival Mean speed (ft/min) 262 268 Standard deviation (ft/min) 52 36 Sample size 36 30 Do people walk faster in the airport when they are departing (getting on a plane) or when they are arriving (getting off a plane)? What is the p-value for this hypothesis test? The walking speeds of random travelers at Los Angeles International Airport and Dallas/Fort Worth International Airport are summarized below. Direction of Travels Departure Arrival Mean speed (ft/min) 262 268 Standard deviation (ft/min) 52 36 Sample size 36 30 Do people walk faster in the airport when they are departing (getting on a plane) or when they are arriving (getting off a plane)? What is the p-value for this hypothesis test? 0.2916 0.5516 0.7084 0.5832arrow_forward
- The table below summarizes data from a survey of a sample of women. Using a 0.01 significance level, and assuming that the sample sizes of 800 men and 300 women are predetermined, test the claim that the proportions of agree/disagree responses are the same for subjects interviewed by men and the subjects interviewed by women. Does it appear that the gender of the interviewer affected the responses of women? Gender of Interviewer Man Woman Women who agree 534 264 Women who disagree 266 36 B. Compute the test statistic. ____ C. Find the critical value(s).___,_____ c2. What is the conclusion based on the hypothesis test? (Fail to reject/ Reject) H0. There (is/is not) sufficient evidence to warrant rejection of the claim that the proportions of agree/disagree responses are the same for subjects interviewed by men and the subjects interviewed by women. It…arrow_forwardThe better-selling candies are often high in calories. Assume that the following data show the calorie content from samples of M&M's, Kit Kat, and Milky Way II. M&M's Kit Kat Milky Way II 250 245 200 230 225 228 220 205 202 210 215 190 250 240 180 Test for significant differences among the calorie content of these three candies. State the null and alternative hypotheses. -H0: MedianMM = MedianKK = MedianMWHa: MedianMM ≠ MedianKK ≠ MedianMW -H0: MedianMM = MedianKK = MedianMWHa: MedianMM > MedianKK > MedianMW -H0: MedianMM ≠ MedianKK ≠ MedianMWHa: MedianMM = MedianKK = MedianMW -H0: All populations of calories are identical.Ha: Not all populations of calories are identical. -H0: Not all populations of calories are identical.Ha: All populations of calories are identical. Find the value of the test statistic. (Round your answer to two decimal places.) Answer=?? Find the p-value. (Round your answer to three decimal places.) p-value =?? At a 0.05…arrow_forwardThe table below summarizes data from a survey of a sample of women. Using a 0.05 significance level, and assuming that the sample sizes of 900 men and 400 women are predetermined, test the claim that the proportions of agree/disagree responses are the same for subjects interviewed by men and the subjects interviewed by women. Does it appear that the gender of the interviewer affected the responses of women? Gender of Interviewer Man Woman Women who agree 532 349 Women who disagree 368 51 Identify the null and alternative hypotheses. Compute the test statistic. Find the critical value(s). What is the conclusion based on the hypothesis test? Reject or fail to reject? Is there sufficient evidence? Does it appear that the gender of the interviewer affected the responses of women?arrow_forward
- The marketing manager of a large super-market chain has the business objective of using shelf space most efficiently. Toward that goal, they would like to use shelf space to predict the sales of a specialty pet food. Data are collected from a random sample of 12 equal-sized store, with the following results: Shelf Space Sales Aisle Location 5 160 0 5 220 1 5 140 0 10 190 0 10 240 0 10 260 1 15 230 0 15 270 0 15 280 1 20 260 0 20 290 0 20 310 1 For these data, Syx = 30.8058436 and hi = 0.1373333 when X = 8. *Round final answers below to three decimal places. Do not round calculations until the final answer. (a) Construct a 95% confidence interval estimate of the mean weekly sales for all stores that have 8 square feet of shelf space for pet food. (b) Construct a 95% prediction interval of the weekly sales of an individual store that has 8 square feet of shelf…arrow_forwardIn low-speed crash tests of five cars, the repair costs were computed for a factory authorizedrepair and an independent repair workshop. The results are listed in Table 2. Is there sufficientevidence to support the claim that the independent workshop has lower repair costs? Use a 0.01significance level.Table 2 car 1 2 3 4 5 authorized repair centre X1 RM797 RM571 RM904 RM1147 RM418 independent workshop X2 RM523 RM488 RM875 RM911 RM297 D=X1 - X2 274 83 29 236 121 D2 = (X1 -X2)2 75076 6889 841 55696 14641arrow_forwardThe table below summarizes data from a survey of a sample of women. Using a 0.01 significance level, and assuming that the sample sizes of 900 men and 400 women are predetermined, test the claim that the proportions of agree/disagree responses are the same for subjects interviewed by men and the subjects interviewed by women. Does it appear that the gender of the interviewer affected the responses of women? Gender of Interviewer Man Woman Women who agree 546 326 Women who disagree 354 74 Click here to view the chi-square distribution table. LOADING... Identify the null and alternative hypotheses. Choose the correct answer below. A. H0: The response of the subject and the gender of the subject are independent. H1: The response of the subject and the gender of the subject are dependent. B. H0: The proportions of agree/disagree responses are…arrow_forward
- A report provided the following information on the sex of smartphone users for representative samples of young people ages 15 to 24 in several different countries. Percent Female Percent Male United States 57% 43% Spain 38% 62% Italy 37% 63% India 18% 82% (a) Suppose the sample sizes were 1,000 for the United States and for India and 500 for Spain and Italy. Complete the following two-way table by entering the observed counts. Female Male United States Spain Italy India (b) Carry out a hypothesis test to determine if there is convincing evidence that the sex proportions are not the same for all four countries. Use a significance level of 0.05. Calculate the test statistic. (Round your answer to two decimal places.) ?2 = Use technology or SALT to calculate the P-value. (Round your answer to four decimal places.) P-value =arrow_forwardIn the Salsberry (2003) study shared in this weeks module, the researcher presents the following results of the statistical analysis: "With respect to family configuration, 20% of the children enrolled in Medicaid, 29% of the uninsured children, and 44% of the privately insured children were in families where the adults were in a “partnered relationship”, [χ2 (2,N = 392) = 21.95; P = .0001]" What type of analysis does this statement reflect?arrow_forwardDetermine whether the following statement makes sense (or is clearly true) or do not make sense ( or is clearly false) a study on the effect of gender on movie attendence was baised because the sample consisted of 800 males and 200 females choose the correct answer and explanation from thenchoices below.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage LearningGlencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY