您还没有绑定微信,更多功能请点击绑定

请问四分之一中位数quartile到底怎么算的,大家帮我看看阿

在EXCEL中我把(A1:A6)分别存储1 2 3 4 5 6,求QUARTILE(A1:A6,1)怎么得出是2.25? 怎么计算的阿 ?
对“好”的回答一定要点个"赞",回答者需要你的鼓励!
已邀请:

aiyinsitan (威望:30) (河南 开封) 在校学生 员工

赞同来自:

Quartiles
Quartiles are values that divide a sample of data into four equal parts. They are commonly used to describe data sets.

First quartile (Q1)
25% of the data are less than or equal to this value.

Second quartile (Q2)
The median. 50% of the data are less than or equal to this value.

Third quartile (Q3)
75% of the data are less than or equal to this value.


For example, for the following data: 7, 9, 16, 36, 39, 45, 45, 46, 48, 51

· Q1 = 16

· Q2 (median) = 42

· Q3 = 46

The interquartile range is equal to the distance between the first and third quartiles (Q3-Q1); thus, it spans the middle 50% of the data.

1 个回复,游客无法查看回复,更多功能请登录注册

发起人

扫一扫微信订阅<6SQ每周精选>