I'm working on a research project for my sports economics class, and am having some difficulties with my data. I'm a little weak with statistics and am unsure how to approach the regression. As in what should be my independent variable/ dependent variables, which to isolate in excel. Essentially what i'm trying to see is if player performance is effected by contract negotiations so I am analyzing the performance immediately before and after contract negotiations and regressing that performance (I suppose this would be my "Y"). The contract year in my data is highlighted, as in the highlighted year is the performance after the off season contract negotiation and the cell before the highlighted one is the year immediately before the new contract. Any guidance would be greatly appreciated. Let me know if anything is unclear and I will follow up. Data is attached.
527.3 KB Views: 7