OCR MEI Further Statistics B AS Specimen — Question 1 9 marks

Exam BoardOCR MEI
ModuleFurther Statistics B AS (Further Statistics B AS)
SessionSpecimen
Marks9
PaperDownload PDF ↗
Mark schemeDownload PDF ↗
TopicGeometric Probability
TypeSimulation design and interpretation
DifficultyEasy -1.2 This is a straightforward simulation question requiring basic spreadsheet functions (RANDBETWEEN, MAX, MIN) and simple probability estimation by counting favorable outcomes. The conceptual demand is low—students just need to understand how to set up formulas and interpret simulation results. No complex probability theory or multi-step reasoning is required.
Spec2.03a Mutually exclusive and independent events

1 Abby runs a stall at a charity event. Visitors to the stall pay to play a game in which six fair dice are rolled. If the difference between the highest and lowest scores is less than 3 then the player wins \(\pounds 5\). Otherwise the player wins nothing. Abby designs the spreadsheet shown in Fig. 1 to estimate the probability of a player winning, by simulating 20 goes at the game. Cell C5, highlighted, shows that the 2nd dice in simulated game 4 scores 5 . Cells H5 and I5 show the highest and lowest scores, respectively, in game 4, and cell J5 gives the difference between them. \begin{table}[h]
C5\(\times \vee f _ { x }\)=RANDBETWEEN(1,6)
ABCDEFGHJ
1dice 1dice 2dice 3dice 4dice 5dice 6High scoreLow scoreDifference
2game 1224233422
3game 2263212615
4game 3315346615
5game 4652563624
6game 5633532624
7game 6563514615
8game 7231264615
9game 8666615615
10game 9362541615
11game 10511461615
12game 11256165615
13game 12256666624
14game 13222244422
15game 14166635615
16game 15223351514
17game 16123433413
18game 17524216615
19game 18615215615
20game 19135135514
21game 20543251
\captionsetup{labelformat=empty} \caption{Fig. 1}
\end{table}
  1. (A) Write down the numbers in columns H , I and J for game 20 .
    (B) Use the spreadsheet to estimate the probability of a player winning a game.
  2. State how the estimate of probability in (i) (B) could be improved.
  3. Give one advantage and one disadvantage of using this simulation technique compared with working out the theoretical probability. All profit made by the stall is given to charity. Abby has to decide how much to charge players to play.
  4. If Abby charges \(\pounds 1\) per game, estimate the total profit when 50 players each play the game once.

Question 1:
AnswerMarks Guidance
1(i) (A)
[1]1.1
1(i) (B)
Estimate of P(Less than 3) =
20
AnswerMarks
=0.1M1
A1
AnswerMarks
[2]3.4
1.1
AnswerMarks Guidance
1(ii) Simulate more goes at the game
[1]3.5c N
1(iii) Advantage is that the probabilities are difficult to
calculate
AnswerMarks
Disadvantage is that it does not give an exact answerE1
E1
AnswerMarks
[2]1.1
3.5bE
M
AnswerMarks Guidance
1(iv) Expected profit = 50 × £1 – 50 × 0.1 × £5
=£25M1
C
M1
A1
AnswerMarks
[3]I
3.4
1.1a
AnswerMarks
1.1For 50 × £1
for 50 × 0.1 × £5
Question 1:
1 | (i) | (A) | 5, 1, 4 | B1
[1] | 1.1
1 | (i) | (B) | 2
Estimate of P(Less than 3) =
20
=0.1 | M1
A1
[2] | 3.4
1.1
1 | (ii) | Simulate more goes at the game | E1
[1] | 3.5c | N
1 | (iii) | Advantage is that the probabilities are difficult to
calculate
Disadvantage is that it does not give an exact answer | E1
E1
[2] | 1.1
3.5b | E
M
1 | (iv) | Expected profit = 50 × £1 – 50 × 0.1 × £5
=£25 | M1
C
M1
A1
[3] | I
3.4
1.1a
1.1 | For 50 × £1
for 50 × 0.1 × £5
1 Abby runs a stall at a charity event. Visitors to the stall pay to play a game in which six fair dice are rolled. If the difference between the highest and lowest scores is less than 3 then the player wins $\pounds 5$. Otherwise the player wins nothing.

