📄 双因素交错f2.frm
字号:
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 375
Left = 120
TabIndex = 12
Top = 2760
Width = 3735
End
Begin VB.Label lblFB
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 255
Left = 3840
TabIndex = 11
Top = 2400
Width = 1455
End
Begin VB.Label Label5
Alignment = 1 'Right Justify
Appearance = 0 'Flat
BackColor = &H80000005&
Caption = "列因素检验值："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 255
Left = 240
TabIndex = 10
Top = 2400
Width = 3615
End
Begin VB.Label lblDA
Alignment = 2 'Center
Appearance = 0 'Flat
AutoSize = -1 'True
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 240
Left = 2685
TabIndex = 9
Top = 2040
Width = 165
End
Begin VB.Label Label4
Alignment = 2 'Center
Appearance = 0 'Flat
BackColor = &H80000005&
Caption = "行因素的检验结论"
BeginProperty Font
Name = "宋体"
Size = 14.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 375
Left = 120
TabIndex = 8
Top = 1680
Width = 5295
End
Begin VB.Label lbl001A
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 255
Left = 3840
TabIndex = 7
Top = 1320
Width = 1455
End
Begin VB.Label lbl005A
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 255
Left = 3840
TabIndex = 6
Top = 960
Width = 1455
End
Begin VB.Label lblFA
Appearance = 0 'Flat
BackColor = &H80000005&
BorderStyle = 1 'Fixed Single
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 255
Left = 3840
TabIndex = 5
Top = 600
Width = 1455
End
Begin VB.Label Label3
Alignment = 1 'Right Justify
Appearance = 0 'Flat
BackColor = &H80000005&
Caption = "显著性水平为0.01的行因素临界值："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 375
Left = 120
TabIndex = 4
Top = 1320
Width = 3735
End
Begin VB.Label Label2
Alignment = 1 'Right Justify
Appearance = 0 'Flat
BackColor = &H80000005&
Caption = "显著性水平为0.05的行因素临界值："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 375
Left = 120
TabIndex = 3
Top = 960
Width = 3735
End
Begin VB.Label Label1
Alignment = 1 'Right Justify
Appearance = 0 'Flat
BackColor = &H80000005&
Caption = "行因素检验值："
BeginProperty Font
Name = "宋体"
Size = 10.5
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
ForeColor = &H80000008&
Height = 375
Left = 120
TabIndex = 2
Top = 600
Width = 3735
End
End
Attribute VB_Name = "frmCalculate"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'双因素交错方差分析
Option Explicit
Private Sub Form_Load()
Label1.Visible = False: Label2.Visible = False
Label3.Visible = False: Label4.Visible = False
Label5.Visible = False: Label6.Visible = False
Label7.Visible = False: Label8.Visible = False
Label9.Visible = False: Label10.Visible = False
Label11.Visible = False: Label12.Visible = False
lblFA.Visible = False: lblDA.Visible = False
lbl001A.Visible = False: lbl005A.Visible = False
lblFB.Visible = False: lblDB.Visible = False
lbl001B.Visible = False: lbl005B.Visible = False
lblFAB.Visible = False: lblDAB.Visible = False
lbl001AB.Visible = False: lbl005AB.Visible = False
End Sub
'检验
Private Sub cmdCheck_Click()
Dim F1 As Double, F2 As Double, F12 As Double
Dim sngF1 As Single, sngF2 As Single, sngF12 As Single
Dim F005A As Double, F001A As Double
Dim sngF005A As Single, sngF001A As Single
Dim F005B As Double, F001B As Double
Dim sngF005B As Single, sngF001B As Single
Dim F005AB As Double, F001AB As Double
Dim sngF005AB As Single, sngF001AB As Single
Dim M1 As Integer, M2 As Integer, K As Integer
Dim m As Integer, p As Integer, n As Integer
Dim Ua As Integer, Ub As Integer, Uab As Integer, Ue As Integer
Label1.Visible = True: Label2.Visible = True
Label3.Visible = True: Label4.Visible = True
Label5.Visible = True: Label6.Visible = True
Label7.Visible = True: Label8.Visible = True
Label9.Visible = True: Label10.Visible = True
Label11.Visible = True: Label12.Visible = True
lblFA.Visible = True: lblDA.Visible = True
lbl001A.Visible = True: lbl005A.Visible = True
lblFB.Visible = True: lblDB.Visible = True
lbl001B.Visible = True: lbl005B.Visible = True
lblFAB.Visible = True: lblDAB.Visible = True
lbl001AB.Visible = True: lbl005AB.Visible = True
'计算F检验值，F1为行因素的检测值，F2为列因素的检测值
DoubleAB V, F1, F2, F12
sngF2 = F2: sngF1 = F1: sngF12 = F12
lblFA.Caption = Str(sngF1): lblFB.Caption = Str(sngF2)
lblFAB.Caption = Str(sngF12)
p = UBound(V, 1): q = UBound(V, 2): r = UBound(V, 3)
'自由度
Ua = p - 1: Ub = q - 1: Ue = p * q * (r - 1): Uab = (p - 1) * (q - 1)
PF_DIST Ub, Ue, 0.05, F005B '计算显著性为0.05的列因素临界值
PF_DIST Ub, Ue, 0.01, F001B '计算显著性为0.01的列因素临界值
sngF005B = F005B: sngF001B = F001B
lbl005B.Caption = Str(sngF005B): lbl001B.Caption = Str(sngF001B)
If F2 <= F005B Then lblDB = "列因素对试验指标的影响不显著"
If F2 > F005B And F2 <= F001B Then lblDB = "列因素对试验指标的影响显著"
If F2 > F001B Then lblDB = "列因素对试验指标的影响特别显著"
PF_DIST Ua, Ue, 0.05, F005A '计算显著性为0.05的行因素临界值
PF_DIST Ua, Ue, 0.01, F001A '计算显著性为0.01的行因素临界值
sngF005A = F005A: sngF001A = F001A
lbl005A.Caption = Str(sngF005A): lbl001A.Caption = Str(sngF001A)
If F1 <= F005A Then lblDA = "行因素对试验指标的影响不显著"
If F1 > F005A And F1 <= F001A Then lblDA = "行因素对试验指标的影响显著"
If F1 > F001A Then lblDA = "行因素对试验指标的影响特别显著"
PF_DIST Uab, Ue, 0.05, F005AB '计算显著性为0.05的交错临界值
PF_DIST Uab, Ue, 0.01, F001AB '计算显著性为0.01的交错临界值
sngF005AB = F005AB: sngF001AB = F001AB
lbl005AB.Caption = Str(sngF005AB): lbl001AB.Caption = Str(sngF001AB)
If F12 <= F005AB Then lblDAB = "交错因素对试验指标的影响不显著"
If F12 > F005AB And F12 <= F001AB Then lblDAB = "交错因素对试验指标的影响显著"
If F12 > F001AB Then lblDAB = "交错因素对试验指标的影响特别显著"
End Sub
'退出
Private Sub cmdExit_Click()
Unload Me
End
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -