Model with seasonal dummy variables

Assignment Help Basic Statistics

Reference no: EM131798546

The controller of a small construction company is attempting to forecast expenses for the next year. He collects quarterly data on expenses (in $ 1,000s) over the past 5 years, a portion of which is shown in the accompanying table. The full data set is on the text website, labeled Expenses.

2325_forecast expenses for the next year.png

a. Estimate a linear trend model with seasonal dummy variables and compute the MSE and MAD of in-sample forecast errors.

b. Estimate an exponential trend model with seasonal dummy variables and compute the resulting MSE and MAD.

c. Which model is more appropriate? With this model, forecast expenses for year 2011.

Reference no: EM131798546

Questions Cloud

How will a price increase affect total revenue : Elasticity suppose the weekly demand function for a product is given by p = 100e-0.1q where p is the price in dollars and q is the number of tons demanded.

Estimate a linear trend model : Revisit the Treasury Bonds data to estimate a linear trend model with seasonal dummy variables to make forecasts for the first three months of 2011.

Create a site specification based on the information : Create a site specification based on the information you developed in Week The Mission of this business is to be the world's leading information supplier on the

Relationship between elasticity and maximum revenue : Revenue A product has the demand function p = 100 - 0.5q where p is in dollars and q is the number of units.

Model with seasonal dummy variables : a. Estimate a linear trend model with seasonal dummy variables and compute the MSE and MAD of in-sample forecast errors.

What amount should lane report in income statement : What amount should Lane report in its 2017 income statement for subscriptions revenue

What population size is expected in 7 years : Demographics because of job outsourcing, a western Pennsylvania town predicts that its public school population will decrease at the rate.

Find the percent rate of change of the number of species : Environment Suppose that in a study of water birds, the relationship between the area A of wetlands (in square miles) and the number of different species.

Challenges by the growing online market : Blockbuster Inc. has lately faced challenges by the growing online market (CNNMoney.com, March 3 , 2009). Its revenue from rental stores

User Account

All Pages