How to Find the Upper and Lower Bounds in Excel

By David Weedmark

Use Descriptive Statistics in Excel 2013 to calculate the upper and lower bound of the mean average on any set of data.

Calculate the upper and lower bound in Excel using Descriptive Statistics, a part of the Analysis Toolpak that comes with Excel 2013.

Step 1

Open a worksheet containing a column of data. Insert a column title if there isn't one already. Make sure there are no blank rows or columns between the data cells.

Step 2

Add the Analysis ToolPak to Excel.

Add the Data Analysis option to Excel's Data ribbon. Click the File tab, select Options and then click Add-Ins. Select the Analysis ToolPak and click the Go button.

Step 3

Select Descriptive Statistics from the Data Analysis window.

Click the Data tab and then the Data Analysis icon that now appears in the ribbon. Select Descriptive Statistics and click OK.

Step 4

Select the Input Range.

Click the Input Range text field and then drag the cursor across the column of data, including the title. Click the Tables in First Row check box.

If you don't select the title too, the Statistics table this process creates will be named after the first cell of data.

Step 5

Select a cell for the Descriptive Statistics output.

Click the Output Range text field and then click any blank cell to the right of your column of data. A two-column table will appear in this cell. Click the Summary Statistics and Confidence Level for Mean check boxes. Leave the Confidence Level for Mean at its default 95 percent value. Click OK to create the analysis table.

Step 6

The Descriptive Statistics table.

Adjust the column size as needed so that you can see the whole table. The Mean is in the first row, while the Confidence Level is in the last row.

Step 7

Calculate the Upper Bound.

Click a cell below the table to calculate the Upper Bound. Type an =, click the Mean value, then a + and then click the Confidence Level value. In this screenshot the formula is =E3+E16. Press Enter to calculate the formula.

Step 8

Calculate the Lower Bound.

Click another empty cell below the table to calculate the Lower Bound. Type an =, click the Mean value, then a - and then click the Confidence Level value, such as =E3-E16.

Step 9

The completed worksheet.

Save your workbook.

Tip

If you update any values in the data column, you must repeat the procedure. Unlike formulas, Descriptive Statistics aren't recalculated after data have been changed.