sequence of observations.

In this exercise you will perform additional analysis of your data. This analysis can be done easily enough using a spreadsheet, but one of the purposes of

this lab is to introduce you to a rudimentary analysis program designed to perform certain very common operations on certain common types of data.

In this exercise you will also learn more about the normal distribution and its application to experimental data.

The average time reported to complete this experiment is about 2 hours, with times pretty evenly distributed between 1 and 3 hours. A few students report

under 1 hour, and a few report over 3 hours.

The data program should save you several hours in analyzing some of the subsequent labs.

The program can be obtained by clicking on the link data program. In case this link doesn't work the program is located at

http://www.vhcc.edu/dsmith/genInfo/labrynth_created_fall_05/levl1_15\levl2_51/dataProgram.exe

or can be access by going to the Access Site using a path similar to the one used to access your site:

http://www.vhcc.edu/dsmith > General Information > (scroll to bottom of page and click on Access Your Information) then when the first menu comes up clicking

on 15, then when the new menu appears on 51, then when the third menu appears on Data Program, which will be near the top of the page.

Analyze 30-interval data

In the space below include a copy of your data from the Error Analysis I experiment. Then state the mean of your 30 time intervals, the mean and standard

deviation of your sample of 6 intervals, and whether the difference of the means is less tha the standard deviation of your sample divided by sqrt(6).

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

data from Error Analysis I:

3 19577.64 1.007813

4 19578.59 .9453125

5 19579.67 1.085938

6 19580.77 1.101563

7 19581.91 1.140625

8 19582.97 1.054688

9 19583.96 .9921875

10 19585.09 1.132813

11 19586.15 1.054688

12 19587.23 1.078125

13 19588.3 1.070313

14 19589.35 1.054688

15 19590.41 1.054688

16 19591.48 1.070313

17 19592.55 1.078125

18 19593.63 1.070313

19 19594.7 1.070313

20 19595.73 1.039063

21 19596.82 1.085938

22 19597.88 1.054688

23 19598.92 1.046875

24 19600.02 1.101563

25 19601.06 1.039063

26 19602.15 1.085938

27 19603.24 1.09375

28 19604.28 1.039063

29 19605.34 1.054688

30 19606.41 1.070313

31 19607.51 1.101563

32 19608.59 1.078125

mean: 1.03

mean of 6 sample: 1.07

standard deviation: .0346

Is not less than.

#$&*

You may download the data program or run it directly from the site. Note the following:

The program is in an ongoing process of development and some of the buttons might not work. However the operations you are instructed to perform below have

been tested and do work.

When you run the program you might encounter some message boxes at the beginning; these boxes have been inserted to prompt the inclusion of some additional

features in the program. If you do encounter these message, you may safely just click through them messages until just the form appears.

The program is easy to use and is very efficient for its purpose. Additional features will be added as needed.

Run the program and click through any extraneous messages. (If necessary you might need to click on the maximize button to maximize the size of the form and

make all the buttons visible, but this should not be an issue.)

Delete all information in the textbox (you can use the Clear button near the lower right corner of the box), and copy your TIMER data into the box. You may

use either the data you have retained from the TIMER program or the data as posted on your access page (data should be posted if you submitted the program in

a timely fashion).

Your data will be in 3 columns. Manually delete all the information except the 30 time intervals, so there are 30 lines each with a single number in the

textbox, the number representing the time interval in seconds (if your original data is in a spreadsheet you could just copy the single column corresponding

to the time intervals).

Copy and paste these 30 lines into a separate text editor or word-processing program so you can use them again later.

Click on the Mean and Standard Deviation button. A message box will appear asking you to confirm that your data is entered in the necessary format. Then

the program will very quickly display the mean and standard deviation of that distribution.

What are the mean and standard deviation of your 30 time intervals, as reported by the program? Report

below, using two tab-delimited numbers in the first line. Starting in the next line give a brief explanation of what your numbers mean and how you obtained

them. After that explanation, include a copy of your data set for reference.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

mean of 30 intervals: 1.065 standard deviation:0.03786

how obtained:copied my data into data program, deleted unneccessary informaion and then clicked mean and standard deviation button

#$&*

Investigate 'first differences' of 30-interval data

Now restore your original 30 time intervals to the box. You will have to do this manually, clearing the contents of the box and then copying and pasting the

data from the text editor or word processor where you stored it before. Make sure your data also stays in that location, because you'll need it at least once

again.

Click on the First Difference button. You will see a report of the differences between your successive time intervals.

Give the first three differences

below, in the first line in comma-delimited format.

Starting at the second line answer the two questions:

Are all the differences between your time intervals all different, or do some occur more than once?

Where have you see this information before and what does it mean?

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

first three differences of clock times:-.06250,.1406,.01563

