VB One Way Ranova Example

← 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
Top