Question: PLEASE ANSWER ONLY QUESTION B!! SOLVE IN EXCEL Years Mortgage Percentage 1993 7.33% 1994 8.29% 1995 8.01% 1996 7.83% 1997 7.65% 1998 6.97% 1999 7.39%
PLEASE ANSWER ONLY QUESTION B!! SOLVE IN EXCEL
| Years | Mortgage Percentage |
| 1993 | 7.33% |
| 1994 | 8.29% |
| 1995 | 8.01% |
| 1996 | 7.83% |
| 1997 | 7.65% |
| 1998 | 6.97% |
| 1999 | 7.39% |
| 2000 | 8.12% |
| 2001 | 6.96% |
| 2002 | 6.59% |
| 2003 | 5.82% |
| 2004 | 5.85% |
| 2005 | 5.82% |
| 2006 | 6.44% |
| 2007 | 6.36% |
| 2008 | 6.11% |
| 2009 | 5.05% |
| 2010 | 4.69% |
| 2011 | 4.50% |
| 2012 | 3.69% |
| 2013 | 3.93% |
| 2014 | 4.21% |
| 2015 | 3.84% |
| 2016 | 3.60% |
| 2017 | 4.00% |
| 2018 | 4.53% |
| 2019 | 4.13% |
| 2020 | 3.38% |
| 2021 | 2.65% |
| 2022 | 7.08% |
| 2023 | 7.92% |
| 2024 | |
| 2025 | |
| 2026 |
(10) A. Tasking: Starting with the data provided, update the data to make it CURFENT and create your oum chart, with linear trend line [show your own final chart with trend line \& equation). (6) B. Following sound forecasting principles, select a different trend line that not only fits the overall dhat but genterates a reasonatbleffeasible 3-Year forecast out through 2026 by choosing ONE of the following: 1) Exponential 2) Linear 3) Logarithmik 4) Polynomial (order 2 thru Gr 5) Power Show your forecast using your chosen method (1 thru 6 ). NOTE: YOu MUST CALCULATE and PLOT your forecasted values going out thru 2026 using your chosen forecasting algorithm
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
Study Help