Excel 四分位数算法 C#实现
/// <summary>
/// 四分位数算法
/// </summary>
/// <param name="list"></param>
/// <param name="num"></param>
/// <returns></returns>
private static decimal? Quartile(List<CalcValueModel> list, int num)
{
if (list.Count < 3)
return null;
//对原数组进行大小排序
var sortList = list.OrderBy(x => x.Value).ToList();
var index = (list.Count + 1) * num / 4.0;
//第一个位置的数
var first = sortList[(int)index - 1].Value;
//第二个位置的数
var second = sortList[(int)index].Value;
//权重偏移量
decimal shifting = 0.25m * num;
//第一个位置权重
decimal wightFirst = 1 - shifting;
//第二个位置权重
decimal wightSecond = shifting;
return first * wightFirst + second * wightSecond;
}