private void button5_Click(object sender, EventArgs e) { dataGridView1.AllowUserToAddRows = false; if (dataGridView1.Columns.Count != 0) { for (int i = 0; i < dataGridView1.Columns.Count; i++) { if (dataGridView1.Columns[i].Name == comboBox1.Text) { double[] columnData = (from DataGridViewRow row in dataGridView1.Rows where row.Cells[i].FormattedValue.ToString() != string.Empty select Convert.ToDouble(row.Cells[i].FormattedValue)).ToArray(); string average = columnData.Average().ToString(); string min = columnData.Min().ToString(); string max = columnData.Max().ToString(); double sum = Convert.ToDouble(columnData.Sum(d => Math.Pow((d - Convert.ToDouble(average)), 2))); string standard_Deviation = Convert.ToString(Math.Sqrt((sum) / (columnData.Count() - 1))); string range = Convert.ToString(Convert.ToDouble(max) - Convert.ToDouble(min)); // Median string median; double[] tempArray = columnData; int count = tempArray.Length; Array.Sort(tempArray); if (count % 2 == 0) { double middleElement1 = tempArray[(count / 2) - 1]; double middleElement2 = tempArray[(count / 2)]; median = Convert.ToString((middleElement1 + middleElement2) / 2); } else { median = Convert.ToString(columnData[(count / 2)]); } var mode = tempArray.GroupBy(n => n). OrderByDescending(g => g.Count()). Select(g => g.Key).FirstOrDefault(); // MOdd string mod = Convert.ToString(mode); double sumOfSquares = 0.0; foreach (int num in tempArray) { sumOfSquares += Math.Pow((num - Convert.ToDouble(average)), 2.0); } // Varience string varience = Convert.ToString(sumOfSquares / (double)(tempArray.Length - 1)); SecondPage open = new SecondPage(average, min, max, varience, standard_Deviation, median, mod, range, columnData); open.Show(); Visible = false; } } } else { MessageBox.Show("Please First Choose any Excel File."); } }
private void pictureBox3_Click(object sender, EventArgs e) { SecondPage backoption = new SecondPage(average, min, max, variance, standard, median, mode, range, colData); backoption.Show(); this.Visible = false; }