Confidence Interval Estimation using Excel (Examples)

This video shows How to use Excel to quickly find an estimation of 95% Confidence Interval for Average Credit Card Balance (in Dollars) of millions of Customers given just a sample data set of say 100 credit card customers.
Two scenarios of known and unknown standard deviation are discussed for credit card balances of all millions of credit card holders. It is shown how and when we can use CONFIDENCE.NORM function in Excel vs using the Data Analysis Tool Box and Descriptive Statistics in Excel.