Descriptive statistics is numerical information of data. Descriptive statistics is collection, presentation, analysis and interpretation of data. OR Descriptive statistics are brief coefficients that summarize a given data set, which can be either a representation of the entire population or a sample of it. They contain measures of central tendency such as mean, median, mode as well as measures of dispersion, such as, variance, standard deviation, etc.
We can get descriptive statistics very easily in excel. The Data set 1 presents a sample of annual salaries for recently hired plant operators for a chemical manufacturing company. Using the data analysis tool for descriptive data on an Excel spreadsheet, I was able to analyze, among other traits, the mean, median, standard deviation, skewness, the minimum, maximum, and range of the salaries. The excel file is shorted on column. Click on the data analysis in the analysis group under the Data tab in excel menu bar. Select Descriptive Statistics form the list of tools. Enter data range in input range text box, select blank column, select Summary statistics and click ok.