Statistics for Business & Economics (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
13th Edition
ISBN: 9781305585317
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 14.6, Problem 38E
Refer to exercise 21, where data on the production volume x and total cost y for a particular manufacturing operation were used to develop the estimated regression equation ŷ = 1246.67 + 7.6x.
- a. The company’s production schedule shows that 500 units must be produced next month. What is the point estimate of the total cost for next month?
- b. Develop a 99% prediction interval for the total cost for next month.
- c. If an accounting cost report at the end of next month shows that the actual production cost during the month was $6000, should managers be concerned about incurring such a high total cost for the month? Discuss.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Price/Book Value Ratio Return on Equity
13.032
1.405
8.305
2.113
6.654
1.239
3.262
2.449
5.291
2.398
7.719
0.353
2.569
7.593
5.104
2.012
4.797
2.182
4.129
1.918
1.549
1.951
5.046
2.417
2.159
3.011
1.725
5.582
4.698
Growth%
6.385
11.846 135.669
12.459
0.073
25.092
14.188
8.804
22.766
38.082
18.985
25.696
24.519
19.666
11.624
22.849
49.965
69.649 36.696
3.819 41.139
9.218
29.108
17.772
25.114
29.295 23.764
31.405
9.497
14.759
18.541
12.026
39.016
14.228
39.439
14.097
27.022
14.841
13.237
20.669
17.311
14.887
15.849
5.601
16.775
11.172
8.401
16.161
18.404
23.973 16.673
14.725 46.605
28.839
52.021
The follow table gives the approximate economic value associated with various levels of oil recovery in Texas. Find the regression line, and use it to estimate the economic value associated with a recovery level of 70%.
The managing director of a consulting group has the accompanying monthly data on total overhead costs and professional labor hours to bill to clients.
Complete parts a through c.
E Click the icon to view the monthly data.
a. Develop a simple linear regression model between billable hours and overhead costs.
Overhead Costs =
5304.4 + (0.0219) × Billable Hours
+1
(Round the constant to one decimal place as needed. Round the coefficient to four decimal places as needed. Do not include the $ symbol in your answers.)
Monthly overhead costs and billable hours data
Overhead Costs
Billable Hours O
IT
$385,000
3,000
$430,000
4,000
$460,000
5,000
$511,000
6,000
$580,000
7,000
$600,000
8,000
Print
Done
Chapter 14 Solutions
Statistics for Business & Economics (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations for two variables, x...Ch. 14.2 - Given are five observations collected in a...Ch. 14.2 - The following data give the percentage of women...Ch. 14.2 - Brawdy Plastics, Inc., produces plastic seat belt...Ch. 14.2 - The National Football League (NFL) records a...Ch. 14.2 - A sales manager collected the following data on...Ch. 14.2 - The American Association of Individual Investors...Ch. 14.2 - Prob. 9ECh. 14.2 - On March 31, 2009, Ford Motor Companys shares were...
Ch. 14.2 - To help consumers in purchasing a laptop computer,...Ch. 14.2 - Concur Technologies, Inc., is a large...Ch. 14.2 - To the Internal Revenue Service, the...Ch. 14.2 - A large city hospital conducted a study to...Ch. 14.3 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.3 - The data from exercise 2 follow. xi 3 12 6 20 14...Ch. 14.3 - The data from exercise 3 follow. xi 2 6 9 13 20 yi...Ch. 14.3 - The following data show the brand, price (), and...Ch. 14.3 - In exercise 7 a sales manager collected the...Ch. 14.3 - Bicycling, the worlds leading cycling magazine,...Ch. 14.3 - An important application of regression analysis in...Ch. 14.3 - Refer to exercise 9, where the following data were...Ch. 14.5 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.5 - The data from exercise 2 follow. xi 3 12 6 20 14...Ch. 14.5 - The data from exercise 3 follow. xi 2 6 9 13 20 yi...Ch. 14.5 - In exercise 18 the data on price () and the...Ch. 14.5 - To identify high-paying jobs for people who do not...Ch. 14.5 - In exercise 8 ratings data on x = the quality of...Ch. 14.5 - Refer to exercise 21, where data on production...Ch. 14.5 - Refer to exercise 9, where the following data were...Ch. 14.5 - In exercise 20, data on x = weight (pounds) and y...Ch. 14.6 - The data from exercise 1 follow. xi 1 2 3 4 5 yi 3...Ch. 14.6 - The data from exercise 2 follow. xi 3 12 6 20 14...Ch. 14.6 - The data from exercise 3 follow. xi 2 6 9 13 20 yi...Ch. 14.6 - The following data are the monthly salaries y and...Ch. 14.6 - In exercise 7, the data on y = annual sales (...Ch. 14.6 - In exercise 13, data were given on the adjusted...Ch. 14.6 - Refer to exercise 21, where data on the production...Ch. 14.6 - In exercise 12, the following data on x = average...Ch. 14.7 - The commercial division of a real estate firm is...Ch. 14.7 - Following is a portion of the computer output for...Ch. 14.7 - A regression model relating x, number of...Ch. 14.7 - A 2012 suvey conducted by Idea Works provided data...Ch. 14.7 - Automobile racing, high-performance driving...Ch. 14.8 - Given are data for two variables, x and y. xi 6 11...Ch. 14.8 - The following data were used in a regression...Ch. 14.8 - Data on advertising expenditures and revenue (in...Ch. 14.8 - Refer to exercise 7, where an estimated regression...Ch. 14.8 - In 2011 home prices and mortgage rates dropped so...Ch. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Consider the following data for two variables, x...Ch. 14.9 - Charity Navigator is Americas leading independent...Ch. 14.9 - Many countries, especially those in Europe, have...Ch. 14.9 - Prob. 54ECh. 14 - Does a high value of r2 imply that two variables...Ch. 14 - In your own words, explain the difference between...Ch. 14 - What is the purpose of testing whether 1 = 0? If...Ch. 14 - The Dow Jones Industrial Average (DJIA) and the...Ch. 14 - Is the number of square feet of living space a...Ch. 14 - One of the biggest changes in higher education in...Ch. 14 - Jensen Tire Auto is in the process of deciding...Ch. 14 - In a manufacturing process the assembly line speed...Ch. 14 - A sociologist was hired by a large city hospital...Ch. 14 - The regional transit authority for a major...Ch. 14 - A marketing professor at Givens College is...Ch. 14 - The Transactional Records Access Clearinghouse at...Ch. 14 - The Toyota Camry is one of the best-selling cars...Ch. 14 - You have been assigned to analyze the risk...Ch. 14 - As part of a study on transportation safety, the...Ch. 14 - Consumer Reports tested 166 different...Ch. 14 - Finding the Best Car Value When trying to decide...Ch. 14 - Buckeye Creek Amusement Park is open from the...
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 does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardOlympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardDoes Table 1 represent a linear function? If so, finda linear equation that models the data.arrow_forward
- Table 2 shows a recent graduate’s credit card balance each month after graduation. a. Use exponential regression to fit a model to these data. b. If spending continues at this rate, what will the graduate’s credit card debt be one year after graduating?arrow_forwardTable 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?arrow_forwardWhich one of the following cost estimation methods is the most accurate? Select one: a. The high-low method. b. Regression analysis. Of Subjective forecasting. Of. Scatter Grapharrow_forward
- Use the Financial database from “Excel Databases.xls” on Blackboard. Use Total Revenues, Total Assets, Return on Equity, Earnings Per Share, Average Yield, and Dividends Per Share to predict the average P/E ratio for a company. Use Excel to develop the multiple linear regression model. Assume a 5% level of significance. Which independent variable is the strongest predictor of the average P/E ratio of a company? A. Total Revenues B. Average Yield C. Earnings Per Share D.Return on Equity E. Total Assets F.Dividends Per Share Company Type Total Revenues Total Assets Return on Equity Earnings per Share Average Yield Dividends per Share Average P/E Ratio AFLAC 6 7251 29454 17.1 2.08 0.9 0.22 11.5 Albertson's 4 14690 5219 21.4 2.08 1.6 0.63 19 Allstate 6 20106 80918 20.1 3.56 1 0.36 10.6 Amerada Hess 7 8340 7935 0.2 0.08 1.1 0.6 698.3 American General 6 3362 80620 7.1 2.19 3 1.4 21.2 American Stores 4 19139 8536 12.2 1.01 1.4 0.34 23.5 Amoco 7 36287…arrow_forwardAccording to human capital theory, a person’s earning is linked to her level of education – there is a relationship between workers income and years of education. Using data from the Labour Force Survey, a researcher found the following regression results for earnings on intercept, years of education, experience, and experience squared: Earnings = 5.24 + 0.035 educ + 0.165 exper – 0.003 exper2 (2.45) (0.012) (0.031) (0.001) Construct a 95% confidence interval for the effect of years of education on earnings ? 2. Consider an individual with 8 years of experience. What would you expect to be the return to two (2) additional years of experience (the effect on earnings)? 3. According to economic theory,…arrow_forwardA Realtor examines the factors that influence the price of a house in Arlington, Massachusetts. He collects data on recent house sales (Price) and notes each house’s square footage (Sqft) as well as its number of bedrooms (Beds) and number of bathrooms (Baths). Which of the following assumptions is NOT made when estimating regression models? a. There is a linear relationship between the explanatory and response variables b. All of the relevant explanatory variables have been included in the model c. All of the explanatory variables are independent d. All of the explanatory variables are positively correlated with the response variable.arrow_forward
- The county assessor is studying housing demand and is interested in developing a regression model to estimate the market value (i.e., selling price) of residential property within her jurisdiction. The assessor suspects that the most important variable affecting selling price (measured in thousands of dollars) is the size of house (measured in hundreds of square feet). She randomly selects 15 houses and measures both the selling price and size, as shown in the following table. Complete the table and then use it to determine the estimated regression line. Observation i 1 2 3 4 5 6 7 8 9 10 i 11 12 13 14 15 Total O 8.074 Regression Parameters Slope (B) Intercept (α) 10.181 8.358 O 0.327 Size (x 100 sq. ft.) O 0.316 12 20.2 27 O 0.398 30 30 O Yes 21.4 21.6 25.2 37.2 14.4 15 22.4 23.9 26.6 30.7 357.60 O No What is the standard error of the estimate (Se)? In words, for each hundred square feet, the expected selling price of a house Selling Price (x $1,000) Ii Yi y 265.2 253.4 12 2 20.2…arrow_forwardMidgett Co. has accumulated data to use in preparing its annual profit plan for the upcoming year. The cost behavior pattern of the maintenance costs must be determined. The accounting staff suggested that linear regression be employed to derive an equation for maintenance hours and costs. Data regarding the maintenance hours and costs for the last year and the results of the regression analysis are as follows: Month MaintenanceCost Machine Hours Jan. $ 5,040 620 Feb. 3,648 420 Mar. 4,320 520 Apr. 3,331 390 May 5,221 650 June 3,550 400 July 3,655 430 Aug. 5,365 690 Sept. 5,110 640 Oct. 4,866 610 Nov. 3,944 460 Dec. 3,790 440 Sum $ 51,840 6,270 Average $ 4,320.00 522.50 Average cost per hour ($51,840/6,270) = $8.27 (rounded to the nearest cent)r = 0.99821r2 = 0.99780The percent of the total variance that can be…arrow_forwardThe county assessor is studying housing demand and is interested in developing a regression model to estimate the market value (i.e., selling price) of residential property within his jurisdiction. The assessor suspects that the most important variable affecting selling price (measured in thousands of dollars) is the size of house (measured in hundreds of square feet). He randomly selects 15 houses and measures both the selling price and size, as shown in the following table. Complete the table and then use it to determine the estimated regression line. Observation Size Selling Price (x 100 sq. ft.) (x $1,000) ii xixi yiyi xixiyiyi xi2xi2 yi2yi2 1 12 265.2 3,182.40 144.00 70,331.04 2 20.2 279.6 5,647.92 408.04 78,176.16 3 27 311.2 8,402.40 729.00 96,845.44 4 30 328.0 9,840.00 900.00 107,584.00 5 30 352.0 10,560.00 900.00 123,904.00 6 21.4 281.2 6,017.68 457.96 79,073.44 7 21.6 288.4 6,229.44 466.56 83,174.56 8 25.2 292.8 7,378.56 635.04…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage LearningCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillAlgebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
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