MLB Payroll and Wins Analysis

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	Year	ARI	ATL	BAL	BOS	CHC	CHW	CIN	CLE	COL	DET	HOU	KCR	LAA	LAD	MIA	MIL	MIN	NYM	NYY	OAK	PHI	PIT	SDP	SFG	SEA	STL	TBR	TEX	TOR	WSN	ST DEV WINS BY YEAR
2	2019	85	97	54	84	84	72	75	93	71	47	107	59	72	106	57	89	101	86	103	97	81	69	70	77	68	91	96	78	67	93	15.63
3	2018	82	90	47	108	95	62	67	91	91	64	103	58	80	92	63	96	78	77	100	97	80	82	66	73	89	88	90	67	73	82	14.47
4	2017	93	72	75	93	92	67	68	102	87	64	101	80	80	104	77	86	85	70	91	75	66	75	71	64	78	83	80	78	76	97	11.34
5	2016	69	68	89	93	103	78	68	94	75	86	84	81	74	91	79	73	59	87	84	69	71	78	68	87	86	86	68	95	89	95	10.49
6	2015	79	67	81	78	97	76	64	81	68	74	86	95	85	92	71	68	83	90	87	68	63	98	74	84	76	100	80	88	93	83	10.28
7	2014	64	79	96	71	73	73	76	85	66	90	70	89	98	94	77	82	70	79	84	88	73	88	77	88	87	90	77	67	83	96	9.44
8	2013	81	96	85	97	66	63	90	92	74	93	51	86	78	92	62	74	66	74	85	96	73	94	76	76	71	97	92	91	74	86	12.05
9	2012	81	94	93	69	61	85	97	68	64	88	55	72	89	86	69	83	66	74	95	94	81	79	76	94	75	88	90	93	73	98	11.73
10	2011	94	89	69	90	71	79	79	80	73	95	56	71	86	82	72	96	63	77	97	74	102	72	71	86	67	90	91	96	81	80	11.22
11	2010	65	91	66	89	75	88	91	69	83	81	76	67	80	80	80	77	94	79	95	81	97	57	90	92	61	86	96	90	85	69	10.82
12	2009	70	86	64	95	83	79	78	65	92	86	74	65	97	95	87	80	87	70	103	75	93	62	75	88	85	91	84	87	75	59	11.24
13	2008	82	72	68	95	97	89	74	81	74	74	86	75	100	84	84	90	88	89	89	75	92	67	63	72	61	86	97	79	86	59	10.9
14	2007	90	84	69	96	85	72	72	96	90	88	73	69	94	82	71	83	79	88	94	76	89	68	89	71	88	78	66	75	83	73	9.14
15	2006	76	79	70	86	66	90	80	78	76	95	82	62	89	88	78	75	96	97	97	93	85	67	88	76	78	83	61	80	87	71	9.91
16	2005	77	90	74	95	79	99	73	93	67	71	89	56	95	71	83	81	83	83	95	88	88	67	82	75	69	100	67	79	80	81	10.65
17	2004	51	96	78	98	89	83	76	80	68	72	92	58	92	93	83	67	92	71	101	91	86	72	87	91	63	105	70	89	67	67	13.32
18	2003	84	101	71	95	88	86	69	68	74	43	87	83	77	85	91	68	90	66	101	96	86	75	64	100	93	85	63	71	86	83	13.14
19	2002	98	101	67	93	67	81	78	74	73	55	84	62	99	92	79	56	94	75	103	103	80	72	66	95	93	97	55	72	78	83	14.51
20	2001	92	88	63	82	88	83	66	91	73	66	93	65	75	86	76	68	85	82	95	102	86	62	79	90	116	93	62	73	80	68	12.79
21	2000	85	95	74	85	65	95	85	90	82	79	72	77	82	86	79	73	69	94	87	91	65	69	76	97	91	95	69	71	83	67	9.82
22	AVERAGE	79.9	86.75	72.65	89.6	81.2	80	76.3	83.55	76.05	75.55	81.05	71.5	86.1	89.05	75.9	78.25	81.4	80.4	94.3	86.45	81.85	73.65	75.4	83.8	79.75	90.6	77.7	80.95	79.95	79.5	11.64
23	STDEV	11.35	10.38	11.82	9.18	12.27	9.73	8.68	10.51	8.37	15.05	15.06	11.09	8.83	7.76	8.36	10.09	11.88	8.42	6.36	10.95	10.46	10.24	8.18	9.83	13.39	6.61	13.26	9.21	6.86	12.13	1.76
24	Seasons 95+	1	6	1	8	4	2	1	2	0	2	3	1	5	3	0	2	2	1	12	6	2	1	0	3	1	6	3	2	0	4
25	Seasons 70-	5	2	10	1	5	3	6	4	5	6	4	10	0	0	4	5	6	3	0	2	3	9	6	1	6	0	9	2	2	6
26	Difference	-4	4	-9	7	-1	-1	-5	-2	-5	-4	-1	-9	5	3	-4	-3	-4	-2	12	4	-1	-8	-6	2	-5	6	-6	0	-2	-2
27	Win Rank	18	5	29	3	12	16	23	9	24	26	13	30	7	4	25	21	11	15	1	6	10	28	27	8	19	2	22	14	17	20
28	Payroll Rank	19	13	16	2	5	17	21	23	20	8	15	24	4	3	29	25	22	6	1	27	9	28	26	7	11	10	30	12	14	18
29	Difference	1	8	-13	-1	-7	1	-2	14	-4	-18	2	-6	-3	-1	4	4	11	-9	0	21	-1	0	-1	-1	-8	8	8	-2	-3	-2
30	Abs Difference	1	8	13	1	7	1	2	14	4	18	2	6	3	1	4	4	11	9	0	21	1	0	1	1	8	8	8	2	3	2
31	Average Rank Differential	5.47
32
33	Data from baseball reference	https://www.baseball-reference.com/leagues/MLB/index.shtml
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100