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
The law of supply is that producers will supply more the higher the price of the commodity.  The supply curve is an upward sloping function showing a direct relationship among pric

What is the classical model's explanation for involuntary unemployment? According to the classical model, involuntary unemployment only increases when there is something impedi

a more simple explanation of the group equilibrium in the short and long run

What is the importance of microeconomics in study of managerial economics?   Normal 0 false false false EN-IN X-NONE X-NONE

Balance of Payments and Developing Economies: It is well-known in development economics that UDCs invariably start as debtor economies. In the process of development itself, t

Q. What is Joint Stock? Joint Stock: A form of business in which company's assets are jointly divided among a large number of different individual owners, each of whom owns a s

Identify path of growth and development to economic maturity.

Surplus The surplus is a condition under that supply for a good or service is in excess of the demand for that good or service. When this happens, there is commonly a reduction

Q. Explain about Counter-Cyclical Policies? Counter-Cyclical Policies:Governments may take many different actions to offset ongoing booms and busts of private-sector economy. T