Spreadsheet: 718655d1613259244-forecast-function-and-drop-down-iferror-and-double-reciprocal-of-sumproduct-jceurovision-
Sheet: Sheet1

State | 1900 | 1904 | 1908 | 1912 | 1916 | 1920 | 1924 | 1928 | 1932 | 1936 | 1940 | 1944 | 1948 | 1952 | 1956 | 1960 | 1964 | 1968 | 1972 | 1976 | 1980 | 1984 | 1988 | 1992 | 1996 | 2000 | 2004 | 2008 | 2012 | 2016 | 2020 | Average
Alabama | 26 | 52.72 | 46.7 | 50.7 | 54.12 | 24.58 | 44.67 | 2.84 | 70.61 | 73.56 | 70.88 | 63.08 | 60.71 | 29.53 | 17.14 | 14.23 | -38.9 | 47.13 | -46.89 | 13.11 | -1.3 | -22.26 | -19.3 | -6.77 | -6.97 | -14.88 | -25.62 | -21.58 | -22.19 | -27.73 | -25.46
Alaska |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1.88 | 31.82 | -2.64 | -23.51 | -22.25 | -27.94 | -36.79 | -23.32 | -9.17 | -17.53 | -30.95 | -25.55 | -21.54 | -13.99 | -14.73 | -10.06
Arizona |  |  |  | 14.23 | 21.8 | -11.22 | -5.79 | -15.34 | 36.5 | 42.92 | 27.48 | 17.9 | 9.97 | -1.95 | -21.21 | -33.88 | -32.36 | -16.57 | -31.26 | -19.76 | -0.9900000000000001 | -11.16 | -22.09 | -16.7 | 2.22 | -6.28 | -10.45 | -8.48 | -9.04 | -3.5 | 0.31
Arkansas | 28.42 | 15.1 | 20.02 | 34.55 | 37.23 | 19.76 | 31.93 | 20.96 | 73.06 | 63.94 | 58.03 | 40.11 | 40.71 | 12.14 | 6.64 | 7.13 | 12.66 | 7.64 | -38.11 | 30.01 | -0.61 | -22.18 | -14.18 | 17.12 | 16.94 | -5.44 | -9.76 | -19.85 | -23.69 | -26.92 | -27.62
California | -13.13 | -34.9 | -22.48 | -0.03 | 0.38 | -41.93 | -24.07 | -30.5 | 21 | 35.26 | 16.1 | 13.51 | 0.44 | -14.56 | -11.11 | -0.55 | 18.32 | -3.08 | -13.46 | -1.78 | -16.78 | -16.25 | -3.57 | 13.39 | 12.89 | 11.8 | 9.95 | 24.02 | 23.09 | 29.98 | 29.15
Colorado | 13.4 | -14.18 | 1.12 | 15.71 | 25.99 | -23.39 | -35.04 | -30.78 | 13.38 | 23.28 | -2.55 | -6.81 | 5.35 | -21.31 | -19.68 | -9.73 | 23.07 | -9.14 | -28.01 | -11.47 | -24 | -28.32 | -7.78 | 4.26 | -1.37 | -8.36 | -4.67 | 8.95 | 5.36 | 4.91 | 13.5
Connecticut | -15.85 | -19.98 | -23.5 | 3.28 | -3.15 | -29.69 | -34.01 | -8.06 | -1.14 | 14.98 | 7.14 | 5.36 | -1.64 | -11.79 | -27.46 | 7.46 | 35.72 | 5.16 | -18.44 | -5.17 | -9.63 | -21.9 | -5.1 | 6.43 | 18.14 | 17.47 | 10.37 | 22.37 | 17.33 | 13.64 | 20.03
Delaware | -8.77 | -9.94 | -6.16 | 13.62 | -2.43 | -13.65 | -20.9 | -30.42 | -2.44 | 9.77 | 9.65 | 9.11 | -1.28 | -3.88 | -10.47 | 1.64 | 22.17 | -3.51 | -20.41 | 5.41 | -2.33 | -19.85 | -12.4 | 8.19 | 15.23 | 13.06 | 7.59 | 24.98 | 18.63 | 11.37 | 18.97
District of Columbia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86.75 | 86.78 | 83.63000000000001 | 85.92 | 79.84 | 76.2 | 75.85 | 75.55 | 68.34 | 71.66 | 61.49 | 65.12 | 56.54 | 63.63999999999999 | 71
Florida | 52.76 | 47.65 | 41.43 | 60.07 | 51.25 | 31.34 | 28.81 | -16.72 | 49.64 | 52.18 | 48.03 | 40.65 | 15.18 | -10.02 | -14.54 | -3.03 | 2.3 | -9.6 | -44.12 | 5.28 | -17.02 | -30.66 | -22.36 | -1.89 | 5.7 | -0.01 | -5.01 | 2.81 | 0.88 | -1.19 | -3.35
Georgia | 38.65 | 45.4 | 23.39 | 58.53 | 66.63 | 44.43 | 55.77 | 13.19 | 83.83 | 74.5 | 70.02 | 63.49 | 40.5 | 39.32 | 33.83 | 25.11 | -8.25 | 12.43 | -50.39 | 33.78 | 14.81 | -20.39 | -20.25 | 0.59 | -1.17 | -11.69 | -16.59 | -5.2 | -7.8 | -5.09 | 0.24
Hawaii |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.06 | 57.52 | 21.12 | -24.96 | 2.53 | 1.9 | -11.28 | 9.52 | 11.4 | 25.29 | 18.33 | 8.74 | 45.26 | 42.71 | 32.18 | 29.46
Idaho | 3.83 | -40.37 | -16.92 | 1.05 | 10.91 | -31.26 | -10.6 | -29.3 | 20.39 | 29.77 | 9.05 | 3.49 | 2.73 | -31 | -22.39 | -7.57 | 1.83 | -26.13 | -38.2 | -22.76 | -41.27 | -45.97 | -26.07 | -13.61 | -18.54 | -39.53 | -38.12 | -25.3 | -31.69 | -31.76 | -30.76
Illinois | -8.39 | -28.34 | -15.5 | 1.62 | -9.23 | -42.3 | -35.48 | -14.65 | 13.19 | 18.01 | 2.43 | 3.47 | 0.84 | -9.9 | -19.23 | 0.19 | 18.94 | -2.92 | -18.52 | -1.97 | -7.93 | -12.88 | -2.08 | 14.24 | 17.51 | 12.01 | 10.34 | 25.1 | 16.84 | 16.88 | 16.97
Indiana | -3.99 | -13.77 | -1.49 | 18.32 | -0.97 | -14.65 | -16.57 | -20.09 | 11.72 | 14.74 | -1.42 | -5.65 | -0.8 | -17.12 | -20.2 | -10.43 | 12.42 | -12.3 | -32.77 | -7.62 | -18.35 | -23.99 | -20.16 | -6.11 | -5.58 | -15.63 | -20.68 | 1.03 | -10.2 | -18.99 | -16.06
Iowa | -18.58 | -32.69 | -15.05 | 4.77 | -11.36 | -45.44 | -26.93 | -24.2 | 17.71 | 11.71 | -4.41 | -4.5 | 2.73 | -28.17 | -18.41 | -13.49 | 23.97 | -12.19 | -17.13 | -1.01 | -12.7 | -7.39 | 10.22 | 6.01 | 10.34 | 0.31 | -0.67 | 9.53 | 5.81 | -9.41 | -8.2
Kansas | -6.6 | -38.59 | -9.58 | 6.42 | 5.86 | -32.23 | -37.94 | -44.96 | 9.43 | 7.72 | -14.47 | -21.07 | -9.02 | -38.27 | -31.23 | -21.35 | 9.03 | -20.13 | -38.15 | -7.55 | -24.56 | -33.67 | -13.23 | -5.14 | -18.21 | -20.8 | -25.38 | -14.92 | -21.59 | -20.38 | -14.65
Kentucky | 1.71 | 2.69 | 1.71 | 22.94 | 5.41 | 0.44 | -2.96 | -18.87 | 18.91 | 18.6 | 15.15 | 9.23 | 15.26 | 0.07 | -9.09 | -7.18 | 28.36 | -6.14 | -28.6 | 7.19 | -1.46 | -20.66 | -11.64 | 3.21 | 0.96 | -15.13 | -19.86 | -16.22 | -22.68 | -29.84 | -25.94
Louisiana | 58.07 | 78.84 | 72.7 | 65.1 | 78.95 | 38.75 | 56.21 | 52.58 | 85.77 | 77.66 | 71.8 | 61.2 | 16.32 | 5.84 | -13.78 | 21.83 | -13.63 | 20.11 | -36.97 | 5.78 | -5.45 | -22.6 | -10.21 | 4.61 | 12.07 | -7.68 | -14.51 | -18.63 | -17.21 | -19.64 | -18.61
Maine | -27.05 | -38.95 | -29.7 | 2.02 | -4.02 | -39.12 | -50.2 | -37.66 | -12.64 | -13.97 | -2.33 | -4.99 | -14.47 | -32.28 | -41.73 | -14.1 | 37.66 | 12.23 | -22.98 | -0.84 | -3.36 | -22.05 | -11.45 | 8.33 | 20.86 | 5.11 | 9 | 17.32 | 15.29 | 2.96 | 9.07
Maine-CD1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1.32 | -3.09 | -19.74 | -100 | 100 | 100 | 7.93 | 11.93 | 22.82 | 21.39 | 14.81 | 23.09
Maine-CD2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.27 | -19.54 | -24.69 | -100 | 100 | 100 | 1.87 | 5.82 | 11.26 | 8.56 | -10.29 | -7.44
Maryland | -5.27 | -0.02 | -0.25 | 23.66 | 8.02 | -12.95 | -4 | -14.74 | 25.46 | 25.31 | 17.42 | 3.7 | -1.39 | -11.54 | -20.07 | 7.23 | 30.94 | 1.64 | -23.9 | 6.07 | 2.96 | -5.49 | -2.91 | 14.18 | 15.99 | 16.39 | 12.98 | 25.44 | 26.08 | 26.42 | 33.21
Massachusetts | -19.74 | -20.69 | -24.17 | 3.58 | -3.93 | -40.7 | -37.41 | 1.09 | 4 | 9.46 | 6.75 | 5.81 | 11.5 | -8.76 | -18.95 | 20.67 | 18.95 | 30.12 | 8.97 | 15.67 | -0.15 | -2.79 | 7.85 | 18.52 | 33.39 | 27.3 | 25.16 | 25.81 | 23.15 | 27.2 | 33.46
Michigan | -19.21 | -43.72 | -29.49 | -11.31 | -8.04 | -50.5 | -62.24 | -41.44 | 7.92 | 17.56 | -0.33 | 1.02 | -1.67 | -11.47 | -11.48 | 2.01 | 33.61 | 6.73 | -14.39 | -5.39 | -6.49 | -18.99 | -7.9 | 7.4 | 13.21 | 5.13 | 3.42 | 16.44 | 9.47 | -0.22 | 2.78
Minnesota | -24.52 | -55.13 | -26.09 | -5.81 | -0.1 | -51.16 | -9.92 | -16.94 | 23.62 | 30.83 | 3.83 | 5.55 | 17.27 | -11.22 | -7.6 | 1.43 | 27.76 | 12.53 | -5.51 | 12.87 | 3.94 | 0.18 | 7.02 | 11.63 | 16.14 | 2.4 | 3.48 | 10.24 | 7.69 | 1.51 | 7.11
Mississippi | 77.89 | 85.49 | 83.59 | 83.39 | 87.87 | 69.95 | 81.79 | 64.2 | 92.44 | 94.28 | 91.51 | 87.12 | 77.09 | 20.87 | 33.78 | 2.64 | -74.28 | 40.44 | -58.57 | 1.88 | -1.32 | -24.39 | -20.82 | -8.92 | -5.13 | -16.91 | -19.69 | -13.17 | -11.5 | -17.8 | -16.54
Missouri | 5.53 | -3.9 | -0.09 | 17.6 | 3.65 | -11.43 | -5.79 | -11.43 | 28.62 | 22.59 | 4.77 | 2.94 | 16.61 | -1.56 | 0.22 | 0.52 | 28.1 | -1.13 | -24.59 | 3.63 | -6.81 | -20.05 | -3.98 | 10.15 | 6.3 | -3.34 | -7.2 | -0.13 | -9.36 | -18.51 | -15.39
Montana | 18.64 | -20.42 | -4.37 | 6.87 | 19.31 | -29.08 | -4.6 | -17.89 | 22.73 | 41.69 | 18.61 | 9.35 | 9.94 | -19.31 | -14.27 | -2.5 | 18.38 | -9.01 | -20.08 | -7.44 | -24.39 | -22.3 | -5.87 | 2.51 | -2.88 | -25.07 | -20.5 | -2.38 | -13.64 | -20.23 | -16.37
Nebraska | -3.24 | -37.94 | 1.54 | 14.56 | 14.29 | -33.41 | -17.51 | -27.01 | 27.7 | 16.4 | -14.37 | -17.16 | -8.31 | -38.31 | -31.03 | -24.14 | 5.21 | -28.01 | -41 | -20.74 | -39.49 | -41.74 | -20.96 | -17.18 | -18.7 | -28.99 | -33.22 | -14.93 | -21.78 | -25.05 | -19.06
Nebraska-CD1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -12 | -22.98 | -27.27 | -9.77 | -16.6 | -20.72 | -14.92
Nebraska-CD2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -15 | -18.4 | -21.72 | 1.22 | -7.15 | -2.24 | 6.64
Nebraska-CD3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -30 | -46.41 | -51.19 | -39.01 | -42.42 | -54.18 | -53.18
Nevada | 24.5 | -23.79 | 1.78 | 11.76 | 16.96 | -20.7 | -5.48 | -13.07 | 38.82 | 45.62 | 20.15 | 9.24 | 3.11 | -22.89 | -15.94 | 2.32 | 17.16 | -8.16 | -27.36 | -4.36 | -35.64 | -33.88 | -20.94 | 2.63 | 1.02 | -3.55 | -2.59 | 12.49 | 6.68 | 2.42 | 2.39
New Hampshire | -20.91 | -22.28 | -21.76 | 2.04 | 0.06 | -20.45 | -25.11 | -17.63 | -1.43 | 1.75 | 6.44 | 4.24 | -5.75 | -21.84 | -32.27 | -6.84 | 27.78 | -8.18 | -29.12 | -11.28 | -29.39 | -37.71 | -26.16 | 1.22 | 9.95 | -1.27 | 1.37 | 9.61 | 5.58 | 0.37 | 7.35
New Jersey | -14.18 | -18.63 | -17.71 | 7.6 | -11.72 | -39.23 | -34.75 | -19.98 | 1.9 | 19.97 | 3.62 | 1.35 | -4.39 | -14.83 | -30.46 | 0.8 | 31.75 | -2.13 | -24.8 | -2.16 | -13.42 | -20.89 | -13.64 | 2.37 | 17.86 | 15.83 | 6.68 | 15.53 | 17.74 | 13.98 | 15.89
New Mexico |  |  |  | 5.48 | 3.56 | -10.4 | -5.5 | -18.16 | 26.96 | 26.2 | 13.31 | 7.03 | 13.45 | -11.11 | -16.02 | 0.74 | 18.98 | -12.1 | -24.49 | -2.47 | -18.18 | -20.48 | -4.96 | 8.56 | 7.33 | 0.06 | -0.79 | 15.13 | 10.15 | 8.21 | 10.79
New York | -9.27 | -10.85 | -12.37 | 12.6 | -7.02 | -37.6 | -26.63 | -2.35 | 12.73 | 19.88 | 3.55 | 5.01 | -0.99 | -11.9 | -22.41 | 5.26 | 37.25 | 5.46 | -17.34 | 4.42 | -2.67 | -8.01 | 4.1 | 15.85 | 28.86 | 25 | 18.29 | 26.86 | 28.18 | 22.49 | 23.09
North Carolina | 8.46 | 20.04 | 8.73 | 30.9 | 16.39 | 13.48 | 19.17 | -9.87 | 40.65 | 46.8 | 48.06 | 33.43 | 25.34 | 7.82 | 1.33 | 4.22 | 12.3 | -8.25 | -40.58 | 11.05 | -2.12 | -24 | -16.26 | -0.79 | -4.69 | -12.83 | -12.43 | 0.33 | -2.04 | -3.66 | -1.35
North Dakota | -26.59 | -54.73 | -26.23 | 4.42 | 1.5 | -59.6 | -2.52 | -10.34 | 41.58 | 33.03 | -10.88 | -8.35 | -8.76 | -42.58 | -23.63 | -10.9 | 16.09 | -17.71 | -26.28 | -5.85 | -37.97 | -31.04 | -13.06 | -12.03 | -6.81 | -27.6 | -27.36 | -8.65 | -19.63 | -35.73 | -33.36
Ohio | -6.64 | -25.43 | -6.2 | 14.14 | 7.67 | -19.88 | -34.63 | -30.43 | 2.85 | 20.56 | 4.41 | -0.37 | 0.24 | -13.51 | -22.23 | -6.57 | 25.89 | -2.28 | -21.56 | 0.27 | -10.6 | -18.76 | -10.85 | 1.83 | 6.36 | -3.51 | -2.11 | 4.58 | 2.97 | -8.07 | -8.02
Oklahoma |  |  | 4.66 | 11.18 | 17.4 | -5.5 | 5.59 | -28.28 | 46.59 | 34.14 | 15.18 | 11.36 | 25.49 | -9.18 | -10.26 | -18.04 | 11.49 | -15.7 | -49.7 | -1.21 | -25.53 | -37.94 | -16.65 | -8.62 | -7.81 | -21.88 | -31.14 | -31.29 | -33.54 | -36.39 | -33.09
Oregon | -16.05 | -47.62 | -22.08 | 6.91 | -2.57 | -26.65 | -26.54 | -30.04 | 21.11 | 34.79 | 8.07 | 4.85 | -3.39 | -21.61 | -10.49 | -5.24 | 27.75 | -6.05 | -10.12 | -0.17 | -9.66 | -12.17 | 4.67 | 9.95 | 8.09 | 0.44 | 4.16 | 16.35 | 12.09 | 10.98 | 16.09
Pennsylvania | -24.58 | -40.67 | -23.43 | -4.04 | -14.03 | -38.56 | -46.26 | -31.35 | -5.51 | 16.04 | 6.89 | 2.78 | -4.01 | -5.88 | -13.19 | 2.32 | 30.22 | 3.57 | -19.98 | 2.66 | -7.11 | 7.35 | -2.32 | 9.02 | 9.2 | 4.17 | 2.5 | 10.31 | 5.38 | -0.72 | 1.18
Rhode Island | -24.71 | -24.42 | -26.6 | 3.48 | -5.08 | -31.19 | -23.17 | 0.61 | 11.77 | 12.92 | 13.55 | 17.33 | 16.16 | -1.84 | -16.52 | 27.26 | 61.74 | 32.25 | -6.19 | 11.28 | 10.47 | -3.65 | 11.71 | 18.02 | 32.89 | 29.08 | 20.75 | 27.81 | 27.46 | 15.51 | 20.77
South Carolina | 85.91 | 90.73 | 87.89 | 93.37 | 94.28 | 92.14 | 94.35 | 82.85 | 96.13 | 97.15 | 91.26 | 80.1 | 47.82 | 1.44 | 15.92 | 2.48 | -17.79 | -5.79 | -42.66 | 13.04 | -1.53 | -27.99 | -23.92 | -8.15 | -6.04 | -15.93 | -17.08 | -8.98 | -10.47 | -14.27 | -11.68
South Dakota | -15.59 | -49.42 | -23.76 | -8.48 | -3.9 | -41.02 | -12.73 | -20.98 | 29.23 | 11.52 | -14.82 | -16.66 | -4.8 | -38.54 | -16.77 | -16.43 | 11.22 | -11.31 | -8.63 | -1.48 | -28.83 | -26.47 | -6.34 | -3.52 | -3.46 | -22.73 | -21.47 | -8.41 | -18.02 | -29.79 | -26.16
Tennessee | 8.08 | 10.83 | 6.86 | 28.8 | 13.61 | -3.1 | 9.31 | -7.72 | 34.01 | 37.97 | 34.9 | 21.23 | 12.26 | -0.27 | -0.62 | -7.14 | 11.01 | -3.83 | -37.95 | 13 | -0.29 | -16.27 | -16.34 | 4.65 | 2.41 | -3.86 | -14.3 | -15.06 | -20.38 | -26.01 | -23.21
Texas | 32.28 | 49.55 | 51.62 | 63.28 | 59.47 | 35.8 | 53.93 | -3.67 | 76.72 | 74.76 | 62.01 | 54.78 | 41.68 | -6.44 | -11.28 | 2 | 26.82 | 1.27 | -32.96 | 3.17 | -13.86 | -27.5 | -12.6 | -3.48 | -4.93 | -21.32 | -22.86 | -11.75 | -15.77 | -8.97 | -5.58
Utah | -2.29 | -28.56 | -16.97 | -4.91 | 20.96 | -17.09 | -19.32 | -7.72 | 15.47 | 39.55 | 24.67 | 21.02 | 8.96 | -17.85 | -29.12 | -9.64 | 9.73 | -19.42 | -41.25 | -28.79 | -52.2 | -49.83000000000001 | -34.17 | -16.02 | -21.07 | -40.48999999999999 | -45.54000000000001 | -27.98 | -47.88 | -17.88 | -20.25
Vermont | -52.87 | -59.13 | -53.25 | -1.91 | -27.21 | -52.56999999999999 | -62.55 | -34 | -16.58 | -13.15 | -9.86 | -14.12 | -24.61 | -43.22 | -44.35 | -17.3 | 32.61 | -9.22 | -26.2 | -11.2 | -5.96 | -17.11 | -3.52 | 15.7 | 22.26 | 9.94 | 20.14 | 37.01 | 35.6 | 26.41 | 35.41
Virginia | 11.47 | 24.9 | 22.16 | 48.95 | 34.72 | 23.47 | 29.7 | -8.01 | 38.38 | 40.84 | 36.52 | 24.98 | 6.85 | -12.97 | -17.01 | -5.47 | 7.36 | -10.87 | -37.72 | -1.34 | -12.72 | -25.19 | -20.5 | -4.37 | -1.96 | -8.04 | -8.2 | 6.3 | 3.87 | 5.32 | 10.11
Washington | -11.74 | -50.6 | -25.76 | -8.32 | 4.25 | -34.82 | -16.49 | -35.75 | 23.52 | 36.5 | 17.64 | 14.61 | 9.93 | -9.64 | -8.47 | -2.41 | 24.59 | 2.11 | -18.28 | -3.88 | -12.34 | -12.97 | 1.59 | 11.44 | 12.54 | 5.58 | 7.17 | 17.08 | 14.77 | 15.71 | 19.2
West Virginia | -9.52 | -13.24 | -10.25 | 12.68 | -0.94 | -12 | -5.38 | -17.39 | 10 | 21.35 | 14.2 | 9.78 | 15.08 | 3.85 | -8.16 | 5.47 | 35.87 | 8.82 | -27.22 | 16.14 | 4.51 | -10.51 | 4.74 | 13.02 | 14.75 | -6.32 | -12.86 | -13.09 | -26.69 | -41.67 | -38.94
Wisconsin | -24.09 | -35.2 | -17.84 | 8.41 | -6.59 | -54.92 | -16.9 | -9.24 | 32.26 | 33.54 | 1.82 | -1.8 | 4.41 | -22.25 | -23.74 | -3.72 | 24.35 | -3.62 | -9.67 | 1.68 | -4.72 | -9.18 | 3.62 | 4.35 | 10.33 | 0.22 | 0.38 | 13.9 | 6.94 | -0.76 | 0.63
Wyoming | -17.49 | -37.64 | -15.76 | 1.77 | 12.77 | -32.29 | -20.88 | -28.31 | 15.25 | 23.1 | 5.93 | -2.47 | 4.35 | -25.62 | -20.16 | -10.03 | 13.12 | -20.25 | -38.54 | -19.49 | -34.67 | -42.27 | -22.52 | -5.58 | -12.98 | -40.06 | -39.79 | -32.24 | -40.82 | -46.3 | -43.38