• Debasree Goswami
• Jasvinder Goswami

This paper presents two Visual Basic for Applications (VBA) functions designed to facilitate bootstrap resampling in Microsoft Excel, a widely used spreadsheet software. Despite Excel's extensive capabilities, it lacks built-in functions for performing bootstrap resampling, a powerful statistical technique used for estimating the sampling distribution of a statistic. The developed VBA functions address this gap, enabling users to generate bootstrap samples and calculate a range of statistics from these samples directly within Excel. The functions are flexible and user-friendly, accommodating a variety of univariate statistics available in Excel. An application study using R.A. Fisher's "ToothGrowth" dataset demonstrates the practical use of the functions. The development of these functions contributes to the toolbox of statistical methods available in Excel, enhancing its utility for statistical analysis.

Bootstrap Resampling, Microsoft Excel, VBA, Univariate Statistics, Sampling Distribution, Data Analysis, Excel Programming

"Enhancing Excel's Statistical Capabilities: A VBA Approach to Bootstrap Resampling", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.10, Issue 7, page no.i91-i96, July-2023, Available :http://www.jetir.org/papers/JETIR2307814.pdf

"Enhancing Excel's Statistical Capabilities: A VBA Approach to Bootstrap Resampling", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.10, Issue 7, page no. ppi91-i96, July-2023, Available at : http://www.jetir.org/papers/JETIR2307814.pdf