Bootstrapping Analysis, Inferential Statistics and EXCEL
Performing a parametric statistical analysis requires the justification of a number of necessary assumptions. If assumptions are not justified research findings are inaccurate and in question. What happens when assumptions are not or cannot be addressed? When a certain statistic has no known samplin...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
McMaster University
|
| Series: | Spreadsheets in Education |
| Online Access: | http://sie.scholasticahq.com/article/4573-bootstrapping-analysis-inferential-statistics-and-excel.pdf |
| _version_ | 1797970384430039040 |
|---|---|
| author | John A Rochowicz Jr |
| author_facet | John A Rochowicz Jr |
| author_sort | John A Rochowicz Jr |
| collection | DOAJ |
| description | Performing a parametric statistical analysis requires the justification of a number of necessary assumptions. If assumptions are not justified research findings are inaccurate and in question. What happens when assumptions are not or cannot be addressed? When a certain statistic has no known sampling distribution what can a researcher do for statistical inference? Options are available for answering these questions and conducting valid research. This paper provides various numerical approximation techniques that can be used to analyze data and make inferences about populations from samples. The application of confidence intervals to inferential statistics is addressed. The analysis of data that is parametric as well as nonparametric is discussed. Bootstrapping analysis for inferential statistics is shown with the application of the Index Function and the use of macros and the Data Analysis Toolpak on the EXCEL spreadsheet. A variety of interesting observations are described. |
| first_indexed | 2024-04-11T03:17:04Z |
| format | Article |
| id | doaj.art-5812130f883b4e9682f8323e07e1b966 |
| institution | Directory Open Access Journal |
| issn | 1448-6156 |
| language | English |
| last_indexed | 2024-04-11T03:17:04Z |
| publisher | McMaster University |
| record_format | Article |
| series | Spreadsheets in Education |
| spelling | doaj.art-5812130f883b4e9682f8323e07e1b9662023-01-02T10:00:15ZengMcMaster UniversitySpreadsheets in Education1448-6156Bootstrapping Analysis, Inferential Statistics and EXCELJohn A Rochowicz JrPerforming a parametric statistical analysis requires the justification of a number of necessary assumptions. If assumptions are not justified research findings are inaccurate and in question. What happens when assumptions are not or cannot be addressed? When a certain statistic has no known sampling distribution what can a researcher do for statistical inference? Options are available for answering these questions and conducting valid research. This paper provides various numerical approximation techniques that can be used to analyze data and make inferences about populations from samples. The application of confidence intervals to inferential statistics is addressed. The analysis of data that is parametric as well as nonparametric is discussed. Bootstrapping analysis for inferential statistics is shown with the application of the Index Function and the use of macros and the Data Analysis Toolpak on the EXCEL spreadsheet. A variety of interesting observations are described.http://sie.scholasticahq.com/article/4573-bootstrapping-analysis-inferential-statistics-and-excel.pdf |
| spellingShingle | John A Rochowicz Jr Bootstrapping Analysis, Inferential Statistics and EXCEL Spreadsheets in Education |
| title | Bootstrapping Analysis, Inferential Statistics and EXCEL |
| title_full | Bootstrapping Analysis, Inferential Statistics and EXCEL |
| title_fullStr | Bootstrapping Analysis, Inferential Statistics and EXCEL |
| title_full_unstemmed | Bootstrapping Analysis, Inferential Statistics and EXCEL |
| title_short | Bootstrapping Analysis, Inferential Statistics and EXCEL |
| title_sort | bootstrapping analysis inferential statistics and excel |
| url | http://sie.scholasticahq.com/article/4573-bootstrapping-analysis-inferential-statistics-and-excel.pdf |
| work_keys_str_mv | AT johnarochowiczjr bootstrappinganalysisinferentialstatisticsandexcel |