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

Q

You are a physiologist on a space flight to a distant planet. You discover intelligent humanoid...

Medical Sciences
Q

Using these three words form a sentence neurotransmitter axon terminals dendrites

Biology
Q

The American Heart Association is about to conduct an anti smoking campaign and wants to...

Statistics
Q

Consistent with ASC Topic 842, if a company sells an asset for a profit of...

Accounting
Q

please help w excel and written 12.6. Jessica Williams, manager of kitchen...

Accounting
Q

On the statement of cash flows; when determining cash flows from operating activities under the...

Accounting
Q

Lease conversion from operating to corporation A company has borrowing cost of about 4% in...

Accounting
Q

Nowak Corp. Had the following trattactiont dung the current period Mar. 2. Isued 4.300 shares...

Accounting
Q

Below is a list of activities for Orange Heffer Incorporated. Required: For each activity, indicate...

Accounting
Q

n January 1, 2018, Elkhardt Ltd. purchased $215,000 of 12%, 10-year bonds at face value...

Accounting
Q

The total amount of a currency that is either circulated in the hands of the...

Finance
Q

c. What is the equilibrium price

Accounting