Appendix: Performing Regression Analysis with Excel

Section 5.5 is optional because it specifically addresses Microsoft Excel software, which you are not required to have in order to take this course. Regardless, regression analysis is an important part of managerial accounting. It provides the best fit between independent variables and allows the best estimations to be made, through extrapolation. The following section provides students with a guide to performing regression analysis with Microsoft Excel. Most spreadsheet programs provide this function.