The manager of Moores Catalog Showroom is trying to predict

The manager of Moore’s Catalog Showroom is trying to predict how much revenue
will be generated by each major department in the store during 2015. The manager
has estimated the minimum and maximum growth rates possible for revenues in
each department. The manager believes that any of the possible growth rates between the minimum and maximum values are equally likely to occur. These estimates are summarized in the following table:

Create a spreadsheet to simulate the total revenues that could occur in the coming
year.
a. Construct a 95% confidence interval for the average level of revenues the manager could expect for 2015.
b. According to your model, what are the chances that total revenues in 2015 will
be more than 5% larger than those in 2014?

Solution