Results 1 to 4 of 4

Thread: Calculating an average

  1. Jun 25th, 2008, 11:28 PM #1
    308holes
    308holes is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2002
    Location
    USA
    Posts
    432

    Calculating an average

    little help I have 5,5 star ratings A-E I need to calculate the average of them for display in another rating and unsure how to do this.
    A = 2 votes value = 7
    B = 1 votes value = 3
    C = 2 votes value = 7
    D = 1 votes value = 3
    E = 1 votes value = 1
    Reply With Quote Reply With Quote
  2. Jun 26th, 2008, 12:19 AM #2
    penagate
    penagate is offline
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: Calculating an average

    How are they stored?
    Reply With Quote Reply With Quote
  3. Jun 26th, 2008, 12:26 AM #3
    308holes
    308holes is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Feb 2002
    Location
    USA
    Posts
    432

    Re: Calculating an average

    they are stored in mysql I know how to fetch them just need to know how to calculate the equation

    A['total_votes'] (2), A['total_value'] (7)
    B ...
    C....
    D...
    Reply With Quote Reply With Quote
  4. Jun 26th, 2008, 02:22 AM #4
    penagate
    penagate is offline
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: Calculating an average

    Isn't it just total value divided by total votes? Or am I missing something?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width