MS Excel Spreadsheet: A Teaching-Learning Tool for Statistical Physics
Keywords:
Physics Education, Probability, Spreadsheet, MS ExcelAbstract
This study investigates the relationship between theoretical probability and empirical probability using simulations of simple experiments programmed in Microsoft Excel. A physics laboratory’s probability experiments of tossing coins and dice for multiple trials:10-100000. The convergence of the experimental probability to the theoretical probability was observed as the number of trials increased. Thus, at the UG level, MS Excel spreadsheet can be used as a teaching-learning tool for statistical principles. The Excel spreadsheet provides the same results in a shorter time than the conventional method used in physics laboratories. It was concluded that MS Excel saved considerable effort and time for conducting probability experiments in statistical physics.
Downloads
Publication Facts
Reviewer profiles N/A
Author statements
Indexed in
- Editor & editorial board
- profiles
- Academic society
- Graduate Journal of Interdisciplinary Research, Reports & Reviews
- Publisher
- Vyom Hans Journals
To learn about these publication facts, click 
PF is maintained by the Public Knowledge Project
References
von Koch, H. (1904). Sur une courbe continue sans tangente, obtenue par une construction géométrique
élémen-taire. Arkiv for Matematik, Astronomi och Fysik, 1, 681–704.
Kolmogorov, A. N. (1933). Grundbegriffe der Wahrscheinlichkeitsrechnung. Springer. https:// link.springer.com
Kolmogorov, A. N. (1950). Foundations of the Theory of Probability. Chelsea. https://archive.org
Kolmogorov, A. N. (1956). Foundations of the Theory of Probability (2nd ed.). Chelsea. https://www.
york.ac.uk
Feller, W. (1968). An Introduction to Probability Theory and Its Applications (3rd ed.). Wiley.
Ross, S. (2020). Introduction to Probability and Statistics for Engineers and Scientists (6th ed.). Elsevier.
Downloads
Published
How to Cite
License
Copyright (c) 2025 Dr Kulwinder Singh Mann
This work is licensed under a Creative Commons Attribution 4.0 International License.
Articles in the Graduate Journal of Interdisciplinary Research, Reports and Reviews (Grad. J. InteR3) by Vyom Hans Publications are published and licensed under a Creative Commons Attribution- CC-BY 4.0 International License.
