0
I have a database that contains information of consumption per animal and per day. However, the animals entered the experiment on different days. Initially I need to get all animals to start counting the days in experiment from 1. Follows part of the base
Animal Dia Consumo
5 9 2533.96
5 10 2329.06
5 11 2943.79
5 12 3361.62
5 13 2890.82
5 14 2538.98
5 15 2978.81
5 16 3038.76
5 17 3038.76
6 10 2314.82
6 11 2434.75
6 12 2643.99
6 13 2320.58
6 14 2439.56
6 15 2139.6
6 16 2459.54
6 17 2339.59
After this unique numbering for all animals need to calculate the average consumption and standard deviation of all animals each day.
Have you tried anything? What? Put your code here
– lazyFox
Let me get this straight: animal 5 starts the experiment on day 9, animal 6 on day 10. So, does that day become day 1 of the count? If so, in order to calculate the mean and standard deviation, do you want these statistics for day 1 of the counting of each animal, day 2 of the counting, etc.? The average result for day 1 will be then
(2533.96 + 2314.82)/2 == 2424.390
. That’s right?– Rui Barradas
Yeah, that’s right, that’s right
– Luciano Hauschild
I even know how to calculate the average and deviation, I would only need to faer with each animal always start at 1. For example animal 5 would be 1 instead of 9.
– Luciano Hauschild