are differences all the same: no

where seen before:some appear more than once

#$&*

Sum your 30 time intervals and speculate on meaning

Restore your original 30 intervals to the box. Click on the Running Sum button.

Scroll down and take a quick look at the entire report.

Give your first three running sums

below, in the first line in comma-delimited format.

Starting at the second line, explain how you think these numbers were calculated from the time intervals, and what these numbers might mean.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

running sum of intervals, first three sums:1.008,1.953,3.039

explanation of how running sums were obtained:it adds each number to the previous sum and tells the new sum

#$&*

Analyze the first difference of the running sums, and the first difference of this result

Delete everything but the single-column report of the running sums, so the data box contains just the running sums with one sum on each line, and click on

the 'first difference' button.

Report your first three new numbers

below, in the first line in comma-delimited format.

Describe what you see and what might be the meaning of the new numbers.

Suggestion: look at your original 30 time intervals.

How do you think the new numbers were calculated, where have you seen them before, and why do they come out the way they do?

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

first difference of running sums, first three numbers:1.008,.945,1.086

description and meaning:this shows the difference in the running sums

explanation of how numbers were calculated:takes the first sum subtracts from the second and tells the difference. Continues all through the list

#$&*

Again isolate only the single-column report and again click on First Differences.

Report your first three new numbers

below, in the first line in comma-delimited format.

How do you think the new numbers were calculated, where have you seen them before, and why do they come out the way they do?

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

first three numbers from first difference:.063,.141,.016

how calculated: using data program, it subtracts 1st from 2nd and displays sum. continues through list

#$&*

Find difference quotients for a new set of data and speculate on the meaning of the difference quotient

Clear the box then copy the following 4 lines into the textbox:

0, 0

10,10

20,25

30,45

Click on the Difference Quotient button.

Report

below the three new numbers you see, reporting your numbers in the first line in comma-delimited format.

In the second line speculate on how the program might have calculated these numbers.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

difference quotient from sample data:

how you think the results were calculated:

#$&*

The information in the table

0, 0

10,10

20,25

30,45

represents the position of an object rolling down an incline vs. clock time, with position in meters and clock time in seconds. Recall that according to our

'y vs. x' convention, in a position vs. clock time table the clock time is in the first column.

How far did the object travel in the first time interval? How much time elapsed while it traveled through this distance? What therefore was its average speed

during this time interval? Report your numerical answers to these three questions in the first line below, in comma-delimited format.

Answer the same questions for the second time interval, and report in the second line, using the same format as in the first.

Answer the same questions for the third time interval, and report in the third line, using the same format as in the first.

Starting in the fourth line, explain how you obtained your results.

Then explain once more what the 'difference quotient' operation does to two columns of numbers.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

distance during first interval: 10 elapsed time while traveling this distance: 10 average speed during interval:1

distance during second interval: 15 elapsed time while traveling this distance: 10 average speed during interval:1.5

distance during third interval: 20 elapsed time while traveling this distance: 10 average speed during interval:2

explanation: shows distance between intervals, time elapsed during intervals, and average speed.

explanation of 'difference quotient' operation: takes information in correct format and displays the difference quotients in a single column.

#$&*

Select and analyze 5 random intervals from 30-interval data, using the data program to find mean and standard deviation

Using a coin according to the following instructions, you will now select 5 intervals randomly from your 3-interval data. You will do this by generating 5

numbers corresponding to the numbers of your data point. The process should take only a couple of minutes:

Using the coin you will generate a series of numbers between 0 and 31. Note that there are 32 numbers between 0 and 31. This process can generate 32 possible

numbers.

If you generate a number you have generated before you will discard it and generate an alternative.

If you generate a number that does not correspond to one of your intervals (probably 1-20 or 1-19) you will discard that number.

You will continue until you have generated 5 numbers that haven't been discarded.

To generate each number will require 5 flips of your coin. You will write down 5 numbers.

Your first flip is worth 1. Flip the coin. If you get Heads write down the number 1. If you get tails write down 0. Whichever number you write down will be

at the top of a column.

Your second flip is worth 2. Flip the coin a second time. If you get Heads write down the number 2. If you get tails write down 0. This number does in the

column below the previous.

The third, fourth, and fifth flips are respectively worth 4, 8 and 16 on Heads, 0 if you get Tails.

You should now have five numbers in your column. Add them up.

The result will be not less than 0 + 0 + 0 + 0 + 0 and not more than 1 + 2 + 4 + 8 + 16 = 31.

Go ahead and generate your first number according to these instructions. If the number is between 1 and the number of intervals you observed (e.g., between 1

and 30, or between 1 and 29), circle the number.

