User Account

All Pages

Construct a time series plot

Assignment Help Basic Statistics
Reference no: EM132855234

The quarterly sales data (number of copies sold) for a college textbook over the past three hears follow

Quarter Year 1 Year 2 Year 3

1 1690 1800 1850

2 940 900 1100

3 2625 2900 2930

4 2500 2360 2615

a. Construct a time series plot. What type of pattern exists in the data?

b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr 1=1 if Qtr 1, 0 otherwise; Qtr 2=1 if Qtr 2, 0 otherwise; Qtr 3=1 if Qtr 3, 0 otherwise

c. Compute the quarterly forecasts for next year

d. Let t=1 to refer to the observation in quarter 1 of year 1;........; and t=12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part b and also using t, develop an equation to account for seasonal effects in the data and linear trend, compute the quarterly forecasts for next year

e. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1-1511.67QTR2 + 326QTR3+ 23.13t; what is the forecast for period 13? Round to the nearest hundredth

f. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1 - 1511.67QTR2 + 326.67QTR3 + 23.13t; what is the forecast for period 14? Round to the nearest hundredth

g. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1 - 1511.67QTR2 + 326.67QTR3 + 23.13t; what is the forecast for period 15? Round to the nearest hundredth

h. Regression analysis yields the following forecast equation: 2491.67 - 711.67QTR1 - 1511.67QTR2 + 326.67QTR3 + 23.13t; what is the forecast for period 16? Round to the nearest hundredth

Reference no: EM132855234

Questions Cloud

What would you have to pay : According to the term structure, what would you have to pay for a $1000, zero-coupon, Treasury bond that matures in five years
What were the major causes of the great depression : What were the major causes of the Great Depression? How did President Herbert Hoover respond to the Great Depression? Analyze the automobile revolution.
Find the marginal revenue for the production : The revenue equation? (in hundreds of millions of? dollars) for barley production in a certain country is approximated
How did most southerners react to such federal policies : How did most Southerners react to such federal policies? what ways were the 4.5 million ex-slaves assisted by the constitutional amendments and the Freedmen's?
Construct a time series plot : The quarterly sales data (number of copies sold) for a college textbook over the past three hears follow
What rate of return did the original investor realize : The investor sold the T-bill 23 days later to another investor who yields 3.3%. What rate of return did the original investor realize
Find the amortization of the patent : In January 2020, Fides paid 20,000 for legal fees in successful defense of the patent. Find the amortization of the patent for 2020
What are the four types of variables : What are the four types of variables (levels of measurement) mentioned in chapter 1? Explain each of one and provide examples.
What amount should be reported as cash on December : Check payable to BLACKPINK, deposited December 15 and included in 500,000. What amount should be reported as cash on December

Reviews

Write a Review

Basic Statistics Questions & Answers

  Determine the expected value of the lottery ticket

Determine the expected value of the lottery ticket? (Round your answer to 3 decimal places)

  Evaluate the last year with the average

For the past 20 years, the high temperature on April 15th has averaged (j = 62 degrees with a standard deviation of a = 8. Last year, the high temperature was 66 degrees.

  Find the probability that the first marble drawn

Find the probability that the first marble drawn was blue given that the second marble drawn was red and what is the range space RY of this new random variable Y and give the probability distribution of Y in tabular form

  What iq score represents the 98th percentile

IQ scores are normally distributed with a mean of 100 and a standard deviation of 15. What IQ score represents the 98th percentile?

  Conduct the hypothesis tests to check for effects

Conduct the hypothesis tests to check for effects due to interaction, factor A, and factor B. Use a = 0.01 for each test. State your conclusions.

  Create indicated confidence interval for population mean

Create the indicated confidence interval for population mean using (a) t-distribution. (b) If you had incorrectly used normal distribution, which interval would be wider?

  Find the mean and variance of x

The moment generating function for a random variable X is MX(t) = eat+ßt2/2. Find the mean and variance of X.

  Listed below are the lengths in minutes of randomly

listed below are the lengths in minutes of randomly selected cds of country rock and movie soundtracks. construct a 94

  What is the sampling distribution of the sample mean

What is the sampling distribution of the sample mean number of beds per household in Bamako, Mali?

  We have administered an anxiety test to all members of the

We have administered an anxiety test to all members of the class. The mean anxiety score is 71 and the standard deviation is 9. (higher score=higher anxiety)

  Determining chip probability

A bowl contains R red and W white chips. Suppose N chips are drawn without replacement from the bowl.

  What is the lower limit of the confidence interval

The following data were randomly drawn from an approximately normal population.

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