User Account

All Pages

Trend model for the deseasonalized time series

Assignment Help Basic Statistics
Reference no: EM132849032

Coca-Cola Revenues ($ millions), 2005-2010

Quarter 2005 2006 2007 2008 2009 2010

Qtr1 5,190 5,100 6,050 7,330 7,100 7,500

Qtr2 6,294 6,440 7,680 9,020 8,200 8,649

Qtr3 6,021 6,390 7,637 8,290 8,000 8,401

Qtr4 5,535 5,880 7,278 7,000 7,450 10,469

(a-1) Use MegaStat or Minitab to deseasonalize Coca-Cola's quarterly data. (Round your answers to 3 decimal places.)

1 2 3 4

2005 _____ _____ _____ ____

2006 _______ ______ _______ ______

2007 _______ _______ _______ ________

2008 _______ _______ _______ _______

2009 ________ _______ _______ ______

2010 _______ _______ _______ _______

mean _______ _______ _______ _______

(a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.)

Q1 Q2 Q3 Q4

____ ____ ____ _____

(a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.)

yt = _______ xt + _________

(b) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers to 4 decimal places.)

yt = ______ + _________ t + ________ Q1 + ________ Q2 + _______ Q3

(c) Use the regression equation to make a prediction for each quarter in 2011. (Enter your answers in millions rounded to 3 decimal places.)

Quarter Predicted

Q1 ________

Q2 ________

Q3 ________

Q4 _________

Reference no: EM132849032

Questions Cloud

Describe the meaning for several individuals : What qualitative design seeks to describe the meaning for several individuals of their lived experiences of a concept or a phenomenon?
Discuss the important changes that took place in england : Which discuss the important changes that took place in England that opened the way for the development of their colonial activity.
Explain the direction and strength of the relationship : Explain the direction and strength of the relationship based on the r.
Briefly discuss the forms of foreign investment : Briefly discuss the forms of foreign investment. Explain the difference between the two forms of direct investments
Trend model for the deseasonalized time series : What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.)
Analyze the social impact of world war one inside the usa : Analyze the social impact of World War One inside the USA- on the domestic front- in the 1910s. Discuss politics, culture, and social impacts.
Describe the powers the constitution gives to the executive : Explain in specific detail how historical and/or philosophical influences resulted in the writing of this component of the U.S. Constitution.
Construct confidence interval : Construct your 95% Confidence Interval (Round to 2 decimal points; your lower boundary should go in the first box and upper boundary in the second box)
Difference in profit between variable and absorption costing : Sales commissions of 4.5% of sales revenue are paid to sales people. What is the difference in profit between variable and absorption costing

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd