How do you  do an descriptive statistics in data analysis on excel?
 In Excel click on Tools, Data Analysis and Descriptive Statistics to get this input window. Excel calculates a separate set of statistics for each column or row of your data.If you want to calculate statistics for all of your data, make sure your data is only in one row or column. 