EC304 Data Files

Data files for UE2
From this link, you can download the files used in the supplement. Please note that all files are downloadable as self-extracting compressed files.

To save most of the files below, right click on the link and choose "Save Link As" or "Save Target As" and save the file to a folder on the server (each of you in the class should have space on the server). NOTE: Computers in the computer labs will not allow you to save to hard drive. Be sure to save to the network! Then you will work with that Excel file and not corrupt the original data file. If included, labels for the variables contained in each file are listed in the first row of each file. If a file is not in Excel workbook form, simply follow Excel's import wizard.

PQ2.txt File containing data on price and quantity.	Total Revenue Function Data set to accompany the example in chapters 7 & 8 of the required text. Note that total revenue and advertising expenditures are measured in units of $1,000 and price is in $1 units.This file has 52 observations. Same file with 78 observations.
Money This file contains three variables, y (GDP), m (money), and i (the interest rate).
Football This file contains three variables, game number, sodas sold, and temperature.	Advertising Media Data for multivariate analysis of the effectiveness of different types of advertising media. NOT in Excel format, the first column is Sales ($000), the second column is Radio and Television advertising expenditures ($000), and the third column is Newspaper advertising expenditures ($000).
Standard & Poor's Index CPI and S&P's stock price index.
Food Expenditures Food expenditures and weekly income data to accompany Table 3.1 of Chapter 3 of the text.	Calculating White's Standard Errors to Correct for Unknown Heteroskedasticity
P's and Q's This file contains two variables, price and quantity.	Wheat Supply Model Data set to accompany the example used for heteroskedasticity as discussed in Chapter 10.
Table 3.2 Feed inputs and associated meat outputs as shown on page 62, Table 3.2 of the required text. Table 3.3 Hamburger price and quantity to accompany Exercise 3.6 of the text (page 62).	Crime Expenditures Variables are (1) total expenditures on a state's criminaljustice system (in millions of dollars), (2) total number of police employed in the state, (3) population of the state (in thousands), (4) total number of incarcerated prisoners in the state
Table 3.4 Price and quantities to be used with problems 3.8 on page 63 and 4.8 on page 84 of the required text.	Suicide Rates in Norway Suicides per 100,000 in Norway, unemployment rate, divorce rate, and religious book production
Beer Consumption Data on price and quantity bought.	NFL Stats Wins, net yards rushing, net yards passing, passes attempted, passes completed, passes intercepted, yards penalities, fumbles lost, net rushing yards allowed, passes attempted by opponents,passes completed by opponents, passes interepted by opponents
Education Pay-offs Beginning salaries with associated years of educaation.	Beef Consumption Per capita data on consumption of beef, price of beef, price of lamb, price of pork, and disposable income in Australia for 1949-1965. To be used for Problem 7.2 on page 148 of the required text.
Petfood Sales Shelf space (in feet) and weekly sales (in $100's) for a popular pet food.	Female Work Participation Rates, Unemployment Rates, and Use of Public Transportation
Vote Buying Contributions and vote index	Public Expenditure on Education for use in Exercise 10.2 of the text EE=expenditure on education GDP=gross domestic product P=population for 34 countries in 1980
Econonmic Data Link This site provides a plethora of available data	Table 7.2 For practicing multivariate regression. No idea what the variables are!
Cobb Douglas Production Function for corn, with nitrate and phosphate as inputs. (Filename=cornprod.xls)	Clothing Industry Cost and output data for use in exercise 7.3, a real challenge!!!
Demand for New Cars The demand for new cars as explained by the new car price index, the overall CPI, disposable income, the interest rate, and the employed labor force.	How much chicken do you like? The demand for chicken, explained by income, price of chicken, price of pork, and price of beef.
Aggregate Production Function More data for multivariate analysis. This interesting model is presented in Exercise 7.4 of the required text. Notice that you must transform the data first, using a log-log specification.	Stock Prices & Dividends Firms' stock prices, dividends, and EPS. Try estimating the models suggested in the file.
Cobb-Douglas Production Function Data set containing three variables; Output (Q), Labor Input (L), and Capital Input (K). Transform to a log-log model to obtain the common Cobb-Douglas production function. A good data set to examine multicollinearity.	Real Estate Values Predict the value of homes.
Food Expenditures in a Large U.S. City Data set to accompany problem 10.7 on page 235 of the required text.	Educational Spending per Student for major U.S. Universities (copyright, 1994, U.S. News & World Report). See the "vardefinition" page of the worksheet for full information.
Models with Dummy Variables Wage Discrimination Absenteeism in the Workplace Variable definitions and instructions are on a separate "page" of this workbook. More Wage Discrimination Does this house imbibe?	Models with Dummy Variables War Years and Consumption Function Beer Expenditures (based on Gender) Pizza Expenditures (based on Age) Highway or City Mileage Choose one of the mileage variables as your dependent variable. File contains missing values. Meddicorp's Sales Variables are defined within the file.