+ Reply to Thread
Results 1 to 3 of 3

Finding the mean daily time (and st. dev.) per row label

  1. #1
    Registered User
    Join Date
    05-27-2018
    Location
    Philippines
    MS-Off Ver
    Office 365
    Posts
    5

    Finding the mean daily time (and st. dev.) per row label

    I'm taking note of the amount of time I spend studying certain subjects. Each row in the table is one study session and I may have multiple study sessions per day. The Pivot Table sums everything in the column. The mean and st dev are over the number of instances.
    Screenshot.jpg

    Is there a way to calculate the total number of minutes spent per day, mean daily minutes, and daily st dev in one pivot table?
    Screenshot001.jpg

    I've tried making a pivot table with the dates as row labels then changing the grand total but that requires three tables for each subject (one for total, one for mean, and another for st dev). (Manually calculated file attached.)
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Finding the mean daily time (and st. dev.) per row label

    Is this what you mean?

    I have added Minutes to the body of the table in order to display Mean and StdDevp
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-27-2018
    Location
    Philippines
    MS-Off Ver
    Office 365
    Posts
    5

    Re: Finding the mean daily time (and st. dev.) per row label

    The calculations of the Pivot Table seem wrong? What it seems to be doing is getting the average and stdev of the Minutes within the Date. The average should be the total Minutes over the count of Days. and the StDev should be the average (as calculated previously) over the count of Days with the x's being the total Minutes within the Day.

    The Grand Total under the Average and StDev columns are very different if manually calculated using =AVERAGE( and =STDEV.P(. Manually calculated averages are below the Grand Total row.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Search of PT Row label not finding string
    By pbexcel in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 03-16-2020, 12:28 PM
  2. Finding a Daily Average
    By Seaplane Jack in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-11-2013, 02:05 PM
  3. Help with finding the percent completed daily
    By Tanith71 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2013, 12:34 PM
  4. Replies: 7
    Last Post: 07-20-2009, 12:05 AM
  5. Finding the last value in a week from daily data
    By borabora12 in forum Excel General
    Replies: 6
    Last Post: 04-20-2009, 05:53 PM
  6. Finding highest value in a week from daily data
    By borabora12 in forum Excel General
    Replies: 5
    Last Post: 04-20-2009, 04:17 PM
  7. Finding Label/Symbol of Biggest Value in an Array
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2007, 05:51 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