# Aggregating Expert Opinion: Simple Averaging Method in Excel

Have you ever thought to yourself, *if only there were an easy way of aggregating the numerical estimates of experts to use in a risk analysis... *then this post is for you. My previous post on this topic, *Aggregating Expert Opinion in Risk Analysis: An Overview of Methods** *covered the basics of expert opinion and the two main methods of aggregation, behavioral and mathematical. While each method has pros and cons, the resulting single distribution is a representation of all the estimates provided by the group and can be used in a risk analysis. This post focuses one, of several, mathematical methods - simple averaging in Excel