standardising values

[Tara Boyle]

Hello. Perhaps this is a simple maths, problem, but I wonder if this is the right way of standardising this value.

I have different subjects who have values for going up the stairs, coming down the stairs.
The tests were repeated twice

The problem is that there are different values for the no of steps.

I would like to standardise this and obtain values for a total of 13 steps

Simple proprtion would look like
Stairs value = Test1Timegoup
13 = ?

gen stdvalue=(13*Test1Timegoup/Stairs) if Stairs !=13

However, I wonder if this makes sense, or perhaps you can get me insight on another potential solution

* Example generated by -dataex-. For more info, type help dataex
clear
input long Subject double(Staitstotaltime1 Stairstotaltime2) byte Stairs double(Test1Timegoup Test2Timegoup Averagegoingup Test2Timetocomedown Test1Timetocomedown)
  2              29.47              33.68 13 10.86 10.25             10.555 18.07 15.55
  9              31.87              30.78 13  9.55  8.37               8.96  8.25  6.81
 10              30.32              24.65 10  11.6  9.47             10.535 10.82  13.5
 13                  0                  0 10     .     .                  .     .     .
 16              46.98              40.13 10 17.64 17.18              17.41 18.18  20.9
 29              19.18 18.259999999999998 13  8.27  7.59               7.93  8.15  8.27
 44              23.27              23.63 13 11.02 10.65             10.835  8.77  9.07
 54              22.69              22.92 10  9.14  8.34               8.74  8.54  9.44
 57               45.6 41.620000000000005 13 15.41 14.06             14.735 20.87 25.07
 64              20.32              20.14 13  7.77  7.04  7.404999999999999 10.57 10.29
255              11.32               8.48 25  4.67  3.71 4.1899999999999995  3.78  4.97
262              22.42              20.35 13  8.31  8.57  8.440000000000001  9.04  9.32
306              21.27               21.3 13  9.02  9.14               9.08  9.95  9.82
350 19.009999999999998              18.89 13  7.64  8.39              8.015  7.84  8.39
449              20.69                  0 13 10.44     .              10.44     .  6.59
499              46.99                  0 10 15.47     0              7.735     0 28.04
750              15.38               7.99 10  5.02  4.08               4.55  3.33  9.65
822              15.61              14.67 13  7.09  6.59               6.84  6.72  7.16
896              27.72              23.33 10 11.53 10.88             11.205 10.67 14.23
978              28.55 28.560000000000002 13 11.62  9.82 10.719999999999999 13.37 13.05
end

[/CODE]

[George Ford]

g timeperstep1 = Staitstotaltime1/Stairs
g timeperstep2 = Staitstotaltime2/Stairs