On the accuracy of statistical procedures in Microsoft Excel 2003

McCullough, B. D.; Wilson, Berry

doi:10.1016/j.csda.2004.06.016

Cited by 86 publications

(61 citation statements)

References 12 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…According to sport results, the regession analysis was used ( Jaccard, 1990 ; Ginevan and Splitstone, 2004 ). Identification of the optimal combination of explanatory variables were done by the correlation matrix of variables, Pearson’s coefficient and factor analysis ( Green, 2003 ; McCullough and Wilson, 2005 ; Keele and Kelly, 2006 ). The impact of variables on the value of Y (explanatory variable) was analysed by multivariate function of regression with parameters calculated by the data characterizing the structure of following function:

Y_{boldt} = f [X_{1, t - 1}, X_{2, t - 1}, \dots \dots, X_{n, t - 1}] + ξ_{t}

…”

Section: Methodsmentioning

confidence: 99%

Game Indicators Determining Sports Performance in the NBA

Mikołajec

Maszczyk

Zając

2013

Journal of Human Kinetics

View full text Add to dashboard Cite

The main goal of the present study was to identify basketball game performance indicators which best determine sports level in the National Basketball Association (NBA) league. The research material consisted of all NBA game statistics at the turn of eight seasons (2003–11) and included 52 performance variables. Through detailed analysis the variables with high influence on game effectiveness were selected for final procedures. It has been proven that a limited number of factors, mostly offensive, determines sports performance in the NBA. The most critical indicators are: Win%, Offensive EFF, 3rd Quarter PPG, Win% CG, Avg Fauls and Avg Steals. In practical applications these results connected with top teams and elite players may help coaches to design better training programs.

show abstract

Y_{boldt} = f [X_{1, t - 1}, X_{2, t - 1}, \dots \dots, X_{n, t - 1}] + ξ_{t}

…”

Section: Methodsmentioning

confidence: 99%

Game Indicators Determining Sports Performance in the NBA

Mikołajec

Maszczyk

Zając

2013

Journal of Human Kinetics

View full text Add to dashboard Cite

show abstract

“…The Microsoft Excel was used as a statistical software package for analyzing the data for the analysis of variance and other statistical parameters (McCullough and Wilson 2005).…”

Section: Discussionmentioning

confidence: 99%

Effect of Different Levels of Phosphorus and Sulphur on Growth and Nutrient Uptake of Green gram (Vigna radiata L.) under Teak (Tectona grandis L.) based Agroforestry System

Dhewa¹,

Daniel²,

chana³

2017

Int.J.Curr.Microbiol.App.Sci

View full text Add to dashboard Cite

“…This is the pre-dominant interface design in XLR. The spreadsheet mode, which retains the automatic recalculation feature in Excel, is adopted to rewrite a list of commonly used Excel functions by making functional calls to the corresponding R functions and, hence, enable us to solve the notorious problems of incorrect handling of delicate numerical problems in Excel as reported in [5,[7][8][9][10].…”

Section: Design Approach and Philosophymentioning

confidence: 99%

“…Numerous studies have highlighted the deficiencies and dangers of using Excel as a statistical package for teaching and research. Reference [5][6][7][8][9] performs extensive studies to reveal that several statistical algorithms used in Excel yield erroneous results. Reference [10] demonstrates the danger of using Excel to perform regression analysis that involves correlated independent variables.…”

Section: Introductionmentioning

confidence: 99%

XLR: A Free Excel Add-In for Introductory Business Statistics

Ng¹

2013

OJAppS

View full text Add to dashboard Cite

XLR is an Excel add-in that unifies the user friendly, widely popular interface of Excel with the powerful and robust computational capability of the GNU statistical and graphical language R. The add-in attempts to address the American Statistical Association's comment that "Generic packages such as Excel are not sufficient even for the teaching of statistics, let alone for research and consulting." R is the program of choice for researchers in statistical methodology that is freely available under the Free Software Foundation's GNU General Public License (GPL) Agreement. By wedding the interactive mode of Excel with the power of statistical computing of R, XLR provides a solution to the problem of numerical inaccuracy of using Excel and its various internal statistical functions and procedures by harnessing the computational power of R. XLR will be distributed under the GNU GPL Agreement. The GPL puts students, instructors and researchers in control of their usage of the software by providing them with the freedom to run, copy, distribute, study, change and improve the software, thus, freeing them from the bondage of proprietary software. The creation of XLR will not only have a significant impact on the teaching of an Introductory Business Statistics course by providing a free alternative to the commercial proprietary software but also provide researchers in all disciplines who require sophisticated and cutting edge statistical and graphical procedures with a user-friendly interactive data analysis tool when the current set of available commands is expanded to include more advance procedures.

show abstract

On the accuracy of statistical procedures in Microsoft Excel 2003

Cited by 86 publications

References 12 publications

Game Indicators Determining Sports Performance in the NBA

Game Indicators Determining Sports Performance in the NBA

Effect of Different Levels of Phosphorus and Sulphur on Growth and Nutrient Uptake of Green gram (Vigna radiata L.) under Teak (Tectona grandis L.) based Agroforestry System

XLR: A Free Excel Add-In for Introductory Business Statistics

Contact Info

Product

Resources

About