Compute the linear trend equation for the deseasonalize data

Assignment Help Basic Statistics
Reference no: EM13903497

1. The following data is sales in millions of dollars for the Cassie Cat Company manufactures of grain free canned cat food.

Year.   1.   2.   3.  4.   5.   6.   7
Sales. 20. 22. 26. 24. 30. 28. 32

A. Use a three year moving average to generate a forecast for year 8 and determine its mean square error.
B. Use a smoothing constant 0f .8 to generate a forecast for year 8 and determine its mean square error.
C. Which method is the better?

2. The quarterly sales data (number of copies sold) for a college textbook 0ver the past three years follows.

Quarters.   year 1.    year 2.     year 3
1              1690.       1900.        1850
2.             890.         9100.        1200
3.             2625.       3000         2930
4.             2550.       2360.        2700

A. Show the four quarter and centered moving average for this time series.

B. Compute the seasonal and adjusted seasonal indexes for the four quarters.

C. Deseasonalize the time series.

D. Compute the linear trend equation for the deseasonalize data and forecast sales for the first quarter of year 4. Be sure to reseasonalize your forecast.

Reference no: EM13903497

Questions Cloud

Analyse financial statements using relevant techniques : Calculate the net present values, payback period ,accounting rate of return and IRR of each of the proposed investments and recommend with justifications which of the two investments, if any, should be selected - Analyse financial statements using ..
How has globalization been good or bad for the post 1945 : How has globalization been good or bad for the post 1945
What does the price elasticity of demand measure : What does the price elasticity of demand measure? What is inelastic demand? What is elastic demand? According to the economists' approach to setting prices, the profit-maximizing price should depend on what two factors?
Marginal cost curve of a typical firm : Widgets are provided by a competitive constant-cost industry where each firm has fixed costs of $30. The following chart shows the industry-wide demand curve and the marginal cost curve of a typical firm:
Compute the linear trend equation for the deseasonalize data : Deseasonalize the time series. Compute the linear trend equation for the deseasonalize data and forecast sales for the first quarter of year 4. Be sure to reseasonalize your forecast
Describe the collapse of the roman empire : Describe the Collapse of the Roman Empire
What assumption does the absorption costing approach make : When the absorption costing approach to cost-plus pricing is used, what is the markup supposed to cover? What assumption does the absorption costing approach make about how consumers react to prices?
Estimate the profit-maximizing price for ice cream cones : Did Kimio make more money selling the cones for $1.79 or for $1.39? Estimate the price elasticity of demand for the ice cream cones. Estimate the profit-maximizing price for ice cream cones.
Find the new equilibrium price and quantity : Suppose quantity demanded for the good rises by 10 units at every possible price while at the same time quantity supplied falls by 5 units at every possible price (with the exception that quantity supplied cannot drop below zero units at any price..

Reviews

Write a Review

Basic Statistics Questions & Answers

  Various high-risk intersections

A number of minor automobile accidents occur at various high-risk intersections. A study was done. Eight intersections were chosen at random. The number of minor accidents during a 6-month period before and after the modifications were:

  Explain process and is it possible to register firearm

So what you send is what you see, no more and no less. handgun would it be possible to register this firearm? What is the process?

  Create histogram using strategies of final fund values

Create a histogram of the final fund values. Based on your simulation results, which of the two strategies would you recommend? Why?

  Description of poisson random variable

We monitor the number of incoming calls into a doctor's office. Let X be the number of incoming calls between the hours of l pm and 2 pm and Y be the number of calls between l pm and 3 pm.

  Compute the expected frequency for brand

The data show that 48 of the doctors picked brand x. If these data were evaluated using a chi-square test for goodness of fit, what is the expected frequency for brand x?

  Determining proportion-pro life

If a random sample of 10 people found that 9 were pro-life (i.e., 90%), while another random sample of 1,000 people from the same population found that 550 were pro-life (i.e., 55%), which would you find more significant?

  Calculate the residual

Regression line drawn as y = c + 1075x, when x was 2, and y was 239, given that y intercept was 11. Calculate the residual

  Descriptive statistical analysis on youngsters involved

Descriptive Statistical Analysis on Youngsters Involved in Alcohol

  Find probability that average lifetime is less

What is the probability that their average lifetime would be less than 510 hours? Use your calculator to solve this problem and give your answer as a number between 0 and 1, rounded to 3 decimal places.

  Two points along a straight stick of length 39 cm are

two points along a straight stick of length 39 cm are randomly selected. the stick is then broken at those two points.

  A survey revealed the amount of pocket money held by each

a survey revealed the amount of pocket money held by each student in a sample of students. the amounts in dollars are

  Probablity that excatly eighty flights will be on time

A Department of Trasporta repot about air travel found that nationwide, 76% of all flights are on time. What is the probablity that you will have have excatly 80 flights on time?

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!

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