Econ 414 and 415 project, economics, Microeconomics

1. Econ 415 Project

Select one time series of real data. The series can be selected from the published data ( The data series must comprise at least 30 observations.

Make a time plot of the data and describe the main features of the series.
Transform your series if necessary. Explain which transformation was used and why? If no transformation was used, explain why not.
Decompose the transformed series.
Produce forecasts of the series using an exponential smoothing method/ARIMA model. (holt, holt winter, holt winter additive, multi….etc, use all the models and compare them, which is the best. By look into some critical values, such as ljung-box, MAD, MAPE, BIC….etc)
Forecasts and prediction intervals

Explain carefully what you have done and why you have done it. You should also compare you results with those obtained using an ARIMA model/exponential smoothing method. Which method do you think gives the better forecasts?

You should write as if your report is to a client who is interested in forecasts of your data. You may assume that your client is familiar with the material covered in the text.

You will be graded on the sophistication of your techniques, as well as on the thoughtfulness and clarity of your discussion and the communication of your results.

The report should be from 10-15 pages including figures and tables.

You will also be required to give a presentation of your analysis in class.


PART I: Use the data in the file andy.dat consisting of data on hamburger franchises in 75 cities from Big Andy''s Burger Barn. The data are available at the website for the text: Simply click Principles of Econometrics, 4th Edition and then click Ascii files (or Excel Spreadsheets) and Data Definition files. The files are in *.Zip format and you will need to unzip/extract them. After extracting the files, look for the files: (i) andy and (ii) andy.def. You will use these files for econometric analysis in the following problem.

Set up the model

ln(Si)=b1 + b2ln(Ai) + ei,


Si = Monthly sales revenue ($1000s) for the i-th firm

Ai = Expenditure on advertising ($1000s) for the i-th firm

(a) Interpret the estimates of slope and intercept.

(b) How well did the model fit to the data? Use any tests and measures presented in class.

(c) Perform any test for heteroscedasticity in your data.

andy.def File: The data definition file is reproduced below.

sales price advert

obs: 75 a sample of hamburger franchises in 75 cities from Big Andy''s Burger Barn.

sales = S Monthly sales revenue ($1000s)

price = P A price index for all products sold in a given month.

advert = A Expenditure on advertising ($1000s)

Data source: Courtesy of hamburger franchise, called Big Andy''s Burger Barn

Variable | Obs Mean Std. Dev. Min Max


sales | 75 77.37467 6.488537 62.4 91.2

price | 75 5.6872 .518432 4.83 6.49

advert | 75 1.844 .8316769 .5 3.1

PART II: Can a corporation''s annual profit be predicted from information about the company''s CEO? Forbes (May 1999) presented data (shown in TABLE 2) on company profit (y) in (millions of dollars), CEO''s annual income (x1) (in thousands of dollars) and percentage of the company''s stock owned by the CEO (x2). Use the data in the TABLE below and answer the following questions.

(a) Fit a multiple regression model of y on x1 and x2. Fit two simple linear regressions: (I) y on x1; (II) y on x2. Compare the results of multiple regression analysis with each of simple linear regressions.

Rank the models in terms of usefulness and briefly comment on their performance. Use all of the tests and measures of usefulness discussed in class.

(b) Do you detect any signs of multicollinearity?

(c) Use the printout to test the following hypotheses using a significance level of 5%: (I) increasing the CEO''s annual income (other things constant) will increase the company profit; (II) increasing the percentage of company stock owned by the CEO will increase the company profit.

TABLE: Company profit (y), CEO''s annual income (x1), and the company stock owned by the CEO (x2)

Profit (y)
CEO''s income (x1)
% of the company stock owned by the CEO (x2)



Gateway 2000

HJ Heinz



Cisco Systems

General Electric

America Online

Computer Associates

Lockheed Martin

Bear Stearns

Source: "Compensation Fit for a King", Forbes, May 1999.

Please let me know your best price, and you must be 100% confident that you can finish the job very nice. They are very important projects for my study.

I wish you can finish them in a week, later deadline can be discuss, it all depends on price you offer as well. Thank you.

Posted Date: 2/26/2012 3:13:53 PM | Location : United States

Related Discussions:- Econ 414 and 415 project, economics, Assignment Help, Ask Question on Econ 414 and 415 project, economics, Get Answer, Expert's Help, Econ 414 and 415 project, economics Discussions

Write discussion on Econ 414 and 415 project, economics
Your posts are moderated
Related Questions
What are the two main forms of economic distribution? What is the difference between them?   The two major forms of economic distribution are exchange and transfer. Exchange in

On Valentine's Day, the price of roses increases by more than the price of greeting cards.  Why? (Hint: Consider what makes roses and cards different and how that difference might

Analyze the various ways in which property rights encourage economic development and make at least one recommendation for improving current laws. Explain your rationale.

would a rational producer be concerned with the average or marginal product of an input in deciding whether or not to hire the inputs?

do you think that dimnishing returns to a factor are consistent with increasing returns to scale? explain with suitable diagram and reasoning.

Externalities: Many economic activities have collateral effects (at times positive, but more often negative) on other people who aren't directly involved in that activity. Illustra

You should find two articles, of which one should report on changes that make farming more productive (more food per acre, hour or other unit of inputs), and another about changes


Consider a market that is served by a single-price monopolist with marginal cost given by MC = $100 + Q. The market demand is given by P = $800 – 3Q. Determine the following: the f

Yao''s weekly demand for basketballs is given by Qd = 3-P^2 where P is the price of basketballs. At the current price, Yao''s demand for basketballs is unit elastic. What is the cu