Week 4 - Excel Problems

Data

Bank Prime Loan Rate
Month	Percent
Jan-1971	6.29
Feb-1971	5.88
Mar-1971	5.44
Apr-1971	5.28
May-1971	5.46
Jun-1971	5.50
Jul-1971	5.91
Aug-1971	6.00
Sep-1971	6.00
Oct-1971	5.90
Nov-1971	5.53
Dec-1971	5.49
Jan-1972	5.18
Feb-1972	4.75
Mar-1972	4.75
Apr-1972	4.97
May-1972	5.00
Jun-1972	5.04
Jul-1972	5.25
Aug-1972	5.27
Sep-1972	5.50
Oct-1972	5.73
Nov-1972	5.75
Dec-1972	5.79
Jan-1973	6.00
Feb-1973	6.02
Mar-1973	6.30
Apr-1973	6.61
May-1973	7.01
Jun-1973	7.49
Jul-1973	8.30
Aug-1973	9.23
Sep-1973	9.86
Oct-1973	9.94
Nov-1973	9.75
Dec-1973	9.75
Jan-1974	9.73
Feb-1974	9.21
Mar-1974	8.85
Apr-1974	10.02
May-1974	11.25
Jun-1974	11.54
Jul-1974	11.97
Aug-1974	12.00
Sep-1974	12.00
Oct-1974	11.68
Nov-1974	10.83
Dec-1974	10.50
Jan-1975	10.05
Feb-1975	8.96
Mar-1975	7.93
Apr-1975	7.50
May-1975	7.40
Jun-1975	7.07
Jul-1975	7.15
Aug-1975	7.66
Sep-1975	7.88
Oct-1975	7.96
Nov-1975	7.53
Dec-1975	7.26
Jan-1976	7.00
Feb-1976	6.75
Mar-1976	6.75
Apr-1976	6.75
May-1976	6.75
Jun-1976	7.20
Jul-1976	7.25
Aug-1976	7.01
Sep-1976	7.00
Oct-1976	6.77
Nov-1976	6.50
Dec-1976	6.35
Jan-1977	6.25
Feb-1977	6.25
Mar-1977	6.25
Apr-1977	6.25
May-1977	6.41
Jun-1977	6.75
Jul-1977	6.75
Aug-1977	6.83
Sep-1977	7.13
Oct-1977	7.52
Nov-1977	7.75
Dec-1977	7.75
Jan-1978	7.93
Feb-1978	8.00
Mar-1978	8.00
Apr-1978	8.00
May-1978	8.27
Jun-1978	8.63
Jul-1978	9.00
Aug-1978	9.01
Sep-1978	9.41
Oct-1978	9.94
Nov-1978	10.94
Dec-1978	11.55
Jan-1979	11.75
Feb-1979	11.75
Mar-1979	11.75
Apr-1979	11.75
May-1979	11.75
Jun-1979	11.65
Jul-1979	11.54
Aug-1979	11.91
Sep-1979	12.90
Oct-1979	14.39
Nov-1979	15.55
Dec-1979	15.30
Jan-1980	15.25
Feb-1980	15.63
Mar-1980	18.31
Apr-1980	19.77
May-1980	16.57
Jun-1980	12.63
Jul-1980	11.48
Aug-1980	11.12
Sep-1980	12.23
Oct-1980	13.79
Nov-1980	16.06
Dec-1980	20.35
Jan-1981	20.16
Feb-1981	19.43
Mar-1981	18.05
Apr-1981	17.15
May-1981	19.61
Jun-1981	20.03
Jul-1981	20.39
Aug-1981	20.50
Sep-1981	20.08
Oct-1981	18.45
Nov-1981	16.84
Dec-1981	15.75
Jan-1982	15.75
Feb-1982	16.56
Mar-1982	16.50
Apr-1982	16.50
May-1982	16.50
Jun-1982	16.50
Jul-1982	16.26
Aug-1982	14.39
Sep-1982	13.50
Oct-1982	12.52
Nov-1982	11.85
Dec-1982	11.50
Jan-1983	11.16
Feb-1983	10.98
Mar-1983	10.50
Apr-1983	10.50
May-1983	10.50
Jun-1983	10.50
Jul-1983	10.50
Aug-1983	10.89
Sep-1983	11.00
Oct-1983	11.00
Nov-1983	11.00
Dec-1983	11.00
Jan-1984	11.00
Feb-1984	11.00
Mar-1984	11.21
Apr-1984	11.93
May-1984	12.39
Jun-1984	12.60
Jul-1984	13.00
Aug-1984	13.00
Sep-1984	12.97
Oct-1984	12.58
Nov-1984	11.77
Dec-1984	11.06
Jan-1985	10.61
Feb-1985	10.50
Mar-1985	10.50
Apr-1985	10.50
May-1985	10.31
Jun-1985	9.78
Jul-1985	9.50
Aug-1985	9.50
Sep-1985	9.50
Oct-1985	9.50
Nov-1985	9.50
Dec-1985	9.50
Jan-1986	9.50
Feb-1986	9.50
Mar-1986	9.10
Apr-1986	8.83
May-1986	8.50
Jun-1986	8.50
Jul-1986	8.16
Aug-1986	7.90
Sep-1986	7.50
Oct-1986	7.50
Nov-1986	7.50
Dec-1986	7.50
Jan-1987	7.50
Feb-1987	7.50
Mar-1987	7.50
Apr-1987	7.75
May-1987	8.14
Jun-1987	8.25
Jul-1987	8.25
Aug-1987	8.25
Sep-1987	8.70
Oct-1987	9.07
Nov-1987	8.78
Dec-1987	8.75
Jan-1988	8.75
Feb-1988	8.51
Mar-1988	8.50
Apr-1988	8.50
May-1988	8.84
Jun-1988	9.00
Jul-1988	9.29
Aug-1988	9.84
Sep-1988	10.00
Oct-1988	10.00
Nov-1988	10.05
Dec-1988	10.50
Jan-1989	10.50
Feb-1989	10.93
Mar-1989	11.50
Apr-1989	11.50
May-1989	11.50
Jun-1989	11.07
Jul-1989	10.98
Aug-1989	10.50
Sep-1989	10.50
Oct-1989	10.50
Nov-1989	10.50
Dec-1989	10.50
Jan-1990	10.11
Feb-1990	10.00
Mar-1990	10.00
Apr-1990	10.00
May-1990	10.00
Jun-1990	10.00
Jul-1990	10.00
Aug-1990	10.00
Sep-1990	10.00
Oct-1990	10.00
Nov-1990	10.00
Dec-1990	10.00
Jan-1991	9.52
Feb-1991	9.05
Mar-1991	9.00
Apr-1991	9.00
May-1991	8.50
Jun-1991	8.50
Jul-1991	8.50
Aug-1991	8.50
Sep-1991	8.20
Oct-1991	8.00
Nov-1991	7.58
Dec-1991	7.21
Jan-1992	6.50
Feb-1992	6.50
Mar-1992	6.50
Apr-1992	6.50
May-1992	6.50
Jun-1992	6.50
Jul-1992	6.02
Aug-1992	6.00
Sep-1992	6.00
Oct-1992	6.00
Nov-1992	6.00
Dec-1992	6.00
Jan-1993	6.00
Feb-1993	6.00
Mar-1993	6.00
Apr-1993	6.00
May-1993	6.00
Jun-1993	6.00
Jul-1993	6.00
Aug-1993	6.00
Sep-1993	6.00
Oct-1993	6.00
Nov-1993	6.00
Dec-1993	6.00
Jan-1994	6.00
Feb-1994	6.00
Mar-1994	6.06
Apr-1994	6.45
May-1994	6.99
Jun-1994	7.25
Jul-1994	7.25
Aug-1994	7.51
Sep-1994	7.75
Oct-1994	7.75
Nov-1994	8.15
Dec-1994	8.50
Jan-1995	8.50
Feb-1995	9.00
Mar-1995	9.00
Apr-1995	9.00
May-1995	9.00
Jun-1995	9.00
Jul-1995	8.80
Aug-1995	8.75
Sep-1995	8.75
Oct-1995	8.75
Nov-1995	8.75
Dec-1995	8.65
Jan-1996	8.50
Feb-1996	8.25
Mar-1996	8.25
Apr-1996	8.25
May-1996	8.25
Jun-1996	8.25
Jul-1996	8.25
Aug-1996	8.25
Sep-1996	8.25
Oct-1996	8.25
Nov-1996	8.25
Dec-1996	8.25
Jan-1997	8.25
Feb-1997	8.25
Mar-1997	8.30
Apr-1997	8.50
May-1997	8.50
Jun-1997	8.50
Jul-1997	8.50
Aug-1997	8.50
Sep-1997	8.50
Oct-1997	8.50
Nov-1997	8.50
Dec-1997	8.50
Jan-1998	8.50
Feb-1998	8.50
Mar-1998	8.50
Apr-1998	8.50
May-1998	8.50
Jun-1998	8.50
Jul-1998	8.50
Aug-1998	8.50
Sep-1998	8.49
Oct-1998	8.12
Nov-1998	7.89
Dec-1998	7.75
Jan-1999	7.75
Feb-1999	7.75
Mar-1999	7.75
Apr-1999	7.75
May-1999	7.75
Jun-1999	7.75
Jul-1999	8.00
Aug-1999	8.06
Sep-1999	8.25
Oct-1999	8.25
Nov-1999	8.37
Dec-1999	8.50
Jan-2000	8.50
Feb-2000	8.73
Mar-2000	8.83
Apr-2000	9.00
May-2000	9.24
Jun-2000	9.50
Jul-2000	9.50
Aug-2000	9.50
Sep-2000	9.50
Oct-2000	9.50
Nov-2000	9.50
Dec-2000	9.50
Jan-2001	9.05
Feb-2001	8.50
Mar-2001	8.32
Apr-2001	7.80
May-2001	7.24
Jun-2001	6.98
Jul-2001	6.75
Aug-2001	6.67
Sep-2001	6.28
Oct-2001	5.53
Nov-2001	5.10
Dec-2001	4.84
Jan-2002	4.75
Feb-2002	4.75
Mar-2002	4.75
Apr-2002	4.75
May-2002	4.75
Jun-2002	4.75
Jul-2002	4.75
Aug-2002	4.75
Sep-2002	4.75
Oct-2002	4.75
Nov-2002	4.35
Dec-2002	4.25
Jan-2003	4.25
Feb-2003	4.25
Mar-2003	4.25
Apr-2003	4.25
May-2003	4.25
Jun-2003	4.22
Jul-2003	4.00
Aug-2003	4.00
Sep-2003	4.00
Oct-2003	4.00
Nov-2003	4.00
Dec-2003	4.00
Jan-2004	4.00
Feb-2004	4.00
Mar-2004	4.00
Apr-2004	4.00
May-2004	4.00
Jun-2004	4.01
Jul-2004	4.25
Aug-2004	4.43
Sep-2004	4.58
Oct-2004	4.75
Nov-2004	4.93
Dec-2004	5.14
Jan-2005	5.25
Feb-2005	5.49
Mar-2005	5.58
Apr-2005	5.75
May-2005	5.98
Jun-2005	6.01
Jul-2005	6.25
Aug-2005	6.44
Sep-2005	6.59
Oct-2005	6.75
Nov-2005	7.00
Dec-2005	7.15
Jan-2006	7.26
Feb-2006	7.50
Mar-2006	7.53
Apr-2006	7.75
May-2006	7.93
Jun-2006	8.02
Jul-2006	8.25
Aug-2006	8.25
Sep-2006	8.25
Oct-2006	8.25
Nov-2006	8.25
Dec-2006	8.25
Jan-2007	8.25
Feb-2007	8.25
Mar-2007	8.25
Apr-2007	8.25
May-2007	8.25
Jun-2007	8.25
Jul-2007	8.25
Aug-2007	8.25
Sep-2007	8.03
Oct-2007	7.74
Nov-2007	7.50
Dec-2007	7.33
Jan-2008	6.98
Feb-2008	6.00
Mar-2008	5.66
Apr-2008	5.24
May-2008	5.00
Jun-2008	5.00
Jul-2008	5.00
Aug-2008	5.00
Sep-2008	5.00
Oct-2008	4.56
Nov-2008	4.00
Dec-2008	3.61
Jan-2009	3.25
Feb-2009	3.25
Mar-2009	3.25
Apr-2009	3.25
May-2009	3.25
Jun-2009	3.25
Jul-2009	3.25
Aug-2009	3.25
Sep-2009	3.25
Oct-2009	3.25
Nov-2009	3.25
Dec-2009	3.25
Jan-2010	3.25
Feb-2010	3.25
Mar-2010	3.25
Apr-2010	3.25
May-2010	3.25
Jun-2010	3.25
Jul-2010	3.25
Aug-2010	3.25
Sep-2010	3.25

