← All NMath Code Examples
Imports System
Imports System.Collections
Imports Microsoft.VisualBasic
Imports CenterSpace.NMath.Core
Namespace CenterSpace.NMath.Examples.VisualBasic
A .NET example in Visual Basic showing one way RANOVA.
Public Class Form1
Inherits System.Windows.Forms.Form
#Region " Windows Form Designer generated code "
Public Sub New()
MyBase.New()
This call is required by the Windows Form Designer.
InitializeComponent()
Add any initialization after the InitializeComponent() call
Construct a DataFrame containing the data to be analyzed. Each
column of the DataFrame represents a treatment and each row
represents a subject.
Dim Data As New DataFrame()
Data.RowKeyHeader = "Dog Number"
Data.AddColumn(New DFNumericColumn("Normal"))
Data.AddColumn(New DFNumericColumn("Stomach"))
Data.AddColumn(New DFNumericColumn("Eating"))
Dim Dog As Integer = 1
Dog = Dog + 1
Data.AddRow(Dog, 104, 91, 22)
Dog = Dog + 1
Data.AddRow(Dog, 106, 94, 14)
Dog = Dog + 1
Data.AddRow(Dog, 111, 105, 14)
Dog = Dog + 1
Data.AddRow(Dog, 114, 106, 15)
Dog = Dog + 1
Data.AddRow(Dog, 117, 120, 18)
Dog = Dog + 1
Data.AddRow(Dog, 139, 111, 8)
Now, use the DataFrame to construct a OneWayRanova instance.
Dim Ranova As New OneWayRanova(Data)
This example will just display a traditional RANOVA table
in a System.Windows.Forms.DataGrid object. The next few lines of
code are formatting the table contents so it will look nice.
First retrieve the table to display. Note that the class
OneWayRanovaTable is a subclass of DataFrame.
Dim RanovaTable As OneWayRanovaTable = Ranova.RanovaTable
Next, lets set the precision to three decimal places. Note that this
does not actually change the numbers in the RANOVA table. It just
determines how many decimal places will be displayed when the table is
converted to a string.
Dim I As Integer
For I = 1 To RanovaTable.Cols - 1
CType(RanovaTable(I), DFNumericColumn).NumericFormat = "F3"
Next
Next convert the RANOVA table into a string. This will have the effect of
formatting all the numbers so that they have three digits after the decimal
point and all Double.NaN values will be represented as a "." (some rows
in the RANOVA table that do not have F statistic values or F statistic
p-values associated with them. The cells that correspond to these rows
and the F and P columns contain Double.NaN values).
Dim DisplayFrame As New DataFrame(RanovaTable.ToString(), True, True, ControlChars.Tab, False)
Notice that in the previous line we passed a value of false for the
parse parameter to the DataFrame constructor (the last parameter).
This will give us a DataFrame object in which all the column types
are strings. This lets me format the data easily before I turn it
over to the DataGrid.
If the p-value for the F statistic is too small, it will be rounded
to zero when we set the precision to three decimal places. It doesnt
look good to have a p-value of 0 in our display, so lets display
something a bit more sensible like display "< 0.001".
First, use the FStatisticPValue property on the OneWayRanovaTable
class to determine if the p-value is too small.
If RanovaTable.FStatisticPValue < 0.001 Then
Use the IndexOfKey() and IndexOfColumn() methods of the DataFrame
to determine the row and column indices of the p-value in our
display table (the display table, being a copy of the original
RANOVA table, has the same rows and columns as the original).
Dim RowIndex As Integer = RanovaTable.IndexOfKey(OneWayRanovaTable.TreatmentRowKey)
Dim ColIndex As Integer = RanovaTable.IndexOfColumn(OneWayRanovaTable.PvalueColName)
Note how we used the static variables OneWayRanovaTable.TreatmentRowKey
and OneWayRanovaTable.PvalueColName to get the names of the row
and column that contain the p-value.
Finally, lets change the string from 0 to something more sensible.
DisplayFrame(RowIndex, ColIndex) = "< 0.001"
End If
We are now ready to display the RANOVA table in the DataGrid. We use
the DataFrames ToDataTable() method to create an ADO DataTable which
we use to set the grids data source.
DataGrid1.DataSource = DisplayFrame.ToDataTable()
End Sub
Form overrides dispose to clean up the component list.
Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
If disposing Then
If Not (components Is Nothing) Then
components.Dispose()
End If
End If
MyBase.Dispose(disposing)
End Sub
Required by the Windows Form Designer
Private components As System.ComponentModel.IContainer
NOTE: The following procedure is required by the Windows Form Designer
It can be modified using the Windows Form Designer.
Do not modify it using the code editor.
Friend WithEvents Label1 As System.Windows.Forms.Label
Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
Me.Label1 = New System.Windows.Forms.Label()
Me.DataGrid1 = New System.Windows.Forms.DataGrid()
CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
Me.SuspendLayout()
Label1
Me.Label1.Font = New System.Drawing.Font("Microsoft Sans Serif", 14.25!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
Me.Label1.Location = New System.Drawing.Point(192, 24)
Me.Label1.Name = "Label1"
Me.Label1.Size = New System.Drawing.Size(264, 23)
Me.Label1.TabIndex = 0
Me.Label1.Text = "One Way Ranova Example"
DataGrid1
Me.DataGrid1.BackgroundColor = System.Drawing.Color.White
Me.DataGrid1.CaptionVisible = False
Me.DataGrid1.DataMember = ""
Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText
Me.DataGrid1.Location = New System.Drawing.Point(24, 72)
Me.DataGrid1.Name = "DataGrid1"
Me.DataGrid1.PreferredColumnWidth = 110
Me.DataGrid1.ReadOnly = True
Me.DataGrid1.RowHeadersVisible = False
Me.DataGrid1.Size = New System.Drawing.Size(664, 96)
Me.DataGrid1.TabIndex = 1
Form1
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
Me.ClientSize = New System.Drawing.Size(714, 192)
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.DataGrid1, Me.Label1})
Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle
Me.Name = "Form1"
Me.Text = "One Way Ranova Example"
CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit()
Me.ResumeLayout(False)
End Sub
#End Region
End Class
End Namespace
← All NMath Code Examples
