Jump to content

  • Welcome!

    Register and log in easily with Twitter or Google accounts!

    Or simply create a new Huddle account. 

    Members receive fewer ads , access our dark theme, and the ability to join the discussion!

     

Actual vs. Expected Wins: Some Interesting Analysis

mr beauxjangles

By mr beauxjangles,
in Carolina Panthers

Recommended Posts

mr beauxjangles Newbie

mr beauxjangles

Posted
Posted

I did this last night and thought I'd share. A little background. My education is in economics and statistics, and I wanted to start playing around with some stats and start building a model to predict wins and other game statistics. What follows below is just the beginning.

To build a model like this, you have to leverage a technique called regression analysis. I won't bother explaining it, but you can check out Wikipedia if you'd like. In short, regression analysis allows you to estimate the effect of one thing on another thing, all other things being constant. So last night I decided to look at the effect of average margin of victory on win-loss records. Once you estimate the equation that includes the impact of average margin of victory on wins, you can estimate the expected number of wins for each team. Again, what I've done here is very basic, and I'm going to beef it up a lot in the coming months.

In the table below:

The second column is average margin of victory.

The third column is actual wins in 08-09.

The fourth column is what the model predicts based on average margin of victory.

The fifth column is the difference between actual and expected wins.

ActualvsExpected0809.jpg

Basically, this gives us a measure of the degree to which a team underachieved or overachieved based on their average margin of victory.

Those with a positive difference (where expected was greater than actual) are the overachievers. Those with with a negative difference are the underachievers.

Miami and Denver were the biggest overachievers, and there we were at #4, with an expected record of 10-6 based on average margin of victory alone. Green Bay, San Diego, and Phili were the biggest underachievers based on margin of victory.

That's all for now. Hopefully I'll be back with some more interesting stuff in the weeks ahead.

Link to comment
Share on other sites
Lt Pinkerton Newbie

Lt Pinkerton

Posted
Posted

Really cool.

Basically we won more games than we should have just looking at our Margin of Victory, That's probably due to Steve Smith and Jake Delhomme Late-Game heroics. It's weird though, I didn't think Detroits MoV was so low... I guess when you lose every game by about 3-5 points it adds up.

Link to comment
Share on other sites
Fireball77 Newbie

Fireball77

Posted
Posted

Let me be the dummy who asks this: how do you arrive at the margin of victory numbers? Take points against and points for and subtract PA from PF then divide by 16? Or do you use the scores of the games, take the point differentials, then average that?

Very interesting topic!

Link to comment
Share on other sites
rayzor Grand Master

rayzor

Posted
Posted

i like it and i have some things i'd like to ask you about it but the first thing i want to know is what you used as the basis for expected wins?

not really a stats background. my education was in telling people that know how to do stats what to do.

Link to comment
Share on other sites
ncbobcat Newbie

ncbobcat

Posted
Posted

I wouldn't have thought that MoV would be an accurate predictor of record, but that numbers seem to make sense. I've looked to try to find one team's figures that I disagree with and really can't argue with any of them.

Good job!

Link to comment
Share on other sites
pstall Newbie

pstall

Posted
Posted

I did this last night and thought I'd share. A little background. My education is in economics and statistics, and I wanted to start playing around with some stats and start building a model to predict wins and other game statistics. What follows below is just the beginning.

To build a model like this, you have to leverage a technique called regression analysis. I won't bother explaining it, but you can check out Wikipedia if you'd like. In short, regression analysis allows you to estimate the effect of one thing on another thing, all other things being constant. So last night I decided to look at the effect of average margin of victory on win-loss records. Once you estimate the equation that includes the impact of average margin of victory on wins, you can estimate the expected number of wins for each team. Again, what I've done here is very basic, and I'm going to beef it up a lot in the coming months.

In the table below:

The second column is average margin of victory.

The third column is actual wins in 08-09.

The fourth column is what the model predicts based on average margin of victory.

The fifth column is the difference between actual and expected wins.

ActualvsExpected0809.jpg

Basically, this gives us a measure of the degree to which a team underachieved or overachieved based on their average margin of victory.

Those with a positive difference (where expected was greater than actual) are the overachievers. Those with with a negative difference are the underachievers.

Miami and Denver were the biggest overachievers, and there we were at #4, with an expected record of 10-6 based on average margin of victory alone. Green Bay, San Diego, and Phili were the biggest underachievers based on margin of victory.

That's all for now. Hopefully I'll be back with some more interesting stuff in the weeks ahead.

*single tear*

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing

  • PMH4OWPW7JD2TDGWZKTOYL2T3E.jpg

  • Topics

  • Posts

    • poorboysrev
      BREAKING: Panthers sign QB Kenny Pickett

      By poorboysrev · Posted

      Right...I think they've done really well. No one's going to bat 1000% but they've addressed areas of need and there's no comparison to the overall talent of the team now than when DC and then Morgan got the reigns. This whole season is about seeing how much of a step up can Bryce and this team make. If Bryce can't and last year is as good as it gets for him then at least we have a talented roster for the next guy. I think we're going to be good this season 
    • SmokinwithWilly
      BREAKING: Panthers sign QB Kenny Pickett

      By SmokinwithWilly · Posted

      I said could, not would. I recognize he has potential based on past performance. Compared to what KP has done, Howell has more potential and the physical traits to make noise. KP has small hands and a weak arm. Not something you want in even your backup QB.  I've been hammering since last off-season before we re-signed Dalton, improve the room. Other than getting younger, I don't see how anyone can say we legitimately improved the room or even tried. We might as well have signed Josh Rosen.  Dalton is still on the roster for now. That's 3 QBs unless we trade or cut him. He's still Bryce's mentor after all. Do you believe we are going to draft someone with potential and give them a legitimate opportunity to develop from the practice squad? Are we going to carry 3 QBs on the active roster? 4 for a developmental rookie? Are we going to potentially cut KP if we draft a rookie and he's outperformed? Doubtful. Cutting Dalton(if we can't trade him) and KP would be 8m in wasted cap space.  I chose Howell as an example because he showed promise in his only full season as a starter. You could plug in another name with the physical traits and potential and what i said would still apply. KP showed almost nothing and was benched. I genuinely don't care if it’s rookie pick as long as there is the potential to develop into a future NFL QB.  As much as I can't stand him, Bellichek was always developing a number 2 QB even with the GOAT as his starter. The wisdom of that was evident when Cassell came in when Brady was hurt week 1 and went 11-5 and almost made the wildcard, which 11-5 gets you almost any other year. I give credit where it's due though. Cassel and Jimmy G both came into the league as developmental QBs, potential QB1s, and went on to have careers.  You never know if you never try. KP feels like a punt in addressing the most important position on the field. Bryce has never played 2 full games of franchise QB level football back to back.  If Bryce progresses, are you ready to offer a 280m 5 year extension based off a one hit wonder year? If Bryce regresses and we need a QB in 27, are we going to trade a fortune away again to trade up to 1 to get one? Are you ready to do the past 3 years all over again?  To me, it's not about Kenny Pickett. It's about the move itself. It was a feeble attempt to improve the QB room. We better hope Bryce succeeds, because if he doesn't, we literally have no backup plan right now.   
    • WhoKnows
      Center/Interior Line at 19

      By WhoKnows · Posted

      IOL that early isn’t good value at all. We have a LT who might not ever be good again and a RT that might retire soon. T seems deep early in this draft, so I’d go there in the 1st. 
×
×
  • Create New...