Sticks

2010-Nov-10, 02:58 PM

From the attached image you will see the minimum data I have

The set up is I have a heart rate monitor my sister sent me and one of the things it tells me along with maximum and average heart rate calories burned is how long I have been in "The zone" for a session of "exercise"

Walking home I have two possible routes and after taking some readings going one way wondered if I would be in the zone for a longer period of time as a proportion of the duration it takes going the other way.

At first it seemed that the new route via Corporation Street meant I spent longer in the zone, but a third data point seems to dispute this, so I turned to statistical tools.

I discovered that Excel can give me a T-test figure, and from the attached image I have used this function, assuming the variances are not equal as well as a difference in sample size so this is unpaired.

As my Ho is that the means uPitt St = uCorp St and H1 that the two means are different this is a two tailed test.

Excel gave me a figure therefore for t as t=0.072191936

The problem is, I do not have access at this time to copies of statistical tables, so what does this value of t mean?

Is it saying there is or there is not a difference between the two routes

(If I can I may gather more data later in the week)

The set up is I have a heart rate monitor my sister sent me and one of the things it tells me along with maximum and average heart rate calories burned is how long I have been in "The zone" for a session of "exercise"

Walking home I have two possible routes and after taking some readings going one way wondered if I would be in the zone for a longer period of time as a proportion of the duration it takes going the other way.

At first it seemed that the new route via Corporation Street meant I spent longer in the zone, but a third data point seems to dispute this, so I turned to statistical tools.

I discovered that Excel can give me a T-test figure, and from the attached image I have used this function, assuming the variances are not equal as well as a difference in sample size so this is unpaired.

As my Ho is that the means uPitt St = uCorp St and H1 that the two means are different this is a two tailed test.

Excel gave me a figure therefore for t as t=0.072191936

The problem is, I do not have access at this time to copies of statistical tables, so what does this value of t mean?

Is it saying there is or there is not a difference between the two routes

(If I can I may gather more data later in the week)