But there are dozens of great tutorials out there on the subject.
NOTE: For those wondering why I haven’t gone into detail about significance testing for P-values, it’s because I believe that field of statistical study is generally arbitrary and altogether intellectually bankrupt. I encourage readers to learn more about regression before attempting any, as they are a complicated and tricky tool and can lead a researcher astray quickly if used incorrectly. Maybe Sack% would be a more useful tool because the sack totals are merely telling us he played more (and QBs who played more probably had better performances because otherwise they would have been benched).Īnyway, I hope this has been helpful. Once you click on Data Analysis, a new window will pop up.
#Linear regression excel 2015 install#
If you don’t see this option, then you need to first install the free Analysis ToolPak. Along the top ribbon in Excel, go to the Data tab and click on Data Analysis. That’s a red flag right there for a bad variable. Step 2: Perform multiple linear regression. Even a QB who has been sacked will only see his Cmp% moved by 1.5%. And it doesn’t take much work realized which variable is more important.
(See that above article for more details.) If you start to see anything other than a circle, in any of your residual plots, then you’ll need to rework your regression.