Closed Thread
Results 1 to 4 of 4

Average for multiple columns of data

  1. #1
    Registered User
    Join Date
    11-16-2014
    Location
    London, England
    MS-Off Ver
    Office Mac 2011
    Posts
    4

    Average for multiple columns of data

    Hi,

    I am looking to calculate the averages for data that looks like this:
    Method Problem size Nodes expanded
    BFS 1 6
    BFS 1 6
    BFS 1 10
    BFS 1 10
    BFS 2 21
    BFS 2 39
    DFS 1 146855
    DFS 1 148596
    DFS 1 1191255
    DFS 2 12
    DFS 2 14

    I have allot of data and am unsure of the best way to do this. Was wondering if any body knew of any easy way to do this, thanks.

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Average for multiple columns of data

    you're going to have to be a bit more specific, do you want averages of each method? average of each column or the average across all the numbers together?

  3. #3
    Registered User
    Join Date
    11-16-2014
    Location
    London, England
    MS-Off Ver
    Office Mac 2011
    Posts
    4

    Re: Average for multiple columns of data

    Sorry, i'm looking for average nodes expanded for each problem size, for each search method so the final output would be say:

    BFS
    Problem Size Average Nodes Expanded
    1 7
    2 30

    thanks for your help.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,897

    Re: Average for multiple columns of data

    Since you have posted in the Commercial Services Forum, I have closed this thread.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Average of Multiple Columns from multiple Pivot Tables
    By element32d in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-01-2013, 11:08 AM
  2. [SOLVED] Sum Multiple Columns and Average Sum of Multiple Rows
    By mcrxb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2013, 08:45 AM
  3. Average GP from multiple columns with criteria
    By t+ccyco in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-30-2013, 07:06 PM
  4. Replies: 3
    Last Post: 01-04-2012, 01:39 AM
  5. Average columns across multiple sheets
    By Stayfair in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2011, 09:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1