Diverge Posted October 30, 2013 Share Posted October 30, 2013 Hi, i hope someone could assist me a bit. Basically i have a list of X amount of items where it's possible to give a negative or positive vote. I would like to calculate a daily average value, like a 0-10s scale but i just can't figure out a good solution for it. Like 10 items 50 positive votes 30 negative votes Any help appreciated. Link to comment https://forums.phpfreaks.com/topic/283437-annoying-math-issue/ Share on other sites More sharing options...
mac_gyver Posted October 30, 2013 Share Posted October 30, 2013 you need to store each vote separately with its date/time so that you will have the data you need to determine which votes occurred in any 24 hour period. getting the average for any date/time period would then be trivial as you can do this directly in the database query statement using an AVG() function. Link to comment https://forums.phpfreaks.com/topic/283437-annoying-math-issue/#findComment-1456205 Share on other sites More sharing options...
Diverge Posted October 30, 2013 Author Share Posted October 30, 2013 Thanks. The amount is not an issues, i have all the daily votes ready. It's the math part i can't get a grip on. Needless to say, math isn't my strong side. Link to comment https://forums.phpfreaks.com/topic/283437-annoying-math-issue/#findComment-1456217 Share on other sites More sharing options...
mentalist Posted October 31, 2013 Share Posted October 31, 2013 As said AVG will do it for you, however the maths is to add all the values together and then divide by how many values there were. Here's a page on the three main types of average, the one you probably want is mean. http://www.purplemath.com/modules/meanmode.htm Link to comment https://forums.phpfreaks.com/topic/283437-annoying-math-issue/#findComment-1456313 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.