View the step-by-step solution to:

I need a nested IF statement in Excel in column E2 on the worksheet market indices. This if statement needs to refer to the table on the worksheet...

Please see the attached spreadhseet. I need a nested IF statement in Excel in column E2 on the worksheet market indices. This if statement needs to refer to the table on the worksheet titled Party. Specifically I have Dates in column B of the worksheet market indices. If this date is between the First Year and the Second Year, then I need it to populate with the corresponding Party (Democratic or Republican) for that year.
Date VWRETD EWRETD Party 1/30/1926 0.0 0724 0.023174 2/27/1926 -0.03 374 -0.05351 3/31/1926 -0.064341 -0.096824 4/30/1926 0.038358 0.032946 5/28/1926 0.012172 0.0 1035 6/30/1926 0.0568 8 0.050487 7/31/1926 0.028365 0.013076 8/31/1926 0.028065 0.0310 2 9/30/1926 0.0 589 -0.0 649 10/30/1926 -0.03106 -0.03463 11/30/1926 0.027547 0.0247 6 12/31/1926 0.03046 0.025 16 1/31/1927 0.0 14 9 0.0125 6 2/28/1927 0.045821 0.05 756 3/31/1927 0.0 6245 -0.01929 4/30/1927 0.0 6 38 0.0 7494 5/31/1927 0.056948 0.062691 6/30/1927 -0.020372 -0.019708 7/30/1927 0.075659 0.05808 8/31/1927 0.02705 0.0 4247 9/30/1927 0.049025 0.032308 10/31/1927 -0.041894 -0.038529 11/30/1927 0.068685 0.097 58 12/31/1927 0.023658 0.02967 1/31/1928 -0.0 3541 0.0324 1 2/29/1928 -0.014 16 -0.02 508 3/31/1928 0.090905 0.071583 4/30/1928 0.043168 0.08746 5/31/1928 0.018386 0.037591 6/30/1928 -0.0453 4 -0.069074 7/31/1928 0.010 74 0.0 3047 8/31/1928 0.069607 0.058396 9/29/1928 0.0314 5 0.04924 10/31/1928 0.018 01 0.017469 11/30/1928 0.121287 0.1 5203 12/31/1928 0.0 5262 -0.0 5 52 1/31/1929 0.05209 0.03 526 2/28/1929 -0.0 019 0.0 6487 3/28/1929 -0.0 7971 -0.032105 4/30/1929 0.016786 0.014024 5/31/1929 -0.059109 -0.091046 6/29/1929 0.09 65 0.073428 7/31/1929 0.045348 0.018561 8/30/1929 0.085 8 0.028368 9/30/1929 -0.050 09 -0.04373 10/31/1929 -0.19549 -0.212145 11/27/1929 -0.123267 -0.12 53 12/31/1929 0.017974 -0.025 98 1/31/1930 0.056 4 0.109826 2/28/1930 0.027 01 0.03 59 3/31/1930 0.075027 0.103754 4/30/1930 -0.0208 5 -0.0416 5/29/1930 -0.013252 -0.0372 7 6/30/1930 -0.157873 -0.18 159 7/31/1930 0.039659 0.037631 8/29/1930 0.0 412 -0.017319 9/30/1930 -0.1240 9 -0.150475 10/31/1930 -0.086989 -0.096057 11/29/1930 -0.0259 -0.024128 12/31/1930 -0.078419 -0.136846 1/31/1931 0.062534 0.141828 2/28/1931 0.109401 0.156753 3/31/1931 -0.064041 -0.061871 4/30/1931 -0.098484 -0.15087 5/29/1931 -0.132915 -0.140379 6/30/1931 0.137961 0.18217 7/31/1931 -0.065034 -0.070214 8/31/1931 0.0 2348 -0.018724 9/30/1931 -0.290 7 -0.312753 10/31/1931 0.07916 0.1053 3 11/30/1931 -0.08 7 6 -0.08 216 12/31/1931 -0.13 406 -0.187239 1/30/1932 -0.01078 0.08592 2/29/1932 0.0560 4 0.02 732 3/31/1932 -0.108741 -0.1 9564 4/30/1932 -0.1792 -0.181056 5/31/1932 -0.20752 -0.202303 6/30/1932 -0.0 5089 0.04127 7/30/1932 0.3 7451 0.43 49 8/31/1932 0.36 025 0.6 5936 9/30/1932 -0.0308 5 -0.0594 2 10/31/1932 -0.131 8 -0.164793 11/30/1932 -0.05 696 -0.073874 12/31/1932 0.045762 -0.036 2 1/31/1933 0.0 9781 0.0358 3 2/28/1933 -0.150298 -0.15 4 3 3/31/1933 0.03 9 0.10 121 4/29/1933 0.383683 0.518249 5/31/1933 0.21 85 0.605986 6/30/1933 0.134354 0.2 643 7/31/1933 -0.096081 -0.092417 8/31/1933 0.12127 0.1 45 2 9/30/1933 -0.104652 -0.150 09 10/31/1933 -0.0832 5 -0.1078 7 11/29/1933 0.09 908 0.065094 12/30/1933 0.019 84 0.017242 1/31/1934 0.1297 9 0.315 46 2/28/1934 -0.023275 0.010863 3/31/1934 0.0 4782 0.0 8062 4/30/1934 -0.017934 0.0 0264 5/31/1934 -0.070987 -0.10724 6/30/1934 0.025152 0.0 3578 7/31/1934 -0.108241 -0.186303 8/31/1934 0.059615 0.098561 9/29/1934 -0.0 29 7 -0.01 748 10/31/1934 -0.019316 -0.01923 11/30/1934 0.084073 0.128705 12/31/1934 0.0 389 0.014735 1/31/1935 -0.032808 -0.0296 3 2/28/1935 -0.01859 -0.056016 3/30/1935 -0.037041 -0.073 53 4/30/1935 0.089162 0.101628 5/31/1935 0.0347 6 0.024 01 6/29/1935 0.05 268 0.040189 7/31/1935 0.073647 0.1 0382 8/31/1935 0.026128 0.083084 9/30/1935 0.025872 0.023798 10/31/1935 0.0713 9 0.0827 6 11/30/1935 0.051857 0.145782 12/31/1935 0.046096 0.060243 1/31/1936 0.06 08 0.150165 2/29/1936 0.02569 0.045619 3/31/1936 0.0 9417 0.0 5947 4/30/1936 -0.080497 -0.12 963 5/29/1936 0.050286 0.051218 6/30/1936 0.0259 3 -0.0 0325 7/31/1936 0.064638 0.08193 8/31/1936 0.010813 0.0214 7 9/30/1936 0.014343 0.0326 8 10/31/1936 0.069087 0.06375 11/30/1936 0.03 293 0.091427 12/31/1936 0.0 206 0.027306 1/30/1937 0.032524 0.0762 1 2/27/1937 0.013041 0.023904 3/31/1937 -0.0 3535 0.0 1065 4/30/1937 -0.074236 -0.101024 5/28/1937 -0.0 8563 -0.024524 6/30/1937 -0.041592 -0.076702 7/31/1937 0.08 8 1 0.09 61 8/31/1937 -0.04862 -0.052749 9/30/1937 -0.135401 -0.193182 10/30/1937 -0.094675 -0.101549 11/30/1937 -0.083731 -0.108639 12/31/1937 -0.040104 -0.09 215 1/31/1938 0.0 7625 0.04206 2/28/1938 0.05786 0.061061 3/31/1938 -0.237131 -0.285 64 4/30/1938 0.145642 0.2062 5/31/1938 -0.03923 -0.070462 6/30/1938 0.236062 0.306353 7/30/1938 0.071869 0.121836 8/31/1938 -0.027202 -0.063787 9/30/1938 0.0 85 9 -0.01463 10/31/1938 0.07 848 0.14 539 11/30/1938 -0.018317 -0.03653 12/31/1938 0.041013 0.03 472 1/31/1939 -0.059613 -0.075729 2/28/1939 0.034935 0.041384 3/31/1939 -0.1 9241 -0.173763 4/29/1939 -0.0 23 4 0.0 2429 5/31/1939 0.068729 0.086137 6/30/1939 -0.05283 -0.083 03 7/31/1939 0.101761 0.135497 8/31/1939 -0.06 1 -0.106495 9/30/1939 0.159628 0.391878 10/31/1939 -0.0 3843 -0.0 6939 11/30/1939 -0.0367 8 -0.08131 12/30/1939 0.030342 0.01781 1/31/1940 -0.02402 -0.019 78 2/29/1940 0.0136 4 0.02973 3/30/1940 0.018939 0.026168 4/30/1940 0.0 1 96 0.0131 5 5/31/1940 -0.2 0314 -0.269754 6/29/1940 0.06 6 4 0.06 5 7/31/1940 0.032 3 0.036805 8/31/1940 0.023962 0.0232 1 9/30/1940 0.023028 0.037207 10/31/1940 0.029705 0.049218 11/30/1940 -0.016348 -0.0 16 9 12/31/1940 0.0 681 -0.018789 1/31/1941 -0.040505 -0.0 7317 2/28/1941 -0.014839 -0.019409 3/31/1941 0.0 959 0.014308 4/30/1941 -0.053065 -0.057382 5/31/1941 0.013858 0.010105 6/30/1941 0.058683 0.06 908 7/31/1941 0.059519 0.130139 8/30/1941 -0.0 0463 -0.0 718 9/30/1941 -0.0 7494 -0.0204 8 10/31/1941 -0.051786 -0.06203 11/29/1941 -0.019367 -0.034209 12/31/1941 -0.046728 -0.0818 6 1/31/1942 0.0 7158 0.130814 2/28/1942 -0.024149 -0.017579 3/31/1942 -0.06565 -0.052 4 4/30/1942 -0.043145 -0.04626 5/29/1942 0.061047 0.028 79 6/30/1942 0.025482 0.025086 7/31/1942 0.03487 0.046405 8/31/1942 0.018656 0.028304 9/30/1942 0.0263 0.0475 7 10/31/1942 0.06768 0.101294 11/30/1942 0.0 25 -0.01317 12/31/1942 0.050416 0.035 54 1/30/1943 0.073 03 0.1685 1 2/27/1943 0.059 2 0.13093 3/31/1943 0.06207 0.1 2136 4/30/1943 0.0 6903 0.03546 5/29/1943 0.057158 0.084513 6/30/1943 0.01691 0.010979 7/31/1943 -0.046205 -0.0643 5 8/31/1943 0.012986 0.0 3 73 9/30/1943 0.024527 0.034867 10/30/1943 -0.012 18 -0.0 3943 11/30/1943 -0.058529 -0.08 584 12/31/1943 0.063623 0.09873 1/31/1944 0.018072 0.045949 2/29/1944 0.0 3686 0.013018 3/31/1944 0.024 17 0.041526 4/29/1944 -0.016341 -0.029289 5/31/1944 0.05095 0.06 135 6/30/1944 0.056171 0.104935 7/31/1944 -0.015151 -0.012724 8/31/1944 0.015927 0.030 82 9/30/1944 0.0 0191 0.0 0252 10/31/1944 0.0 2504 0.0 0953 11/30/1944 0.016456 0.023183 12/30/1944 0.0412 4 0.069303 1/31/1945 0.019194 0.043 53 2/28/1945 0.064282 0.0863 9 3/31/1945 -0.038728 -0.056802 4/30/1945 0.07 474 0.08 84 5/31/1945 0.01863 0.030 17 6/30/1945 0.0 342 0.036565 7/31/1945 -0.02 095 -0.035068 8/31/1945 0.061 23 0.065928 9/29/1945 0.048051 0.062646 10/31/1945 0.039018 0.06452 11/30/1945 0.054546 0.097574 12/31/1945 0.01 763 0.024073 1/31/1946 0.063 09 0.09467 2/28/1946 -0.057852 -0.06 906 3/30/1946 0.058716 0.05792 4/30/1946 0.04289 0.052109 5/31/1946 0.039864 0.054749 6/28/1946 -0.03914 -0.048 87 7/31/1946 -0.025465 -0.040842 8/30/1946 -0.06392 -0.075327 9/30/1946 -0.10 202 -0.135 52 10/31/1946 -0.014164 -0.01 814 11/30/1946 0.0 12 -0.0 2634 12/31/1946 0.050925 0.046908 1/31/1947 0.015128 0.030197 2/28/1947 -0.01 57 -0.0 7105 3/31/1947 -0.017058 -0.030425 4/30/1947 -0.047868 -0.08168 5/29/1947 -0.0 9 97 -0.037321 6/30/1947 0.053652 0.057096 7/31/1947 0.04124 0.06167 8/29/1947 -0.017509 -0.01716 9/30/1947 -0.0 4 19 0.0 5783 10/31/1947 0.024614 0.03 156 11/29/1947 -0.018306 -0.029305 12/31/1947 0.030189 0.023863 1/31/1948 -0.03726 -0.016276 2/28/1948 -0.043439 -0.059451 3/31/1948 0.082763 0.095843 4/30/1948 0.037 75 0.040151 5/28/1948 0.074581 0.08763 6/30/1948 -0.0 017 -0.012534 7/30/1948 -0.050421 -0.05373 8/31/1948 0.0 3854 -0.0 1818 9/30/1948 -0.02954 -0.042785 10/30/1948 0.060 56 0.053201 11/30/1948 -0.090626 -0.10632 12/31/1948 0.032 02 0.013703 1/31/1949 0.0 3043 0.017 49 2/28/1949 -0.029464 -0.041302 3/31/1949 0.041521 0.059309 4/30/1949 -0.01786 -0.03149 5/31/1949 -0.0274 -0.043168 6/30/1949 0.0 3093 -0.0 7 13 7/29/1949 0.05 845 0.06202 8/31/1949 0.026592 0.02602 9/30/1949 0.031831 0.043249 10/31/1949 0.0312 4 0.039025 11/30/1949 0.018 42 0.0 94 12/31/1949 0.052102 0.07012 1/31/1950 0.017283 0.040293 2/28/1950 0.014635 0.016102 3/31/1950 0.012198 -0.0 17 4/29/1950 0.040257 0.0474 3 5/31/1950 0.043689 0.03 185 6/30/1950 -0.057935 -0.075737 7/31/1950 0.0161 8 0.050635 8/31/1950 0.05069 0.051892 9/29/1950 0.048 04 0.05 013 10/31/1950 -0.0 1 09 -0.0 5 04 11/30/1950 0.028518 0.03162 12/30/1950 0.057 03 0.084545 1/31/1951 0.058239 0.076248 2/28/1951 0.014 34 0.01 586 3/31/1951 -0.020949 -0.03 89 4/30/1951 0.049613 0.040814 5/31/1951 -0.02 624 -0.024919 6/29/1951 -0.025324 -0.04 929 7/31/1951 0.071 6 0.063 32 8/31/1951 0.045082 0.047438 9/28/1951 0.0 917 0.023631 10/31/1951 -0.02 397 -0.023609 11/30/1951 0.0 5923 0.0 7185 12/31/1951 0.034898 0.015248 1/31/1952 0.016906 0.017491 2/29/1952 -0.024983 -0.02065 3/31/1952 0.045 86 0.028 64 4/30/1952 -0.0489 -0.04 936 5/29/1952 0.032874 0.024515 6/30/1952 0.039283 0.030728 7/31/1952 0.01 482 0.010652 8/29/1952 -0.0 6584 0.0 0 56 9/30/1952 -0.0189 1 -0.01516 10/31/1952 -0.0 5456 -0.01 717 11/28/1952 0.058795 0.05 64 12/31/1952 0.03121 0.02 641 1/30/1953 -0.0 1342 0.024706 2/27/1953 -0.0 171 0.012031 3/31/1953 -0.013417 -0.010486 4/30/1953 -0.027474 -0.024027 5/29/1953 0.0 7141 0.0 5896 6/30/1953 -0.016 5 -0.031671 7/31/1953 0.025329 0.017571 8/31/1953 -0.04 092 -0.051874 9/30/1953 0.0 3053 -0.01 0 5 10/30/1953 0.04709 0.037834 11/30/1953 0.028267 0.021317 12/31/1953 0.0 0768 -0.0154 4 1/29/1954 0.05246 0.071683 2/26/1954 0.017482 0.013576 3/31/1954 0.037251 0.02915 4/30/1954 0.042851 0.016373 5/28/1954 0.031569 0.043151 6/30/1954 0.01 47 0.012 75 7/30/1954 0.050368 0.071989 8/31/1954 -0.02 516 -0.0 9175 9/30/1954 0.064304 0.04 308 10/29/1954 -0.01621 -0.0 686 11/30/1954 0.095289 0.09219 12/31/1954 0.05 263 0.087 24 1/31/1955 0.0 69 4 0.014124 2/28/1955 0.03128 0.042781 3/31/1955 -0.0 1 2 0.0 053 4/29/1955 0.032 81 0.02 598 5/31/1955 0.01 856 0.0 7814 6/30/1955 0.0658 0.034694 7/29/1955 0.020283 0.0 80 1 8/31/1955 0.0 425 0.0 5764 9/30/1955 -0.0 2034 -0.0 7 51 10/31/1955 -0.025728 -0.017815 11/30/1955 0.0715 8 0.05 257 12/30/1955 0.016437 0.02 836 1/31/1956 -0.027987 -0.020746 2/29/1956 0.039532 0.03 613 3/29/1956 0.068175 0.051383 4/30/1956 0.0 5093 0.0 3827 5/31/1956 -0.049186 -0.039 64 6/29/1956 0.037157 0.021712 7/31/1956 0.050753 0.039 67 8/31/1956 -0.030342 -0.018161 9/28/1956 -0.04967 -0.035938 10/31/1956 0.0 72 1 0.0 7063 11/30/1956 0.0 461 0.0 527 12/31/1956 0.034934 0.02312 1/31/1957 -0.032051 0.0 3613 2/28/1957 -0.018698 -0.02329 3/29/1957 0.024087 0.02 49 4/30/1957 0.045059 0.025909 5/31/1957 0.03659 0.02 263 6/28/1957 -0.0 5107 -0.0 6747 7/31/1957 0.0 892 0.0 561 8/30/1957 -0.050 03 -0.05019 9/30/1957 -0.05762 -0.052982 10/31/1957 -0.04109 -0.065213 11/29/1957 0.025457 0.021027 12/31/1957 -0.03745 -0.049129 1/31/1958 0.049 05 0.106481 2/28/1958 -0.014125 -0.01 845 3/31/1958 0.03 787 0.035918 4/30/1958 0.0307 3 0.030171 5/29/1958 0.024569 0.039475 6/30/1958 0.029507 0.031729 7/31/1958 0.04 915 0.054168 8/29/1958 0.01909 0.029878 9/30/1958 0.048638 0.052 39 10/31/1958 0.0275 0.032975 11/28/1958 0.030526 0.0421 4 12/31/1958 0.052872 0.03879 1/30/1959 0.0 919 0.041502 2/27/1959 0.01 294 0.0281 2 3/31/1959 0.0 4509 0.012 23 4/30/1959 0.037947 0.025714 5/29/1959 0.01949 0.0 8206 6/30/1959 0.0 0564 0.0 4149 7/31/1959 0.034193 0.030 62 8/31/1959 -0.012437 -0.014839 9/30/1959 -0.04 8 5 -0.04576 10/30/1959 0.015682 0.023206 11/30/1959 0.018454 0.01504 12/31/1959 0.028015 0.021 7 1/29/1960 -0.06 354 -0.039202 2/29/1960 0.014202 0.0 8478 3/31/1960 -0.012847 -0.024876 4/29/1960 -0.0153 -0.01973 5/31/1960 0.03 982 0.025 46 6/30/1960 0.023039 0.021609 7/29/1960 -0.02 708 -0.019598 8/31/1960 0.032 58 0.037948 9/30/1960 -0.05862 -0.059524 10/31/1960 -0.0 4797 -0.02323 11/30/1960 0.048489 0.046495 12/30/1960 0.048457 0.037495 1/31/1961 0.063879 0.082048 2/28/1961 0.036972 0.06013 3/30/1961 0.030583 0.0498 8 4/28/1961 0.0 56 4 0.0 9487 5/31/1961 0.02581 0.041572 6/30/1961 -0.02849 -0.042415 7/31/1961 0.029 24 0.01 517 8/31/1961 0.0268 3 0.021358 9/29/1961 -0.019 92 -0.029686 10/31/1961 0.027435 0.02098 11/30/1961 0.045381 0.046461 12/29/1961 0.0 0746 -0.0 3757 1/31/1962 -0.036179 -0.0 7807 2/28/1962 0.019502 0.015405 3/30/1962 -0.0 46 9 -0.0 6241 4/30/1962 -0.063452 -0.068134 5/31/1962 -0.08468 -0.098186 6/29/1962 -0.082632 -0.085125 7/31/1962 0.065 04 0.064 8/31/1962 0.023414 0.037061 9/28/1962 -0.050154 -0.06383 10/31/1962 0.0 2184 -0.039528 11/30/1962 0.1 0137 0.121 76 12/31/1962 0.01 865 -0.025 61 1/31/1963 0.051848 0.08914 2/28/1963 -0.021931 -0.014 7 3/29/1963 0.032917 0.012027 4/30/1963 0.047439 0.02689 5/31/1963 0.020 51 0.032306 6/28/1963 -0.01803 -0.010383 7/31/1963 -0.0 1718 -0.0 6304 8/30/1963 0.052684 0.042305 9/30/1963 -0.01 898 -0.010373 10/31/1963 0.027 08 0.012 08 11/29/1963 -0.0 5 49 -0.016139 12/31/1963 0.021736 -0.0 42 8 1/31/1964 0.02579 0.032092 2/28/1964 0.017207 0.025173 3/31/1964 0.017636 0.025 1 4/30/1964 0.0 4608 0.0 10 4 5/28/1964 0.017403 0.0 7507 6/30/1964 0.01508 0.01041 7/31/1964 0.0201 8 0.030161 8/31/1964 -0.01 26 -0.0 6038 9/30/1964 0.03048 0.038248 10/30/1964 0.0 8 69 0.018 21 11/30/1964 0.0 3089 -0.0 0516 12/31/1964 0.0 369 -0.012365 1/29/1965 0.038646 0.071403 2/26/1965 0.0 6947 0.032325 3/31/1965 -0.0 9715 0.015393 4/30/1965 0.03 652 0.04156 5/28/1965 -0.0 435 -0.0 5845 6/30/1965 -0.051868 -0.083718 7/30/1965 0.016759 0.02863 8/31/1965 0.0308 3 0.04184 9/30/1965 0.031952 0.02742 10/29/1965 0.029271 0.058679 11/30/1965 0.0 3065 0.04654 12/31/1965 0.013545 0.042981 1/31/1966 0.01212 0.06417 2/28/1966 -0.0 8621 0.028 65 3/31/1966 -0.020923 -0.0 8 89 4/29/1966 0.024837 0.046 19 5/31/1966 -0.052539 -0.086024 6/30/1966 -0.010317 -0.0 498 7/29/1966 -0.01287 -0.016316 8/31/1966 -0.07538 -0.10 714 9/30/1966 -0.0 6958 -0.018161 10/31/1966 0.042 94 -0.014385 11/30/1966 0.017516 0.040725 12/30/1966 0.0 621 0.017306 1/31/1967 0.085 3 0.172104 2/28/1967 0.010945 0.042368 3/31/1967 0.043 84 0.05824 4/28/1967 0.041609 0.041928 5/31/1967 -0.039293 -0.0 8098 6/30/1967 0.026903 0.081958 7/31/1967 0.049189 0.083251 8/31/1967 -0.0 6282 0.0 6312 9/29/1967 0.034286 0.062963 10/31/1967 -0.02743 -0.020594 11/30/1967 0.0 7902 0.0 0878 12/29/1967 0.03 69 0.080465 1/31/1968 -0.0363 0.023902 2/29/1968 -0.03 624 -0.0561 8 3/29/1968 0.0 51 6 -0.01 218 4/30/1968 0.094148 0.143031 5/31/1968 0.027041 0.091309 6/28/1968 0.01 527 0.0162 5 7/30/1968 -0.02 024 -0.02621 8/30/1968 0.018038 0.035918 9/30/1968 0.04 454 0.068 08 10/31/1968 0.0 9041 0.0 6913 11/29/1968 0.058502 0.0719 4 12/31/1968 -0.03 873 0.0 5896 1/31/1969 -0.0 671 -0.0 168 2/28/1969 -0.05364 -0.085728 3/28/1969 0.030506 0.02029 4/30/1969 0.020526 0.0 3459 5/29/1969 0.0 504 0.0 6262 6/30/1969 -0.067387 -0.1 3404 7/31/1969 -0.065172 -0.095823 8/29/1969 0.05149 0.052175 9/30/1969 -0.02 59 -0.024618 10/31/1969 0.05 638 0.092413 11/28/1969 -0.032164 -0.05 078 12/31/1969 -0.019681 -0.06 178 1/30/1970 -0.073254 -0.038 3 2/27/1970 0.056706 0.040195 3/31/1970 -0.0 4729 -0.023712 4/30/1970 -0.105318 -0.161963 5/29/1970 -0.064346 -0.090524 6/30/1970 -0.051075 -0.073904 7/31/1970 0.074169 0.059258 8/31/1970 0.050 36 0.061617 9/30/1970 0.047536 0.126098 10/30/1970 -0.018208 -0.058604 11/30/1970 0.0504 8 0.0 3021 12/31/1970 0.060723 0.081324 1/29/1971 0.05203 0.136096 2/26/1971 0.016913 0.04791 3/31/1971 0.04 7 8 0.056 03 4/30/1971 0.03 3 2 0.027087 5/28/1971 -0.036409 -0.049435 6/30/1971 0.0 31 9 -0.01724 7/30/1971 -0.040283 -0.053634 8/31/1971 0.04251 0.041 59 9/30/1971 -0.0 5016 -0.0 4653 10/29/1971 -0.040682 -0.057468 11/30/1971 -0.0 1262 -0.03415 12/31/1971 0.091257 0.1 7128 1/31/1972 0.028383 0.103892 2/29/1972 0.031349 0.041809 3/30/1972 0.0 872 -0.0 0951 4/28/1972 0.0 5 05 0.0 1231 5/31/1972 0.016375 -0.018121 6/30/1972 -0.020896 -0.03 7 5 7/31/1972 -0.0 4254 -0.02948 8/31/1972 0.03596 0.012 52 9/29/1972 -0.0 7671 -0.030725 10/31/1972 0.0 8676 -0.013767 11/30/1972 0.049764 0.051096 12/29/1972 0.01 243 -0.019873 1/31/1973 -0.02745 -0.02613 2/28/1973 -0.04 368 -0.072836 3/30/1973 -0.0 7851 -0.028981 4/30/1973 -0.051759 -0.07062 5/31/1973 -0.024503 -0.083582 6/29/1973 -0.0 8647 -0.037 45 7/31/1973 0.056954 0.10592 8/31/1973 -0.029648 -0.04 417 9/28/1973 0.053937 0.0729 5 10/31/1973 -0.0 0427 0.0 0303 11/30/1973 -0.120703 -0.175252 12/31/1973 0.01 425 -0.041764 1/31/1974 0.0 4 08 0.132374 2/28/1974 0.0 2352 0.0 8623 3/29/1974 -0.023 65 0.0 8379 4/30/1974 -0.045957 -0.05 537 5/31/1974 -0.041982 -0.072545 6/28/1974 -0.02 942 -0.03 483 7/31/1974 -0.070879 -0.051915 8/30/1974 -0.087 56 -0.08578 9/30/1974 -0.109718 -0.079025 10/31/1974 0.165 85 0.08 87 11/29/1974 -0.041047 -0.051395 12/31/1974 -0.0270 5 -0.08074 1/31/1975 0.1416 0.29 26 2/28/1975 0.05841 0.053918 3/31/1975 0.030191 0.081497 4/30/1975 0.046497 0.031093 5/30/1975 0.05 14 0.072876 6/30/1975 0.051473 0.071792 7/31/1975 -0.060385 -0.0 896 8/29/1975 -0.0235 7 -0.0481 8 9/30/1975 -0.03801 -0.038 67 10/31/1975 0.05 857 0.01472 11/28/1975 0.0312 3 0.016796 12/31/1975 -0.0109 8 -0.0 059 1/30/1976 0.12601 0.190 37 2/27/1976 0.0 7314 0.106291 3/31/1976 0.02679 0.018109 4/30/1976 -0.010389 -0.0 381 5/28/1976 -0.0 9369 -0.01968 6/30/1976 0.04 487 0.02651 7/30/1976 -0.0 6157 0.0 2 36 8/31/1976 -0.0 1435 -0.016 73 9/30/1976 0.024 84 0.0169 10/29/1976 -0.020373 -0.02 586 11/30/1976 0.0 5364 0.026 86 12/31/1976 0.061591 0.10241 1/31/1977 -0.0363 7 0.036903 2/28/1977 -0.01576 0.0 4 3/31/1977 -0.0 9246 0.010654 4/29/1977 0.0 4952 0.016931 5/31/1977 -0.010785 0.0 287 6/30/1977 0.051367 0.051503 7/29/1977 -0.01281 0.012362 8/31/1977 -0.013 52 -0.0 123 9/30/1977 0.0 1574 0.014968 10/31/1977 -0.03928 -0.02319 11/30/1977 0.045432 0.070872 12/30/1977 0.0 8218 0.021081 1/31/1978 -0.05 202 -0.01 152 2/28/1978 -0.0 9275 0.0260 8 3/31/1978 0.034013 0.067839 4/28/1978 0.082841 0.079317 5/31/1978 0.023238 0.06762 6/30/1978 -0.010751 0.010292 7/31/1978 0.056749 0.052394 8/31/1978 0.042352 0.093545 9/29/1978 -0.0 6891 0.0 62 10/31/1978 -0.1 09 7 -0.17 28 11/30/1978 0.03 792 0.038205 12/29/1978 0.017 1 0.014346 1/31/1979 0.049489 0.0936 1 2/28/1979 -0.02676 -0.016269 3/30/1979 0.065618 0.084167 4/30/1979 0.0 852 0.028 14 5/31/1979 -0.013576 -0.0 6845 6/29/1979 0.04685 0.0546 3 7/31/1979 0.0149 1 0.02136 8/31/1979 0.064728 0.075616 9/28/1979 0.0 1428 -0.0 1 72 10/31/1979 -0.0726 -0.097915 11/30/1979 0.063603 0.065295 12/31/1979 0.028212 0.067485 1/31/1980 0.065607 0.105129 2/29/1980 0.0 1015 -0.0 6301 3/31/1980 -0.1202 4 -0.165043 4/30/1980 0.052 8 0.053461 5/30/1980 0.060 9 0.071249 6/30/1980 0.037 14 0.046176 7/31/1980 0.069438 0.089279 8/29/1980 0.0235 3 0.063984 9/30/1980 0.029498 0.052459 10/31/1980 0.020 93 0.047525 11/28/1980 0.104951 0.069205 12/31/1980 -0.034 09 -0.032416 1/30/1981 -0.040 85 0.0 5615 2/27/1981 0.015 21 0.0 215 3/31/1981 0.046184 0.072674 4/30/1981 -0.01 268 0.0278 5 5/29/1981 0.0135 1 0.027187 6/30/1981 -0.010242 -0.013194 7/31/1981 -0.0 308 -0.019 8 8/31/1981 -0.056279 -0.071906 9/30/1981 -0.0637 2 -0.090 61 10/30/1981 0.060162 0.069728 11/30/1981 0.045849 0.0216 7 12/31/1981 -0.028096 -0.019694 1/29/1982 -0.026209 -0.017347 2/26/1982 -0.051 26 -0.047987 3/31/1982 -0.010 9 -0.012064 4/30/1982 0.043267 0.052 42 5/28/1982 -0.028212 -0.02 49 6/30/1982 -0.023912 -0.036 9 7/30/1982 -0.020526 -0.0147 6 8/31/1982 0.1 9013 0.063285 9/30/1982 0.016761 0.03 164 10/29/1982 0.1 8636 0.1284 7 11/30/1982 0.051935 0.092037 12/31/1982 0.014516 0.0234 7 1/31/1983 0.04185 0.1 7062 2/28/1983 0.030218 0.04726 3/31/1983 0.034673 0.050515 4/29/1983 0.07418 0.080687 5/31/1983 0.0132 4 0.09174 6/30/1983 0.037837 0.046341 7/29/1983 -0.031567 -0.0175 6 8/31/1983 0.0 3464 -0.03292 9/30/1983 0.016059 0.0 0 51 10/31/1983 -0.028049 -0.059273 11/30/1983 0.0295 6 0.031713 12/30/1983 -0.010464 -0.019672 1/31/1984 -0.013023 0.0 5424 2/29/1984 -0.039073 -0.050767 3/30/1984 0.013 89 0.0 74 9 4/30/1984 0.0 2534 -0.020524 5/31/1984 -0.052342 -0.05157 6/29/1984 0.023 85 0.01 9 6 7/31/1984 -0.020621 -0.050303 8/31/1984 0.1 2689 0.08 817 9/28/1984 0.0 0404 -0.0 037 10/31/1984 -0.0 0 74 -0.023756 11/30/1984 -0.010685 -0.031506 12/31/1984 0.023656 0.0 2732 1/31/1985 0.085718 0.121475 2/28/1985 0.016896 0.046034 3/29/1985 -0.0 1747 -0.0 3581 4/30/1985 -0.0 2186 -0.0 9652 5/31/1985 0.05 7 5 0.02 2 1 6/28/1985 0.017091 0.0 2103 7/31/1985 -0.0 0251 0.021382 8/30/1985 -0.0 4795 -0.0 2 14 9/30/1985 -0.039825 -0.056859 10/31/1985 0.04 4 1 0.017652 11/29/1985 0.0692 8 0.052563 12/31/1985 0.043061 0.028021 1/31/1986 0.0 9829 0.04 071 2/28/1986 0.0725 0.060381 3/31/1986 0.0538 5 0.047192 4/30/1986 -0.0 79 0.01614 5/30/1986 0.05084 0.036194 6/30/1986 0.014246 0.0 8087 7/31/1986 -0.0597 -0.073128 8/29/1986 0.06 181 0.023269 9/30/1986 -0.079021 -0.059071 10/31/1986 0.049303 0.0237 7 11/28/1986 0.015093 -0.0 6263 12/31/1986 -0.02638 -0.034609 1/30/1987 0.128496 0.1 7565 2/27/1987 0.047918 0.074612 3/31/1987 0.0236 4 0.036283 4/30/1987 -0.0170 1 -0.017 09 5/29/1987 0.0 5125 0.0 0573 6/30/1987 0.0436 2 0.021487 7/31/1987 0.04 248 0.035123 8/31/1987 0.037146 0.01454 9/30/1987 -0.0207 4 -0.015876 10/30/1987 -0.2 5363 -0.272 48 11/30/1987 -0.072 73 -0.05085 12/31/1987 0.070327 0.026065 1/29/1988 0.04 8 0.07 392 2/29/1988 0.051695 0.060265 3/31/1988 -0.016598 0.03569 4/29/1988 0.0109 1 0.014016 5/31/1988 0.0 04 8 -0.017671 6/30/1988 0.05146 0.04767 7/29/1988 -0.0 7272 0.0 0289 8/31/1988 -0.0280 6 -0.0250 1 9/30/1988 0.037202 0.016951 10/31/1988 0.017637 -0.01 485 11/30/1988 -0.016412 -0.036484 12/30/1988 0.021075 0.018 72 1/31/1989 0.06 103 0.062124 2/28/1989 -0.0164 6 0.0 298 3/31/1989 0.021465 0.01806 4/28/1989 0.048204 0.029089 5/31/1989 0.0393 8 0.025054 6/30/1989 -0.0 486 -0.0 7 4 7/31/1989 0.07 131 0.031017 8/31/1989 0.02 127 0.018626 9/29/1989 -0.0 1474 0.0 5 32 10/31/1989 -0.029281 -0.049 34 11/30/1989 0.017815 -0.0 58 12/29/1989 0.018295 -0.012375 1/31/1990 -0.0701 5 -0.046408 2/28/1990 0.014901 0.015434 3/30/1990 0.02414 0.021315 4/30/1990 -0.028286 -0.0281 7 5/31/1990 0.08 936 0.045675 6/29/1990 -0.0 4196 0.0 5359 7/31/1990 -0.0 9405 -0.025732 8/31/1990 -0.091896 -0.10891 9/28/1990 -0.053843 -0.080468 10/31/1990 -0.012504 -0.05715 11/30/1990 0.06574 0.035468 12/31/1990 0.029513 -0.0 4526 1/31/1991 0.049078 0.084175 2/28/1991 0.075847 0.13 898 3/28/1991 0.028923 0.078293 4/30/1991 0.0 3 2 0.031962 5/31/1991 0.040732 0.031385 6/28/1991 -0.04 029 -0.0317 3 7/31/1991 0.046795 0.034202 8/30/1991 0.026819 0.027507 9/30/1991 -0.010975 0.0 813 10/31/1991 0.017 89 0.024639 11/29/1991 -0.037275 -0.023735 12/31/1991 0.1067 8 0.035353 1/31/1992 -0.0 1 82 0.149 7 2/28/1992 0.013 54 0.052124 3/31/1992 -0.0237 -0.014169 4/30/1992 0.013419 -0.03 262 5/29/1992 0.0 6439 0.0 5678 6/30/1992 -0.019287 -0.039215 7/31/1992 0.039 0.027617 8/31/1992 -0.02082 -0.0239 9/30/1992 0.0124 7 0.01 05 10/30/1992 0.010986 0.0162 4 11/30/1992 0.040193 0.06 686 12/31/1992 0.017 68 0.03567 1/29/1993 0.012643 0.067612 2/26/1993 0.0 5402 -0.0 7198 3/31/1993 0.0251 6 0.031465 4/30/1993 -0.0254 -0.01 1 2 5/28/1993 0.029598 0.03874 6/30/1993 0.0 54 0.013419 7/30/1993 -0.0 0795 0.013719 8/31/1993 0.039479 0.039698 9/30/1993 0.0 0641 0.025 07 10/29/1993 0.018064 0.040518 11/30/1993 -0.017606 -0.024 67 12/31/1993 0.019513 0.01619 1/31/1994 0.03146 0.04916 2/28/1994 -0.0242 4 -0.0 9 52 3/31/1994 -0.045795 -0.045962 4/29/1994 0.0 9478 -0.01 728 5/31/1994 0.0 936 -0.0 0831 6/30/1994 -0.027909 -0.028182 7/29/1994 0.03063 0.0157 8 8/31/1994 0.042597 0.036756 9/30/1994 -0.018363 0.0 4865 10/31/1994 0.01452 -0.0 3 05 11/30/1994 -0.037219 -0.040741 12/30/1994 0.012609 -0.013424 1/31/1995 0.02039 0.02786 2/28/1995 0.039615 0.028369 3/31/1995 0.027041 0.019518 4/28/1995 0.025048 0.026976 5/31/1995 0.0340 7 0.02027 6/30/1995 0.031 73 0.049 17 7/31/1995 0.040783 0.054708 8/31/1995 0.0 9305 0.032043 9/29/1995 0.036362 0.0264 10/31/1995 -0.01 317 -0.041473 11/30/1995 0.042708 0.016 59 12/29/1995 0.015191 0.0 8928 1/31/1996 0.02814 0.034657 2/29/1996 0.01631 0.032305 3/29/1996 0.010927 0.024086 4/30/1996 0.025 1 0.058049 5/31/1996 0.0268 0.062615 6/28/1996 -0.0 8298 -0.032167 7/31/1996 -0.053819 -0.079602 8/30/1996 0.032463 0.045634 9/30/1996 0.053019 0.028753 10/31/1996 0.013739 -0.020842 11/29/1996 0.065 69 0.024696 12/31/1996 -0.01 38 -0.0 2604 1/31/1997 0.053473 0.063831 2/28/1997 -0.0 1 2 -0.01029 3/31/1997 -0.04 868 -0.0492 4 4/30/1997 0.042373 -0.021596 5/30/1997 0.071624 0.085194 6/30/1997 0.04 095 0.043145 7/31/1997 0.076514 0.048 24 8/29/1997 -0.03629 0.027605 9/30/1997 0.05849 0.081737 10/31/1997 -0.034 36 -0.026145 11/28/1997 0.030404 -0.02 063 12/31/1997 0.017817 -0.023875 1/30/1998 0.0 4502 0.015367 2/27/1998 0.073 03 0.060451 3/31/1998 0.051301 0.0468 4 4/30/1998 0.010903 0.023243 5/29/1998 -0.025748 -0.042571 6/30/1998 0.031939 -0.02915 7/31/1998 -0.023 68 -0.050546 8/31/1998 -0.15784 -0.196383 9/30/1998 0.063828 0.043245 10/30/1998 0.074393 0.037827 11/30/1998 0.062024 0.075912 12/31/1998 0.063051 0.018 61 1/29/1999 0.038456 0.064848 2/26/1999 -0.038085 -0.042172 3/31/1999 0.037932 -0.0 1373 4/30/1999 0.049105 0.0839 5/28/1999 -0.020709 0.025134 6/30/1999 0.05082 0.038391 7/30/1999 -0.030716 0.0 7271 8/31/1999 -0.0 9 87 -0.030607 9/30/1999 -0.02 846 -0.01425 10/29/1999 0.062147 -0.0 1351 11/30/1999 0.036823 0.091409 12/31/1999 0.083758 0.08483 1/31/2000 -0.039612 0.05061 2/29/2000 0.03182 0.120436 3/31/2000 0.053526 -0.0 0429 4/28/2000 -0.059529 -0.08 504 5/31/2000 -0.038967 -0.057324 6/30/2000 0.051591 0.0792 8 7/31/2000 -0.017106 -0.01935 8/31/2000 0.07591 0.059257 9/29/2000 -0.051054 -0.040102 10/31/2000 -0.024597 -0.06 807 11/30/2000 -0.102492 -0.1 85 9 12/29/2000 0.020402 -0.0 7035 1/31/2001 0.03949 0.2 5012 2/28/2001 -0.09 263 -0.074508 3/30/2001 -0.07026 -0.072716 4/30/2001 0.083832 0.0764 1 5/31/2001 0.010576 0.062 01 6/29/2001 -0.017464 0.0 7 2 7/31/2001 -0.018297 -0.028407 8/31/2001 -0.05898 -0.0350 9 9/28/2001 -0.091526 -0.127801 10/31/2001 0.027835 0.078103 11/30/2001 0.0787 4 0.08081 12/31/2001 0.017859 0.057 42 1/31/2002 -0.015984 0.018178 2/28/2002 -0.02169 -0.03 06 3/28/2002 0.04 685 0.0746 6 4/30/2002 -0.049632 -0.0 3169 5/31/2002 -0.010524 -0.015 19 6/28/2002 -0.070249 -0.06731 7/31/2002 -0.081 35 -0.10749 8/30/2002 0.0 7965 0.0 63 7 9/30/2002 -0.09 965 -0.084 9 10/31/2002 0.074925 0.0427 3 11/29/2002 0.061275 0.1 7 75 12/31/2002 -0.053 16 -0.040159 1/31/2003 -0.023 92 0.0 6068 2/28/2003 -0.01539 -0.0214 8 3/31/2003 0.010325 0.0 9434 4/30/2003 0.082762 0.0982 2 5/30/2003 0.063471 0.13 17 6/30/2003 0.0163 5 0.049741 7/31/2003 0.0231 2 0.061927 8/29/2003 0.02496 0.047429 9/30/2003 -0.0 91 2 0.025239 10/31/2003 0.060318 0.08093 11/28/2003 0.016594 0.038147 12/31/2003 0.045 28 0.038907 1/30/2004 0.023049 0.065763 2/27/2004 0.015459 0.01372 3/31/2004 -0.010694 0.0 6293 4/30/2004 -0.024231 -0.04359 5/28/2004 0.014125 0.0 2592 6/30/2004 0.021582 0.02 729 7/30/2004 -0.0376 7 -0.051082 8/31/2004 0.0 2713 -0.0 4725 9/30/2004 0.020546 0.041594 10/29/2004 0.017805 0.020837 11/30/2004 0.04821 0.079 29 12/31/2004 0.035179 0.05292 1/31/2005 -0.0265 6 -0.029278 2/28/2005 0.02 672 0.016 36 3/31/2005 -0.016935 -0.031835 4/29/2005 -0.025186 -0.046509 5/31/2005 0.03795 0.043808 6/30/2005 0.01 534 0.032153 7/29/2005 0.043 27 0.058745 8/31/2005 -0.0 5946 -0.0 7217 9/30/2005 0.010565 0.01053 10/31/2005 -0.020801 -0.03 876 11/30/2005 0.040385 0.034319 12/30/2005 0.0 345 0.013484 1/31/2006 0.040 3 0.076354 2/28/2006 -0.0 164 0.0 4836 3/31/2006 0.01905 0.036978 4/28/2006 0.012962 0.0 9791 5/31/2006 -0.031046 -0.04 3 1 6/30/2006 -0.0 0406 -0.0 8479 7/31/2006 -0.0 1902 -0.02 698 8/31/2006 0.025062 0.02501 9/29/2006 0.019424 0.0 90 6 10/31/2006 0.037125 0.04621 11/30/2006 0.023705 0.031 68 12/29/2006 0.01083 0.0148 1/31/2007 0.019428 0.02 283 2/28/2007 -0.013957 0.0 21 3/30/2007 0.012949 0.0 6545 4/30/2007 0.039821 0.02704 5/31/2007 0.038932 0.023123 6/29/2007 -0.014756 -0.0 7906 7/31/2007 -0.031756 -0.043537 8/31/2007 0.01 6 -0.01 737 9/28/2007 0.04086 0.025363 10/31/2007 0.025835 0.017406 11/30/2007 -0.0492 2 -0.076 08 12/31/2007 -0.0 4 19 -0.010989 1/31/2008 -0.062151 -0.045082 2/29/2008 -0.021653 -0.021401 3/31/2008 -0.01042 -0.02531 4/30/2008 0.051 05 0.031907 5/30/2008 0.023843 0.0317 5 6/30/2008 -0.078434 -0.086 26 7/31/2008 -0.013 3 -0.0 1296 8/29/2008 0.010564 0.013023 9/30/2008 -0.0980 5 -0.120105 10/31/2008 -0.184603 -0.2052 2 11/28/2008 -0.084614 -0.13032 12/31/2008 0.02 149 0.042157 1/30/2009 -0.07 3 2 -0.024042 2/27/2009 -0.10 184 -0.1076 7 3/31/2009 0.086 93 0.1074 1 4/30/2009 0.109359 0.192761 5/29/2009 0.067 89 0.1023 6/30/2009 -0.0 3098 0.023917 7/31/2009 0.081718 0.085217 8/31/2009 0.031459 0.056864 9/30/2009 0.045235 0.071237 10/30/2009 -0.0279 8 -0.050612 11/30/2009 0.05709 0.0284 4 12/31/2009 0.028419 0.054978 1/29/2010 -0.037098 -0.01 38 2/26/2010 0.0347 5 0.03 603 3/31/2010 0.063605 0.069246 4/30/2010 0.020 1 0.057837 5/28/2010 -0.079141 -0.076975 6/30/2010 -0.050721 -0.056 68 7/30/2010 0.070293 0.059 58 8/31/2010 -0.042818 -0.047592 9/30/2010 0.091518 0.096353 10/29/2010 0.03853 0.040681 11/30/2010 0.0 5165 0.0106 1 12/31/2010 0.067152 0.068748 1/31/2011 0.019159 0.014 12
Background image of page 1
Year 2 Range PARTY Year 1 1928 1923-1929 Republican 1923 1932 1929-1933 Republican 1929 1944 1933-1945 Democratic 1933 1952 1945-1953 Democratic 1945 1960 1953-1961 Republican 1953 1962 1961-1963 Democratic 1961 1968 1963-1969 Democratic 1963 1973 1969-1974 Republican 1969 1976 1974-1977 Republican 1974 1980 1977-1981 Democratic 1977 1988 1981-1989 Republican 1981 1992 1989-1993 Republican 1989 2000 1993-2001 Democratic 1993 2008 2001-2009 Republican 2001 2011 2009-2012 Democratic 2009
Background image of page 2
Sign up to view the entire interaction

Top Answer

Change your values in Party Info Sheet, and check the correct ans.... View the full answer

IfElseLogic.xlsx

date
19260130
19260227
19260331
192604 30
19260528
19260630
19260731
19260831
19260930
19261030
19261130
19261231
19270131
19270228
19270331
192704 30
19270531
19270630
19270730
19270831
19270930...

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online