Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please do LINEAR REGRESSION FORECASTING MODEL on this time series to find MAE , MSE and MAPE. Please upload workings on excel thank you in
Please do LINEAR REGRESSION FORECASTING MODEL on this time series to find MAE , MSE and MAPE. Please upload workings on excel thank you in advance team!
Date | Private Dwellig Approvals |
Jan-1965 | 8.8 |
Feb-65 | 9.1 |
Mar-65 | 8.7 |
Apr-65 | 8.9 |
May-65 | 8.4 |
Jun-65 | 8.6 |
Jul-65 | 8.2 |
Aug-65 | 7.9 |
Sep-65 | 7.7 |
Oct-65 | 7.7 |
Nov-65 | 7.6 |
Dec-65 | 7.4 |
Jan-66 | 7.7 |
Feb-66 | 8.1 |
Mar-66 | 8.2 |
Apr-66 | 8 |
May-66 | 8.2 |
Jun-66 | 8.5 |
Jul-66 | 8.3 |
Aug-66 | 8.5 |
Sep-66 | 8.5 |
Oct-66 | 9.1 |
Nov-66 | 8.6 |
Dec-66 | 8.5 |
Jan-67 | 8.4 |
Feb-67 | 9.3 |
Mar-67 | 7.9 |
Apr-67 | 8.9 |
May-67 | 9.2 |
Jun-67 | 9 |
Jul-67 | 9.2 |
Aug-67 | 9.4 |
Sep-67 | 9.4 |
Oct-67 | 9.8 |
Nov-67 | 9.9 |
Dec-67 | 9.5 |
Jan-68 | 11 |
Feb-68 | 9.6 |
Mar-68 | 10.2 |
Apr-68 | 10 |
May-68 | 10.7 |
Jun-68 | 10.5 |
Jul-68 | 10.9 |
Aug-68 | 10.9 |
Sep-68 | 11.3 |
Oct-68 | 10.5 |
Nov-68 | 10.8 |
Dec-68 | 11 |
Jan-69 | 11 |
Feb-69 | 10.9 |
Mar-69 | 10.7 |
Apr-69 | 11.3 |
May-69 | 11.6 |
Jun-69 | 11.3 |
Jul-69 | 11.8 |
Aug-69 | 11.9 |
Sep-69 | 11.3 |
Oct-69 | 11.7 |
Nov-69 | 11.8 |
Dec-69 | 13.1 |
Jan-70 | 11.9 |
Feb-70 | 12.2 |
Mar-70 | 11.4 |
Apr-70 | 12 |
May-70 | 9.6 |
Jun-70 | 9.4 |
Jul-70 | 9 |
Aug-70 | 9.7 |
Sep-70 | 10.4 |
Oct-70 | 10.5 |
Nov-70 | 10.2 |
Dec-70 | 10.9 |
Jan-71 | 10.8 |
Feb-71 | 10.4 |
Mar-71 | 10 |
Apr-71 | 10.8 |
May-71 | 10.1 |
Jun-71 | 10.6 |
Jul-71 | 11 |
Aug-71 | 11.4 |
Sep-71 | 10.4 |
Oct-71 | 11.2 |
Nov-71 | 10.9 |
Dec-71 | 11.4 |
Jan-72 | 11.6 |
Feb-72 | 11.6 |
Mar-72 | 12.1 |
Apr-72 | 10.8 |
May-72 | 12.2 |
Jun-72 | 12.4 |
Jul-72 | 12.3 |
Aug-72 | 12.7 |
Sep-72 | 13.7 |
Oct-72 | 13.4 |
Nov-72 | 14 |
Dec-72 | 13.9 |
Jan-73 | 15.8 |
Feb-73 | 14.5 |
Mar-73 | 15.7 |
Apr-73 | 14.4 |
May-73 | 15.6 |
Jun-73 | 16.2 |
Jul-73 | 15.9 |
Aug-73 | 16 |
Sep-73 | 15.8 |
Oct-73 | 15.4 |
Nov-73 | 14.6 |
Dec-73 | 13.6 |
Jan-74 | 13.1 |
Feb-74 | 12.7 |
Mar-74 | 12 |
Apr-74 | 11.7 |
May-74 | 12.6 |
Jun-74 | 11.3 |
Jul-74 | 10.6 |
Aug-74 | 8.2 |
Sep-74 | 7.3 |
Oct-74 | 7.4 |
Nov-74 | 7.5 |
Dec-74 | 7.6 |
Jan-75 | 7.7 |
Feb-75 | 7.9 |
Mar-75 | 9.3 |
Apr-75 | 8.8 |
May-75 | 9.5 |
Jun-75 | 9.7 |
Jul-75 | 9.6 |
Aug-75 | 10 |
Sep-75 | 10.6 |
Oct-75 | 10.7 |
Nov-75 | 12 |
Dec-75 | 11.4 |
Jan-76 | 11.2 |
Feb-76 | 12.1 |
Mar-76 | 11.5 |
Apr-76 | 12.2 |
May-76 | 11.4 |
Jun-76 | 11.1 |
Jul-76 | 11.4 |
Aug-76 | 10.9 |
Sep-76 | 11.5 |
Oct-76 | 11.4 |
Nov-76 | 11.3 |
Dec-76 | 11.2 |
Jan-77 | 11.6 |
Feb-77 | 10.3 |
Mar-77 | 8.5 |
Apr-77 | 10 |
May-77 | 9.6 |
Jun-77 | 9.5 |
Jul-77 | 9.9 |
Aug-77 | 9.9 |
Sep-77 | 9.3 |
Oct-77 | 9.6 |
Nov-77 | 9.1 |
Dec-77 | 9.3 |
Jan-78 | 9.3 |
Feb-78 | 9 |
Mar-78 | 9.1 |
Apr-78 | 8.8 |
May-78 | 8.8 |
Jun-78 | 8.9 |
Jul-78 | 8.8 |
Aug-78 | 8.8 |
Sep-78 | 9.5 |
Oct-78 | 9.7 |
Nov-78 | 9.7 |
Dec-78 | 10.3 |
Jan-79 | 9.3 |
Feb-79 | 10.3 |
Mar-79 | 10.1 |
Apr-79 | 10 |
May-79 | 10.7 |
Jun-79 | 10.7 |
Jul-79 | 10.7 |
Aug-79 | 10.6 |
Sep-79 | 10.9 |
Oct-79 | 11 |
Nov-79 | 11.2 |
Dec-79 | 10.2 |
Jan-80 | 11 |
Feb-80 | 11.6 |
Mar-80 | 11.9 |
Apr-80 | 12.1 |
May-80 | 11.7 |
Jun-80 | 11.9 |
Jul-80 | 11.5 |
Aug-80 | 12.3 |
Sep-80 | 11.8 |
Oct-80 | 12.2 |
Nov-80 | 12.4 |
Dec-80 | 12.3 |
Jan-81 | 12.6 |
Feb-81 | 12.3 |
Mar-81 | 12.5 |
Apr-81 | 12.8 |
May-81 | 12 |
Jun-81 | 12.5 |
Jul-81 | 12 |
Aug-81 | 12.4 |
Sep-81 | 12 |
Oct-81 | 11.8 |
Nov-81 | 11.6 |
Dec-81 | 10.9 |
Jan-82 | 11.1 |
Feb-82 | 10.6 |
Mar-82 | 10.3 |
Apr-82 | 10 |
May-82 | 9.4 |
Jun-82 | 8.8 |
Jul-82 | 9.3 |
Aug-82 | 8.2 |
Sep-82 | 8 |
Oct-82 | 8 |
Nov-82 | 8.1 |
Dec-82 | 8 |
Jan-83 | 8 |
Feb-83 | 8.5 |
Mar-83 | 8.6 |
Apr-83 | 8.7 |
May-83 | 9.5 |
Jun-83 | 9.5 |
Jul-83 | 9.2 |
Aug-83 | 10.3 |
Sep-83 | 10.6 |
Oct-83 | 10.9 |
Nov-83 | 10.8 |
Dec-83 | 12 |
Jan-84 | 10.4 |
Feb-84 | 11.8 |
Mar-84 | 12.5 |
Apr-84 | 12.2 |
May-84 | 13 |
Jun-84 | 12.2 |
Jul-84 | 12.6 |
Aug-84 | 12.8 |
Sep-84 | 11.6 |
Oct-84 | 12.2 |
Nov-84 | 12.2 |
Dec-84 | 12.1 |
Jan-85 | 11.9 |
Feb-85 | 12.1 |
Mar-85 | 12 |
Apr-85 | 12.7 |
May-85 | 11.9 |
Jun-85 | 12.5 |
Jul-85 | 12.3 |
Aug-85 | 12 |
Sep-85 | 11.8 |
Oct-85 | 12.5 |
Nov-85 | 10.8 |
Dec-85 | 10.2 |
Jan-86 | 10.5 |
Feb-86 | 9.9 |
Mar-86 | 9.6 |
Apr-86 | 9.2 |
May-86 | 8.9 |
Jun-86 | 9.6 |
Jul-86 | 9.5 |
Aug-86 | 9.1 |
Sep-86 | 9.1 |
Oct-86 | 9 |
Nov-86 | 9.3 |
Dec-86 | 9.2 |
Jan-87 | 8.7 |
Feb-87 | 9 |
Mar-87 | 9.2 |
Apr-87 | 8.6 |
May-87 | 9.4 |
Jun-87 | 9.2 |
Jul-87 | 9.6 |
Aug-87 | 9.9 |
Sep-87 | 10.2 |
Oct-87 | 10.9 |
Nov-87 | 11.4 |
Dec-87 | 11.6 |
Jan-88 | 12.5 |
Feb-88 | 12.3 |
Mar-88 | 12.3 |
Apr-88 | 13.6 |
May-88 | 13.4 |
Jun-88 | 14.4 |
Jul-88 | 14.4 |
Aug-88 | 15.9 |
Sep-88 | 15 |
Oct-88 | 14.8 |
Nov-88 | 15 |
Dec-88 | 14.7 |
Jan-89 | 14.7 |
Feb-89 | 15 |
Mar-89 | 14.6 |
Apr-89 | 15.2 |
May-89 | 14.2 |
Jun-89 | 13.3 |
Jul-89 | 11.7 |
Aug-89 | 11.5 |
Sep-89 | 11.2 |
Oct-89 | 11.5 |
Nov-89 | 11.1 |
Dec-89 | 10.8 |
Jan-90 | 10.4 |
Feb-90 | 11.2 |
Mar-90 | 10.9 |
Apr-90 | 10.7 |
May-90 | 10.5 |
Jun-90 | 9.9 |
Jul-90 | 9.8 |
Aug-90 | 9.8 |
Sep-90 | 9.8 |
Oct-90 | 9.7 |
Nov-90 | 10.6 |
Dec-90 | 9.4 |
Jan-91 | 9.9 |
Feb-91 | 9.9 |
Mar-91 | 9.9 |
Apr-91 | 9.5 |
May-91 | 10.6 |
Jun-91 | 10.2 |
Jul-91 | 11.3 |
Aug-91 | 11.3 |
Sep-91 | 11.2 |
Oct-91 | 11.2 |
Nov-91 | 11 |
Dec-91 | 11.1 |
Jan-92 | 11.4 |
Feb-92 | 11.5 |
Mar-92 | 11.9 |
Apr-92 | 12 |
May-92 | 12.4 |
Jun-92 | 12.7 |
Jul-92 | 12.8 |
Aug-92 | 13.2 |
Sep-92 | 12.9 |
Oct-92 | 13.4 |
Nov-92 | 13.2 |
Dec-92 | 13.9 |
Jan-93 | 14 |
Feb-93 | 13.3 |
Mar-93 | 13.9 |
Apr-93 | 14.4 |
May-93 | 13.6 |
Jun-93 | 13.8 |
Jul-93 | 14.4 |
Aug-93 | 14.3 |
Sep-93 | 14.5 |
Oct-93 | 14.7 |
Nov-93 | 14.7 |
Dec-93 | 14.8 |
Jan-94 | 15.6 |
Feb-94 | 14.8 |
Mar-94 | 14.9 |
Apr-94 | 15.2 |
May-94 | 16.8 |
Jun-94 | 15.8 |
Jul-94 | 14.8 |
Aug-94 | 17.2 |
Sep-94 | 16.4 |
Oct-94 | 15.3 |
Nov-94 | 14.3 |
Dec-94 | 13.9 |
Jan-95 | 12.9 |
Feb-95 | 12.7 |
Mar-95 | 11.8 |
Apr-95 | 11.5 |
May-95 | 11.7 |
Jun-95 | 10.9 |
Jul-95 | 10.7 |
Aug-95 | 10 |
Sep-95 | 10.5 |
Oct-95 | 9.5 |
Nov-95 | 9.7 |
Dec-95 | 9.8 |
Jan-96 | 8.9 |
Feb-96 | 10.1 |
Mar-96 | 9.9 |
Apr-96 | 9.6 |
May-96 | 10.5 |
Jun-96 | 9.8 |
Jul-96 | 10.3 |
Aug-96 | 10.7 |
Sep-96 | 9.6 |
Oct-96 | 10.7 |
Nov-96 | 10.4 |
Dec-96 | 10.3 |
Jan-97 | 11 |
Feb-97 | 11.6 |
Mar-97 | 11.5 |
Apr-97 | 11.7 |
May-97 | 12.3 |
Jun-97 | 11.4 |
Jul-97 | 11.1 |
Aug-97 | 13.1 |
Sep-97 | 12.1 |
Oct-97 | 11.8 |
Nov-97 | 12.5 |
Dec-97 | 12.6 |
Jan-98 | 12.8 |
Feb-98 | 12.2 |
Mar-98 | 12.8 |
Apr-98 | 13.7 |
May-98 | 12.7 |
Jun-98 | 13.5 |
Jul-98 | 13.2 |
Aug-98 | 12.3 |
Sep-98 | 12 |
Oct-98 | 11.8 |
Nov-98 | 12.7 |
Dec-98 | 12.7 |
Jan-99 | 11.9 |
Feb-99 | 12.9 |
Mar-99 | 12.3 |
Apr-99 | 13.1 |
May-99 | 12.8 |
Jun-99 | 13.4 |
Jul-99 | 14.4 |
Aug-99 | 15 |
Sep-99 | 14.3 |
Oct-99 | 14.5 |
Nov-99 | 15.1 |
Dec-99 | 15.5 |
Jan-00 | 16.4 |
Feb-00 | 15.9 |
Mar-00 | 14.4 |
Apr-00 | 13.9 |
May-00 | 12.8 |
Jun-00 | 10.4 |
Jul-00 | 9.3 |
Aug-00 | 8.9 |
Sep-00 | 8.8 |
Oct-00 | 9.1 |
Nov-00 | 10.2 |
Dec-00 | 9.8 |
Jan-01 | 9.7 |
Feb-01 | 9 |
Mar-01 | 9.3 |
Apr-01 | 10.1 |
May-01 | 11.8 |
Jun-01 | 12 |
Jul-01 | 12.6 |
Aug-01 | 14.7 |
Sep-01 | 14.4 |
Oct-01 | 14.4 |
Nov-01 | 14.2 |
Dec-01 | 14 |
Jan-02 | 13.9 |
Feb-02 | 13.3 |
Mar-02 | 14.4 |
Apr-02 | 15.6 |
May-02 | 14.5 |
Jun-02 | 14.2 |
Jul-02 | 13.7 |
Aug-02 | 17.5 |
Sep-02 | 13.7 |
Oct-02 | 17.6 |
Nov-02 | 13.5 |
Dec-02 | 13.8 |
Jan-03 | 14.6 |
Feb-03 | 13.4 |
Mar-03 | 14.5 |
Apr-03 | 14.5 |
May-03 | 14.1 |
Jun-03 | 14.2 |
Jul-03 | 14.9 |
Aug-03 | 14.7 |
Sep-03 | 16.2 |
Oct-03 | 16.5 |
Nov-03 | 14.6 |
Dec-03 | 14.6 |
Jan-04 | 14.8 |
Feb-04 | 14.4 |
Mar-04 | 15.1 |
Apr-04 | 15.2 |
May-04 | 14.9 |
Jun-04 | 14.4 |
Jul-04 | 13.8 |
Aug-04 | 13.5 |
Sep-04 | 12.7 |
Oct-04 | 12.6 |
Nov-04 | 12.5 |
Dec-04 | 13.4 |
Jan-05 | 13.7 |
Feb-05 | 13.3 |
Mar-05 | 12.9 |
Apr-05 | 13.1 |
May-05 | 14.6 |
Jun-05 | 14.1 |
Jul-05 | 12.6 |
Aug-05 | 11.9 |
Sep-05 | 11.9 |
Oct-05 | 11.9 |
Nov-05 | 12.3 |
Dec-05 | 12.5 |
Jan-06 | 12.4 |
Feb-06 | 12.6 |
Mar-06 | 12.7 |
Apr-06 | 12.3 |
May-06 | 13.2 |
Jun-06 | 13.1 |
Jul-06 | 13.8 |
Aug-06 | 12.5 |
Sep-06 | 12.8 |
Oct-06 | 12.1 |
Nov-06 | 12.4 |
Dec-06 | 12.2 |
Jan-07 | 12.3 |
Feb-07 | 13.4 |
Mar-07 | 12.1 |
Apr-07 | 12.6 |
May-07 | 12.5 |
Jun-07 | 12.9 |
Jul-07 | 12.8 |
Aug-07 | 12.6 |
Sep-07 | 13.6 |
Oct-07 | 13.9 |
Nov-07 | 14.3 |
Dec-07 | 13.9 |
Jan-08 | 14 |
Feb-08 | 13.4 |
Mar-08 | 12.3 |
Apr-08 | 13.4 |
May-08 | 12.7 |
Jun-08 | 13 |
Jul-08 | 12.7 |
Aug-08 | 12 |
Sep-08 | 11.4 |
Oct-08 | 11.3 |
Nov-08 | 10 |
Dec-08 | 9.6 |
Jan-09 | 9.2 |
Feb-09 | 10.5 |
Mar-09 | 10.5 |
Apr-09 | 11 |
May-09 | 10.2 |
Jun-09 | 11.3 |
Jul-09 | 12.5 |
Aug-09 | 12.1 |
Sep-09 | 13.4 |
Oct-09 | 12.9 |
Nov-09 | 13.4 |
Dec-09 | 13.8 |
Jan-10 | 13.2 |
Feb-10 | 13.4 |
Mar-10 | 14.8 |
Apr-10 | 14.2 |
May-10 | 13.6 |
Jun-10 | 13.9 |
Jul-10 | 14.3 |
Aug-10 | 14 |
Sep-10 | 13.1 |
Oct-10 | 14.6 |
Nov-10 | 13.5 |
Dec-10 | 14.4 |
Jan-11 | 12.8 |
Feb-11 | 12.5 |
Mar-11 | 13.7 |
Apr-11 | 13.6 |
May-11 | 12.5 |
Jun-11 | 12.4 |
Jul-11 | 12.6 |
Aug-11 | 14.5 |
Sep-11 | 12.1 |
Oct-11 | 11.1 |
Nov-11 | 11.6 |
Dec-11 | 11.6 |
Jan-12 | 11 |
Feb-12 | 11.6 |
Mar-12 | 11.6 |
Apr-12 | 10.7 |
May-12 | 14.1 |
Jun-12 | 14.7 |
Jul-12 | 11.5 |
Aug-12 | 13.3 |
Sep-12 | 15 |
Oct-12 | 13.8 |
Nov-12 | 13.6 |
Dec-12 | 13.7 |
Jan-13 | 12.6 |
Feb-13 | 13 |
Mar-13 | 13.1 |
Apr-13 | 14.7 |
May-13 | 13.9 |
Jun-13 | 13.4 |
Jul-13 | 14.9 |
Aug-13 | 14.7 |
Sep-13 | 18.1 |
Oct-13 | 17.4 |
Nov-13 | 17 |
Dec-13 | 16.7 |
Jan-14 | 17.5 |
Feb-14 | 16.5 |
Mar-14 | 15.7 |
Apr-14 | 16.1 |
May-14 | 16.5 |
Jun-14 | 16.3 |
Jul-14 | 16.9 |
Aug-14 | 18.3 |
Sep-14 | 16.2 |
Oct-14 | 18 |
Nov-14 | 19.9 |
Dec-14 | 19.9 |
Jan-15 | 19.6 |
Feb-15 | 19.1 |
Mar-15 | 20.5 |
Apr-15 | 18.8 |
May-15 | 20.5 |
Jun-15 | 19 |
Jul-15 | 18.9 |
Aug-15 | 19.3 |
Sep-15 | 20.1 |
Oct-15 | 21.4 |
Nov-15 | 18.6 |
Dec-15 | 20.1 |
Jan-16 | 18.6 |
Feb-16 | 19.3 |
Mar-16 | 20.5 |
Apr-16 | 20.6 |
May-16 | 19.9 |
Jun-16 | 18.5 |
Jul-16 | 21.3 |
Aug-16 | 21.7 |
Sep-16 | 19.1 |
Oct-16 | 16.3 |
Nov-16 | 18.1 |
Dec-16 | 18.2 |
Jan-17 | 16.9 |
Feb-17 | 18.5 |
Mar-17 | 16.3 |
Apr-17 | 17.9 |
May-17 | 16.8 |
Jun-17 | 18.4 |
Jul-17 | 18.9 |
Aug-17 | 19.3 |
Sep-17 | 19.6 |
Oct-17 | 19.4 |
Nov-17 | 22.8 |
Dec-17 | 17.8 |
Jan-18 | 19.4 |
Feb-18 | 18.5 |
Mar-18 | 19.5 |
Apr-18 | 18.1 |
May-18 | 17.9 |
Jun-18 | 19.2 |
Jul-18 | 18.3 |
Aug-18 | 16.4 |
Sep-18 | 16.6 |
Oct-18 | 17.1 |
Nov-18 | 14.8 |
Dec-18 | 14.1 |
Jan-19 | 14.5 |
Feb-19 | 16.1 |
Mar-19 | 14.8 |
Apr-19 | 14.2 |
May-19 | 14.2 |
Jun-19 | 14.5 |
Jul-19 | 13.3 |
Aug-19 | 13.8 |
Sep-19 | 14.5 |
Oct-19 | 14.2 |
Nov-19 | 14.4 |
Dec-19 | 15.6 |
Jan-20 | 13.3 |
Feb-20 | 15.8 |
Mar-20 | 15 |
Apr-20 | 14.6 |
May-20 | 13 |
Jun-20 | 12.4 |
Jul-20 | 14.9 |
Aug-20 | 14.3 |
Sep-20 | 15.9 |
Oct-20 | 17.2 |
Nov-20 | 17.1 |
Dec-20 | 19.1 |
Jan-21 | 16.6 |
Feb-21 | 19.3 |
Mar-21 | 22.9 |
Apr-21 | 20 |
May-21 | 20.4 |
Jun-21 | 19.4 |
Jul-21 | 18.1 |
Aug-21 | 19.2 |
Sep-21 | 19.1 |
Oct-21 | 15.9 |
Nov-21 | 15.8 |
Dec-21 | 17.2 |
Jan-22 | 12.9 |
Feb-22 | 16.9 |
Mar-22 | 15.1 |
Apr-22 | 15.1 |
May-22 | 16.2 |
Jun-22 | 16 |
Jul-22 | 13.4 |
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