Empirical Project 2 Working in Excel
Part 2.1 Collecting data by playing a public goods game
Learning objectives for this part
 collect data from an experiment and enter it into a spreadsheet
 use summary measures, for example, mean and standard deviation, and line charts to describe and compare data.
Note
You can still do Parts 2.2 and 2.3 without completing this part of the project.
Before taking a closer look at the experimental data, you will play a public goods game like the one in the introduction with your classmates to learn how experimental data can be collected. If your instructor has not set up a game, follow the instructions below to set up your own game.
Instructions How to set up the public goods game
Form a group of at least four people. (You may also want to set a maximum of 8 or 10 players to make the game easier to play). Choose one person to be the game administrator. The administrator will monitor the game, while the other people play the game.
Administrator
 Create the game: Go to the ‘Economics Games’ website, scroll down to the bottom of the page, and click ‘Create a Multiplayer Game and Get Logins’. Then click ‘Externalities and public goods’. Under the heading ‘Voluntary contribution to a public good’, click ‘Choose this Game’. Enter in the number of people playing the game, and select ‘1’ for the number of universes. Then click ‘Get Logins’. A popup will appear, showing the login IDs and passwords for the players and for the administrator.
 Start the game: Give each player a different login ID. The game should be played anonymously, so make sure that players do not know the login IDs of other players. You are now ready to start the first round of the game. There are ten rounds in total.
 Confirm that all the rounds are complete: On the top right corner of the webpage, click ‘Login’, enter your login ID and password, and then click the green ‘Login’ button. You will be taken to the game administration page, which will show the average contribution in each round, and the results of the round just played. Wait until all the players have finished playing ten rounds before refreshing this page.
 Collect the game results: Once the players have finished playing ten rounds, refresh this page. The table at the top of the page will now show the average contribution (in euros) for each of the ten rounds played. Select the whole table, then copy and paste it into a new worksheet in Excel.
Players
 Login: Once the administrator has created the game, go to the ‘Economics Games’ website. On the top right corner, click ‘Login’, enter the login ID and password that your administrator has given you, then click the green ‘Login’ button. You will be taken to the public goods game that your administrator has set up.
 Play the first round of the game: Read the instructions at top of the page carefully before starting the game. In each round, you must decide how much to contribute to the public good. Enter your choice for each universe (group of players) that you are a part of (if the same players are in two universes, then make the same contribution in both), then click ‘Validate’.
 View the results of the first round: You will then be shown the results of the first round, including how much each player (including yourself) contributed, the payoffs, and the profits. Click ‘Next’ to start the next round.
 Complete all the rounds of the game: Repeat steps 2 and 3 until you have played ten rounds in total, then collect the results of the game from your administrator.
The results from your game will look like Figure 2.1. In the questions below you will compare your results with those in Figure 3 of Herrmann et al. (2008), but first you need to reformat your table to look like Figure 2.2. Follow the steps in Excel walkthrough 2.1 to reformat your table.
Round  10  9  8  7  6  5  4  3  2  1 

Average contribution 
Round  Average contribution 

1  
2  
3  
4  
5  
6  
7  
8  
9  
10 
Excel walkthrough 2.1 Reformatting a table
Use the results of the game you have played to answer the following questions.
 Make a line chart with average contribution as the vertical axis variable, and period (from 1 to 10) on the horizontal axis. Describe how average contributions have changed over the course of the game.
Excel walkthrough 2.2 Drawing a line chart with multiple variables
Follow the walkthrough in the CORE video, or in Figure 2.4, to find out how to draw a line chart with multiple variables in Excel.
 Compare your line chart with Figure 3 of Herrmann et al. (2008).^{1} Comment on any similarities or differences between the results (for example, the amount contributed at the start and end, or the change in average contributions over the course of the game).
 Can you think of any reasons why your results are similar to (or different from) those in Figure 3? You may find it helpful to read the ‘Experiments’ section of the Herrmann et al. (2008) study for a more detailed description of how the experiments were conducted.
Part 2.2 Describing the data
Learning objectives for this part
 use summary measures, for example, mean and standard deviation, and column charts to describe and compare data.
