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
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
Average & Error Bars in Bar Graphs
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
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 Quadratic Function
(X, Y) Data Quadratic Function
(X, Y) Data Quadratic Function
(X, Y) Data Quadratic Function
(X, Y) Data Quadratic Function
(X, Y) Data Quadratic Function
(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: 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!
- Slides: 32