17 3.6 Appendix Performing Regression Analysis with Excel

Last updated
 Dec 28, 2020
Learning Objectives
 Perform regression analysisusing Excel.
Question:


The discussion of regression analysis in this chapter is meant to serve as an introduction to the topic. To further enhance your knowledge of regression analysis and to provide for a more thorough analysis of the data, you should pursue the topic in an introductory statistics course.
Key Takeaway
Software applications, such as Excel, can use regression analysis to estimate fixed and variable costs.
 Once the data analysis package is installed, historical data are entered in the spreadsheet, and the regression analysis is run.
 The resulting data are used to determine the cost equation, which includes estimated fixed and variable costs.
The line fit plot and Rsquared statistic are used to assess the usefulness of the cost equation in estimating costs.
Refer to the monthly production cost data for Alta Production, Inc., in Note 3.21 “Review Problem 3.5”. Use the four steps of


Definitions
 Measures the percent of the variance in the dependent variable explained by the independent variable.