How to perform a Linear Regression

  • Hey guys, I did this in college but its been awhile. I have 5 columns of baseball attributes (Power, Contact etc on a 20-80 scale) and an output (WAR, which is between -1.5 and 11). Sample size of 753 players.


    I need to be able to create a formula using the 5 attributes to predict a players WAR. How is this done? I have already added in the analysis toolpak, just not sure which test to perform and how to set it up. Assume the Columns are in the B-F columns and WAR is in G column.