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

## Video of the Day

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.

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.

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

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 is named after the first cell of data.

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.

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.

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.

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**.

Save your workbook.