This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
how to calcuate x bar , standard deviation using excel , could u pls post steps
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
By x-bar I assume you mean average (also called mean)
For std, I have used the function for a sample as opposed to a population
best wishes
Hi,
Standard Deviation or STDEV function is a statistical measure in Excel, that is used to identify or measures how widely values in a data set vary around the mean. For more information about the STDEV funtion in Excel, kindly click on this link.
Feel free to post back if you have further questions.