Note
You can still do Parts 2.2 and 2.3 without completing Part 2.1.
We will now use the data for Figures 2A and 3 of Herrmann et al. (2008), and evaluate the effect of the punishment option on average contributions. Rather than compare two charts showing all of the data from each experiment, as the authors of the study did, we will use summary measures to compare the data, and show the data from both experiments (with and without punishment) on the same chart.
First, download and save the data. The spreadsheet contains two tables:
 The first table shows average contributions in a public goods game without punishment (Figure 3).
 The second shows average contributions in a public goods game with punishment (Figure 2A).
 mean
 A summary statistic for a set of observations, calculated by adding all values in the set and dividing by the number of observations.
 variance
 A measure of dispersion in a frequency distribution, equal to the mean of the squares of the deviations from the arithmetic mean of the distribution. The variance is used to indicate how ‘spread out’ the data is. A higher variance means that the data is more spread out. Example: The set of numbers 1, 1, 1 has zero variance (no variation), while the set of numbers 1, 1, 999 has a high variance of 221,334 (large spread).
You can see that in each period (row), the average contribution varies across countries, in other words, there is a distribution of average contributions in each period.
The mean and variance are two ways to summarize distributions. We will now use these measures, along with other measures (range and standard deviation) to summarize and compare the distribution of contributions in both experiments.
Before answering these questions, make sure you understand mean and variance, and how to calculate these measures in Excel.
 See Figure 1.5 in Exercise 1.3 of Economy, Society, and Public Policy for more information about the mean.
 See Excel walkthrough 1.6 for more information about the variance.
 Using the data for Figures 2A and 3 of Herrmann et al. (2008):
 Calculate the mean contribution in each period (row) separately for both experiments, using Excel’s AVERAGE function.
 Plot a line chart of mean contribution on the vertical axis and time period (from 1 to 10) on the horizontal axis (with a separate line for each experiment). Make sure the lines in the legend are clearly labelled according to the experiment (with punishment or without punishment).
 Describe any differences and similarities you see in the mean contribution over time in both experiments.
 Instead of looking at all periods, we can focus on contributions in the first and last period. Plot a column chart showing the mean contribution in the first and last period for both experiments. Your chart should look like Figure 2.6.
Excel walkthrough 2.3 Drawing a column chart to compare two groups
Follow the walkthrough in the CORE video, or in Figure 2.5, to find out how to draw a column or bar chart in Excel.
 variance
 A measure of dispersion in a frequency distribution, equal to the mean of the squares of the deviations from the arithmetic mean of the distribution. The variance is used to indicate how ‘spread out’ the data is. A higher variance means that the data is more spread out. Example: The set of numbers 1, 1, 1 has zero variance (no variation), while the set of numbers 1, 1, 999 has a high variance of 221,334 (large spread).
The mean is one useful measure of the ‘middle’ of a distribution, but is not a complete description of what our data looks like. We also need to know how ‘spread out’ the data is in order to get a clearer picture and make comparisons between the distributions. The variance is one way to measure spread—the higher the variance, the more spread out the data is.
 standard deviation
 A measure of dispersion in a frequency distribution, equal to the square root of the variance. The standard deviation has a similar interpretation to the variance. A larger standard deviation means that the data is more spread out. Example: The set of numbers 1, 1, 1 has a standard deviation of zero (no variation or spread), while the set of numbers 1, 1, 999 has a standard deviation of 46.7 (large spread).
A similar measure is standard deviation, which is the square root of the variance. Standard deviation is commonly used because it provides a handy rule of thumb for large datasets—most of the data (95% if there are many observations) will be less than two standard deviations away from the mean.
 Using the data for Figures 2A and 3 of Herrmann et al. (2008):
 Calculate the standard deviation for Periods 1 and 10 separately, for both experiments. Does the rule of thumb apply? (In other words, are most values within two standard deviations of the mean?)
 As shown in Figure 2.6, the mean contribution for both experiments was 10.6 in Period 1. With reference to your standard deviation calculations, explain whether this means that the two sets of data are the same.
Excel walkthrough 2.4 Calculating the standard deviation
Follow the walkthrough in the CORE video, or in Figure 2.7, to find out how to calculate standard deviation in Excel.
 range
 The interval formed by the smallest (minimum) and the largest (maximum) value of a particular variable. The range shows the two most extreme values in the distribution, and can be used to check whether there are any outliers in the data. (Outliers are a few observations in the data that are very different from the rest of the observations.)
Another measure of spread is the range, the interval formed by the smallest (minimum) and the largest (maximum) values of a particular variable. For example, we might say that the number of periods in the public goods experiment ranges from 1 to 10. Once we know the most extreme values in our dataset, we have a better picture of what our data looks like.
 Calculate the maximum and minimum value for Periods 1 and 10 separately, for both experiments.
