Descriptive Statistics

Fill a table in the spreadsheet with the main statistical properties of the data set.

このコマンドの見つけ方

「メニューバー」から

Choose Data - Statistics - Descriptive Statistics

From the tabbed interface:

Choose Data - Statistics - Descriptive Statistics.

On the Data menu of the Data tab, choose Statistics - Descriptive Statistics.

The Descriptive Statistics analysis tool generates a report of univariate statistics for data in the input range, providing information about the central tendency and variability of your data.

For more information on descriptive statistics, refer to the corresponding Wikipedia article.

データ

入力範囲: 分析対象のデータ範囲の参照です。

結果貼り付け先: 検定の結果表示の先頭のセルの参照です。

Grouped By

Select whether the input data has columns or rows layout.

Open file with example:

例

The following data will be used as example

1	Maths	Physics	Biology
	A	B	C
2	47	67	33
3	36	68	42
4	40	65	44
5	39	64	60
6		38	43
7	47	84	62
8	29	80	51
9	27	49	40
10	57	49	12
11	56	33	60
12	57
13	26

The following table displays the results of the descriptive statistics of the sample data above.

	Maths	Physics	Biology
平均値	41.9090909091	59.7	44.7
標準誤差	3.5610380138	5.3583786934	4.7680650629
モード	47	49	60
中央値	40	64.5	43.5
分散	139.4909090909	287.1222222222	227.3444444444
標準偏差	11.8106269559	16.944681237	15.0779456308
尖度	-1.4621677981	-0.9415988746	1.418052719
歪度	0.0152409533	-0.2226426904	-0.9766803373
参照範囲	31	51	50
最小値	26	33	12
最大値	57	84	62
合計	461	597	447
数値の個数	11	10	10