A Quick Guide to Using Excel 2007’s Regression Analysis Tool

3 For the data in our sample, the data need not be rearranged. The X variables are together in Columns F through K and the Y variable values are all in Column E. 2. Open the Regression Analysis Tool In the “Data” tab on Excel’s ribbon find the “Analysis”

faculty.fuqua.duke.edu