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:

Tutorial for MS Word: http://www.youtube.com/watch?v=oocieLn6umo

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.