4.6 Using Computer Software for Regression
Software such as Excel 2016, Excel QM, and QM for Windows is usually used for the regression calculations. All of these will be illustrated using the Triple A Construction example.
Excel 2016
To use Excel 2016 for regression, enter the data in columns. Click the Data tab to access the data ribbon. Then select Data Analysis, as shown in Program 4.1A. If Data Analysis does not appear on the Data ribbon, the Excel add-in for this has not yet been activated. See Appendix F at the end of the book for instructions on how to activate this. Once this add-in is activated, it will remain on the Data ribbon for future use.
When the Data Analysis window opens, scroll down to and highlight Regression and click
Get Quantitative Analysis for Management, 13/e now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
