Evaluating forecasting-based analytics assessment

Assignment Help Other Subject
Reference no: EM133561665 , Length: word count:1000

Data-driven Decision Making and Forecasting

Assessment - Evaluating forecasting-based analytics

Your Task

Given a dataset with multivariate time series data, you are to conduct multiple forecasting methods and provide a description and interpretation of the techniques used.

Assessment Description
A dataset will be provided to you at the beginning of week 9. The objective of the assessment is to build different forecasting models using Orange Data Mining and Tableau. Students must calculate the Root Mean Square Error (RMSE) or Mean Absolute Percentage Error (MAPE) to evaluate the performance and accuracy of the model, as well as choose the appropriate metrics for model selection.

Assessment Instructions

Report Structure and Content

Imagine you work for the Central Bank of Genovia and your task is to forecast the unemployment rate in one quarter.

1. Import the DATA4400_A2_Data.csv dataset into Orange Data Mining .

2. Assess the quality of the data in terms of missing values and provide summary statistics of the variables.

3. Using an ARIMA model, forecast the unemployment rate for one quarter.
a. What is the forecast unemployment rate based on the ARIMA model?
b. Provide a screenshot of the ARIMA model settings and the appropriate visualisation for your forecast.

4. Using a VAR model, forecast the unemployment rate for one quarter.
a. What is the forecast unemployment rate based on the VAR model?
b. Provide a screenshot of the VAR model settings and the appropriate visualisation for your forecast.

5. How do the Fed Funds rate and the unemployment rate affect each other in Genovia?

6. Use Tableau to visualise the dataset and generate a forecast of the unemployment rate at the end of the next quarter.

7. What is the unemployment rate forecasted by Tableau?

8. Explain which model was used in Tableau and report on its parameters.

9. Evaluate the models using the available metrics and report which model provides the best forecast.

10. Summary

Part A: Descriptive Analysis

• Provide summary statistics of each time series data and briefly comment.

• Provide an appropriate visualization of each time series data.

• Does each time series exhibit trend and/or seasonality components?

• What is the frequency of each time series data?

Part B: Holt-Winters Model

• Use the Holt-Winters model to forecast the unemployment rate at the end of the next quarter.

• Provide a screenshot of the Holt-Winters model settings.

• What is the forecast unemployment rate based on the Holt-Winters model?

• Provide the 95% prediction interval of the forecast unemployment rate.

• Report the Holt-Winters model‘s parameters.

Part C: ARIMA Model

• Use an ARIMA model to forecast the unemployment rate at the end of the next quarter.

• Provide a screenshot of the ARIMA model settings.

• What is the forecast unemployment rate based on the ARIMA model?

• Provide the 95% prediction interval of the forecast unemployment rate.

• Report the ARIMA model‘s parameters.

Part D: VAR Model

• Use a VAR model to forecast the unemployment rate at the end of the next quarter.

• Provide a screenshot of the VAR model settings.

• What is the forecast unemployment rate based on the VAR model?

• Provide the 95% prediction interval of the forecast unemployment rate.

• Report the VAR model‘s parameters.

• How do the Fed Funds rate and the unemployment rate affect each other in Genovia?

Part E: Models Comparison

• By splitting the dataset into 90% training and 10% testing, evaluate the forecasting models (Holt- Winters, ARIMA, and VAR) of the unemployment rate using the following criteria RMSE, MAE, and MAPE.
• For each model, provide an appropriate visualization of the forecasts on the testing data.

• Provide a table including RMSE, MAE, and MAPE calculated on the testing data for each model.

• Report and justify which model provides the best forecast for the unemployment rate on the testingdata.

• Provide the Excel file used to generate the calculations of RMSE, MAE, and MAPE.

Reference no: EM133561665

Questions Cloud

What is your next approach for treatment in this patient : What is your next approach for treatment in this patient and why? What monitoring/labs do you need? Please list mechanism of action of each current medication
What is the forecast unemployment rate based on the arima : What is the forecast unemployment rate based on the ARIMA model and Provide a screenshot of the ARIMA model settings and the appropriate visualisation for your
Evaluate the nation treatment of native americans : Evaluate the nation's treatment of Native Americans during the settlement of the west. You must provide examples to support your answer.
Summarize primary causes and characteristics of healthcare : Considering these factors summarize at least 5 primary causes and characteristics of healthcare delivery. Past, present, and future influences in U.S.
Evaluating forecasting-based analytics assessment : Data-driven Decision Making and Forecasting - conduct multiple forecasting methods and provide a description and interpretation of the techniques used
Reconstruction to current george floyd protests : Describe some comparisons/parallels that can be made from injustices fought against in Reconstruction to the current George Floyd Protests
What the security violation was, any penalties : what the security violation was, any penalties (civil or criminal) incurred, and other aspects of the case. If you were the security/privacy officer
The gilded age was defined by unrestrained : The Gilded Age was defined by unrestrained. how did the fire serve as a catalyst for political, cultural, and economic change?
How leadership behaviors support safe quality care : Examples of current behaviors that reflect leadership and emotional intelligence theories. (refer to Stanley's model steps 1-3)

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd