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