statistics

Lab Report – What to hand in? When to hand in? How to hand in?

Excel portion (ONLY FOR PART I): In an email with subject titled MATH 10 LAB 2 report by YOUR NAME,
attach a copy of your Excel Workbook. This workbook should contain the 2 simulations (one for n = 50 and one
for n = 1000), the 2 number count summaries of the possible sums, and the 2 histogram you created for the
possible  sums  for  the  simulations  by  using  appropriate  Excel  commands.  This  email  should  be  sent  to  me
BEFORE 1:30 PM on the due date. Late submission will be penalized (see syllabus for late submission policy).
I go by the time stamp in my inbox. Make sure you allow enough time for your mail server to send the email
and  my  mail  server  to  receive  it.  Name  your  workbook  using  your  name: LASTNAME_FIRSTNAME_LAB2.
For example: Wong_Winnie_LAB2.

Written portion (PART I AND II): You will then hand in the written portion of the Lab report at the beginning of
lecture on the due date. When you write your Lab report, I expect you to use complete sentences with correct
grammar.  You  should  articulate  your  thoughts  in  a  clear  and  logical  manner. Your written  report  should  be
typed using MS Word.

Here are some videos you might like to use as reference:

How to create a table in MS Word: http://www.youtube.com/watch?v=2y-HY10SBPQ
How to install data analysis toolpak: http://www.youtube.com/watch?v=_yNxLFagKgw
How to copy tables and graph from Excel to Word: http://www.youtube.com/watch?v=9WVUz3P1Pfw
How to create a histogram with excel: http://www.youtube.com/watch?v=xe2Q6z6PTqk

A FEW WORDS ABOUT MY EXPECTATIONS ON YOUR MS WORD WRITE UP.
?  EVERYTHING SHOULD BE TYPED. DO NOT USE PEN OR PENCIL.
?  MAKE SURE YOU CLEARLY IDENTIFY THE LAB AND INCLUDE YOUR NAME.
?  COPY AND PASTE THE QUESTION ONTO YOUR DOCUMENT. YOUR ANSWER SHOULD BE RIGHT BELOW EACH QUESTION.
?  USE COMPLETE SENTENCES AND PERFORM SPELL CHECK AND REMOVE ALL TYPOS.
?  PLEASE WORK INDIVDUALLY. EVEN IF YOU DISCUSS HOW TO DO THE LAB WITH A CLASSMATE, I STILL EXPECT YOU TO WRITE
YOUR OWN LAB. IF YOU LET SOMEONE COPY YOUR LAB, YOU AND THE ONE(S) WHO COPIED IT WILL ALL RECEIVE A SCORE OF
ZERO FOR THE LAB.
Dr. Wong   Math 10 – Lab 2  Page 2 of 4
LAB #2

PART 1- ROLLING A PAIR OF FAIR DICE WITH MS EXCEL

IN THIS PART YOU WILL LEARN HOW TO:
1.  SIMULATE THE RESULT OF ROLLING A PAIR OF FAIR DICE WITH MS EXCEL
2.  CHART THE POSSIBLE SUMS
3.  CREATE A HISTOGRAM WITH THE POSSIBLE SUMS
4.  ANALYZE WHAT HAPPENS WHEN THE NUMBER OF ROLL INCREASES

WHAT TO HAND IN FOR WRITTEN PART:  IN A MICROSOFT WORD DOCUMENT, ANSWER THE FOLLOWING QUESTIONS:

1.  Let x = the sum of a pair of dice being rolled.
Construct a table that displays the probability distribution of X (Watch video: HOW TO CONSTRUCT A TABLE IN MS
WORDS). REFER TO THE LECTURE NOTES IN CHAPTER 4.1.
x  2  3  4  5  6  7  8  9  10  11  12
P(x)

2.  Use Excel to simulate rolling a pair of fair dice 50 times and record the sum.  Then, create a table of the relative
frequencies as well as a histogram in MS Excel (See A and B). Cut and paste the histogram to your MS Word
document.
3.  Use Excel to simulate rolling a pair of fair dice 1000 times and record the sum.  Then, create a table of the relative
frequencies as well as a histogram in MS Excel (See A and B). Cut and paste the histogram to your MS Word
document.
4.  Which simulation better corresponds to the true probabilities?  Be specific in your analysis. Explain your reasoning.
5.  Should you have expected to see the results that you did indeed see?  Why should you have expected such results?

PART 2  – REVIEW OF GRAPHS

On the internet or from any reading materials, search for a graph that is used in an article. Be sure it is a type of graph
that we have studied in class. You can use graph from a newspaper, journal, magazine, official publication or the internet.
Include a copy of the graph with this lab.  If the article is short (everything can be fit into one page), include the article as
well as the graph. Answer the following questions. Your written report should be typed using MS Word.

1.  From where did you get the graph?  What was the name of the article from which the graph was taken and from what
source was the article taken?  Be specific and include a date of the publication, if relevant.
2.  What type of graph is displayed?
3.  Clearly explain what the graph is telling you in the context of the article.
4.    Do you think the graph was effective in conveying the information? Explain.

Dr. Wong   Math 10 – Lab 2  Page 3 of 4
A.  HOW TO SIMULATE ROLLING A PAIR OF DICE AND RECORDING THE SUM USING EXCEL:

1.  Open Microsoft Excel.
2.  Input the numbers 1, 2, 3, 4, 5, and 6 in the first six cells of column 1.
3.  Input the numbers 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, and 12 in column 2.
4.  Simulate the roll of the first die:  In the Data menu, click on Data Analysis.
?  Scroll down and select Sampling.  Click OK.
?  Fill out the window using the following values then click OK:

Column D will then be populated with simulated roll of the first die.

5.  Repeat step 4 above, however, Change the Output Range to E1.
6.  Click in cell F1 and type the following:  “=SUM(D1:E1)” then press ENTER.
7.  Click in cell F1 again and select Home -> COPY.
8.  Put the mouse arrow over cell F2 and drag down so that column F is highlighted all the way down to row 50.
9.  Once all 50 cells are selected in column F, select Home -> PASTE.
10.  Column F is now populated with the simulated sum of the 50 rolls of the two dice.

B.  HOW TO COUNT UP (SUMMARIZE IN A TABLE) THE SUMS GENERATED BY THE SIMULATION USING EXCEL:

1.  In the Data menu, click on Data Analysis
?  Scroll down and select Histogram.  click OK.
?  Fill out the window with the following values and boxes checked and click OK:

This number means
you are simulating
rolling the pair of dice
50 times.
This is the location of
the cell where the
summary table will be
pasted.
Dr. Wong   Math 10 – Lab 2  Page 4 of 4
?  You will then see a table summarizing the frequency of each possible sum (everyone’s values will be different).
You should ignore the row in the table labeled “More”.
?  IMPORTANT:  convert these frequencies to relative frequencies by dividing each frequency by the total number
of simulated rolls.
?  Create a table in your Word document of the relative frequencies by filling in the blanks of a table like the one
below before continuing! Use these values to compare to the true probabilities.

Number of Simulated Rolls = ________ (fill in the blank with either 50 or 1000 depending on the simulation)

x  2  3  4  5  6  7  8  9  10  11  12
Relative
Frequency

C.  REPEAT STEPS A AND B ABOVE, HOWEVER, INCREASE NUMBER OF SIMULATED ROLLS FROM 50 TO 1000.
You will need to make the following changes to the process above:

Step A4:          Step B1:

Change to
1000.
Change to
1000.
Change to
K1.