Use 2019 Q4 CES Interview 2018-2019 to complete the following:

1. Construct a variable titled Total Expenditures by adding expenditures from all categories and calculate a 99% confidence interval of the mean. Interpret what the interval means.

2. Use a Pivot Table to calculate means and standard deviations for Total Expenditures by Race category.

3. Calculate 99% confidence intervals of average total expenditures for each category.

4. Plot the means in a bar chart and superimpose whiskers that represent the confidence intervals for each mean. NOTE: You should not have a second set of bars for the standard deviations.

5. Explain what your chart shows.