Excel walkthrough 2.5 Finding the minimum, maximum, and range of a variable
 A concise way to describe the data is in a summary table. With just four numbers (mean, standard deviation, minimum value, maximum value), we can get a general idea of what the data looks like.
 In Excel, create a summary table as shown in Figure 2.9 below. Make three more summary tables, for Period 10 (without punishment), Period 1 (with punishment), and Period 10 (with punishment). Use your answers to Questions 2 to 4 to complete the summary tables.
 Comment on any similarities and differences in the distributions, both across time and across experiments.
Mean  Standard deviation  Minimum  Maximum  

Contribution (Period 1, without punishment) 
Part 2.3 Did changing the rules of the game affect behaviour?
Learning objectives for this part
 calculate and interpret the pvalue
 evaluate the usefulness of experiments for determining causality, and the limitations of these experiments.
The punishment option was introduced into the public goods game in order to see whether it could help sustain contributions, compared to the game without a punishment option. We will now use a calculation called a pvalue to compare the results from both experiments more formally.
By comparing the results in Period 10 of both experiments, we can see that the mean contribution in the experiment with punishment is 8.5 units higher than in the experiment without punishment (see Figure 2.6). Is it more likely that this behaviour is due to chance, or is it more likely to be due to the difference in experimental conditions?
 You can conduct another experiment to understand why we might see differences in behaviour that are due to chance.
 First, flip a coin six times, using one hand only, and record the results (for example, Heads, Heads, Tails, etc.). Then, using the same hand, flip a coin six times and record the results again.
 Compare the outcomes from Question 1(a). Did you get the same number of heads in both cases? Even if you did, was the sequence of the outcomes (for example, Heads, Tails, Tails …) the same in both cases?
The important point to note is that even when we conduct experiments under the same controlled conditions, due to an element of randomness, we may not observe the exact same behaviour each time we do the experiment.
Randomness arises because the statistical analysis is conducted on a sample of data (for example, a small group of people from the entire population), and the sample we observe is only one of many possible samples. Whatever differences we calculate between two samples would almost certainly change if we had observed another pair of samples. Importantly, economists aren’t really interested in whether two samples are actually different, but rather whether the underlying populations, from which the samples were drawn, differ in the characteristics we are interested in (for example, age, income, contributions to the public good). And this is the challenge faced by the empirical economist.
When we are interested in whether a treatment works — in this case, whether having the punishment option makes a difference in how much people contribute to the public good — we want a way to check whether any observed differences could just be due to sample variation.
The size of the difference alone cannot tell us whether it might just be due to chance. Even if the observed difference seems large, it could be small relative to how much the data vary. Figures 2.10 and 2.11 show the mean exam score of two groups of high school students and the size of house in which they live (represented by the height of the columns, and reported in the boxes above the columns), with the dots representing the underlying data. Figure 2.10 shows a relatively large difference in means that could have arisen by chance because the data is widely spread out (the standard deviation is large), while Figure 2.11 shows a relatively small difference that looks unlikely to be due to chance because the data is tightly clustered together (the standard deviation is very small). Note that we are looking at two distinct questions here: first, is there a large or small difference in exam score associated with the size of house of the student and second, is that difference likely to have arisen by chance. A social scientist is interested in the answer to both questions. If the difference is large but could easily have occurred by chance or if the difference is very small and unlikely to have occurred by chance, then the results are not suggestive of an important relationship between size of house and exam grade.
 pvalue
 The probability of observing data at least as extreme as the data collected if a particular hypothesis about the population is true. The pvalue ranges from 0 to 1: the lower the probability (the lower the pvalue), the less likely it is to observe the given data, and therefore the less compatible the data are with the hypothesis.
To help us decide, we consider the hypothesis that the difference occurred by chance – in other words, we start by hypothesizing that house size does not matter for exam scores. Then we ask how likely it is that we would observe differences at least as extreme as those we actually observe in our sample groups, assuming that our hypothesis is true. The answer to this question is called a pvalue. The smaller the pvalue, the less likely that we would observe differences at least as extreme as those we did, given our hypothesis. So the smaller this pvalue, the smaller our confidence will be in the hypothesis that in the population house size does not matter for exam grades.
Notice that the pvalue is not the probability that the hypothesis is correct – the data cannot tell us that probability. It is the probability that we would find a difference as big as the one we have observed if the hypothesis were correct.
We can estimate the pvalue from the data, using the sample means and sample deviations. It is calculated by comparing the difference in the means with the amount of variation in the data as measured by the standard deviations. This is a wellestablished method, although some other statistical assumptions, which we do not discuss, are required to ensure that it gives a good estimate.
When we look at the data in Figure 2.10, we cannot be absolutely certain that there really is a link between house size and exam scores. But if the pvalue for the difference in means is very small (for example, 0.02) then we know that there would only be a 2% probability of seeing differences at least as extreme as those we did observe in the sample, given our hypothesis that in the population there was no relationship between house size and exam scores.
 hypothesis test
 A test in which a null (default) and an alternative hypothesis are posed about some characteristic of the population. Sample data is then used to test how likely it is that these sample data would be seen if the null hypothesis was true.
