Estimating with Microsoft Excel Spreadsheet
| Author(s) | : | V.V.KAMBLE, S.DHAVALE, S.HARUDE, ARBHUZ, Prof. Maid N. S |
| Institution | : | Civil Engineering, Jai Hind Polytechnic |
| Published In | : | Vol. 5, Issue 16 — January 2018 |
| Page No. | : | - |
| Domain | : | Engineering |
| Type | : | Research Paper |
| ISSN (Online) | : | 2348-4470 |
| ISSN (Print) | : | 2348-6406 |
Computer- intensive resampling / bootstrap methods are feasible when calculating reference intervals fromnon-Gaussian or small reference samples. Microsoft Excel®in version 2010 or later includes natural functions, whichlend themselves well to this purpose including recommended interpolation procedures for estimating 2.5 and 97.5percentiles.The purpose of this paper is to introduce the reader to resampling estimation techniques in general and in usingMicrosoft Excel®2010 for the purpose of estimating reference intervals in particular. Parametric methods are preferableto resampling methods when the distributions of observations in the reference samples is Gaussian or can transformed tothat distribution even when the number of reference samples is less than 120. Resampling methods are appropriate whenthe distribution of data from the reference samples is non-Gaussian and in case the number of reference individuals andcorresponding samples are in the order of 40. At least 500-1000 random samples with replacement should be taken fromthe results of measurement of the reference samples.
V.V.KAMBLE, S.DHAVALE, S.HARUDE, ARBHUZ, Prof. Maid N. S, “Estimating with Microsoft Excel Spreadsheet”, International Journal of Advance Engineering and Research Development (IJAERD), Vol. 5, Issue 16, pp. -, January 2018.
