How to Find the Upper and Lower Bounds in Excel

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

Step

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.

Open a worksheet with your data.
credit: Screenshot courtesy of Microsoft.
Add the Analysis ToolPak to Excel.
credit: Screenshot courtesy of Microsoft.

Step

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.

Select Descriptive Statistics from the Data Analysis window.
credit: Screenshot courtesy of Microsoft.

Step

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

Select the Input Range.
credit: Screenshot courtesy of Microsoft.

Step

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.

Step

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

Select a cell for the Descriptive Statistics output.
credit: Screenshot courtesy of Microsoft.

Step

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.

The Descriptive Statistics table.
credit: Screenshot courtesy of Microsoft.

Step

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.

Calculate the Upper Bound.
credit: Screenshot courtesy of Microsoft.

Step

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.

Calculate the Lower Bound.
credit: Screenshot courtesy of Microsoft.

Step

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.

The completed worksheet.
credit: Screenshot courtesy of Microsoft.

Step

Save your workbook.