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

1. ## 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.)

2. ## 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

3. ## 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.

##### Users Browsing this Thread

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

#### 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