They are also used in hypothesis testing and regression analysis. They are most often constructed using confidence levels of 95% or 99%. ... Calculating Confidence Intervals in Excel .