Prime Loan Rate

25934.0 25965.0 25993.0 26024.0 26054.0 26085.0 26115.0 26146.0 26177.0 26207.0 26238.0 26268.0 26299.0 26330.0 26359.0 26390.0 26420.0 26451.0 26481.0 26512.0 26543.0 26573.0 26604.0 26634.0 26665.0 26696.0 26724.0 26755.0 26785.0 26816.0 26846.0 26877.0 26908.0 26938.0 26969.0 26999.0 27030.0 27061.0 27089.0 27120.0 27150.0 27181.0 27211.0 27242.0 27273.0 27303.0 27334.0 27364.0 27395.0 27426.0 27454.0 27485.0 27515.0 27546.0 27576.0 27607.0 27638.0 27668.0 27699.0 27729.0 27760.0 27791.0 27820.0 27851.0 27881.0 27912.0 27942.0 27973.0 28004.0 28034.0 28065.0 28095.0 28126.0 28157.0 28185.0 28216.0 28246.0 28277.0 28307.0 28338.0 28369.0 28399.0 28430.0 28460.0 28491.0 28522.0 28550.0 28581.0 28611.0 28642.0 28672.0 28703.0 28734.0 28764.0 28795.0 28825.0 28856.0 28887.0 28915.0 28946.0 28976.0 29007.0 29037.0 29068.0 29099.0 29129.0 29160.0 29190.0 29221.0 29252.0 29281.0 29312.0 29342.0 29373.0 29403.0 29434.0 29465.0 29495.0 29526.0 29556.0 29587.0 29618.0 29646.0 29677.0 29707.0 29738.0 29768.0 29799.0 29830.0 29860.0 29891.0 29921.0 29952.0 29983.0 30011.0 30042.0 30072.0 30103.0 30133.0 30164.0 30195.0 30225.0 30256.0 30286.0 30317.0 30348.0 30376.0 30407.0 30437.0 30468.0 30498.0 30529.0 30560.0 30590.0 30621.0 30651.0 30682.0 30713.0 30742.0 30773.0 30803.0 30834.0 30864.0 30895.0 30926.0 30956.0 30987.0 31017.0 31048.0 31079.0 31107.0 31138.0 31168.0 31199.0 31229.0 31260.0 31291.0 31321.0 31352.0 31382.0 31413.0 31444.0 31472.0 31503.0 31533.0 31564.0 31594.0 31625.0 31656.0 31686.0 31717.0 31747.0 31778.0 31809.0 31837.0 31868.0 31898.0 31929.0 31959.0 31990.0 32021.0 32051.0 32082.0 32112.0 32143.0 32174.0 32203.0 32234.0 32264.0 32295.0 32325.0 32356.0 32387.0 32417.0 32448.0 32478.0 32509.0 32540.0 32568.0 32599.0 32629.0 32660.0 32690.0 32721.0 32752.0 32782.0 32813.0 32843.0 32874.0 32905.0 32933.0 32964.0 32994.0 33025.0 33055.0 33086.0 33117.0 33147.0 33178.0 33208.0 33239.0 33270.0 33298.0 33329.0 33359.0 33390.0 33420.0 33451.0 33482.0 33512.0 33543.0 33573.0 33604.0 33635.0 33664.0 33695.0 33725.0 33756.0 33786.0 33817.0 33848.0 33878.0 33909.0 33939.0 33970.0 34001.0 34029.0 34060.0 34090.0 34121.0 34151.0 34182.0 34213.0 34243.0 34274.0 34304.0 34335.0 34366.0 34394.0 34425.0 34455.0 34486.0 34516.0 34547.0 34578.0 34608.0 34639.0 34669.0 34700.0 34731.0 34759.0 34790.0 34820.0 34851.0 34881.0 34912.0 34943.0 34973.0 35004.0 35034.0 35065.0 35096.0 35125.0 35156.0 35186.0 35217.0 35247.0 35278.0 35309.0 35339.0 35370.0 35400.0 35431.0 35462.0 35490.0 35521.0 35551.0 35582.0 35612.0 35643.0 35674.0 35704.0 35735.0 35765.0 35796.0 35827.0 35855.0 35886.0 35916.0 35947.0 35977.0 36008.0 36039.0 36069.0 36100.0 36130.0 36161.0 36192.0 36220.0 36251.0 36281.0 36312.0 36342.0 36373.0 36404.0 36434.0 36465.0 36495.0 36526.0 36557.0 36586.0 36617.0 36647.0 36678.0 36708.0 36739.0 36770.0 36800.0 36831.0 36861.0 36892.0 36923.0 36951.0 36982.0 37012.0 37043.0 37073.0 37104.0 37135.0 37165.0 37196.0 37226.0 37257.0 37288.0 37316.0 37347.0 37377.0 37408.0 37438.0 37469.0 37500.0 37530.0 37561.0 37591.0 37622.0 37653.0 37681.0 37712.0 37742.0 37773.0 37803.0 37834.0 37865.0 37895.0 37926.0 37956.0 37987.0 38018.0 38047.0 38078.0 38108.0 38139.0 38169.0 38200.0 38231.0 38261.0 38292.0 38322.0 38353.0 38384.0 38412.0 38443.0 38473.0 38504.0 38534.0 38565.0 38596.0 38626.0 38657.0 38687.0 38718.0 38749.0 38777.0 38808.0 38838.0 38869.0 38899.0 38930.0 38961.0 38991.0 39022.0 39052.0 39083.0 39114.0 39142.0 39173.0 39203.0 39234.0 39264.0 39295.0 39326.0 39356.0 39387.0 39417.0 39448.0 39479.0 39508.0 39539.0 39569.0 39600.0 6.29 5.88 5.44 5.28 5.46 5.5 5.91 6.0 6.0 5.9 5.53 5.49 5.18 4.75 4.75 4.97 5.0 5.04 5.25 5.27 5.5 5.73 5.75 5.79 6.0 6.02 6.3 6.61 7.01 7.49 8.3 9.23 9.86 9.94 9.75 9.75 9.73 9.210000000000001 8.85 10.02 11.25 11.54 11.97 12.0 12.0 11.68 10.83 10.5 10.05 8.96 7.93 7.5 7.4 7. 07 7.15 7.66 7.88 7.96 7.53 7.26 7.0 6.75 6.75 6.75 6.75 7.2 7.25 7.01 7.0 6.769999999999999 6.5 6.35 6.25 6.25 6.25 6.25 6.41 6.75 6.75 6.83 7.13 7.52 7.75 7.75 7.93 8.0 8.0 8.0 8.27 8.630000000000001 9.0 9.01 9.41 9.94 10.94 11.55 11.75 11.75 11.75 11.75 11.75 11.65 11.54 11.91 12.9 14.39 15.55 15.3 15.25 15.63 18.31 19.77 16.57 12.63 11.48 11.12 12.23 13.79 16.06 20.35 20.16 19.43 18.05 17.15 19.61 20.03 20.39 20.5 20.08 18.45 16.84 15.75 15.75 16.56 16.5 16.5 16.5 16.5 16.26 14.39 13.5 12.52 11.85 11.5 11.16 10.98 10.5 10.5 10.5 10.5 10.5 10.89 11.0 11.0 11.0 11.0 11.0 11.0 11.21 11.93 12.39 12.6 13.0 13.0 12.97 12.58 11.77 11.06 10.61 10.5 10.5 10.5 10.31 9.78 9.5 9.5 9.5 9.5 9.5 9.5 9.5 9.5 9.1 8.83 8.5 8.5 8.16 7.9 7.5 7.5 7.5 7.5 7.5 7.5 7.5 7.75 8.140000000000001 8.25 8.25 8.25 8.7 9.07 8.78 8.75 8.75 8.51 8.5 8.5 8.84 9.0 9.29 9.84 10.0 10.0 10.05 10.5 10.5 10.93 11.5 11.5 11.5 11.07 10.98 10.5 10.5 10.5 10.5 10.5 10.11 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 10.0 9.52 9.05 9.0 9.0 8.5 8.5 8.5 8.5 8.2 8.0 7.58 7.21 6.5 6.5 6.5 6.5 6.5 6.5 6.02 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.0 6.06 6.45 6.99 7.25 7.25 7.51 7.75 7.75 8.15 8.5 8.5 9.0 9.0 9.0 9.0 9.0 8.8 8.75 8.75 8.75 8.75 8.65 8.5 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.3 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.5 8.49 8.12 7.89 7.75 7.75 7.75 7.75 7.75 7.75 7.75 8.0 8.06 8.25 8.25 8.37 8.5 8.5 8.73 8.83 9.0 9.24 9.5 9.5 9.5 9.5 9.5 9.5 9.5 9.05 8.5 8.32 7.8 7.24 6.98 6.75 6.67 6.28 5.53 5.1 4.84 4.75 4.75 4.75 4.75 4.75 4.75 4.75 4.75 4.75 4.75 4.35 4.25 4.25 4.25 4.25 4.25 4.25 4.22 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.0 4.01 4.25 4.43 4.58 4.75 4.93 5.14 5.25 5.49 5.58 5.75 5.98 6.01 6.25 6.44 6.59 6.75 7.0 7.15 7.26 7.5 7.53 7.75 7.93 8.02 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.25 8.03 7.74 7.5 7.33 6.98 6.0 5.66 5.24 5.0 5.0