Deseasonalize the data and use an appropriate technique to find the seasonally unadjusted forecasts for the...

Deseasonalize the data and use an appropriate technique to find the seasonally unadjusted forecasts for the next year. Include your results here, showing the deseasonalized data and the seasonally unadjusted forecasts.

Period	Year	Quarter	Sales
1	1	1	40
2	1	2	60
3	1	3	65
4	1	4	80
5	2	1	44
6	2	2	70
7	2	3	72
8	2	4	91
9	3	1	46
10	3	2	77
11	3	3	74
12	3	4	100
13	4	1	50
14	4	2	80
15	4	3	83
16	4	4	109

Expert Solution

The calculations are:

				Centered
				Moving	Ratio to	Seasonal	Sales
t	Year	Quarter	Sales	Average	CMA	Indexes	Deseasonalized
1	1	1	40			0.653	61.2
2	1	2	60			1.031	58.2
3	1	3	65	61.750	1.053	1.026	63.3
4	1	4	80	63.500	1.260	1.290	62.0
5	2	1	44	65.625	0.670	0.653	67.4
6	2	2	70	67.875	1.031	1.031	67.9
7	2	3	72	69.500	1.036	1.026	70.2
8	2	4	91	70.625	1.288	1.290	70.5
9	3	1	46	71.750	0.641	0.653	70.4
10	3	2	77	73.125	1.053	1.031	74.7
11	3	3	74	74.750	0.990	1.026	72.1
12	3	4	100	75.625	1.322	1.290	77.5
13	4	1	50	77.125	0.648	0.653	76.5
14	4	2	80	79.375	1.008	1.031	77.6
15	4	3	83			1.026	80.9
16	4	4	109			1.290	84.5

The forecasts are:

Forecast

50.54341

79.74376

79.39294

99.81989

orchestra answered 2 years ago

Use the data below and find the clusters using a single link technique. Use Euclidean distance...

Use the data below and find the clusters using a single link technique. Use Euclidean distance and draw the dendrogram. X Y P1 0.35 0.48 P2 0.17 0.33 P3 0.3 0.28 P4 0.21 0.18 P5 0.08 0.29

Which technique to use? Give reasons for and against as appropriate. - If you have a...

Which technique to use? Give reasons for and against as appropriate. - If you have a sample of a zinc protein to study, would you use UV-vis and/or CD.

Find the appropriate center of the data (mean or median) and the appropriate measure of variability...

Find the appropriate center of the data (mean or median) and the appropriate measure of variability (standard deviation or interquartile range). Explain in your own words why you chose these measures. Describe the shape of the data distribution and explain why you chose that shape. Include any information that will help your readers understand or visualize your data set. DATA SET B 302.4 262.8 255.6 214.2 230.4 345.6 237.6 253.8 370.8 333.0 271.8 266.4 280.8 271.8 358.2 354.6 228.6 302.4 ...

what criteria would you use to decide whether distillation is an appropriate technique for the purification...

what criteria would you use to decide whether distillation is an appropriate technique for the purification of a reaction product and what type of distillation method- simple , fractional vacuum or steam - should be used?

Answer the questions below using the appropriate statistical technique. For questions involving the use of hypothesis...

Answer the questions below using the appropriate statistical technique. For questions involving the use of hypothesis testing, you must: 1. State the null and research hypotheses 2. Provide the Z(critical), T(critical), or χ 2 (critical) score corresponding to the α threshold for your test 3. Provide your test statistic 4. Provide your decision about statistical significance A random sample of 350 persons yields a sample mean of 105 and a sample standard deviation of 10. Construct three different confidence intervals...

Use the following data for the next 4 questions. At the end of January, the unadjusted...

Use the following data for the next 4 questions. At the end of January, the unadjusted trial balance of Vernon, Inc., included the following accounts: Debit Credit Sales (75% represent credit sales) ………………. $600,000 Accounts Receivable ……………………………. $200,000 Allowance for Doubtful Accounts ……………… 2,000 1.Refer to the above data. Vernon estimates bad debts expense to be 2% of credit sales. What is the amount of Bad Debts expense recognized in Vernon’s income statement for January? 2.Refer to the above data. Vernon estimates bad...

Use an appropriate analysis technique of your choosing to evaluate the following three mutually exclusive projects...

Use an appropriate analysis technique of your choosing to evaluate the following three mutually exclusive projects each lasting 6 years. Which project should be selected if MARR = 6%. Project 1 involves an initial cost of $300,000 and annual costs of $50,000. The project will generate annual revenues of $110,000. At the end of year 6, the project will have a salvage value of $25,000. Project 2 will require an initial investment of $150,000 and annual costs of $25,000. There...

QUESTION 37 Match the appropriate term to the definition or technique. Each technique can be used...

QUESTION 37 Match the appropriate term to the definition or technique. Each technique can be used only once. As such, choice the best definition - A. B. C. D. Hypothesis Test - A. B. C. D. ANOVA - A. B. C. D. Two Way ANOVA ...

When evaluating the radial pulse measurement technique of the nursing assistant, the nurse identifies appropriate technique...

When evaluating the radial pulse measurement technique of the nursing assistant, the nurse identifies appropriate technique when the assistant:

Use a Laplace Transform technique to find the solution to the differential equation (ie. initial value...

Use a Laplace Transform technique to find the solution to the differential equation (ie. initial value problem). y'' + 4y' + 5y = 35e^(-4t) y(0) = -3 y'(0) = 1

Question