bubble-plots in Excel for meta-regressions | Spreadsheet Synthesis

A bubble-plot is a type of scientific plot that displays the relationship between effect sizes and a continuous predictor -- with effect sizes presented as bubbles of different sizes to emphasize their relative weight in the meta-regression.  Finally, it also typically includes the predicted linear fit using a slope and intercept estimated from a meta-regression model. Sometimes this type of bubble-plot is called a "meta-regression scatter plot".

00:00:00 Here I show how to generate a bubble-plot for a meta-regression using Microsoft Excel
00:00:05 bubble plot description
00:01:00 goals
00:01:53 adding column for bubble sizes based on weights
00:07:12 building bubble plot using Excel's bubble plot tools
00:12:44 adding meta-regression slope to plot
00:16:30 building model prediction table for slope and 95%CI
00:25:50 adding 95%CI of slope to bubble plot
00:30:56 summary


cite this video (follow figshare link for dataset):

Lajeunesse, M.J. (2021): Bubble-plots for meta-regression in Microsoft Excel. figshare. Online resource. DOI: 10.6084/m9.figshare.14374124

playlist of other videos using Excel for research synthesis:
Spreadsheet Synthesis with Excel

• #science_technology
• #bubble_plot_meta_regression
• #bubble_plot_excel
• #meta_regression_excel
• #meta_analysis
• #effect_size
• #scatter_plot
• #regression_plot
• #research_synthesis
• #meta_regression