Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
6th Edition
ISBN: 9780357228708
Author: David R. Anderson; Dennis J. Sweeney; Thomas A. Williams
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 19.2, Problem 7E
To determine
Construct the R and
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Roy ‘s Texaco wants to keep the price of its unleaded gasoline competitive with that of other stations in the area. Roy’s is currently charging $1.29 per gallon. To check that the average price for this gasoline for all stations within a 15 mile radius is higher than his price, Roy randomly samples the price of unleaded gasoline at ten stations located in this area. He obtains the following data for the price per gallon (in dollars):
1.7, 1.5, 2.6, 2.2, 2.4, 2.3, 2.6, 3.0, 1.4, 2.3
Set up the appropriate hypotheses and test them using a significance level of α= .05
Roy's Texaco wants to keep the price of its unleaded gasoline competitive with that of other stations in the area. Roy's is currently charging $1.29 per gallon. To check that the average price for this gasoline for all stations within 12-mile radius is higher than his price, Roy randomly samples the price of unleaded gasoline at ten stations located in this area. He obtains the following data for the price per gallon (in dollars):
1.7, 1.5, 2.6, 2.2, 2.4, 2.3, 2.6, 3.0, 1.4, 2.3
Set up appropriate hypotheses and test them using a significant level of .01.
The materials handling manager of a manufacturing company is trying to forecast the cost of maintenance for the company's fleet of over-the-road tractors. The manager believes that the cost of maintaining the
tractors increases with their age. The following data was collected:
Age
(years)
5.5
where Y = Yearly maintenance cost in dollars and X = Age in years.
5.5
5.5
5.0
5.0
5.0
6.0
6.0
6.5
Yearly
Maintenance
Cost (S)
1,319
1,749
1,733
1,195
1,423
1,381
1,590
2,222
1,687
Age
(years)
5.0
1.5
1.5
Y =
7.0
7.0
2.0
2.0
2.0
Yearly
Maintenance
Cost ($)
1,894
863
882
a. Use POM for Windows' least squares-linear regression module to develop a relationship to forecast the yearly maintenance cost based on the age of a tractor. (Enter your responses rounded to three decimal
places and include a minus sign if necessary.)
1,464
2,073
1,678
1,166
1,249
Chapter 19 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card)
Ch. 19.2 - 1. A process that is in control has a mean of =...Ch. 19.2 - 2. Twenty-five samples, each of size 5, were...Ch. 19.2 - Prob. 3ECh. 19.2 - Prob. 4ECh. 19.2 - Prob. 5ECh. 19.2 - Prob. 6ECh. 19.2 - Prob. 7ECh. 19.2 - Prob. 8ECh. 19.2 - Prob. 9ECh. 19.3 - 10. For an acceptance sampling plan with n = 25...
Ch. 19.3 - Prob. 11ECh. 19.3 - Prob. 12ECh. 19.3 - 13. Refer to the KALI problem presented in this...Ch. 19.3 - Prob. 14ECh. 19 - Prob. 16SECh. 19 - Prob. 17SECh. 19 - Prob. 18SECh. 19 - The following are quality control data for a...Ch. 19 - The following were collected for the Master Blend...Ch. 19 - An insurance company samples claim forms for...Ch. 19 - Prob. 22SECh. 19 - 23. An n = 10, c = 2 acceptance sampling plan is...Ch. 19 - Prob. 24SE
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
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardMarks obtained by students in a Chemistry test was adjusted because of an error in one of the questions. The marks are now classified as:A. Primary dataB. Secondary dataC. Regression dataD. External dataarrow_forwardWaterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below. ANOVA table Source SS df MS F Regression 1,850.5782 1 1,850.5782 39.69 Residual 1,305.4934 28 46.6248 Total 3,156.0716 29 Regression output Variables Coefficients Std. Error t(df=28) Intercept 12.6882 3.1699 2.82 Distance–X 5.121 8.504 6.3 Click here for the Excel Data File d-1. Determine the correlation coefficient. (Round your answer to 3 decimal places.) d-2. Choose the right option. d-3. How did you determine the sign of the correlation…arrow_forward
- Waterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below. ANOVA table Source SS df MS F Regression 1,815.5782 1 1,815.5782 40.82 Residual 1,245.4934 28 44.4819 Total 3,061.0716 29 Regression output Variables Coefficients Std. Error t(df=28) Intercept 13.3334 3.0617 3.556 Distance–X 4.7711 0.7468 6.39 Click here for the Excel Data File a-1. Write out the regression equation. (Round your answers to 3 decimal places.) a-2. Is there a direct or indirect relationship between the distance from the fire station and…arrow_forwardWaterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below. ANOVA table Source SS df MS F Regression 1,865.5782 1 1,865.5782 39.56 Residual 1,320.4934 28 47.1605 Total 3,186.0716 29 Regression output Variables Coefficients Std. Error t(df=28) Intercept 13.7523 3.0957 3.672 Distance–X 6.3449 1.0088 6.29 a-1. Write out the regression equation. (Round your answers to 3 decimal places.) a-2. Is there a direct or indirect relationship between the distance from the fire station and the amount of fire damage? How much damage would…arrow_forwardWaterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below. ANOVA table Source SS df MS F Regression 1,850.5782 1 1,850.5782 39.69 Residual 1,305.4934 28 46.6248 Total 3,156.0716 29 Regression output Variables Coefficients Std. Error t(df=28) Intercept 12.6882 3.1699 2.82 Distance–X 5.121 8.504 6.3 Click here for the Excel Data File a-1. Write out the regression equation. (Round your answers to 3 decimal places.) a-2. Is there a direct or indirect relationship between the distance from the fire station and…arrow_forward
- Waterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below. ANOVA table Source SS df MS F Regression 1,850.5782 1 1,850.5782 39.69 Residual 1,305.4934 28 46.6248 Total 3,156.0716 29 Regression output Variables Coefficients Std. Error t(df=28) Intercept 12.6882 3.1699 2.82 Distance–X 5.121 8.504 6.3 c-1. Determine the coefficient of determination. (Round your answer to 3 decimal places.) c-2. Fill in the blank below. (Round your answer to one decimal place.) d-1. Determine the correlation coefficient. (Round…arrow_forwardWaterbury Insurance Company wants to study the relationship between the amount of fire damage and the distance between the burning house and the nearest fire station. This information will be used in setting rates for insurance coverage. For a sample of 30 claims for the last year, the director of the actuarial department determined the distance from the fire station (x) and the amount of fire damage, in thousands of dollars (y). The MegaStat output is reported below. ANOVA table Source SS df MS F Regression 1,850.5782 1 1,850.5782 39.69 Residual 1,305.4934 28 46.6248 Total 3,156.0716 29 Regression output Variables Coefficients Std. Error t(df=28) Intercept 12.6882 3.1699 2.82 Distance–X 5.121 8.504 6.3 e-1. State the decision rule for 0.01 significance level: H0 : ρ = 0; H1 : ρ ≠ 0. (Negative value should be indicated by a minus sign. Round your answers to 3 decimal places.) e-2. Compute the value of the test…arrow_forwardFind the regression equation for the following paired data. (1, 2), (3, 7), (5, 9), (9, 15), (4, 7) a) b) y = 1.1250 + 1.5625 x y = 1.1250 x + 1.5625 c) y = 2.1250 + 3.5625 x d) y = 1.5625 xarrow_forward
- Determine the type of variation model that best fits the data in the attached image.arrow_forward2) Use the given information to find the coefficient of determination. A regression equation is obtained for a collection of paired data. It is found that the total variation is 20.711, the explained variation is 18.592, and the unexplained variation is 2.119. A) 1.114 B) 0.102 C) 0.898 D) 0.114arrow_forwardThe following data are the monthly salaries and the grade point averages for students who obtained a bachelor's degree in mathematics. GPA: 2.6, 3.4, 3.6, 3.2, 3.5, and 2.9; Monthly Salary: 330o, 3600, 4000, 3500, 3900, and 3600. Plot the scatter diagram showing the deviations about the estimated regression line and the line y = y(bar).arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
What Are Research Ethics?; Author: HighSchoolScience101;https://www.youtube.com/watch?v=nX4c3V23DZI;License: Standard YouTube License, CC-BY
What is Ethics in Research - ethics in research (research ethics); Author: Chee-Onn Leong;https://www.youtube.com/watch?v=W8Vk0sXtMGU;License: Standard YouTube License, CC-BY