Forums › ProRealTime English forum › ProBuilder support › trying to code a formula into › Reply To: trying to code a formula into
Hello i’m sorry to tell you that code didn’t work it did print the three ranges but they all have the same number and the number is 195.7 I also looked at the Look Back of 10 ranges and manually did the equation and I didn’t get anywhere near that number and I also shifted the 10 ranges back one more just a double check has the way that I did the equations and the output of those equations
They also is a screenshot if you look at the bottom right that’s this code that you’ve helped me with top right is my previous code we’ve standard deviations not this more complex but better equation
360.8 123.6 304.3 290.7 503.7 91.8 211.6 157.2 528.9 195.7
Overall Average
\frac{360.8 + 123.6 + 304.3 + 290.7 + 503.7 + 91.8 + 211.6 + 157.2 + 528.9 + 195.7}{10} ]
Summing the values: [ 360.8 + 123.6 + 304.3 + 290.7 + 503.7 + 91.8 + 211.6 + 157.2 + 528.9 + 195.7 = 2768.3 ]
Dividing by 10: [ 2768.3 \div 10 = 276.83 ]
So, overall average = 276.83.
– Overall Average: 276.83
– Low Average: 155.98
– High Average: 397.68
Low Average
Numbers: 91.8, 123.6, 157.2, 195.7, 211.6 [ \frac{91.8 + 123.6 + 157.2 + 195.7 + 211.6}{5} ]
Summing: [ 91.8 + 123.6 + 157.2 + 195.7 + 211.6 = 779.9 ]
Dividing by 5: [ 779.9 \div 5 = 155.98 ]
High Average
Numbers: 290.7, 304.3, 360.8, 503.7, 528.9 [ \frac{290.7 + 304.3 + 360.8 + 503.7 + 528.9}{5} ]
Summing: [ 290.7 + 304.3 + 360.8 + 503.7 + 528.9 = 1988.4 ]
Dividing by 5: [ 1988.4 \div 5 = 397.68 ]
Sorting the Numbers
Sorted list: 91.8, 123.6, 157.2, 181.2, 211.6, 290.7, 304.3, 360.8, 503.7, 528.9
Low Average
Numbers: 91.8, 123.6, 157.2, 181.2, 211.6 [ \frac{91.8 + 123.6 + 157.2 + 181.2 + 211.6}{5} ]
Summing: [ 91.8 + 123.6 + 157.2 + 181.2 + 211.6 = 765.4 ]
Dividing by 5: [ 765.4 \div 5 = 153.08 ]
So, low average = 153.08.
High Average
Numbers: 290.7, 304.3, 360.8, 503.7, 528.9 [ \frac{290.7 + 304.3 + 360.8 + 503.7 + 528.9}{5} ]
Summing: [ 290.7 + 304.3 + 360.8 + 503.7 + 528.9 = 1988.4 ]
Dividing by 5: [ 1988.4 \div 5 = 397.68 ]
So, high average = 397.68.