Development of Excel Functions for Statistical Testing of Proportions

Article Sidebar

PDF (Magyar)
Published: Mar 16, 2024
DOI: https://doi.org/10.14232/jtgf.2023.3-4.31-39
Keywords:
test for proportion, Excel, statistics, VBA programming

Main Article Content

Zoltán Fabulya
University of Szeged Faculty of Engineering
https://orcid.org/0000-0003-2309-1075
György Hampel
University of Szeged Faculty of Engineering
https://orcid.org/0000-0003-0550-1878
Anita Kiss
University of Debrecen
https://orcid.org/0009-0007-4755-4931

Abstract

Our research objective was to develop a simple and widely applicable tool which is able to test the hypothesis regarding the proportion of individuals corresponding to a characteristic in a statistical population in the case of large samples. There are several benefits of using the Excel spreadsheet program, in which the evaluation can be performed with functions developed with the Microsoft Excel Visual Basic for Applications service. Compared to statistical software packages, the test can be automated on Excel spreadsheets, thus providing a faster and more convenient technique. In addition to different data types, our functions are capable of testing the proportion of individuals that meet conditions specified by relations, forming the significance value of the test as a result. An error message is displayed if the criterion of the big sample size is not satisfied.

Downloads

Download data is not yet available.

Article Details

How to Cite
Fabulya, Zoltán, György Hampel, and Kiss Anita. 2024. “Development of Excel Functions for Statistical Testing of Proportions”. Jelenkori Társadalmi és Gazdasági Folyamatok 18 (3-4):31-39. https://doi.org/10.14232/jtgf.2023.3-4.31-39.
Issue
Vol. 18 No. 3-4 (2023)
Section
Digitalization, IT tools and statistical applications
Author Biographies

Zoltán Fabulya, University of Szeged Faculty of Engineering

főiskolai docens

György Hampel, University of Szeged Faculty of Engineering

főiskolai docens

Anita Kiss, University of Debrecen

adjunktus

References

Alexander, M., Kusleika, R. (2016): Excel 2016 Power Programming with VBA. John Wiley & Sons, Inc., Hoboken, New Jersey.

Domán Cs., Szilágyi R., Varga B. (2009): Statisztikai elemzések alapjai II. Közgazdasági-módszertani képzés fejlesztéséért Alapítvány, Miskolc.

Hunyadi L., Vita L. (2008): Statisztika II. Aula Kiadó, Budapest.

Mansfield, R. (2019): Mastering VBA for Microsoft Office 365, 2019 Edition. John Wiley & Sons, Inc., Hoboken, New Jersey.

Obádovics J. Gy. (2020): Valószínűségszámítás és matematikai statisztika. Scolar Kiadó Kft., Budapest.

Tóthné Lőkös K. (2008): Statisztika II. Századvég Kiadó, Budapest.

Thode, H. C. (2002): Testing For Normality (1st ed.). CRC Press, Boca Raton, Florida. https://doi.org/10.1201/9780203910894

Vita L. (2011): A statisztikai próbák gondolatvilága. Statisztikkai szemle, 89 (10-11): 1130–1149. <https://www.ksh.hu/statszemle_archive/2011/2011_10-11/2011_10-11_1130.pdf> (2023.10.05.)

Walkenbach, J. (2015): Excel 2016 Bible (1st ed.). John Wiley & Sons, Inc., Hoboken, New Jersey.