Private Sub CommandClicking_Click()
Dim m As Integer
Dim g As String
Randomize Timer
m = Int(Rnd * 100)
Cells(10, 1).Value = m
If m < 35 And m >= 0 Then
g = "F"
Cells(11, 1).Value = g
ElseIf m < 55 And m >= 35 Then
g = "E"
Cells(11, 1).Value = g
ElseIf m < 65 And m >= 55 Then
g = "D"
Cells(11, 1).Value = g
ElseIf m < 75 And m >= 65 Then
g = "B"
Cells(11, 1).Value = g
ElseIf mark < 90 And mark >= 75 Then
g = "A"
Cells(11, 1).Value = g
ElseIf mark < 100 And mark >= 90 Then
grade = "A*"
Cells(11, 1).Value = g
End If
End Sub
1. There is only one telephone in a public booth of a metro station. Following table indicates the distribution of arrival time and duration of calls: Time Between arrivals (minutes) 4 5 6 Probability 0.1 .6 0.3 Call Duration (minutes) 3 4 5 6 Probability 0.14 0.6 0.12 0.14 Simulate for 100/500/1000 times. Conduct 3 such trials. It is proposed to add another telephone to the booth. Justify the proposal based on the waiting time of caller.Generate graphs to support your answer. 2. A baker needs to find out the cookies he need to bake each day. The probability distribution for the cookies customers is as follows: Number of customers/day 7 9 11 14 Probability 0.35 0.30 0.15 0.20 C...
Comments