平均值,方差计算(sss)
sss系統的平均值,標準差計算公式。先放個效果圖:
代碼如下:
protected void Page_Load(object sender, EventArgs e) { //Flash畫圖 CreateChart(); } //FLash柱狀圖顯示 public void CreateChart() { DataTable dt = new DataTable(); string[] targetArr = new string[3]; string[] targetNameArr = new string[3]; //存放targetName的數組 double[] percentNum = new double[3]; //存放百分位數數組; string sqlstr = "SELECT SUM(GetFeng) as gf,SUM(TotalFeng) as tf,UID FROM answertable where CpTID='3' group by UID order by tf"; dt = DtDB.GetDataTable(sqlstr); double[] doubleArray = new double[dt.Rows.Count]; //doubleArray每一元素中裝的值是 一個人的某項指標的平均值 for (int x = 0; x < dt.Rows.Count; x++) { DataRow dr2 = dt.Rows[x]; doubleArray[x] = Convert.ToDouble(dr2["gf"]) / 4; //4為一指標所含題量(一般一指標4道題) } double An = 0.0; double AvgN = 0.0; double StandDevN = 0.0; AvgN = Average(doubleArray); StandDevN = StandardDeviation(doubleArray); Label1.Text = dt.Rows.Count+ "平均值是:" + AvgN.ToString() + " ^^^ 標準差是:" + StandDevN.ToString(); dt.Dispose(); } //平均值標準差計算公式 protected double StandardDeviation(double[] num) { double avg = Average(num); double SumOfSqrs = 0.0; foreach (double d in num) { SumOfSqrs += Math.Pow(d - avg, 2); } return Math.Sqrt((SumOfSqrs / (num.Length - 1))); } protected double Average(double[] num) { double sum = 0.0; foreach (double d in num) { sum += d; } return sum / Convert.ToDouble(num.Length); }
轉載于:https://www.cnblogs.com/Renn/archive/2009/08/17/2048411.html
總結
以上是生活随笔為你收集整理的平均值,方差计算(sss)的全部內容,希望文章能夠幫你解決所遇到的問題。
- 上一篇: fastreport dll_报表如何连
- 下一篇: MS