Question: 1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November

1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks]

a. What is the forecasted value for November 2019? [60 marks]

b. What is the forecast of the demand in the next 3 years? [20 marks]

c. Does the forecast follow seasonality? [5 marks]

2. Create a forecast using the excel built-in feature for the sales in the 12 months of 2017 for the data set provided similar to question 1. Take confidence as 95%. Choose seasonality as 12 months. Add a trendline that best fits the data with the least error using the R2 method. [Total - 15 marks]

Year Month Demand 2014 January 238

February 228

March 213

April 200

May 202

June 201

July 217

August 224

September 230

October 224

November 201

December 235 2015 January 271

February 261

March 246

April 233

May 235

June 234

July 250

August 257

September 263

October 257

November 234

December 268 2016 January 339

February 329

March 314

April 301

May 303

June 302

July 318

August 325

September 331

October 325

November 302

December 336

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

1. Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast for the demand in...

Create a forecast for the data set provided using the regression formula. [Total - 85 marks] a. What is the forecasted value for November 2019? [60 marks] b. What is the forecast of the demand in the...

GIVIISI V. Common Size Income Statement Prepare a common size income statement for two years and compare/contrast the changes (Refer to chapter 17) VI. Ratio Analysis of Financial Statements Prepare...

Plasma Pathology has incurred the following costs in its diagnostic blood laboratory during the past 12 months: Month Number of blood test completed Cost January 6100 $90000 February 5300 87000 March...

Hi, I need help with a statistics assignment related to excel. Properties sold in Melboune Property Location 3 1 8 1 28 1 29 1 30 1 31 1 34 1 37 1 45 1 47 1 51 1 54 1 55 1 56 1 57 1 58 1 60 1 61 1 62...

my questions Exercise 13.5 (Hard) Tammy lives for two periods. In the first period of life she works ` hours at a wage of w per hour. In the second period of life she is retired and supplies no...

MM305 Unit 7 Project Name: Holly Peterson 1. Even though independent gasoline stations have been having a difficult time, Susan Solomon has been thinking about starting her own independent gas...

oalll Question: Put together a portfolio of work documents you have drafted and written. If you are working you can use actual workplace documents, with identifying names redacted. Do not include any...

Section B (40 marks) Refer to Table 1. Write the Excel formula for each cell marked with "?" in column C such that formula could be copied and pasted into columns D and E using Microsoft Excel...

JX A B C Electricity cost ($) Average outdoor temperature (OF) Tons of product QUESTION 3 24100 26 The facility manager at a sports textile company wants to build a regression model to forecast 23700...

For the vectors = (1,3,1,2) and (2,-1,-3,1), (a) Find the dot product Number (b) Find the vector length || ||. Enter the answer exactly, using sqrt() if necessary. U4 Number (c) Find the angle...

For the data (10, 15, 20, 25, 30), which of the following will not change if 30 was replaced by 50? Select one: O a. The range O b. The median O . The standard deviation O d. The mean

Which one of the following statements is incorrect regarding regular payback and discounted payback method? Both regular payback and discounted payback method ignore cash flows beyond the payback...

Financial Statements and Closing Entries Last Chance Company offers legal consulting advice to prison inmates. Last Chance Company prepared the end-of-period spreadsheet that follows at June 30,...