Error Bars in Normal Distributions Error Bars in

Error Bars in Normal Distributions

Error Bars in Column / Bar Graphs http: //support 2. dundas. com/Online. Documentation/winchart 2005/Er ror. Bars. Chart. html http: //chandoo. org/wp/2010/07/12/gantt-box-chart-tutorial-template/

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

Average & Error Bars in Column Graphs

Compute Sigma

How to Add Error Bars

3 2 How to Add Error Bars 1 5 4

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

Average & Error Bars in Bar Graphs

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

How to Present (X, Y) Scatter Graphs, Compute Trendlines, and Extract Chemical Information using Excel Example: Chemical Kinetics & Equilibria SP 10 Assign. #4 on Aspirin: Handout & online. SP 11 Assign. #4 on p. H-Indicator: Handout & online.

AP 11 Assignment #4

AP 11 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.

AP 11 Assignment #4 1. 40 E-06 0. 4 1. 00 E-06 8. 00 E-07 [C] 6. 00 E-07 [D] 4. 00 E-07 [A] Absorption Concentration (M) 1. 20 E-06 0. 45 Concentration vs. p. H Gaussian Sums 0. 35 [C] 0. 3 [D] 0. 25 [A] 0. 2 11. 5 0. 15 9 7 0. 05 5 0. 00 E+00 0 p. H 1. 5 2 2. 5 3 3. 5 4 4. 5 5 5. 5 6 6. 5 7 7. 5 8 8. 5 9 9. 5 10 10. 5 11 11. 5 0. 1 1. 5 2 2. 5 3 3. 5 4 4. 5 5 5. 5 6 6. 5 7 7. 5 8 8. 5 9 9. 5 10 10. 5 11 11. 5 2. 00 E-07 1. 5 Wavelength (nm)

(X, Y) Built-In Functions

(X, Y) Data Quadratic Function

(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”.

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

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

(X, Y) Data QF: Types of Errors The precise function was y = x 2 Systematic error: All numbers in the sample will be too high! 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. 9937 x 2+ 0. 3459 x 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!