Imagine you work in the finance department of a large company. Revenues seem to have increased for the company and the budget must be planned for the upcoming year. Your supervisor believes the new business plan has resulted in daily revenue that is greater than $100,000. Your supervisor wants to determine if they are correct and has asked you to investigate. If you can prove the daily revenue is greater than $100,000, your company can adjust the budget and begin implementing the next phase of the business plan.

You collect data from the past six months and then randomly sample 30 days of revenue. The results of your sample are shown in the Excel file below.

1. Construct a box-and-whisker plot for the provided data set. Copy each of the values needed to construct a box-and-whisker plot from the Excel worksheet provided and enter those numbers below.

Minimum	Maximum	Quartile 1 (Median of first half of the data set)	Quartile 2 (Median of data set)	Quartile 3 (Median of second half of the data set)

Create the box-and-whisker plot in Excel and include a screen shot of the box-and-whisker plot below.