Questions 2 through 5 below utilize the Excel data file titled "BSAD 503 510 Examination 6 Data Set 2". This file presents quarterly data from the first quarter of 1936 through the third quarter of 2021 on U.S. treasury bill rates (TBILL). For these questions, I do not need to see the Megastat files you used for your underlying work. I only need to see the work you did on calculating the within-sample RMSE's, an indication of which model you chose, and the actual forecast values. For each question, you will be asked to forecast the next four quarters (2021 Quarter 4 through 2022 Quarter 3) and to use the within-sample forecasting technique in determining your forecasting model. It is possible to have negative forecasted values even though treasury bill rates are not going to be negative (we hope). Use the entire data set in developing your forecast for 2021 Quarter 4 through 2022 Quarter 3. To save time, consider only the following possible forecasting models: First Order Trend Polynomial Second Order Trend Polynomial Third Order Trend Polynomial Fourth Order Trend Polynomial Again, provide your work on calculating the within RMSE values and the actual forecast.

Year	Quarter	TBILL
1936	1	0.527
1936	2	0.153
1936	3	0.183
1936	4	0.250
1937	1	0.180
1937	2	0.150
1937	3	0.170
1937	4	0.170
1938	1	0.200
1938	2	0.200
1938	3	0.170
1938	4	0.120
1939	1	0.233
1939	2	0.443
1939	3	0.293
1939	4	0.133
1940	1	0.087
1940	2	0.063
1940	3	0.070
1940	4	0.040
1941	1	0.030
1941	2	0.030
1941	3	0.077
1941	4	0.047
1942	1	0.017
1942	2	0.060
1942	3	0.047
1942	4	0.020
1943	1	0.057
1943	2	0.110
1943	3	0.117
1943	4	0.233
1944	1	0.257
1944	2	0.353
1944	3	0.380
1944	4	0.380
1945	1	0.380
1945	2	0.380
1945	3	0.380
1945	4	0.380
1946	1	0.380
1946	2	0.380
1946	3	0.380
1946	4	0.380
1947	1	0.380
1947	2	0.380
1947	3	0.380
1947	4	0.380
1948	1	0.380
1948	2	0.380
1948	3	0.380
1948	4	0.380
1949	1	0.380
1949	2	0.380
1949	3	0.737
1949	4	0.907
1950	1	0.990
1950	2	1.000
1950	3	1.050
1950	4	1.140
1951	1	1.170
1951	2	1.170
1951	3	1.043
1951	4	1.077
1952	1	1.103
1952	2	1.153
1952	3	1.220
1952	4	1.337
1953	1	1.367
1953	2	1.490
1953	3	1.603
1953	4	1.610
1954	1	1.567
1954	2	1.647
1954	3	1.783
1954	4	1.893
1955	1	1.980
1955	2	2.153
1955	3	1.957
1955	4	1.473
1956	1	1.060
1956	2	0.790
1956	3	0.883
1956	4	1.020
1957	1	1.223
1957	2	1.483
1957	3	1.857
1957	4	2.337
1958	1	2.327
1958	2	2.567
1958	3	2.583
1958	4	3.033
1959	1	3.097
1959	2	3.140
1959	3	3.353
1959	4	3.310
1960	1	1.757
1960	2	0.957
1960	3	1.680
1960	4	2.690
1961	1	2.773
1961	2	3.000
1961	3	3.540
1961	4	4.230
1962	1	3.873
1962	2	2.993
1962	3	2.360
1962	4	2.307
1963	1	2.350
1963	2	2.303
1963	3	2.303
1963	4	2.460
1964	1	2.723
1964	2	2.717
1964	3	2.840
1964	4	2.813
1965	1	2.907
1965	2	2.940
1965	3	3.293
1965	4	3.497
1966	1	3.530
1966	2	3.477
1966	3	3.497
1966	4	3.683
1967	1	3.890
1967	2	3.873
1967	3	3.867
1967	4	4.167
1968	1	4.610
1968	2	4.587
1968	3	5.043
1968	4	5.210
1969	1	4.513
1969	2	3.660
1969	3	4.300
1969	4	4.753
1970	1	5.050
1970	2	5.520
1970	3	5.197
1970	4	5.587
1971	1	6.093
1971	2	6.197
1971	3	7.023
1971	4	7.353
1972	1	7.210
1972	2	6.677
1972	3	6.327
1972	4	5.353
1973	1	3.840
1973	2	4.250
1973	3	5.010
1973	4	4.230
1974	1	3.437
1974	2	3.770
1974	3	4.220
1974	4	4.863
1975	1	5.700
1975	2	6.603
1975	3	8.323
1975	4	7.500
1976	1	7.617
1976	2	8.153
1976	3	8.190
1976	4	7.360
1977	1	5.750
1977	2	5.393
1977	3	6.330
1977	4	5.627
1978	1	4.917
1978	2	5.157
1978	3	5.150
1978	4	4.673
1979	1	4.630
1979	2	4.840
1979	3	5.497
1979	4	6.110
1980	1	6.393
1980	2	6.477
1980	3	7.313
1980	4	8.570
1981	1	9.383
1981	2	9.377
1981	3	9.673
1981	4	11.843
1982	1	13.353
1982	2	9.617
1982	3	9.153
1982	4	13.613
1983	1	14.390
1983	2	14.907
1983	3	15.053
1983	4	11.750
1984	1	12.813
1984	2	12.420
1984	3	9.317
1984	4	7.907
1985	1	8.107
1985	2	8.397
1985	3	9.140
1985	4	8.800
1986	1	9.170
1986	2	9.797
1986	3	10.320
1986	4	8.803
1987	1	8.183
1987	2	7.460
1987	3	7.107
1987	4	7.167
1988	1	6.897
1988	2	6.140
1988	3	5.523
1988	4	5.353
1989	1	5.537
1989	2	5.657
1989	3	6.043
1989	4	5.863
1990	1	5.723
1990	2	6.210
1990	3	7.010
1990	4	7.727
1991	1	8.540
1991	2	8.410
1991	3	7.843
1991	4	7.653
1992	1	7.760
1992	2	7.747
1992	3	7.477
1992	4	6.990
1993	1	6.023
1993	2	5.560
1993	3	5.377
1993	4	4.540
1994	1	3.893
1994	2	3.680
1994	3	3.083
1994	4	3.070
1995	1	2.960
1995	2	2.967
1995	3	3.003
1995	4	3.060
1996	1	3.243
1996	2	3.987
1996	3	4.477
1996	4	5.280
1997	1	5.737
1997	2	5.597
1997	3	5.367
1997	4	5.260
1998	1	4.930
1998	2	5.020
1998	3	5.097
1998	4	4.977
1999	1	5.060
1999	2	5.047
1999	3	5.047
1999	4	5.090
2000	1	5.053
2000	2	4.977
2000	3	4.823
2000	4	4.253
2001	1	4.407
2001	2	4.453
2001	3	4.650
2001	4	5.043
2002	1	5.520
2002	2	5.713
2002	3	6.017
2002	4	6.017
2003	1	4.817
2003	2	3.660
2003	3	3.170
2003	4	1.907
2004	1	1.720
2004	2	1.713
2004	3	1.643
2004	4	1.333
2005	1	1.157
2005	2	1.040
2005	3	0.930
2005	4	0.917
2006	1	0.917
2006	2	1.077
2006	3	1.487
2006	4	2.007
2007	1	2.537
2007	2	2.863
2007	3	3.360
2007	4	3.827
2008	1	4.393
2008	2	4.703
2008	3	4.907
2008	4	4.903
2009	1	4.983
2009	2	4.737
2009	3	4.303
2009	4	3.390
2010	1	2.043
2010	2	1.627
2010	3	1.493
2010	4	0.297
2011	1	0.213
2011	2	0.173
2011	3	0.157
2011	4	0.057
2012	1	0.107
2012	2	0.147
2012	3	0.157
2012	4	0.137
2013	1	0.127
2013	2	0.047
2013	3	0.023
2013	4	0.013
2014	1	0.067
2014	2	0.087
2014	3	0.103
2014	4	0.087
2015	1	0.087
2015	2	0.050
2015	3	0.033
2015	4	0.063
2016	1	0.047
2016	2	0.033
2016	3	0.027
2016	4	0.023
2017	1	0.027
2017	2	0.020
2017	3	0.040
2017	4	0.123
2018	1	0.287
2018	2	0.257
2018	3	0.297
2018	4	0.430
2019	1	0.590
2019	2	0.890
2019	3	1.037
2019	4	1.207
2020	1	1.560
2020	2	1.840
2020	3	2.040
2020	4	2.317
2021	1	2.387
2021	2	2.300
2021	3	2.350