Activity: Analyzing Public Good Game Contributions Using Excel
This practical exercise involves using spreadsheet software like Excel to analyze data from public goods experiments. The first step is to download and save the spreadsheet that contains the data used for Figures 4.14b and 4.14c. The objective is to investigate how participant contributions evolved over the course of the game and to evaluate the impact of introducing a punishment option.
0
1
Tags
Library Science
Economics
Economy
Social Science
Empirical Science
Science
CORE Econ
Introduction to Microeconomics Course
Ch.4 Strategic interactions and social dilemmas - The Economy 2.0 Microeconomics @ CORE Econ
Learn After
Analysis of Public Goods Game Data
A researcher analyzes data from a 10-round game where participants can contribute to a public pot. The data is split into two phases. In Phase 1 (Rounds 1-10), there was no mechanism to enforce cooperation. In Phase 2 (Rounds 11-20), a punishment option was introduced, allowing participants to penalize others for low contributions. After processing the data, the researcher generates the following summary statistics:
- Average contribution in Phase 1: $4.20 per round
- Average contribution in Phase 2: $7.90 per round
Based on this summary data, what is the most reasonable inference about the effect of the punishment option?
Explaining Experimental Outcomes
Designing an Analysis for a Public Goods Experiment
A student analyzes data from a public goods experiment with two conditions: a 'No Punishment' condition and a 'Punishment' condition. To compare them, they create a line chart showing the average contribution per round for both conditions over 10 rounds. They observe that the line for the 'Punishment' condition is consistently higher than the 'No Punishment' line. However, they also notice that the 'No Punishment' line shows a steady decline from Round 1 to Round 10, while the 'Punishment' line remains relatively stable. What is the most critical conclusion that can be drawn by comparing the trends of the two lines, beyond simply observing which one is higher?
Calculating the Impact of a Punishment Mechanism
A student is analyzing a spreadsheet containing data from a 20-round public goods experiment. Column A lists the round number (1-20), Column B indicates the condition ('Punishment' or 'No Punishment'), and Column C contains each participant's monetary contribution for that round. The goal is to calculate the average contribution specifically for the rounds where the 'Punishment' condition was active. Which spreadsheet function or method is the most direct and appropriate for this specific task?
Evaluating the Net Impact of a Punishment Mechanism
A student analyzes data from an experiment where participants contribute money to a group fund over 20 rounds. For the first 10 rounds, no special rules are in place. For the last 10 rounds, a 'punishment' option is available, allowing participants to pay a small fee to reduce another participant's earnings. The student calculates the following:
- Average contribution without punishment (Rounds 1-10): $3.50
- Average contribution with punishment (Rounds 11-20): $8.00
The student concludes: 'The punishment mechanism was clearly successful because it more than doubled the average contribution to the group fund.'
Which of the following statements represents the most significant critique of the student's conclusion?