Jensen Tire & Auto Company’s Regression Case Study

Exclusively available on Available only on IvyPanda® Made by Human No AI

Introduction

Jensen Tire & Auto is experiencing a decline in performance. The company embarked on cost cutting strategy as a way to improve the bottom line. One cost that the company is targeting is the maintenance cost of its own machine. The two options that are available are either buying a maintenance contract for its machine or maintaining their own machine. The purchase price of the contract is estimated at $5,000 per annum. Thus, various statistical analyses will be used to evaluate the two options and recommend whether the company should purchase the contract or not.

Analysis

Chart 1 shows the scatter diagram for annual maintenance expense and weekly usage. The points on the diagram tend to slope upwards. This implies that there is a positive linear relationship between the two variables. Regression results are contained in Table 1. The results show that there is a weak positive correlation (0.4551) between the two variables. It implies that they move in the same direction. Thus, if one variable increases, then the other variable will also increase. Since there is only one explanatory variable, a simple regression model will be used. The regression equation will take the form presented below.

Y = a + bX

Where;

Y = annual maintenance expense

X = usage hours

Based on the results, the regression equation will be Y = 22.47 + 0.496X. The intercept value of 22.47 has no significant economic interpretation. It captures the omitted variables. The coefficient value is +0.496. The sign shows that there is a positive relationship between annual maintenance expense and the weekly usage. The value of 0.496 is the amount by which the annual maintenance expense will increase if weekly usage increases by one unit. The value of the coefficient of determination (R-square), a measure of goodness of fit, is 0.2071. It implies that the weekly usage explains only 0.2071 of the variations in annual maintenance expenses. Thus, weekly usage is a weak explanatory variable.

The significance of the explanatory variable can be evaluated using t-test. The t-statistics for weekly usage is 2.7047, while the corresponding p-value is 0.0115. The p-value is less than the significance level of 0.05. It implies that weekly usage is a significant determinant of annual maintenance expense. The results of ANOVA will be used to analyze the significance of the overall regression line. The F-statistic is 7.32, while significance F is 0.0115. This value is lower than the significance level of 0.05. This implies that the overall regression line is significant at the 95% confidence level. Thus, the regression is significant and can be used for further analysis (Black 141).

The calculations of confidence interval show that there is a 95% chance that the annual maintenance fees will fall between 2,990 and 3,640. The contract price of 5,000 is higher than the upper limit of the annual maintenance fees. Therefore, purchasing the contract will be expensive (Fraser 239).

Recommendations

The company should not purchase the contract because it will be more expensive than the current arrangement. Secondly, the weekly usage hours do not explain significant variations in annual maintenance fees. Therefore, other cost drivers such as machine hours can be used to estimate the fees.

Scatter Diagram
Chart 1: Scatter Diagram.

Table 1: Regression Output.

SUMMARY OUTPUT
Regression Statistics
Multiple R0.4551
R Square0.2071
Adjusted R Square0.1788
Standard Error8.1954
Observations30
ANOVA
dfSSMSFSignificance F
Regression1491.33491.337.320.0115
Residual281880.6167.16
Total292371.94
CoefficientsStandard Errort StatP-valueLower 95%Upper 95%
Intercept22.46734.21675.32821.13E-0513.829831.1048
Weekly Usage (hours)0.49670.18362.70470.01150.12050.8729

Confidence and Prediction Interval

Average annual maintenance fee = 3,310

95% confidence interval corresponds to 5% alpha

= Ẋ ± Zs√n

= 33.1 ± 3.24

Upper limit = 3,640

Lower limit = 2,990

2,990 ≤ Ẋ ≤ 3,640

Works Cited

Black, Ken. Business Statistics, Binder Ready Version: For Contemporary Decision Making. John Wiley & Sons Ltd, 2013.

Fraser, Cynthia. Business Statistics for Competitive Advantage with Excel 2010: Basics, Model Building, and Cases. Springer Science and Business Media LLC, 2012.

More related papers Related Essay Examples
Cite This paper
You're welcome to use this sample in your assignment. Be sure to cite it correctly

Reference

IvyPanda. (2021, May 14). Jensen Tire & Auto Company's Regression. https://ivypanda.com/essays/jensen-tire-amp-auto-companys-regression/

Work Cited

"Jensen Tire & Auto Company's Regression." IvyPanda, 14 May 2021, ivypanda.com/essays/jensen-tire-amp-auto-companys-regression/.

References

IvyPanda. (2021) 'Jensen Tire & Auto Company's Regression'. 14 May.

References

IvyPanda. 2021. "Jensen Tire & Auto Company's Regression." May 14, 2021. https://ivypanda.com/essays/jensen-tire-amp-auto-companys-regression/.

1. IvyPanda. "Jensen Tire & Auto Company's Regression." May 14, 2021. https://ivypanda.com/essays/jensen-tire-amp-auto-companys-regression/.


Bibliography


IvyPanda. "Jensen Tire & Auto Company's Regression." May 14, 2021. https://ivypanda.com/essays/jensen-tire-amp-auto-companys-regression/.

If, for any reason, you believe that this content should not be published on our website, please request its removal.
Updated:
This academic paper example has been carefully picked, checked and refined by our editorial team.
No AI was involved: only quilified experts contributed.
You are free to use it for the following purposes:
  • To find inspiration for your paper and overcome writer’s block
  • As a source of information (ensure proper referencing)
  • As a template for you assignment
Privacy Settings

IvyPanda uses cookies and similar technologies to enhance your experience, enabling functionalities such as:

  • Basic site functions
  • Ensuring secure, safe transactions
  • Secure account login
  • Remembering account, browser, and regional preferences
  • Remembering privacy and security settings
  • Analyzing site traffic and usage
  • Personalized search, content, and recommendations
  • Displaying relevant, targeted ads on and off IvyPanda

Please refer to IvyPanda's Cookies Policy and Privacy Policy for detailed information.

Required Cookies & Technologies
Always active

Certain technologies we use are essential for critical functions such as security and site integrity, account authentication, security and privacy preferences, internal site usage and maintenance data, and ensuring the site operates correctly for browsing and transactions.

Site Customization

Cookies and similar technologies are used to enhance your experience by:

  • Remembering general and regional preferences
  • Personalizing content, search, recommendations, and offers

Some functions, such as personalized recommendations, account preferences, or localization, may not work correctly without these technologies. For more details, please refer to IvyPanda's Cookies Policy.

Personalized Advertising

To enable personalized advertising (such as interest-based ads), we may share your data with our marketing and advertising partners using cookies and other technologies. These partners may have their own information collected about you. Turning off the personalized advertising setting won't stop you from seeing IvyPanda ads, but it may make the ads you see less relevant or more repetitive.

Personalized advertising may be considered a "sale" or "sharing" of the information under California and other state privacy laws, and you may have the right to opt out. Turning off personalized advertising allows you to exercise your right to opt out. Learn more in IvyPanda's Cookies Policy and Privacy Policy.

1 / 1