Abby designs the spreadsheet shown in Fig. 1 to estimate the probability of a player winning, by simulating 20 goes at the game. Cell C5, highlighted, shows that the 2nd dice in simulated game 4 scores 5 . Cells H5 and I5 show the highest and lowest scores, respectively, in game 4, and cell J5 gives the difference between them.

\begin{table}[h]
\begin{center}
\begin{tabular}{|l|l|l|l|l|l|l|l|l|l|l|}
\hline
\multicolumn{3}{|l|}{C5} & \multicolumn{2}{|c|}{$\times \vee f _ { x }$} & \multicolumn{6}{|c|}{=RANDBETWEEN(1,6)} \\
\hline
 & A & B & C & D & E & F & G & H &  & J \\
\hline
1 &  & dice 1 & dice 2 & dice 3 & dice 4 & dice 5 & dice 6 & High score & Low score & Difference \\
\hline
2 & game 1 & 2 & 2 & 4 & 2 & 3 & 3 & 4 & 2 & 2 \\
\hline
3 & game 2 & 2 & 6 & 3 & 2 & 1 & 2 & 6 & 1 & 5 \\
\hline
4 & game 3 & 3 & 1 & 5 & 3 & 4 & 6 & 6 & 1 & 5 \\
\hline
5 & game 4 & 6 & 5 & 2 & 5 & 6 & 3 & 6 & 2 & 4 \\
\hline
6 & game 5 & 6 & 3 & 3 & 5 & 3 & 2 & 6 & 2 & 4 \\
\hline
7 & game 6 & 5 & 6 & 3 & 5 & 1 & 4 & 6 & 1 & 5 \\
\hline
8 & game 7 & 2 & 3 & 1 & 2 & 6 & 4 & 6 & 1 & 5 \\
\hline
9 & game 8 & 6 & 6 & 6 & 6 & 1 & 5 & 6 & 1 & 5 \\
\hline
10 & game 9 & 3 & 6 & 2 & 5 & 4 & 1 & 6 & 1 & 5 \\
\hline
11 & game 10 & 5 & 1 & 1 & 4 & 6 & 1 & 6 & 1 & 5 \\
\hline
12 & game 11 & 2 & 5 & 6 & 1 & 6 & 5 & 6 & 1 & 5 \\
\hline
13 & game 12 & 2 & 5 & 6 & 6 & 6 & 6 & 6 & 2 & 4 \\
\hline
14 & game 13 & 2 & 2 & 2 & 2 & 4 & 4 & 4 & 2 & 2 \\
\hline
15 & game 14 & 1 & 6 & 6 & 6 & 3 & 5 & 6 & 1 & 5 \\
\hline
16 & game 15 & 2 & 2 & 3 & 3 & 5 & 1 & 5 & 1 & 4 \\
\hline
17 & game 16 & 1 & 2 & 3 & 4 & 3 & 3 & 4 & 1 & 3 \\
\hline
18 & game 17 & 5 & 2 & 4 & 2 & 1 & 6 & 6 & 1 & 5 \\
\hline
19 & game 18 & 6 & 1 & 5 & 2 & 1 & 5 & 6 & 1 & 5 \\
\hline
20 & game 19 & 1 & 3 & 5 & 1 & 3 & 5 & 5 & 1 & 4 \\
\hline
21 & game 20 & 5 & 4 & 3 & 2 & 5 & 1 &  &  &  \\
\hline
\end{tabular}
\captionsetup{labelformat=empty}
\caption{Fig. 1}
\end{center}
\end{table}
\begin{enumerate}[label=(\roman*)]
\item (A) Write down the numbers in columns H , I and J for game 20 .\\
(B) Use the spreadsheet to estimate the probability of a player winning a game.
\item State how the estimate of probability in (i) (B) could be improved.
\item Give one advantage and one disadvantage of using this simulation technique compared with working out the theoretical probability.

All profit made by the stall is given to charity. Abby has to decide how much to charge players to play.
\item If Abby charges $\pounds 1$ per game, estimate the total profit when 50 players each play the game once.
\end{enumerate}

\hfill \mbox{\textit{OCR MEI Further Statistics B AS  Q1 [9]}}