Solved

How to Show Standard Error in Excel Pivot Table

Posted on 2014-04-22
3
1,110 Views
Last Modified: 2014-04-30
Excel can show standard deviation in pivot tables. Is there any way to show a standard error ? Or to add a custom formula to do so, which would be SD/sqrt(N)
0
Comment
Question by:datastarstar
  • 2
3 Comments
 
LVL 48

Expert Comment

by:Rgonzo1971
ID: 40015002
Hi,

Could you send a dummy sample?

Regards
0
 

Accepted Solution

by:
datastarstar earned 0 total points
ID: 40023248
After considerable research on my own, I do not believe there is a way to do this on a pivot table, so found a manual workaround that gave me what I needed. Closing the question with no solution.
0
 

Author Closing Comment

by:datastarstar
ID: 40031569
No other solution found.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
This article seeks to propel the full implementation of geothermal power plants in Mexico as a renewable energy source.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now