Solution
What is the mean and standard deviation of the ABV values for the craft beers made by the Alameda Brewing? Round any intermediate calculations, if needed, to more than six decimal places, and round your final answer to four decimal places.
First, let's use the Excel "Filter" feature to view the portion of the data for which the City variable is "Portland" and the Brewery Name variable is "Alameda Brewing".
The number of observations in the obtained data subset is $n = 3$.
Recall that for a data set containing $n$ observations $x_1, x_2, \dots, x_n$, the mean is given by
$\bar{x} = \frac{\sum x_i}{n}$
and the standard deviation is given by
$s = \sqrt{\frac{\sum (x_i - \bar{x})^2}{n - 1}}$
Thus, we have
$\bar{x} = \frac{\sum x_i}{3} \approx 0.058333$ and $s = \sqrt{\frac{\sum (x_i - 0.058333)^2}{3 - 1}} \approx 0.021502$.
Therefore, the mean and standard deviation of the ABV values for the craft beers made by the Alameda Brewing are 0.058333 and 0.021502, respectively.
