Question
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.
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 21Step 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