天数 日销量 参考线 分位数 1 28 =PERCENTILE.INC(B2:B21, 0.10) 2 10 =PERCENTILE.INC(B2:B21, 0.25) 3 45 =PERCENTILE.INC(B2:B21, 0.50) 4 5 =PERCENTILE.INC(B2:B21, 0.75) 5 60 =PERCENTILE.INC(B2:B21, 0.90) 6 15 7 22 8 80 9 7 10 30 11 12 12 50 13 18 14 100 15 35 16 20 17 40 18 55 19 70 20 25 1 =PERCENTILE.INC(B2:B21, 0.10) 分位0.10 1 =PERCENTILE.INC(B2:B21, 0.25) 分位0.25 1 =PERCENTILE.INC(B2:B21, 0.50) 分位0.50 1 =PERCENTILE.INC(B2:B21, 0.75) 分位0.75 1 =PERCENTILE.INC(B2:B21, 0.90) 分位0.90 20 =PERCENTILE.INC(B2:B21, 0.10) 分位0.10 20 =PERCENTILE.INC(B2:B21, 0.25) 分位0.25 20 =PERCENTILE.INC(B2:B21, 0.50) 分位0.50 20 =PERCENTILE.INC(B2:B21, 0.75) 分位0.75 20 =PERCENTILE.INC(B2:B21, 0.90) 分位0.90