'自己修改
Option Explicit
Const studentNUM = 30
Private Sub Form_Click()
Dim arr(), i, max, min, temp, sum, a(), m, maxno, minno
ReDim arr(1 To studentNUM)
For i = 1 To UBound(arr)
Randomize
arr(i) = Int(Rnd * 100) + 1
If i = 1 Then
max = arr(i): min = max
maxno = i: minno = i
Else
If min > arr(i) Then
min = arr(i)
minno = i
End If
If max < arr(i) Then
max = arr(i)
maxno = i
End If
End If
sum = sum + arr(i)
If arr(i) >= 60 Then
m = m + 1
End If
Next
For i = 1 To UBound(arr)
Debug.Print arr(i);
If i Mod 10 = 0 Then Debug.Print
Next
Debug.Print vbNewLine & "最高分:" & max & Space(4) & "学号:" & maxno & vbNewLine & "最低分:" & min & Space(4) & "学号:" & minno & vbNewLine
Debug.Print "平均分:" & Format(sum / UBound(arr), "0.00") & "及格人数:" & m & vbNewLine & "及格率:" & Format(m / UBound(arr), "0.00%")
End Sub