Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Determine the most appropriate forecasting technique for the mortgage rates data and implement the model. Choose any one of the series below for your forecast.
Determine the most appropriate forecasting technique for the mortgage rates data and implement the model. Choose any one of the series below for your forecast.
Mortgage Rates | |||||||
Fixed Rate | Fixed Rate | Adjustable Rate | |||||
Week Ending | 30 year | 15 year | 1 year | ||||
1/7/2005 | 5.77 | 5.21 | 4.1 | ||||
1/14/2005 | 5.74 | 5.19 | 4.1 | ||||
1/21/2005 | 5.67 | 5.15 | 4.11 | ||||
1/28/2005 | 5.66 | 5.14 | 4.18 | ||||
2/4/2005 | 5.63 | 5.14 | 4.23 | ||||
2/11/2005 | 5.57 | 5.1 | 4.11 | ||||
2/18/2005 | 5.62 | 5.14 | 4.15 | ||||
2/25/2005 | 5.69 | 5.22 | 4.16 | ||||
3/4/2005 | 5.79 | 5.33 | 4.14 | ||||
3/11/2005 | 5.85 | 5.38 | 4.24 | ||||
3/18/2005 | 5.95 | 5.47 | 4.2 | ||||
3/25/2005 | 6.01 | 5.56 | 4.24 | ||||
4/1/2005 | 6.04 | 5.58 | 4.33 | ||||
4/8/2005 | 5.93 | 5.48 | 4.23 | ||||
4/15/2005 | 5.91 | 5.46 | 4.3 | ||||
4/22/2005 | 5.8 | 5.36 | 4.26 | ||||
4/29/2005 | 5.78 | 5.33 | 4.21 | ||||
5/6/2005 | 5.75 | 5.31 | 4.22 | ||||
5/13/2005 | 5.77 | 5.33 | 4.23 | ||||
5/20/2005 | 5.71 | 5.27 | 4.26 | ||||
5/27/2005 | 5.65 | 5.21 | 4.21 | ||||
6/3/2005 | 5.62 | 5.2 | 4.26 | ||||
6/10/2005 | 5.56 | 5.14 | 4.21 | ||||
6/17/2005 | 5.63 | 5.22 | 4.25 | ||||
6/24/2005 | 5.57 | 5.16 | 4.23 | ||||
7/1/2005 | 5.53 | 5.12 | 4.24 | ||||
7/8/2005 | 5.62 | 5.2 | 4.33 | ||||
7/15/2005 | 5.66 | 5.25 | 4.39 | ||||
7/22/2005 | 5.73 | 5.32 | 4.42 | ||||
7/29/2005 | 5.77 | 5.34 | 4.46 | ||||
7/1/2005 | 5.53 | 5.12 | 4.24 | ||||
7/8/2005 | 5.62 | 5.2 | 4.33 | ||||
7/15/2005 | 5.66 | 5.25 | 4.39 | ||||
7/22/2005 | 5.73 | 5.32 | 4.42 | ||||
7/29/2005 | 5.77 | 5.34 | 4.46 | ||||
8/5/2005 | 5.82 | 5.38 | 4.47 | ||||
8/12/2005 | 5.89 | 5.47 | 4.57 | ||||
8/19/2005 | 5.8 | 5.4 | 4.58 | ||||
8/26/2005 | 5.77 | 5.35 | 4.56 | ||||
9/2/2005 | 5.71 | 5.32 | 4.48 | ||||
9/9/2005 | 5.71 | 5.3 | 4.45 | ||||
9/16/2005 | 5.74 | 5.32 | 4.46 | ||||
9/23/2005 | 5.8 | 5.37 | 4.48 | ||||
9/30/2005 | 5.91 | 5.48 | 4.68 | ||||
10/7/2005 | 5.98 | 5.54 | 4.77 | ||||
10/14/2005 | 6.03 | 5.62 | 4.85 | ||||
10/21/2005 | 6.1 | 5.65 | 4.89 | ||||
10/28/2005 | 6.15 | 5.69 | 4.91 | ||||
11/4/2005 | 6.31 | 5.85 | 5.09 | ||||
11/11/2005 | 6.36 | 5.89 | 5.12 | ||||
11/18/2005 | 6.37 | 5.9 | 5.2 | ||||
11/25/2005 | 6.28 | 5.81 | 5.14 | ||||
12/2/2005 | 6.26 | 5.81 | 5.16 | ||||
12/9/2005 | 6.32 | 5.87 | 5.16 | ||||
12/16/2005 | 6.3 | 5.85 | 5.15 | ||||
12/23/2005 | 6.26 | 5.79 | 5.22 | ||||
12/30/2005 | 6.22 | 5.76 | 5.15 | ||||
1/6/2006 | 6.21 | 5.76 | 5.16 | ||||
1/13/2006 | 6.15 | 5.71 | 5.15 | ||||
1/20/2006 | 6.1 | 5.67 | 5.18 | ||||
1/27/2006 | 6.12 | 5.7 | 5.2 | ||||
2/3/2006 | 6.23 | 5.81 | 5.33 | ||||
2/10/2006 | 6.24 | 5.83 | 5.34 | ||||
2/17/2006 | 6.28 | 5.91 | 5.36 | ||||
2/24/2006 | 6.26 | 5.89 | 5.32 | ||||
3/3/2006 | 6.24 | 5.89 | 5.34 | ||||
3/10/2006 | 6.37 | 6 | 5.45 | ||||
3/17/2006 | 6.34 | 5.98 | 5.37 | ||||
3/24/2006 | 6.32 | 5.97 | 5.41 | ||||
3/31/2006 | 6.35 | 6 | 5.51 | ||||
4/7/2006 | 6.43 | 6.1 | 5.57 | ||||
4/14/2006 | 6.49 | 6.14 | 5.61 | ||||
4/21/2006 | 6.53 | 6.17 | 5.63 | ||||
4/28/2006 | 6.58 | 6.21 | 5.68 | ||||
5/5/2006 | 6.59 | 6.22 | 5.67 | ||||
5/12/2006 | 6.58 | 6.17 | 5.62 | ||||
5/19/2006 | 6.6 | 6.2 | 5.62 | ||||
5/26/2006 | 6.62 | 6.23 | 5.61 | ||||
6/2/2006 | 6.67 | 6.26 | 5.68 | ||||
6/9/2006 | 6.62 | 6.23 | 5.63 | ||||
6/16/2006 | 6.63 | 6.25 | 5.66 | ||||
6/23/2006 | 6.71 | 6.36 | 5.75 | ||||
6/30/2006 | 6.78 | 6.43 | 5.82 | ||||
7/7/2006 | 6.79 | 6.44 | 5.83 | ||||
7/14/2006 | 6.74 | 6.37 | 5.75 | ||||
7/21/2006 | 6.8 | 6.41 | 5.8 | ||||
7/28/2006 | 6.72 | 6.34 | 5.78 | ||||
8/4/2006 | 6.63 | 6.27 | 5.69 | ||||
8/11/2006 | 6.55 | 6.2 | 5.69 | ||||
8/18/2006 | 6.52 | 6.2 | 5.65 | ||||
8/25/2006 | 6.48 | 6.18 | 5.6 | ||||
9/1/2006 | 6.44 | 6.14 | 5.59 | ||||
9/8/2006 | 6.47 | 6.16 | 5.63 | ||||
9/15/2006 | 6.43 | 6.11 | 5.6 | ||||
9/22/2006 | 6.4 | 6.06 | 5.54 | ||||
9/29/2006 | 6.31 | 5.98 | 5.47 | ||||
10/6/2006 | 6.3 | 5.98 | 5.46 | ||||
10/13/2006 | 6.37 | 6.06 | 5.56 | ||||
10/20/2006 | 6.36 | 6.06 | 5.57 | ||||
10/27/2006 | 6.4 | 6.1 | 5.6 | ||||
11/3/2006 | 6.31 | 6.02 | 5.53 | ||||
11/10/2006 | 6.33 | 6.04 | 5.55 | ||||
11/17/2006 | 6.24 | 5.94 | 5.53 | ||||
11/24/2006 | 6.18 | 5.91 | 5.49 | ||||
12/1/2006 | 6.14 | 5.87 | 5.46 | ||||
12/8/2006 | 6.11 | 5.84 | 5.43 | ||||
12/15/2006 | 6.12 | 5.86 | 5.45 | ||||
12/22/2006 | 6.13 | 5.89 | 5.44 | ||||
12/29/2006 | 6.18 | 5.93 | 5.47 | ||||
1/5/2007 | 6.18 | 5.94 | 5.42 | ||||
1/12/2007 | 6.21 | 5.96 | 5.44 | ||||
1/19/2007 | 6.23 | 5.98 | 5.51 | ||||
1/26/2007 | 6.25 | 5.98 | 5.49 | ||||
2/2/2007 | 6.34 | 6.06 | 5.54 | ||||
2/9/2007 | 6.28 | 6.02 | 5.49 | ||||
2/16/2007 | 6.3 | 6.03 | 5.52 | ||||
2/23/2007 | 6.22 | 5.97 | 5.49 | ||||
3/2/2007 | 6.18 | 5.92 | 5.49 | ||||
3/9/2007 | 6.14 | 5.86 | 5.47 | ||||
3/16/2007 | 6.14 | 5.88 | 5.42 | ||||
3/23/2007 | 6.16 | 5.9 | 5.4 | ||||
3/30/2007 | 6.16 | 5.86 | 5.43 | ||||
4/6/2007 | 6.17 | 5.87 | 5.44 | ||||
4/13/2007 | 6.22 | 5.9 | 5.47 | ||||
4/20/2007 | 6.17 | 5.89 | 5.45 | ||||
4/27/2007 | 6.16 | 5.87 | 5.43 | ||||
5/4/2007 | 6.16 | 5.87 | 5.42 | ||||
5/11/2007 | 6.15 | 5.87 | 5.48 | ||||
5/18/2007 | 6.21 | 5.92 | 5.48 | ||||
5/25/2007 | 6.37 | 6.06 | 5.64 | ||||
6/1/2007 | 6.42 | 6.12 | 5.57 | ||||
6/8/2007 | 6.53 | 6.22 | 5.65 | ||||
6/15/2007 | 6.74 | 6.43 | 5.75 | ||||
6/22/2007 | 6.69 | 6.37 | 5.66 | ||||
6/29/2007 | 6.67 | 6.34 | 5.65 | ||||
7/6/2007 | 6.63 | 6.3 | 5.71 | ||||
7/13/2007 | 6.73 | 6.39 | 5.71 | ||||
7/20/2007 | 6.73 | 6.38 | 5.72 | ||||
7/27/2007 | 6.69 | 6.37 | 5.69 | ||||
8/3/2007 | 6.68 | 6.32 | 5.59 | ||||
8/10/2007 | 6.59 | 6.25 | 5.65 | ||||
8/17/2007 | 6.62 | 6.3 | 5.67 | ||||
8/24/2007 | 6.52 | 6.18 | 5.6 | ||||
8/31/2007 | 6.45 | 6.12 | 5.84 | ||||
9/7/2007 | 6.46 | 6.15 | 5.74 | ||||
9/14/2007 | 6.31 | 5.97 | 5.66 | ||||
9/21/2007 | 6.34 | 5.98 | 5.65 | ||||
9/28/2007 | 6.42 | 6.09 | 5.6 | ||||
10/5/2007 | 6.37 | 6.03 | 5.58 | ||||
10/12/2007 | 6.4 | 6.06 | 5.73 | ||||
10/19/2007 | 6.4 | 6.08 | 5.76 | ||||
10/26/2007 | 6.33 | 5.99 | 5.66 | ||||
11/2/2007 | 6.26 | 5.91 | 5.57 | ||||
11/9/2007 | 6.24 | 5.9 | 5.5 | ||||
|
|
|
| ||||
11/23/2007 | 6.2 | 5.83 | 5.42 | ||||
11/30/2007 | 6.1 | 5.73 | 5.43 | ||||
12/7/2007 | 5.96 | 5.65 | 5.46 | ||||
12/14/2007 | 6.11 | 5.78 | 5.5 | ||||
12/21/2007 | 6.14 | 5.79 | 5.51 | ||||
12/28/2007 | 6.17 | 5.79 | 5.53 | ||||
1/4/2008 | 6.07 | 5.68 | 5.47 | ||||
1/11/2008 | 5.87 | 5.43 | 5.37 | ||||
1/18/2008 | 5.69 | 5.21 | 5.26 | ||||
1/25/2008 | 5.48 | 4.95 | 4.99 | ||||
2/1/2008 | 5.68 | 5.17 | 5.05 | ||||
2/8/2008 | 5.67 | 5.15 | 5.03 | ||||
2/15/2008 | 5.72 | 5.25 | 5 | ||||
2/22/2008 | 6.04 | 5.64 | 4.98 | ||||
2/29/2008 | 6.24 | 5.72 | 5.11 | ||||
3/7/2008 | 6.03 | 5.47 | 4.94 | ||||
3/14/2008 | 6.13 | 5.6 | 5.14 | ||||
3/21/2008 | 5.87 | 5.27 | 5.15 | ||||
3/28/2008 | 5.85 | 5.34 | 5.24 | ||||
4/4/2008 | 5.88 | 5.42 | 5.19 | ||||
4/11/2008 |
|
|
| ||||
4/18/2008 | 5.88 | 5.4 | 5.1 | ||||
4/25/2008 | 6.03 | 5.62 | 5.29 | ||||
5/2/2008 | 6.06 | 5.59 | 5.29 | ||||
5/9/2008 | 6.05 | 5.6 | 5.29 | ||||
5/16/2008 | 6.01 | 5.6 | 5.18 | ||||
5/23/2008 | 5.98 | 5.55 | 5.24 | ||||
5/30/2008 | 6.08 | 5.66 | 5.22 | ||||
6/6/2008 | 6.09 | 5.65 | 5.06 | ||||
6/13/2008 | 6.32 | 5.93 | 5.09 | ||||
6/20/2008 | 6.42 | 6.02 | 5.19 | ||||
6/27/2008 | 6.45 | 6.04 | 5.27 | ||||
7/4/2008 | 6.35 | 5.92 | 5.17 | ||||
7/11/2008 | 6.37 | 5.91 | 5.17 | ||||
7/18/2008 | 6.26 | 5.78 | 5.1 | ||||
7/25/2008 | 6.63 | 6.18 | 5.49 | ||||
8/1/2008 | 6.52 | 6.07 | 5.27 | ||||
8/8/2008 | 6.52 | 6.1 | 5.22 | ||||
8/15/2008 | 6.52 | 6.07 | 5.18 | ||||
8/22/2008 | 6.47 | 6 | 5.29 | ||||
8/29/2008 | 6.4 | 5.93 | 5.33 | ||||
9/5/2008 | 6.35 | 5.9 | 5.15 | ||||
9/12/2008 | 5.93 | 5.54 | 5.21 | ||||
9/19/2008 | 5.78 | 5.35 | 5.03 | ||||
9/26/2008 | 6.09 | 5.77 | 5.16 | ||||
10/3/2008 | 6.1 | 5.78 | 5.12 | ||||
10/10/2008 | 5.94 | 5.63 | 5.15 | ||||
10/17/2008 | 6.46 | 6.14 | 5.16 | ||||
10/24/2008 | 6.04 | 5.72 | 5.23 | ||||
10/31/2008 | 6.46 | 6.19 | 5.38 | ||||
11/7/2008 | 6.2 | 5.88 | 5.25 | ||||
11/14/2008 | 6.14 | 5.81 | 5.33 | ||||
11/21/2008 | 6.04 | 5.73 | 5.29 | ||||
11/28/2008 | 5.97 | 5.74 | 5.18 | ||||
12/5/2008 | 5.53 | 5.33 | 5.02 | ||||
12/12/2008 | 5.47 | 5.2 | 5.09 | ||||
12/19/2008 | 5.19 | 4.92 | 4.94 | ||||
12/26/2008 | 5.14 | 4.91 | 4.95 | ||||
1/9/2009 | 5.01 | 4.62 | 4.95 | ||||
1/16/2009 | 4.96 | 4.65 | 4.89 | ||||
1/23/2009 | 5.12 | 4.8 | 4.92 | ||||
1/30/2009 | 5.1 | 4.8 | 4 | ||||
2/6/2009 | 5.25 | 4.92 | 4.92 | ||||
2/13/2009 | 5.16 | 4.81 | 4.94 | ||||
2/20/2009 | 5.04 | 4.68 | 4.8 | ||||
2/27/2009 | 5.07 | 4.68 | 4.81 | ||||
3/6/2009 | 5.15 | 4.72 | 4.86 | ||||
3/13/2009 | 5.03 | 4.64 | 4.8 | ||||
3/20/2009 | 4.98 | 4.61 | 4.91 | ||||
3/27/2009 | 4.85 | 4.58 | 4.85 | ||||
4/3/2009 | 4.78 | 4.52 | 4.75 | ||||
4/10/2009 | 4.87 | 4.54 | 4.83 | ||||
4/17/2009 | 4.82 | 4.48 | 4.91 | ||||
4/24/2009 | 4.8 | 4.48 | 4.82 | ||||
5/1/2009 | 4.78 | 4.48 | 4.77 | ||||
5/8/2009 | 4.84 | 4.51 | 4.78 | ||||
5/15/2009 | 4.86 | 4.52 | 4.71 | ||||
5/22/2009 | 4.82 | 4.5 | 4.82 | ||||
5/29/2009 | 4.91 | 4.53 | 4.69 | ||||
6/5/2009 | 5.29 | 4.79 | 4.81 | ||||
6/12/2009 | 5.59 | 5.06 | 5.04 | ||||
6/19/2009 | 5.38 | 4.89 | 4.95 | ||||
6/26/2009 | 5.42 | 4.87 | 4.93 | ||||
7/3/2009 | 5.32 | 4.77 | 4.94 | ||||
7/10/2009 | 5.2 | 4.69 | 4.82 | ||||
7/17/2009 | 5.14 | 4.63 | 4.76 | ||||
7/24/2009 | 5.2 | 4.68 | 4.77 | ||||
7/31/2009 | 5.25 | 4.69 | 4.8 | ||||
8/7/2009 | 5.22 | 4.63 | 4.78 | ||||
8/14/2009 | 5.29 | 4.68 | 4.72 | ||||
8/21/2009 | 5.12 | 4.56 | 4.69 | ||||
8/28/2009 | 5.14 | 4.58 | 4.69 | ||||
9/4/2009 | 5.08 | 5.54 | 4.62 | ||||
9/11/2009 | 5.07 | 4.5 | 4.64 | ||||
9/18/2009 | 5.04 | 4.47 | 4.58 | ||||
9/25/2009 | 5.04 | 4.46 | 4.52 | ||||
10/2/2009 | 4.94 | 4.36 | 4.49 | ||||
10/9/2009 | 4.87 | 4.33 | 4.53 | ||||
10/16/2009 | 4.92 | 4.37 | 4.6 | ||||
10/23/2009 | 5 | 4.43 | 4.54 | ||||
10/30/2009 | 5.03 | 4.46 | 4.57 | ||||
11/6/2009 | 4.98 | 4.4 | 4.47 | ||||
11/13/2009 | 4.91 | 4.36 | 4.46 | ||||
11/20/2009 | 4.83 | 4.32 | 4.35 | ||||
11/27/2009 | 4.78 | 4.29 | 4.35 | ||||
12/4/2009 | 4.71 | 4.27 | 4.25 | ||||
12/11/2009 | 4.81 | 4.32 | 4.24 | ||||
12/18/2009 | 4.94 | 4.38 | 4.34 | ||||
12/25/2009 | 5.05 | 4.45 | 4.38 | ||||
1/1/2010 | 5.14 | 4.54 | 4.33 | ||||
1/8/2010 | 5.09 | 4.5 | 4.31 | ||||
1/15/2010 | 5.06 | 4.45 | 4.39 | ||||
1/22/2010 | 4.99 | 4.4 | 4.32 | ||||
1/29/2010 | 4.98 | 4.39 | 4.29 | ||||
2/5/2010 | 5.01 | 4.4 | 4.22 | ||||
2/12/2010 | 4.97 | 4.34 | 4.33 | ||||
2/19/2010 | 4.93 | 4.33 | 4.23 | ||||
2/26/2010 | 5.05 | 4.4 | 4.15 | ||||
3/5/2010 | 4.97 | 4.33 | 4.27 | ||||
3/12/2010 | 4.95 | 4.32 | 4.22 | ||||
3/19/2010 | 4.96 | 4.33 | 4.12 | ||||
3/26/2010 | 4.99 | 4.34 | 4.2 | ||||
4/2/2010 | 5.08 | 4.39 | 4.05 | ||||
4/9/2010 | 5.21 | 4.52 | 4.14 | ||||
4/16/2010 | 5.07 | 4.4 | 4.13 | ||||
4/23/2010 | 5.07 | 4.39 | 4.22 | ||||
4/30/2010 | 5.06 | 4.39 | 4.25 | ||||
5/7/2010 | 5 | 4.36 | 4.07 | ||||
5/14/2010 | 4.93 | 4.3 | 4.02 | ||||
5/21/2010 | 4.84 | 4.24 | 4 | ||||
5/28/2010 | 4.78 | 4.21 | 3.95 | ||||
6/4/2010 | 4.79 | 4.2 | 3.95 | ||||
6/11/2010 | 4.72 | 4.17 | 3.91 | ||||
6/18/2010 | 4.75 | 4.2 | 3.82 | ||||
6/25/2010 | 4.69 | 4.13 | 3.77 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started