Statistics for everyone: Excel and Statistics(10), Descriptive Statistics

Excel and Statistics, everybody should know. : Contents

Descriptive Statistics

‘example1.xlsx’ and open the <Data Analysis> window. The configuration of the menu is easy and simple, and there are no rules such as what is commonly used is higher, so I think I will introduce the simple and basic things in order. Let’s first learn the most basic <descriptive statistics>.

Specifies the range of data to use. In most cases, you will organize your data in column directions, using the first row as a label, or choosing it in your situation.

For very simple data, you can specify an “output range” so that the results appear next to the data, and in many cases, you can create a new worksheet to show the results.

All the remaining results are checked first. Depending on the check, the display may vary slightly, but it is simple enough to understand immediately if you run it yourself.

Up to row 15 is the basic ‘summary statistic’, the minimum and maximum values in rows 16 and 17, which are the same as the values in lines 12 and 13., By specifying, you can get the corresponding confidence level for the mean in row 18.