Physics assigment 10

# Physics assigment 10 - Assignment 10 Due Monday April 16...

This preview shows pages 1–2. Sign up to view the full content.

Assignment  10 Due Monday  April 16 and see how to work. On this assignment, we will work with a simulation of a coin toss. If the function =INT(2*(RAND()-1) is inserted into a cell of an Excel spreadsheet, it will simulate the toss of a coin, where 1 means a head, and 0 means a tail. Put this function into the 100 cells from A1 to J10, and look at the results. Does it look roughly like the results of a hundred tosses of a coin? Now, enter the number 1 into any cell outside of the range a1 to J10 and watch what happens to the coin tosses. Enter 1 into any other cell, and watch the results. You will see that any change in the spreadsheet will the program to retoss the coin 100 times. If you want to preserve the 100 coin tosses for future analysis, you have to highlight them, and COPY -> PASTE SPECIAL -> VALUES the block into another location. I know that this is annoying, but it is the only way to preserve the results of a coin toss in you want to. 1 aOnce again, toss the coin 100 times in the same way.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 05/10/2008 for the course PHYS 1202 taught by Professor Stein,p during the Spring '07 term at Cornell University (Engineering School).

### Page1 / 2

Physics assigment 10 - Assignment 10 Due Monday April 16...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online