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 maintenanceexpense should be related to usage, and they collected the following information on weekly usage (hours) and annual maintenance expense (in hundreds of dollars).AnnualMaintenanceExpenseWeeklyUsage(hours)1617132223303137354720312733343943524140a. Develop the estimated regression equation that relates annual maintenance expense (in hundreds of dollars) to weekly usage hours (to 3 decimals).Expense =*+Weekly Usageb. Test the significance of the relationship in part (a) at a 0.05 level of significance.Compute the value of the F test statistic (to 2 decimals).The p value is less than 0.01What is your conclusion?Conclude that there is a significant relationship between expense and weekly usagec. Jensen expects the new machine to be used 30 hours per week. What is the expected annual maintenance expense in hundreds of dollars (to 2 decimals)?✩ hundred$ⒸDevelop a 95% prediction interval for the company's annual maintenance expense for this machine (to 2 decimals).($hundred, $hundred)d. If the maintenance contract costs $3000 per year, would you recommend purchasing the contract for the new machine in part (c)? Why or why not?Yes, the expected maintenance expense is greater than $3000

Given that By using excel Regression excel > data > data analysis > regression > input…

Answered: Jensen Tire & Auto is in the process of…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

The manager of the Bayville police department motor pool wants to develop a forecast model for annual maintenance on police cars, based on mileage in the past year and age of the cars. The following data have been collected for eight different cars: a. Using Excel, develop a multiple regression equation for these data. b. What is the coefficient of determination for this regression equation? c. Forecast the annual maintenance cost for a police car that is 5 years old and will be driven 10,000 miles in 1 year.
A major brokerage company has an office in Miami, Florida. The manager of the office is evaluated based on the number of new clients generated each quarter. Data were collected that show the number of new customers added during each quarter between 2015 and 2018. A multiple regression model was developed with the number of new customers as the dependent and the following four independent variables: Period (1, …, 16): A variable that measures the trend; Q1 = 1 for first quarter, Q1 = 0 otherwise; Q2 = 1 for second quarter, Q2 = 0 otherwise; Q3 = 1 for third quarter, Q3 = 0 otherwise. Questions: 1. Explain each of the four slopes (Period, Q1, Q2, Q3). 2. How many new customers would you expect in the second quarter of the following year (2019)?
A county real estate appraiser wants to develop a statistical model to predict the appraised value of houses in a section of the county called East Meadow. One of the many variables thought to be an important predictor of appraised value is the number of rooms in the house. Consequently, the appraiser decided to fit the simple linear regression model, y = b₁x + bowhere y = appraised value of the house (in $thousands) and x = number of rooms. Using data collected for a sample of n=74 houses in East Meadow, the following results were obtained: y=74.80+ 17.80x Give a practical interpretation of the estimate of the slope of the least squares line. For each additional room in the house, we estimate the appraised value to increase $74,800. 1000 For each additional dollar of appraised value, we estimate the number of rooms in the house to increase by 17.80 rooms. For a house with 0 rooms, we estimate the appraised value to be $74,800. For each additional room in the house, we estimate the…
The table below shows the average weekly wages (in dollars) for state government employees and federal government employees for 10 years. Construct and interpret a 99% prediction interval for the average weekly wages of federal government employees when the average weekly wages of state government employees is $925. The equation of the regression line is
Used cars 2010 Vehix.com offered several used ToyotaCorollas for sale. The following table displays the ages ofthe cars and the advertised prices. a) Make a scatterplot for these data.b) Do you think a linear model is appropriate? Explain.c) Find the equation of the regression line. d) Check the residuals to see if the conditions for infer-ence are met. Age (yr) Price ($) Age (yr) Price ($)1 15988 6 99951 13988 6 119882 14488 7 89903 10995 8 94883 13998 8 89954 13622 9 59904 12810 10 41005 9988 12 2995
We have data from 209 publicly traded companies (circa 2010) indicating sales and compensation information at the firm-level. We are interested in predicting a company's sales based on the CEO's salary. The variable sales; represents firm i's annual sales in millions of dollars. The variable salary; represents the salary of a firm i's CEO in thousands of dollars. We use least-squares to estimate the linear regression sales; = a + ßsalary; + ei and get the following regression results: . regress sales salary Source Model Residual Total sales salary cons SS 337920405 2.3180e+10 2.3518e+10 df 1 207 208 Coef. Std. Err. .9287785 .5346574 5733.917 1002.477 MS 337920405 111980203 113066454 Number of obs F (1, 207) Prob > F R-squared t P>|t| = Adj R-squared = Root MSE 1.74 0.084 5.72 0.000 = = -.1252934 3757.543 = 209 3.02 0.0838 0.0144 0.0096 10582 [95% Conf. Interval] 1.98285 7710.291 This output tells us the regression line equation is sales = 5,733.917 +0.9287785 salary. Interpret the…
One of the biggest changes in higher education in recent years has been the growth of online universities. The Online Education Database is an independent organization whose mission is to build a comprehensive list of the top accredited online colleges. The following table shows the retention rate (%) and the graduation rate (%) for 29 online colleges.a). Use Excel Data Analysis Tool – Regression to get the relationship between the two variables;b). Create a scatter diagram for the two variables and display regression equation and R square on chart, then explain the relationship between the variables;c). Did the estimated regression equation provide a good fit?d). Suppose you were the president of South University. After reviewing the results, would you be able to use the regression result for forecasting. College RR(%) GR(%) Western International University 7 25 South University 51 25 University of Phoenix 4 28 American InterContinental University 29 32 Franklin…
The value of a sports franchise is directly related to the amount of revenue that a franchise can generate. The accompanying data table gives the value and the annual revenue for 15 major sport teams. Suppose you want to develop a simple linear regression model to predict franchise value based on annual revenue generated.
The Wall Street Journal asked Concur Technologies, Inc., an expense management company, to examine data from million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city. The following table shows the average daily hotel room rate () and the average amount spent on entertainment () for a random sample of of the most-visited U.S. cities. These data lead to the estimated regression equation . For these data . Click on the datafile logo to reference the data. Use Table 1 of Appendix B. full question attached in ss thanks for help aprpeicated aigjrowoirj
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 Annual (hours) Maintenance Expense 15 22 12 27 22 35 30 42 34 52 19 36 26 38 33 44 42 57 40 45 a. Develop the estimated regression equation that relates annual maintenance expense (in hundreds of dollars) to weekly usage hours (to 3 decimals). Expense = Weekly Usage b. Test the significance of the relationship in part (a) at a 0.05 level of significance. Compute the value of the F test statistic (to 2 decimals). The p value is Select your answer- - Select your answer What is your less than 0.01 between 0.01 and 0.025 - Select your a between 0.025 and 0.05 c. Jensen expe between 0.05 and 0.10 greater than 0.10 sed 30 hours per week.…
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 o. Click the icon to view the monthly data. a. Develop a simple linear regression model between billable hours and overhead costs. Overhead Costs OxBillable Hours (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 $385,000 Billable Hours 3,000 $425,000 4,000 $445.000 5,000 $497,000 6,000 $570,000 7,000 $590,000 8,000
Question 7n A business analyst wants to estimate the average monthly expenditure on bread by a family in Montreal. She wants to be 95% confident of her results, and she wants the estimate to be within $1.00 of the actual figure. Choices below are given as [lower limit, upper limit]. The historical standard deviation of monthly bread purchases is $4.00. What is the required sample size to achieve her estimation accuracy? a) 62 b) 63 c) 44 d) 61

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS