JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 558
- Office Version
- 365
- Platform
- Windows
Hi All,
May I say thanks for all of your help up front. The knowledge base in this forum is astounding.
Anyway, I have an issue that I don't know how to solve.
I have data set, that is generated externally. It looks like this:
I would like to run a linear regression, using Weight as the x axis and Speed as the y axis. No problem there if I do it one by one.
The problem is that sometimes, there are 2 data sets and other times there are 3 data sets per horse. I can not control that part of the input.
Because the data sets vary between 2 and 3 on a horse by horse basis, I have no idea how to code for the variation.
I have tried transposing the data so that everything was all on the same line, but it wasn't long before the data was in the wrong equation.
Is this something that would be better handled via VBA to transpose the data, where it could be programmed to always have 3 data sets?
Any suggestions would be exceptionally appreciated.
Regards
Jeff
May I say thanks for all of your help up front. The knowledge base in this forum is astounding.
Anyway, I have an issue that I don't know how to solve.
I have data set, that is generated externally. It looks like this:
Horse | Distance (m) | Weight (kg) | Time (min) | Time (s) | Speed (m/s) |
Blow Dart | 1000 | 57 | 00:56.77 | 56.77 | 17.61493747 |
Blow Dart | 1000 | 56 | 00:56.79 | 56.79 | 17.61 |
Blow Dart | 900 | - | 00:54.29 | 54.29 | 16.58 |
Hard To Excel | 1100 | 57 | 01:04.80 | 64.80 | 16.98 |
Hard To Excel | 1100 | 56 | 01:03.60 | 63.60 | 17.30 |
The Sherpa | 850 | - | 00:51.97 | 51.97 | 16.36 |
The Sherpa | 900 | - | 00:54.80 | 54.80 | 16.42 |
Aero Nautica | 1100 | 57 | 01:04.80 | 64.80 | 16.98 |
Aero Nautica | 1000 | - | 01:01.20 | 61.20 | 16.34 |
Diggers Reach | 1000 | 54 | 00:57.27 | 57.27 | 17.46 |
Diggers Reach | 1000 | - | 01:02.80 | 62.80 | 15.92 |
Molecular | 1000 | 55 | 00:56.77 | 56.77 | 17.61 |
Molecular | 900 | - | 00:55.29 | 55.29 | 16.28 |
One Penny | 1000 | 55 | 00:56.77 | 56.77 | 17.61 |
One Penny | 1000 | - | 00:59.26 | 59.26 | 16.87 |
Sebrini | 800 | - | 00:51.10 | 51.10 | 15.66 |
Sebrini | 800 | - | 00:50.42 | 50.42 | 15.87 |
Sebrini | 800 | - | 00:50.83 | 50.83 | 15.74 |
Secia | 1100 | 54 | 01:05.26 | 65.26 | 16.86 |
Secia | 1100 | 55 | 01:05.85 | 65.85 | 16.70 |
Secia | 900 | 55 | 00:52.33 | 52.33 | 17.20 |
Shemakesastatement | 800 | - | 00:49.79 | 49.79 | 16.07 |
Shemakesastatement | 800 | - | 00:50.52 | 50.52 | 15.84 |
Shemakesastatement | 800 | - | 00:50.76 | 50.76 | 15.76 |
I would like to run a linear regression, using Weight as the x axis and Speed as the y axis. No problem there if I do it one by one.
The problem is that sometimes, there are 2 data sets and other times there are 3 data sets per horse. I can not control that part of the input.
Because the data sets vary between 2 and 3 on a horse by horse basis, I have no idea how to code for the variation.
I have tried transposing the data so that everything was all on the same line, but it wasn't long before the data was in the wrong equation.
Is this something that would be better handled via VBA to transpose the data, where it could be programmed to always have 3 data sets?
Any suggestions would be exceptionally appreciated.
Regards
Jeff