Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I'm not sure how to create a regression model for this data: the question asks; Forecast the out-of-sample values for every month in the period

I'm not sure how to create a regression model for this data: the question asks; Forecast the out-of-sample values for every month in the period August 2020 - July 2021 (both months inclusive) using a multiple linear regression with an intercept, time as an explanatory variable, and 11 dummy variables for all months except January - hence use January as the base. Once you perform this regression, what are the following numerical values: I know the Significance F = 0.000000000 anf F = 1213.09 however I can't get to those values. Any help is appreicated.

image text in transcribed
C26 X V fx A B C D E F G H 1 Time Year Total Employed 2 1 Aug-2020 12563.7 3 2 Sep-2020 12568.0 4 3 Oct-2020 12737.4 5 4 Nov-2020 12884.5 6 5 Dec-2020 12998.7 7 6 Jan-2021 12734.5 8 7 Feb-2021 13031.2 9 8 Mar-2021 13052.4 10 9 Apr-2021 13022.9 11 10 May-2021 13187.4 12 11 Jun-2021 13168.3 13 12 Jul-2021 13148.1 14 15 16 17 18 19 20 21

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Finite Mathematics

Authors: Stefan Waner, Jerry Lee Ford Jr, Waner/Costenoble, Steven Costenoble

5th Edition

1111789304, 9781111789305

More Books

Students also viewed these Mathematics questions