Now generate another number, using the same procedure with 5 flips of the coin. If this number is between 1 and your number of intervals (e.g., between 1 and

30), and if it does not duplicate the first number you generated, circle it.

Continue this process, generating totals between 0 and 31 and circling those that lie in the correct range and do not duplicate any your previous numbers.

Stop when you have generated 5 distinct numbers within the appropriate range.

Now select the time intervals corresponding to the numbers you have generated (e.g., if you had a 30-interval set and your numbers were 23, 8, 11, 19, 5 and

22 you would select the 23d, 8th, 11th, 19th, 5th and 22d time intervals).

Clear, then put these 5 time intervals into the textbox. Note that you will put time intervals into the textbox, not the numbers you have generated between

0 and 31.

Click on the Mean and Standard Deviation button.

In the first line below, report the five random numbers you generated, in comma delimited format.

In the second line below, report the five time intervals you put into the box, in comma delimited format.

In the third line, report the mean and the standard deviation in comma-delimited format.

Starting in the fourth line give a brief explanation of what your numbers mean and they were obtained. Optional comments may be added.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

your five random numbers:7,13,16,20,24

your five intervals:.9921875,1.054688,1.070313,1.054688,1.085938

mean and standard deviation:1.052,0.03563

explanation: followed directions and listed values

#$&*

In three lines report the following numbers:

By how much does the mean of your 5-interval sample differ from the mean of the entire data set of 30 intervals?

What is the standard deviation of the 30-interval set?

What is the first number you reported as a percent of the second. That is, what is the difference between your sample and the entire data set, as a percent

of the standard deviation of the data set?

Starting in the fourth line give a brief explanation of what your numbers mean and how you obtained them

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

difference of means:.02

standard deviation of 30-interval set:.0346

first number as percent of second:58 percent

explanation and meanings: this random sample is more accurate

#$&*

Analyze a set of 'made-up' time intervals and look at their distribution

The set of numbers given below represents a set of 30 'made-up' quick-click time intervals. You will answer a few questions about this data set, including

the mean and standard deviation of a 5-interval random sample. Later the results of all students will be compiled and used to demonstrate the 'sample

standard deviation', which is an important statistical characteristic of sample and very relevant to interpretation of experimental results.

.1752

.172

.1979

.1991

.176

.1711

.1664

.1665

.1858

.1764

.1765

.1885

.173

.1853

.1683

.1674

.1833

.1632

.1783

.1962

.1704

.1914

.1751

.1715

.1967

.1852

.1851

.1771

.1639

.1824

.1877

Copy these numbers into a cleared textbox, click on Mean and Standard Deviation, and report their mean and standard deviation in comma-delimited format in

the first line below. Starting in the next line give a brief explanation of what your numbers mean and how you obtained them.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

mean and standard deviation of given data: There are 31 numbers listed above not 30. However, based on the 31 sample the mean is .1791, .01025

explanation and meanings: the average is .1791 and the standard dev. is .01025

#$&*

below, enter the following numbers, one to a line, in the given order:

The number which is two standard deviations less than the mean.

The number which is one standard deviation less than the mean.

The number which is equal to the mean.

The number which is one standard deviation more than the mean.

The number which is two standard deviations more than the mean.

Starting in the next line give a brief explanation of what your numbers mean and how you obtained them

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

two standard deviations less than the mean:.1586

one standard deviation less than the mean: .1689

the mean:.1791

one standard deviation more than the mean:.1894

two standard deviations more than the mean:.1997

explanation and meanings:setting up marks for a bell curve.

#$&*

below, report each of the following numbers, one number to each line:

The number of the given time intervals which are less than the number which is two standard deviations less than the mean:

The number of the given time intervals which lie between two standard deviations less than the mean and one standard deviation less than the mean:

The number of the given time intervals which lie between one standard deviation less than the mean and the mean:

The number of the given time intervals which lie between the mean and one standard deviation more than the mean:

The number of the given time intervals which lie between one standard deviation more than the mean and two standard deviations more than the mean:

The number of the given time intervals which are greater than the number which is two standard deviations more than the mean:

Starting in the 7th line give a brief explanation of what your numbers mean and how you obtained them; as usual you may include optional comments:

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

number of given intervals which are less than the number which is two standard deviations less than the mean:0

number of given intervals which are between two standard deviations less than the mean and one standard deviation less than the mean:6

number of given intervals which are between one standard deviation less than the mean and the mean:12

number of given intervals which are between the mean and one standard deviation more than the mean:8

number of given intervals which are between one standard deviation more than the mean and two standard deviations more than the mean:5

number of given intervals which are greater than the number which is two standard deviations more than the mean:0

explanation and comments:counted how many fall in each standard deviation

#$&*

below, report each of the numbers you reported above, but expressed as a percent of the 30 intervals (rounded to the nearest percent). For example, the