Find out more Hypothesis testing and pvalues
The process of formulating a hypothesis about the data, calculating the pvalue, and using it to assess whether what we observe is consistent with the hypothesis, is known as a hypothesis test. When we conduct a hypothesis test, we consider two hypotheses: either there is no difference between the populations, in which case the differences we observe must have happened by chance (known as the ’null hypothesis’); or the populations really are different (known as the ‘alternative hypothesis’). The smaller the pvalue, the lower is the probability that the differences we observe could have happened simply by chance, i.e. if the null hypothesis was true. The smaller the pvalue, the stronger is the evidence in favour of the alternative hypothesis.
It is a common, but highly debatable practice, to pick a cutoff level for the pvalue, and reject the null hypothesis if the pvalue is below this cutoff. This approach has been criticized recently by statisticians and social scientists because the cutoff level is quite arbitrary.
Instead of using a cutoff, we prefer to calculate pvalues and use them to assess the strength of the evidence. Whether the statistical evidence is strong enough for us to draw a firm conclusion about the data will always be a matter of judgement.
In particular, you want to make sure that you understand the consequences of concluding that the null hypothesis is not true, and hence that the alternative is true. You may be quite easily prepared to conclude that house sizes and exam scores are related, but much more cautious about deciding that a new medication is more effective than an existing one if you know that this new medication has severe side effects. In the case of the medication, you might want to see stronger evidence against the null hypothesis before deciding that doctors should be advised to prescribe the new medication.
To calculate the pvalue, we use a function in Excel called T.TEST.
 Using the data for Figures 2A and 3:
 Use Excel’s T.TEST function to calculate the pvalue for the difference in means in Period 1 (with and without punishment). What is the pvalue?
 What does this pvalue tell us about the difference in means in Period 1?
Excel walkthrough 2.6 Using Excel’s T.TEST function
 Using the data for Period 10:
 Use Excel’s T.TEST function to calculate the pvalue for the difference in means in Period 10 (with and without punishment). What is the pvalue?
 What does this pvalue tell us about the relationship between punishment, and behaviour in the public goods game?
 With reference to Figures 2.10 and 2.11, explain why we cannot use the size of the difference to directly conclude whether the difference could be due to chance.
 spurious correlation
 A strong linear association between two variables that does not result from any direct relationship, but instead may be due to coincidence or to another unseen factor.
An important point to note is that calculating pvalues may not tell us anything about causation. The example of house size and exam scores shown in Figure 2.11, gives us evidence that some kind of relationship between house size and exam scores is very likely. However, we would not conclude that building an extra room automatically makes someone smarter. Pvalues cannot help us detect these spurious correlations.
However, calculating pvalues for experimental evidence can help us determine whether there is a causal link between two variables. If we conduct an experiment and find a difference in outcomes with a low pvalue, then we may conclude that the change in experimental conditions is likely to have caused the difference.
 Refer to the results from the public goods games.
 Which characteristics of the experimental setting make it likely that the punishment option was the cause of the change in behaviour?
 With reference to Figure 2.6, explain why we need to compare the two groups in Period 1 in order to conclude that there is a causal link between the punishment option and behaviour in the game.
Experiments can be useful for identifying causal links. However, if people’s behaviour in experimental conditions were different from their behaviour in the real world, our results would not be applicable anywhere outside the experiment.
 Discuss some limitations of lab experiments, and suggest some ways to address (or partially address) them. (You may find pages 158–171 of the paper ‘What do laboratory experiments measuring social preferences reveal about the real world?’ helpful, as well as the discussion on free riding and altruism in Section 2.6 of Economy, Society, and Public Policy.)

Benedikt Herrmann, Christian Thöni, and Simon Gächter. 2008. Figure 3 in ‘Antisocial punishment across societies’. Science Magazine 319 (5868): p. 1365. ↩