VRITE FORMULAS in the NBER Business Cycle worksheet to display: he Peak End-of-Month Date (Column K) for the given row based on the Peak Month (Column C or E). he Trough End-of-Month Date (Column L) for the given row based on the Trough Month (Column D or F). Note: Month numbers start in January 1800 (e.g. February 1800 is month 2) Grey Cells need formulas. Since Excel dates cannot be in date format before 1900, the first several cells have been blacked-out (no formulas required here). Hint: Write the first formula in L15, and copy it down through Column L and then over to Column K. It may help to reference text in Columns C&D instead of the month number \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ Source: National Bureau of Economic Research - Business Cycle } \\ \hline \multicolumn{10}{|c|}{ Note: Month numbers start in January 1800} \\ \hline Peak month (Peak Quarter) & Trough month (Trough Quarter) & \multirow[b]{2}{*}{\begin{tabular}{c} Peak \\ month \\ number \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Trough \\ month \\ number \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} Contraction \\ Duration, \\ peak to \\ trough \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} Expansion \\ Duration, \\ trough to \\ peak \end{tabular}} & \multicolumn{2}{|c|}{ Cycle } & \multirow[b]{2}{*}{\begin{tabular}{c} Peak \\ end-of-month \\ Date \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Trough \\ end-of-month \\ Date \end{tabular}} \\ \hline \multirow[t]{2}{*}{ Peak month } & Trough month & & & & & \begin{tabular}{c} Duration, \\ trough to \\ trough \end{tabular} & \begin{tabular}{c} Duration, \\ peak to \\ peak \end{tabular} & & \\ \hline & December 1854 (1854Q4) & & 660 & & & & & & \\ \hline June 1857 (1857Q2) & December 1858 (1858Q4) & 690 & 708 & 18 & 30 & 48 & & & \\ \hline October 1860 (1860Q3) & June 1861(1861Q3) & 730 & 738 & 8 & 22 & 30 & 40 & & \\ \hline April 1865 (1865Q1) & December 1867 (1868Q1) & 784 & 816 & 32 & 46 & 78 & 54 & & \\ \hline June 1869 (1869Q2) & December 1870 (1870Q4) & 834 & 852 & 18 & 18 & 36 & 50 & & \\ \hline October 1873 (1873Q3) & March 1879 (1879Q1) & 886 & 951 & 65 & 34 & 99 & 52 & & \\ \hline March 1882 (1882Q1) & May 1885 (1885Q2) & 987 & 1025 & 38 & 36 & 74 & 101 & & \\ \hline March 1887 (1887Q2) & April 1888 (1888Q1) & 1047 & 1060 & 13 & 22 & 35 & 60 & & \\ \hline July 1890 (1890Q3) & May 1891 (1891Q2) & 1087 & 1097 & 10 & 27 & 37 & 40 & & \\ \hline January 1893 (1893Q1) & June 1894 (1894Q2) & 1117 & 1134 & 17 & 20 & 37 & 30 & & \\ \hline December 1895 (1895Q4) & June 1897 (1897Q2) & 1152 & 1170 & 18 & 18 & 36 & 35 & & \\ \hline June 1899 (1899Q3) & December 1900 (1900Q4) & 1194 & 1212 & 18 & 24 & 42 & 42 & & \\ \hline September 1902 (1902Q4) & August 1904 (1904Q3) & 1233 & 1256 & 23 & 21 & 44 & 39 & & \\ \hline May 1907 (1907Q2) & June 1908 (1908Q2) & 1289 & 1302 & 13 & 33 & 46 & 56 & & \\ \hline January 1910 (1910Q1) & January 1912 (1911Q4) & 1321 & 1345 & 24 & 19 & 43 & 32 & & \\ \hline January 1913 (1913Q1) & December 1914 (1914Q4) & 1357 & 1380 & 23 & 12 & 35 & 36 & & \\ \hline August 1918 (1918Q3) & March 1919 (1919Q1) & 1424 & 1431 & 7 & 44 & 51 & 67 & & \\ \hline January 1920 (1920Q1) & July 1921 (1921Q3) & 1441 & 1459 & 18 & 10 & 28 & 17 & & \\ \hline May 1923 (1923Q2) & July 1924 (1924Q3) & 1481 & 1495 & 14 & 22 & 36 & 40 & & \\ \hline October 1926 (1926Q3) & November 1927 (1927Q4) & 1522 & 1535 & 13 & 27 & 40 & 41 & & \\ \hline August 1929 (1929Q3) & March 1933 (1933Q1) & 1556 & 1599 & 43 & 21 & 64 & 34 & & \\ \hline May 1937 (1937Q2) & June 1938 (1938Q2) & 1649 & 1662 & 13 & 50 & 63 & 93 & & \\ \hline February 1945 (1945Q1) & October 1945 (1945Q4) & 1742 & 1750 & 8 & 80 & 88 & 93 & & \\ \hline November 1948 (1948Q4) & October 1949 (1949Q4) & 1787 & 1798 & 11 & 37 & 48 & 45 & & \\ \hline July 1953 (1953Q2) & May 1954 (1954Q2) & 1843 & 1853 & 10 & 45 & 55 & 56 & & \\ \hline August 1957 (1957Q3) & April 1958 (1958Q2) & 1892 & 1900 & 8 & 39 & 47 & 49 & & \\ \hline April 1960 (1960Q2) & February 1961 (1961Q1) & 1924 & 1934 & 10 & 24 & 34 & 32 & & \\ \hline December 1969 (1969Q4) & November 1970 (1970Q4) & 2040 & 2051 & 11 & 106 & 117 & F 116 & & \\ \hline November 1973 (1973Q4) & March 1975 (1975Q1) & 2087 & 2103 & 16 & 36 & 52 & 47 & & \\ \hline January 1980 (1980Q1) & July 1980 (1980Q3) & 2161 & 2167 & 6 & 58 & 64 & 74 & & \\ \hline July 1981 (1981Q3) & November 1982 (1982Q4) & 2179 & 2195 & 16 & 12 & 28 & 18 & & \\ \hline July 1990 (1990Q3) & March 1991 (1991Q1) & 2287 & 2295 & 8 & 92 & 100 & 108 & & \\ \hline March 2001 (2001Q1) & November 2001 (2001Q4) & 2415 & 2423 & 8 & 120 & 128 & 128 & & \\ \hline December 2007 (2007Q4) & June 2009 (2009Q2) & 2496 & 2514 & 18 & 73 & 91 & 81 & & \\ \hline February 2020 (2019Q4) & April 2020 (2020Q2) & 2642 & 2644 & 2 & 128 & 130 & 146 & & \\ \hline & & & & & & & & & \\ \hline \multicolumn{2}{|l|}{ 1854-2020 (34 cycles) } & & & 17 & 41.4 & 58.4 & 59.2 & & \\ \hline \multicolumn{2}{|l|}{ 1854-1919 (16 cycles) } & & & 21.6 & 26.6 & 48.2 & 48.9 & & \\ \hline \multicolumn{2}{|l|}{ 1919-1945 (6 cycles) } & & & 18.2 & 35 & 53.2 & 53 & & \\ \hline \multicolumn{2}{|l|}{19452020 (12 cycles) } & & & 10.3 & 64.2 & 74.5 & 75 & & \\ \hline \end{tabular} VRITE FORMULAS in the NBER Business Cycle worksheet to display: he Peak End-of-Month Date (Column K) for the given row based on the Peak Month (Column C or E). he Trough End-of-Month Date (Column L) for the given row based on the Trough Month (Column D or F). Note: Month numbers start in January 1800 (e.g. February 1800 is month 2) Grey Cells need formulas. Since Excel dates cannot be in date format before 1900, the first several cells have been blacked-out (no formulas required here). Hint: Write the first formula in L15, and copy it down through Column L and then over to Column K. It may help to reference text in Columns C&D instead of the month number \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline \multicolumn{10}{|c|}{ Source: National Bureau of Economic Research - Business Cycle } \\ \hline \multicolumn{10}{|c|}{ Note: Month numbers start in January 1800} \\ \hline Peak month (Peak Quarter) & Trough month (Trough Quarter) & \multirow[b]{2}{*}{\begin{tabular}{c} Peak \\ month \\ number \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Trough \\ month \\ number \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} Contraction \\ Duration, \\ peak to \\ trough \end{tabular}} & \multirow{2}{*}{\begin{tabular}{c} Expansion \\ Duration, \\ trough to \\ peak \end{tabular}} & \multicolumn{2}{|c|}{ Cycle } & \multirow[b]{2}{*}{\begin{tabular}{c} Peak \\ end-of-month \\ Date \end{tabular}} & \multirow[b]{2}{*}{\begin{tabular}{c} Trough \\ end-of-month \\ Date \end{tabular}} \\ \hline \multirow[t]{2}{*}{ Peak month } & Trough month & & & & & \begin{tabular}{c} Duration, \\ trough to \\ trough \end{tabular} & \begin{tabular}{c} Duration, \\ peak to \\ peak \end{tabular} & & \\ \hline & December 1854 (1854Q4) & & 660 & & & & & & \\ \hline June 1857 (1857Q2) & December 1858 (1858Q4) & 690 & 708 & 18 & 30 & 48 & & & \\ \hline October 1860 (1860Q3) & June 1861(1861Q3) & 730 & 738 & 8 & 22 & 30 & 40 & & \\ \hline April 1865 (1865Q1) & December 1867 (1868Q1) & 784 & 816 & 32 & 46 & 78 & 54 & & \\ \hline June 1869 (1869Q2) & December 1870 (1870Q4) & 834 & 852 & 18 & 18 & 36 & 50 & & \\ \hline October 1873 (1873Q3) & March 1879 (1879Q1) & 886 & 951 & 65 & 34 & 99 & 52 & & \\ \hline March 1882 (1882Q1) & May 1885 (1885Q2) & 987 & 1025 & 38 & 36 & 74 & 101 & & \\ \hline March 1887 (1887Q2) & April 1888 (1888Q1) & 1047 & 1060 & 13 & 22 & 35 & 60 & & \\ \hline July 1890 (1890Q3) & May 1891 (1891Q2) & 1087 & 1097 & 10 & 27 & 37 & 40 & & \\ \hline January 1893 (1893Q1) & June 1894 (1894Q2) & 1117 & 1134 & 17 & 20 & 37 & 30 & & \\ \hline December 1895 (1895Q4) & June 1897 (1897Q2) & 1152 & 1170 & 18 & 18 & 36 & 35 & & \\ \hline June 1899 (1899Q3) & December 1900 (1900Q4) & 1194 & 1212 & 18 & 24 & 42 & 42 & & \\ \hline September 1902 (1902Q4) & August 1904 (1904Q3) & 1233 & 1256 & 23 & 21 & 44 & 39 & & \\ \hline May 1907 (1907Q2) & June 1908 (1908Q2) & 1289 & 1302 & 13 & 33 & 46 & 56 & & \\ \hline January 1910 (1910Q1) & January 1912 (1911Q4) & 1321 & 1345 & 24 & 19 & 43 & 32 & & \\ \hline January 1913 (1913Q1) & December 1914 (1914Q4) & 1357 & 1380 & 23 & 12 & 35 & 36 & & \\ \hline August 1918 (1918Q3) & March 1919 (1919Q1) & 1424 & 1431 & 7 & 44 & 51 & 67 & & \\ \hline January 1920 (1920Q1) & July 1921 (1921Q3) & 1441 & 1459 & 18 & 10 & 28 & 17 & & \\ \hline May 1923 (1923Q2) & July 1924 (1924Q3) & 1481 & 1495 & 14 & 22 & 36 & 40 & & \\ \hline October 1926 (1926Q3) & November 1927 (1927Q4) & 1522 & 1535 & 13 & 27 & 40 & 41 & & \\ \hline August 1929 (1929Q3) & March 1933 (1933Q1) & 1556 & 1599 & 43 & 21 & 64 & 34 & & \\ \hline May 1937 (1937Q2) & June 1938 (1938Q2) & 1649 & 1662 & 13 & 50 & 63 & 93 & & \\ \hline February 1945 (1945Q1) & October 1945 (1945Q4) & 1742 & 1750 & 8 & 80 & 88 & 93 & & \\ \hline November 1948 (1948Q4) & October 1949 (1949Q4) & 1787 & 1798 & 11 & 37 & 48 & 45 & & \\ \hline July 1953 (1953Q2) & May 1954 (1954Q2) & 1843 & 1853 & 10 & 45 & 55 & 56 & & \\ \hline August 1957 (1957Q3) & April 1958 (1958Q2) & 1892 & 1900 & 8 & 39 & 47 & 49 & & \\ \hline April 1960 (1960Q2) & February 1961 (1961Q1) & 1924 & 1934 & 10 & 24 & 34 & 32 & & \\ \hline December 1969 (1969Q4) & November 1970 (1970Q4) & 2040 & 2051 & 11 & 106 & 117 & F 116 & & \\ \hline November 1973 (1973Q4) & March 1975 (1975Q1) & 2087 & 2103 & 16 & 36 & 52 & 47 & & \\ \hline January 1980 (1980Q1) & July 1980 (1980Q3) & 2161 & 2167 & 6 & 58 & 64 & 74 & & \\ \hline July 1981 (1981Q3) & November 1982 (1982Q4) & 2179 & 2195 & 16 & 12 & 28 & 18 & & \\ \hline July 1990 (1990Q3) & March 1991 (1991Q1) & 2287 & 2295 & 8 & 92 & 100 & 108 & & \\ \hline March 2001 (2001Q1) & November 2001 (2001Q4) & 2415 & 2423 & 8 & 120 & 128 & 128 & & \\ \hline December 2007 (2007Q4) & June 2009 (2009Q2) & 2496 & 2514 & 18 & 73 & 91 & 81 & & \\ \hline February 2020 (2019Q4) & April 2020 (2020Q2) & 2642 & 2644 & 2 & 128 & 130 & 146 & & \\ \hline & & & & & & & & & \\ \hline \multicolumn{2}{|l|}{ 1854-2020 (34 cycles) } & & & 17 & 41.4 & 58.4 & 59.2 & & \\ \hline \multicolumn{2}{|l|}{ 1854-1919 (16 cycles) } & & & 21.6 & 26.6 & 48.2 & 48.9 & & \\ \hline \multicolumn{2}{|l|}{ 1919-1945 (6 cycles) } & & & 18.2 & 35 & 53.2 & 53 & & \\ \hline \multicolumn{2}{|l|}{19452020 (12 cycles) } & & & 10.3 & 64.2 & 74.5 & 75 & & \\ \hline \end{tabular}