Descriptive statistics in excel file

How to Create Descriptive Statistics in Excel

1. On the Data tab, in the Analysis group, click Data Analysis . Note: can't find the Data Analysis button? Click here to load the Analysis ...
2. Select Descriptive Statistics and click OK.
3. Select the range A2:A15 as the Input Range.
4. Select cell C1 as the Output Range.
5. Make sure Summary statistics is checked.

See More....

How to Run Descriptive Statistics

• To use Descriptive Statistics, you first need to go to Data > Data Analysis.
• From the given options, click on Descriptive Statistics and then click OK.

To calculate descriptive statistics for the data set, follow these steps:

• Click the Data tab’s Data Analysis command button to tell Excel that you want to calculate descriptive statistics. Excel displays the Data Analysis dialog box.

More itemsTo get Descriptive Statistics, go to the ‘Data’ tab and click the ‘Data Analysis’ tool from the Analysis section. In the Data Analysis dialog window, select ‘Descriptive Statistics’ under Analysis Tools and click ‘OK’. This will open the Descriptive Statistics dialog box where you need to configure the Input and Output options.Below are the steps to do this: Click the Data tab In the Analysis group, click on Data Analysis In the Data Analysis dialog box that opens, click on Descriptive Statistics Click OK In the Descriptive Statistics dialog box, specify the input range that has the data.