number 10 would be 33% of 30. Include a brief explanation of what your numbers mean and how you obtained them

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

percent of given intervals which are less than the number which is two standard deviations less than the mean:0

percent of given intervals which are between two standard deviations less than the mean and one standard deviation less than the mean:19

percent of given intervals which are between one standard deviation less than the mean and the mean:39

percent of given intervals which are between the mean and one standard deviation more than the mean:26

percent of given intervals which are between one standard deviation more than the mean and two standard deviations more than the mean:16

percent of given intervals which are greater than the number which is two standard deviations more than the mean:0

explanation and comments:took each answer from previous question and divided by 31

#$&*

Perform a similar analysis with your 30-interval data

Return to your own 30 time intervals. Count the numbers in each range (less than mean - 2 std dev, between mean - 2 std dev and mean - 1 std dev, between

mean - 1 std dev and mean, etc.), using the mean and standard deviation of that data set.

Report each number as a percent of your total number of intervals, one number in each of the first six lines below. Starting in the 7th line give a brief

explanation of what your numbers mean and how you obtained them

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

number and percent of given intervals which are less than the number which is two standard deviations less than the mean:1,3

number and percent of given intervals which are between two standard deviations less than the mean and one standard deviation less than the mean:3,10

number and percent of given intervals which are between one standard deviation less than the mean and the mean:13,43

number and percent of given intervals which are between the mean and one standard deviation more than the mean:8,27

number and percent of given intervals which are between one standard deviation more than the mean and two standard deviations more than the mean:1,3

number and percent of given intervals which are greater than the number which is two standard deviations more than the mean:1,3

explanation and comments:some of my numbers fell directly on the cutoff points

#$&*

In a standard 'normal' distribution, we expect that the respective percents in the six ranges will be about 2%, 14%, 34%, 34%, 14% and 2%. In a very large

sample of data (say, at least tens of thousands of data points), if the data are in fact distributed normally, we expect actual results to very nearly

reflect this distribution. If a large distribution does not closely match the expected results, we suspect that something in the system or in our observation

process in fact deviates from the 'standard normal' expectation. Not everything we observe does in fact follow the standard normal pattern. You 3-interval

results might or might not be expected to follow a standard normal distribution.

If the data sample is not very large, the chance fluctuations in the distribution could have a significant effect on the percents, which in that case may not

be all that close to the expected distribution. However in a medium-sized sample of 30 or so, we definitely expect more observations to lie in the middle two

ranges and in either of the outer ranges, and we aren't too surprised if no results at all appear in the outermost ranges (more than 2 standard deviations

from the mean).

Based on the percents you reported and the percents quoted above, by how much would you say your actual 30-interval results deviated from the standard normal

distribution? Did your results deviate enough to make you suspect that your clicks were not normally distributed about their mean?

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

the majority of my information falls between 1 standard dev. below the mean and the mean. My curve won't exactly fit a normal distribution.

#$&*

Answer the same question for the 30 made-up time intervals given earlier.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

I think the made up one fits the bell curve better.

#$&*

Compare your distribution with the standard normal distribution

We will in a subsequent exercise learn to sketch a standard normal curve, and to represent our information using this sketch.

For the present, simply copy this figure below and label it as indicated below:

There are five vertical lines on the graph, representing respectively

mean - 2 * std dev, also labeled z = -2

mean - 1 * std dev, also labeled z = -1

mean - std dev, also labeled z = 0

mean + 1 * std dev, also labeled z = 1

mean + 2 * std dev, also labeled z = 2.

Label the x axis with the z numbers -2, -1, 0, 1 and 2.

Below these labels, place the respective numbers you obtained earlier for your 30-interval results, the numbers corresponding to mean - 2 * std dev, mean - 1

* std dev, etc..

The five lines divide the region between the curve and the x axis into six smaller regions. Each of these regions will include either 2%, 14% or 34% of the

total area between the curve and the x axis.

Within each region, write your best estimate of the number that represents its area as a percent of the total.

below:

Indicate in the first line in comma-delimited format the numbers you placed in the regions, from left to right.

Indicate in the second line the x-axis labels corresponding to z = -2, -1, 0, 1 and 2 for the mean and standard deviation you obtained for your data.

Starting in the third line give a brief explanation of what your numbers mean and how you obtained them.

your response &&&&&&&&&&&&&&&&&&

(start in the next line):

numbers representing percents in each of six regions: 2,14,34,34,14,2 suppose to be. mine is 3,10,43,27,3,3

x-axis labels for your data:1.01,1.04,1.07,1.10,1.13

explanation: mine are incorrect, the bell curve percentages are suppose to add up to 100percent.

#$&*

*#&!

&#This looks good. Let me know if you have any questions. &#