+ Reply to Thread
Results 1 to 5 of 5

Average prices for products throughout time

  1. #1
    Registered User
    Join Date
    07-23-2010
    Location
    NYC, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Average prices for products throughout time

    So I'm looking to work on some historical prices. I have the data set I want to use (categoized by product type and date). My issues is that each product type sells at a different price, various times throughout the day. So I need a way to calculate the average product price per day, so that I can then plot the change in average prices throughout time.

    Is there any simple way to do this? Or will I have to use pivot tables to separate the data set into product and then date (to average the prices).

    any help is much appreciated

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Help with averaging prices for products throughout time

    As you infer - the task sounds ideally suited to a Pivot Table / Chart.

    You can have Product Type and Date fields as a Row Fields with the Price column as Date Field set to AVERAGE.

    Pivots will be far more efficient at handling this data than a multitude of formulae doing the same.

  3. #3
    Registered User
    Join Date
    07-23-2010
    Location
    NYC, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Help with averaging prices for products throughout time

    thank you for your response. I don't folloow the "date fieldm set to averagea" part. how does this work? Any chance you happen to have a worksheet example I can see. thank you so much i reallly appreciate it

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Help with averaging prices for products throughout time

    Hi
    you'll find an explanation at this site which has a nice tutorial on PT's

  5. #5
    Registered User
    Join Date
    07-23-2010
    Location
    NYC, USA
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Average prices for products throughout time

    awesome. thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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