Question

How do you add an error bar when the add error bar is not included in the add chart element box? How do you do the dependent t-test calculation in excel?

Answer 1

How to add error bars in Excel

In Excel 2019, Excel 2016, and Excel 2013, inserting error bars is quick and straightforward:

1. Click anywhere in your graph.
2. Click the Chart Elements button to the right of the chart.
3. Click the arrow next to Error Bars and pick the desired option:
   • Standard Error - displays the standard error of the mean for all values, which shows how far the sample mean is likely to be from the population mean.
   • Percentage - adds error bars with the default 5% value, but you can set your own percentage by choosing More Options.
   • Standard Deviation - shows the amount of variability of the data, i.e. how close it is to the average. By default, the bars are graphed with 1 standard deviation for all data points.
   • More Options… - allows specifying your own error bar amounts and creating custom error bars.

   

How to do error bars in Excel 2010 and 2007

In earlier versions of Excel, the path to error bars is different. To add error bars in Excel 2010 and 2007, this is what you need to do:

1. Click anywhere in the chart to activate Chart Tools on the ribbon.
2. On the Layout tab, in the Analysis group, click Error Bars and choose one of the following options:
   

dependent t-test calculation in excel

data -> data analysis -> t-test : paired two sample for means

choose cell values for both pair , choose alpha