Weibull Worksheet

Since I know that all of you at home have been dying to make your very own Weibull curves, I'm releasing another fun tool today.  It's a Weibull Worksheet that allows you to generate Weibull run distributions and associated charts with only a few pieces of information:

  1. The average number of runs allowed (or scored) for a team.
  2. The run environment, which is the average total number of runs scored in a game by both teams.  You can "grain" this any way you like - I prefer coarse grain run environments which take into account league and era, but I suppose you could use fine grain run environments which take into account league, era, teams, and park.  All standard sample size caveats apply, blah blah blah.
Here's how it works.  Right click on the link below and "save as" to download the Excel File "Weibull_Worksheet.xls"

Weibull_Worksheet.xls

Once you've opened the worksheet, you'll see three sheets: Engine, Freq Char, and Cum Freq Chart.  In the Engine sheet, you'll see an Input and an Output section.  In the input section, there are three cells with are highlighted in green: RE, , and .  In the RE cell, enter the run environment; in the cell, enter the average number of runs allowed by a team; and in the cell, enter the number of runs scored by a team.

Technical note: the parameter α is computed such that the actual or matches the model or .  I do realize that a better way to do this would be to minimize the least squares error, but I was too lazy to do it.  The parameter generated here is close enough for almost any application.  The parameter γ is calculated using the Smyth-Patriot model.

That is enough information to generate two Weibull curves: one for runs allowed and one for runs scored.  

In the output section, you'll find the frequency with which a particular number of runs are scored as a function of runs for both runs allowed and runs scored.  These data are used to generate the Frequency Chart on the Freq Chart tab.  You'll also find in the output section the cumulative frequency with which a particular number of runs are scored (e.g., the frequency with which 4 or fewer runs are scored) as a function of runs for both runs allowed and runs scored.  These data are used to generate the Cumulative Frequency Chart on the Freq Chart tab.

I hope you find this enjoyable and useful.  More run distribution resources:

Criticism and questions welcome in the comments.  (Accolades will also be accepted.)
SB Nation Featured Video
X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Beyond the Box Score

You must be a member of Beyond the Box Score to participate.

We have our own Community Guidelines at Beyond the Box Score. You should read them.

Join Beyond the Box Score

You must be a member of Beyond the Box Score to participate.

We have our own Community Guidelines at Beyond the Box Score. You should read them.

Spinner.vc97ec6e

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9351_tracker