Begin by opening the Excel File and read through the Scenario at the top of the page, then notice there are tabs at the bottom of the workbook that constitute your homework assignment.
Next, hyperlinked directly below are several YouTube videos that will aid you in completing the assignment tasks. They are all short (under 10 minutes), so watch them all in succession before you start your homework. Then, as you start each Tab in the Excel Workbook, keep a copy of the appropriate video handy, each assignment almost exactly mirrors these videos; albeit with different scenarios.
There are several “Tasks” in the workbook and they are on separate Tabs. Look over the tasks and make sure you understand the scenario, the data you are given, and the parameters for the regression analysis. If you get lost and can’t quite figure out how to proceed, message your instructor, we are always glad to help. Before submitting this assignment, scroll down each tab in succession and make sure you have completed all of the tasks described in the Spreadsheet.
This weeks assignment is best completed while watching the videos above; in order. It is recommended that you have the video open on one side (1/2) of your screen and the homework template on the second half of the screen. That way, you can watch the video and complete the assignment synchronously. Make sense?
You must use formulas to calculate every answer. No credit will be given if a number is simply inserted.
Using Excel to calculate a correlation coefficient || interpret relationship between variables
(Linear) Regression Equation on Excel 2016
How to do Multiple Regression in Excel 2016 for Windows (Job Performance Example)
Creating a dummy variable for regression
Category: global demand management
CO3: Evaluate Forecasting methods, predictability factors, and causes of error in Forecasting
Prompt:
This week you will be researching and writing on one of the most basic methods of forecasting: Judgmental Forecasting. After reading Chapter 3 in Chase (Overview of Forecasting Methods), access the three excellent resources on Judgmental Forecasting hyperlinked below. Use all three, for they each provide a different perspectives on the broad methodology of forecasting future demand using experience, insight, and business savvy. You may also want to search the internet for any additional resources that add to the lesson material in chapter 3. As the instructions advise in previous assignments, if you do add additional sources, do not use advertisements of any kind, including consultancies and software. Use the template attached to this assignment for your submission. The template includes sections to guide you this week on your essay assignment to explain the methodology of Judgmental Forecasting.
https://otexts.com/fpp2/judgmental.html
https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=189503&type=coursefile&fileId=A+Comparison+of+Judgmental+Forecasting+Techniquess.pdf
https://otexts.com/fpp2/delphimethod.html
Week 2 Assignment: Demand Forecasting Research
Course Learning Objectives:
CO2: Examine the concept of demand-driven forecasting as compared to supply-driven forecasting
Prompt:
For this week’s assignment you will want to start in Google Scholar (or any electronic Library you may have access to) and locate one Journal Articles (less than 7 years old) that address some facet of forecasting. To Search, start by entering search terms such as “Demand Forecasting” or “Forecasting Methods” into the search bar and a long list of sub-topic titles will appear. Choose a journal article that (a) interests you, and (b) has a PDF version you can download to your PC or MAC. Read the journal article through from start to finish while making notes on the research, the findings, and the conclusions. Then using the Word template provided below, report on the journal article you chose:
Title of the journal article, author, publishing journal, year of publication,
A summation that introduces the Journal article subject matter
Type of research conducted and research question (if there is one)
Background information as to why this journal article was written (look in the Literature Search/Survey section)
Findings and Conclusions if a research-based article
A short summary of what you learned that added to your understanding of demand driven forecasting
Instructions:
Utilize the template attached below for this assignment. Label your submission document as follows: yourlastname_Assignment1.docx (ex: BJohnson_Assignment2.docx)
Minimum 1000 words of content of strategic material, double spaced. Content requirement does not include cover page, abstract, nor reference pages
Resources and citations are formatted according to APA (7th edition) style and formatting
Once you submit your document to the assignment folder it will automatically be loaded to TURNITIN.COM for this course. Your similarity scan score must be 20% or less (the following will be excluded: headers, references, etc. prior to instructor grading paper—focus on the content of scan percentage
Plagiarism in any form will result in an automatic zero for this assignment:
Using another author’s exact words without quotations AND without an in-text citation
Paraphrasing by changing a couple of another author’s words and claiming them to be your own.
There are no late assignments accepted after the last day of the course unless: (a) prior approval has been obtained from the professor or (b) you have an approved 30 day extension.
Week 3: Judgmental Forecasting
Course Objectives:
CO3: Evaluate Forecasting methods, predictability factors, and causes of error in Forecasting
Prompt:
This week you will be researching and writing on one of the most basic methods of forecasting: Judgmental Forecasting. After reading Chapter 3 in Chase (Overview of Forecasting Methods), access the three excellent resources on Judgmental Forecasting hyperlinked below. Use all three, for they each provide a different perspectives on the broad methodology of forecasting future demand using experience, insight, and business savvy. You may also want to search the internet for any additional resources that add to the lesson material in chapter 3. As the instructions advise in previous assignments, if you do add additional sources, do not use advertisements of any kind, including consultancies and software. Use the template attached to this assignment for your submission. The template includes sections to guide you this week on your essay assignment to explain the methodology of Judgmental Forecasting.
Judgmental Forecasting Resources:
Forecasting Principles and Practices (1 page)
A Comparison of Judgmental Forecasting Techniques (9 pages)
The Delphi Method (1 pages)
Instructions:
Utilize the template attached below for this assignment, it has the sections already formatted for you to insert your findings by subject/question.
Label your submission document as follows: firstinitiallastname_Assignment_3 (something like JJohnston_Assignment_3)
Minimum 1000 words of content of strategic material, double spaced. Content requirement does not include cover page, abstract, nor reference pages.
Source, Cite, and Reference a minimum of three (3) expert resources to provide support for main points in your essay. Each resource is to add to the content through either paraphrasing the author’s position on the subject or a direct quote. Refrain from excessive use of quotes in your response (less than 5% of the 1000 words).
Resources and citations are formatted according to APA (7th edition) style and formatting.
Once you submit your document to the assignment folder it will automatically be loaded to TURNITIN.COM for plagiarism. Make sure your quotes have quotations and correct (to APA) in-text citations and a reference at the end of the paper.
Plagiarism can result in a zero for this assignment:
When using another author’s exact words insert quotation marks and a citation including year of publication and page or paragraph number
When paraphrasing, do not use ANY of the author’s words, use your own “take” on the author’s meaning and context
Week 1 Assignment: Research & Essay
Course Objectives:
CO1:Research online resources
Assignment Prompt and Instructions:
This week you will be searching the internet for two resources that add to your understanding of the lesson material in chapter 1 of your textbook by Chase on Demystifying Demand Forecasting. Use the template attached to this assignment for your submission. Start your search by first listing key search terms you will use to locate two resources for this essay. Then, search in YouTube, Google, Bing, or any other search engine for a resource that adds to your knowledge of forecasting. Do not source “for-purchase options” such as consultancies or statistical software. As an example, you could source a YouTube video that expands your understanding of the basics of forecasting demand from either the demand or supply side. You will have four sections in this 1000-word paper.
Overview of subject(s) searched for including key-terms used to search
Resource 1: Hyperlink the title of the resource, then complete a thorough review of the content
Resource 2: Hyperlink the title of the resource, then complete a thorough review of the content
Summarize what you learned that added to your understanding of forecasting
Assignment Instructions:
Utilize the template attached below for this assignment. Label your submission document as follows: firstinitiallastname_Assignment1.docx (ex: JJohnson_Assignment1.docx)
Minimum 1000 words of content of strategic material, double spaced. Content requirement does not include cover page, abstract, nor reference pages
Resources and citations are formatted according to APA (7th edition) style and formatting
Once you submit your document to the assignment folder it will automatically be loaded to TURNITIN.COM for this course.
Plagiarism in any form will result in an automatic zero for this assignment:
Using another author’s exact words without quotations AND without an in-text citation
Paraphrasing by changing a couple of another author’s words and claiming them to be your own.
Using another student’s submission in any form will be considered plagiarism
There are no late assignments accepted after the last day of the course unless: (a) prior approval has been obtained from the professor or (b) you have an approved 30 day extension.