How to add descriptive statistics in excel?
Answers
1. 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.
2. In Data Analysis dialog box, highlight the Descriptive Statistics entry in the Analysis Tools list and then click OK.
Excel displays the Descriptive Statistics dialog box.
3. In the Input section of the Descriptive Statistics dialog box, identify the data that you want to describe.
o To identify the data that you want to describe statistically: Click the Input Range text box and then enter the worksheet range reference for the data. In the case of the example worksheet, the input range is $A$1:$C$38. Note that Excel wants the range address to use absolute references — hence, the dollar signs.
o To identify whether the data is arranged in columns or rows: Select either the Columns or the Rows radio button.
o To indicate whether the first row holds labels that describe the data:Select the Labels in First Row check box. In the case of the example worksheet, the data is arranged in columns, and the first row does hold labels, so you select the Columns radio button and the Labels in First Row check box.
4. In the Output Options area of the Descriptive Statistics dialog box, describe where and how Excel should produce the statistics.
o To indicate where the descriptive statistics that Excel calculates should be placed: Choose from the three radio buttons here — Output Range, New Worksheet Ply, and New Workbook. Typically, you place the statistics onto a new worksheet in the existing workbook. To do this, simply select the New Worksheet Ply radio button.
o To identify what statistical measures you want calculated: Use the Output Options check boxes. Select the Summary Statistics check box to tell Excel to calculate statistical measures such as mean, mode, and standard deviation. Select the Confidence Level for Mean check box to specify that you want a confidence level calculated for the sample mean.