Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. consider the following time series data. excel fil

Consider the following time series data. Excel File: data17-35.xls Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 b. Show the four-quarter and...

90.2K

Verified Solution

Question

Statistics

Consider the following time series data.

Excel File: data17-35.xls

QuarterYear 1Year 2Year 3
1467
2236
3356
4578

b. Show the four-quarter and centered movingaverage values for this time series (to 3 decimals ifnecessary).

YearQuarterTime Series ValueFour-Quarter Moving AverageCentered Moving Average
114
22
3.25
33________
4
45_______
_________
216_________
4.75
235
5.25
355.375
5.5
47_______
_______
317_______
_______
26______
________
36
48

c. Compute seasonal indexes and adjustedseasonal indexes for the four quarters (to 3 decimals).

QuarterSeasonal
Index		Adjusted
Seasonal
Index
1
2
3
4
Total

Answer & Explanation Solved by verified expert
4.0 Ratings (794 Votes)
    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Accounting
1.2K views

Question 1: (21 Marks)Calgon Products, a distributor of organic beverages, needs acash budget for...Question...

Finance
1.2K views

Dinklage Corp. has 7 million shares of common stock outstanding. The current share price is $68,...

Biology
1.2K views

Some diseases are caused by too many unfolded proteins in the endoplasmic reticulum (ER). Which...

Physics
1.2K views

Two blocks of masses m 1 kg and m2 2 kg are connected by a...

Physics
1.2K views

3 Consider a hollow spherical conductor that has a potential of 300 volts at its...

Basic Math
1.2K views

Consider the logarithmic statement below Identify the base Base Identify the exponent Exponent Identify the...

Statistics
1.2K views

Put some air in your tires: Let X represent the number of tires with low...

Algebra
1.2K views

Consider the difference equation yt+1(a+byt) = cyt, t = 0,1, .... , where a, b,...

Accounting
1.2K views

The Foundational...

Accounting
1.2K views

Suppose two portfolios have the same averge return, the same standard deviation of returns, but...

Accounting
1.2K views

Madison Products sold $250,000 of 6% ten-year bonds on January 1, 20x3. Interest is payable...

Accounting
1.2K views

Please answer all! I will leave a like! ...