Unformatted text preview: Step 1. Create an Excel Data Set. Open an excel spread sheet and define the following columns. Round Value Bid Input your auction data. You should produce a data set that looks like this. Round Value Bid 1 88.12 60.00 2 2.32 2.12 . . . . . . . . . 10 78.78 75.00 Step 2. Run a regression using Bids as the “Y” variable and Values as the “X” variable. Fill in the following tables: FPA 2 bidder 5-bidder Coefficient Standard Error Coefficient Standard Error Intercept X variable (slope) SPA 2 bidder 5-bidder Coefficient Standard Error Coefficient Standard Error Intercept X variable (slope)...
View Full Document
- Fall '09
- Standard Error, Auction, Vickrey auction, first-price auction bid, auction bid sheet