Issue 10, 1994

Tutorial review. Calculating standard deviations and confidence intervals with a universally applicable spreadsheet technique

Abstract

A quick and universally applicable spreadsheet method is outlined for the calculation of standard deviations based on the general formula for error propagation: “graphic omitted” With this method, standard deviations are calculated numerically without violating the condition of mutual independence, with a substantial time gain and with no risk of calculating errors. Satterthwaite's approximation of the degrees of freedom is a logical extension of the technique with which confidence intervals can be easily established. Direct insight is obtained about the separate contributions of the different error sources.

Article information

Article type
Review Article

Analyst, 1994,119, 2161-2165

Tutorial review. Calculating standard deviations and confidence intervals with a universally applicable spreadsheet technique

J. Kragten, Analyst, 1994, 119, 2161 DOI: 10.1039/AN9941902161

To request permission to reproduce material from this article, please go to the Copyright Clearance Center request page.

If you are an author contributing to an RSC publication, you do not need to request permission provided correct acknowledgement is given.

If you are the author of this article, you do not need to request permission to reproduce figures and diagrams provided correct acknowledgement is given. If you want to reproduce the whole article in a third-party publication (excluding your thesis/dissertation for which permission is not required) please go to the Copyright Clearance Center request page.

Read more about how to correctly acknowledge RSC content.

Social activity

Spotlight

Advertisements