SCMS 7110 Exam a couple of Solutions Composition

SCMS 7110 Test 2 Solutions

п»їQuestion 1

5 / four points

The general upward or perhaps downward routine of the info in an twelve-monthly time series will be within the ____________ aspect.




in season

Question 2

4 / 4 factors

When using the significantly weighted shifting average pertaining to purposes of forecasting rather than smoothing,

the prior smoothed benefit becomes the forecast.

the existing smoothed worth becomes the forecast.

the next smoothed worth becomes the forecast.

None of the above.

Problem 3

four / some points

The following is the list of MAD figures for each of the models you could have estimated via time-series info: Model


Linear Pattern

1 . 32

Quadratic Pattern

1 . twenty two

Exponential Trend

1 . 39


zero. 71

Based upon the MAD criterion, the best model can be

linear trend.

quadradic craze.

exponential trend.


Question 4

4 / four points

This table provides the number of grievances received within a department store intended for the initially 6 months of last year. MonthВ В В Complaints

JanВ В В В В В В В В В В В В В В thirty six

FebВ В В В В В В В В В В В В В В forty five

MarВ В В В В В В В В В В В В seventy eight

AprВ В В В В В В В В В В В 108

MayВ В В В В В В В В В 144В В В В В В В В В В В В В В В В В В Referring to the above table, if the three-term going average can be used to soft this series, what would be the second calculated term?


forty. 5



Query 5

4 / 5 points

STAND 16-4В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В Given below are EXCEL outputs for various estimated autoregressive models pertaining to Coca-Cola's genuine operating income (in huge amounts of dollars) coming from 1975 to 1998. В В From the data, all of us also realize that the real operating revenues to get 1996, 1997, and 1998 are 10. 7909, 14. 7757 and, В 11. 5537, respectively. В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В В AR(1) Model: В


Normal Error

capital t Stat



zero. 1802077

zero. 39797154

0. 452815546

zero. 655325119


1 . 011222533

0. 049685158

20. 35260757

2 . 64373E-15

AR(2) Model:


Common Error

capital t Stat



zero. 30047473

0. 4407641

zero. 681713257

zero. 503646149

Back button Lag one particular

1 . 17322186

0. 234737881

4. 998008229

7. 98541E-05

X Lag 2

-0. 183028189

zero. 250716669

-0. 730020026

0. 474283347

AR(3) Model:


Standard Mistake

t Stat



0. 313043288

0. 514437257

0. 608515972

0. 550890271


1 . 173719587

0. 246490594

4. 761721601

zero. 000180926


-0. 069378567

0. 373086508

-0. 185958391

0. 854678245


-0. 122123515

zero. 282031297

-0. 433014053

zero. 670448392

Discussing Table 16-4 and by using a 5% degree of significance, what is the appropriate AR model intended for Coca-Cola's real operating income? В




Any of the previously mentioned.

Question 6th

4 as well as 4 details

TABLE 16-8В The president of a chain of department stores is convinced that her stores' total sales have already been showing a linear craze since 1980. She uses Microsoft Surpass to obtain the partial output below. The centered variable is usually sales (in millions of dollars), while the impartial variable is definitely coded years, where 80 is coded as 0, 1981 is coded since 1, etc . В В В В В В В В В В В В В Summary Output

Regression Statistics

Multiple RВ В В В В В В В В В В В В В В В В В В В 0. 604

R SquareВ В В В В В В В В В В В В В В В В В В В В В 0. 365

Adjusted R SquareВ В В В В В В 0. 316В

Common ErrorВ В В В В В В В В В В В В В В В В В В В В В 4. 800В ObservationsВ В В В В В В В В В В В В В В В В В 17


InterceptВ В В В В В В В В 23. 2

Coded YearВ В В В В В В В 0. 78В В

Referring to Table 16-8, the fixed trend worth (in an incredible number of dollars) intended for 1985 can be __________.

. 365

31. two

35. you

35. 88

Question 7

4 / 4 points

A real estate builder wishes to determine how residence size (House)...