1 / 32

Understanding Error Bars in Normal Distributions and Their Applications in Excel Graphs

Error bars are crucial for visualizing the variability and uncertainty in data representations, particularly in column and bar graphs. This guide explains how to compute standard deviation and add error bars in Excel, enabling you to convey a clearer understanding of data trends and statistical significance. Learn about the differences between sample and population standard deviations and how error bars can highlight the precision of your measurements. Enhance your data presentations with effective error bar techniques for better insights.

zanthe
Télécharger la présentation

Understanding Error Bars in Normal Distributions and Their Applications in Excel Graphs

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Error Bars in Normal Distributions

  2. Error Bars in Column / Bar Graphs http://chandoo.org/wp/2010/07/12/gantt-box-chart-tutorial-template/ http://support2.dundas.com/OnlineDocumentation/winchart2005/ErrorBarsChart.html

  3. Standard Deviation, s Standard Deviation: A statistical measure of spread or variability. Computed as the root mean square (RMS) deviation of the values from their arithmetic mean. Variance: The square of the standard deviation. STDEV, sample of a larger population STDEVP, entire population

  4. Average & Error Barsin Column Graphs

  5. Compute Sigma

  6. Compute Sigma

  7. How to Add Error Bars

  8. How to Add Error Bars 3 2 1 5 4

  9. How to Add Error Bars Select the cell that contains the sigma value Type sigma here

  10. Average & Error Barsin Bar Graphs

  11. Average & Error Barsin Bar Graphs

  12. Average & Error Barsin Bar Graphs

  13. (X,Y) Scatter Graphs & Regression Bad example Better example

  14. How to Present (X,Y) Scatter Graphs, Compute Trendlines, and Extract Chemical Information using Excel Example: Chemical Kinetics & Equilibria SP10 Assign. #4 on Aspirin: Handout & online. SP11 Assign. #4 on pH-Indicator: Handout & online.

  15. AP11 Assignment #4

  16. AP11 Assignment #4

  17. AP11 Assignment #4 Your simulated spectrum will be the sum of the Gaussian functions that describe the absorbances of the three species: -- protonated dye -- neutral dye, and -- deprotonated dye.

  18. AP11 Assignment #4

  19. (X,Y) Built-In Functions

  20. (X,Y) Data Quadratic Function

  21. (X,Y) Data Quadratic Function

  22. (X,Y) Data Quadratic Function

  23. (X,Y) Data Quadratic Function

  24. (X,Y) Data Quadratic Function

  25. (X,Y) Data Quadratic Function

  26. (X,Y) Data Quadratic Function

  27. (X,Y) Data Quadratic Function

  28. (X,Y) Data QF: Y-Axis Error Bars 1. Left click the graph line to which you want to add error bars. 2-Mac: Control-click the selected line. 2-PC: Left-click the selected line. 3. Select “Format Data Series”.

  29. (X,Y) Data QF: Y-Axis Error Bars 3 1 2 4 5

  30. (X,Y) Data QF: Y-Axis Error Bars

  31. (X,Y) Data QF: Y-Axis Error Bars

  32. (X,Y) Data QF: Types of Errors Systematic error: All numbers in the sample will be too high! The precise function was y = x2 The sample data were computed with: y = [x+0.3*RAND()]2 The x-values were assumed to be error-free The fitted function was: y = 0.9937x2+ 0.3459x The STDEV of the y-values is 0.62 Systematic error: There should not be a linear term. This is were you notice the systematic error made (on purpose) in the sample data generation!

More Related