|
Assignment 08 (Extra credit; not
required)
Overview
The purpose of this assignment is to
determine the number of matches that might be expected between two randomly
generated lists of numbers and letters.
Requirements
- Generate two lists of 300 random
numbers. Determine the number of times that a three digit number from
the first list appears in the second list. Compute the percentage of
matches. Repeat ten times.
- Generate two lists of 300 random
3-digit alpha characters. Determine the number of times that a three
character alpha string from the first list appears in the second list.
Compute the percentage of matches. Repeat ten times.
- Prepare a 2-3 page report summarizes
your findings and conclusions.
Technical notes
- To generate a three digit random
number in Excel: int(rand()*1000)
- To generate a signal alpha (letter)
character in Excel: char(90-25*rand())
- To generate a three character string
from three individual characters: Assume that the individual
characters are represented by A, B, and C. The three character string:
A&B&C. The "&" operator is known as the
concatenation operator.
|