FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Statistics For Business Decision Making And Analysis

Statistics For Business Decision Making And Analysis

Authors: Robert Stine, Dean Foster

2nd Edition

978-0321836519, 321836510, 978-0321890269

More Books

Students also viewed these Economics questions

Question

★★★★★
If you deposit $4,000 at the end of each of the next 20 years into an account paying 9.7 percent interest, how much money will you have in the account in 20 years? How much will you have if you make...

Answered: 1 week ago

Question

★★★★★
Discuss the importance of sampling bias, access issues, and sample size.

Answered: 1 week ago

Question

★★★★★
Shari Patel of the controller's office of Diamond Corporation was given the assignment of determining the basic and diluted earnings per share values for the year ending December 31, 2014. Patel has...

Answered: 1 week ago

Question

★★★★★
5 The financial statements for Lexington Service Company include the following items: Compute the current ratio for 2016. (Round answer to two decimal places.) 2017 2016 Cast Short-terin Investments...

Answered: 1 week ago

Question

★★★★★
INTRA-ENTITY INVENTORY TRANSFER Pit Corporation owns 70% of Stop Companys outstanding common stock. On 08/28/20, Pit sold inventory to Stop in exchange for $560,000 cash. Pit had purchased the...

Answered: 1 week ago

Question

★★★★★
Dan owned a farm. Most of his products are being supplied to different restaurants. Products include cow's milk, chicken egg, meat (chicken, pork, and beef). On the side, they also sell carrots,...

Answered: 1 week ago

Question

★★★★★
Task 1: A. Describe the operation of the following thermodynamic systems and their properties: (i) System (ii) Surroundings (iii) Open System (iv) Close System (v) Isolated System B. A large fraction...

Answered: 1 week ago

Question

★★★★★
3. (10 points) In this question you will see that soft-SVM can be formulated as solving a regularized ERM rule, which uses a popular error function called hinge loss (see https:...

Answered: 1 week ago

Question

★★★★★
Suppose that Ivanhoe International Ltd. had the following records: 2025 2024 Ending inventory $48650 $27490 Cost of goods sold 222100 210890 What is Ivanhoe's average days in inventory for 2025?...

Answered: 1 week ago

Question

★★★★★
1 . If Custom Call Services does transition to a PTO policy, what are some things that Stan should consider including in the policy to address concerns about absenteeism ?

Answered: 1 week ago

Question

★★★★★
Mr Barry & Mrs Luke operate a roofing company which manufactures roofs for the commercial market in Darwin. The company is 'No.1 in Roofs Pty Ltd'. Mr Barry is director of the company and Mrs Luke is...

Answered: 1 week ago

Previous Question Next Question