Use SAS to analyze the data set Use proc forecast to run the Winters model with a trend Note that trend 1 is no trend, trend 2 is linear trend, and trend 3 is quadratic trend A smoothing (alpha) parameter value must be selected Examine the output Is the general trend upward or downward Provide analysis output MyDate LeadProd 12 Jan 38500 12 Feb 36400 12 Mar 37400 12 Apr 33900 12 May 29800 12 Jun 32400 12 Jul 32100 12 Aug 29500 12 Sep 27000 12 Oct 37900 12 Nov 33300 12 Dec 42300 13 Jan 34000 13 Feb 27500 13 Mar 32900 13 Apr 30500 13 May 28000 13 Jun 36900 13 Jul 34000 13 Aug 36900 13 Sep 37200 13 Oct 30800 13 Nov 29100 13 Dec 36800 14 Jan 27600 14 Feb 38600 14 Mar 38000 14 Apr 34800 14 May 33300 14 Jun 31100 14 Jul 31800 14 Aug 30300 14 Sep 28000

The Answer is in the image, click to view ...

Question: Use SAS to analyze the data set. Use proc forecast to run the Winters model with a trend. Note that trend = 1 is no

Use SAS to analyze the data set. Use proc forecast to run the Winters model with a trend. Note that trend = 1 is no trend, trend=2 is linear trend, and trend =3 is quadratic trend. A smoothing (alpha) parameter value must be selected.

Examine the output. Is the general trend upward or downward? Provide analysis output

MyDate	LeadProd
12-Jan	38500
12-Feb	36400
12-Mar	37400
12-Apr	33900
12-May	29800
12-Jun	32400
12-Jul	32100
12-Aug	29500
12-Sep	27000
12-Oct	37900
12-Nov	33300
12-Dec	42300
13-Jan	34000
13-Feb	27500
13-Mar	32900
13-Apr	30500
13-May	28000
13-Jun	36900
13-Jul	34000
13-Aug	36900
13-Sep	37200
13-Oct	30800
13-Nov	29100
13-Dec	36800
14-Jan	27600
14-Feb	38600
14-Mar	38000
14-Apr	34800
14-May	33300
14-Jun	31100
14-Jul	31800
14-Aug	30300
14-Sep	28000

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 Databases Questions!

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

Curve-fitting Project - Linear Model (due at the end of Week 5) Instructions For this assignment, collect data exhibiting a relatively linear trend, find the line of best fit, plot the data and the...

Unlike Softdrink sales, you have no data for 2008, Q1 through Q4. You must create those 4 quarters of forecast. MAE MAPE Time 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Quarter 2004 Q1 2004...

read this report and answer questions provided: ICTE in Transportation and Logistics 2018 (ICTE 2018) Demand forecasting in pharmaceutical supply chains: A case study Galina Merkuryeva"*, Aija...

1. What are at lest two diagnostic checks you should apply to a Box-Jenkins model to determine its reliability (excluding error measures such as MSE, RMSE, etc.)? (Points : 3) t-test of the...

Richard has been hired by Buckeye Bookstore as a demand planner at the beginning of 2021. His first job is to forecast the sales for the first 4 months in 2021. The historical sales records in the...

Python and most Python libraries are free to download or use, though many users use Python through a paid service. Paid services help IT organizations manage the risks associated with the use of...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Discussion Board Week 3 "Managing in the Global Economy and Outsourcing Offshore" Using Techniques to Forecast Variables of Interest to Business and Foreign Exchange During the Weekly Scenarios Herb...

Instuctor's Annotated Edition TENTH EDITION Understandable Statistics Concepts and Methods Charles Henry Brase Regis University Corrinne Pellillo Brase Arapahoe Community College Australia Brazil...

A task with hourly rate of $10.10 per hour and was baselined at 10000 hours, it is assumed that the total budget will be spent equally during the project duration. Now, 4950.50 hours have been spent...

Refer to the situation described in Problem 19-2. Assume Pastner measures the fair value of all options on January 1, 2011, to be $4.50 per option using a single weighted-average expected life of the...

A bridge loan provided by a secaritics finm would most likely be made to an acquirter that needs temporary financing to complete a merger. a commercial bank is the federal funds market. a mutas fund...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

1-8 Rabatt operates deep-discount stores offering housewares, cleaning supplies, clothing, health and beauty aids, and packaged food throughout Germany, with most items selling for 1 euro. Its...

1-7 Warbenton Snack Foods is a manufacturer of potato crisps and savoury snacks in the U.K. Warbentons financial department uses spreadsheets and manual processes for much of its data gathering and...

1-3 What academic disciplines are used to study information systems and how does each contribute to an understanding of information systems? List and describe each discipline that contributes to a...