Up

Meta-Analysis Spreadsheet

A spreadsheet in the Excel Spreadsheet format is available from the following link.

             Meta-Analysis Spreadsheet

 When this link is clicked, you will be prompted to save or open the file. Regardless of what you select first, eventually opening the spreadsheet reveals the following spreadsheet.

 

 

The spreadsheet contains data from ten hypothetical studies. In each case, the measure of effect size is expressed in terms of correlations. You may replace these data with your own and the analyses will be completed for you.

        If you have more than ten studies, you will need to add rows. These rows should be added somewhere after the current row 3 and somewhere before the current row 12.

        If you have fewer than ten studies, you will need to delete rows, these rows should be deleted somewhere after the current row 3 and somewhere before the current row 12.

Once new rows are added values for appropriate columns will need to be copied from nearby rows of data within the same column.

As can be seen, this spreadsheet includes several valuable pieces of information including:

bullet Rosenthalís Fail Safe Number;
bullet Mean Unweighted Effect size;
bullet Weighted Mean Effect size; and
bullet Weighted Diffuse Test and accompanying reports of degrees of freedom and reports of exact probability.

 In this case, there are four study characteristics that have been coded (date of study, number of independent variables, ratings of study quality, whether studies were field or laboratory inquiries). For your own analyses, different categories may need to be included.