Abstract

A simple and easy method is employed to construct complete statistical tables like Student’s tdistribution, F distribution, Chi-square distribution and Cumulative standard normal distribution in Excel software which are used in all fields of research. Also, we generate other statistical tables like Cumulative binomial distribution, Cumulative Poisson distribution, Fisher transformation and Fisher inverse transformation. The proposed method depends only on the Excel software; it does not depend on the traditional statistical tables.

Highlights

  • Statistical tables are very important issues in data analysis because whenever the researchers want to test their hypothesis, they need a critical value which is available in the statistical tables

  • There have already been proposed various statistical tables to investigate the hypothesis according to the situation e.g. Gosset (1908) developed Student’s t-distribution, Snedecor (1934) proposed F distribution, according to Chaudary (1996) the chi square distribution was first obtained in 1875 by Helmert and De Moivre (1738) worked firstly on the Normal distribution but no software is available to present all the values of a table at the same time

  • A simple and easy method is used to construct statistical tables like Student’s tdistribution, F distribution, Chi-square distribution and Cumulative standard normal distribution in Excel software which are mostly used in all fields of research

Read more

Summary

Introduction

Statistical tables are very important issues in data analysis because whenever the researchers want to test their hypothesis, they need a critical value which is available in the statistical tables. We construct statistical tables like Student’s t-distribution, F distribution, Chisquare distribution and Cumulative standard normal distribution which are mostly used in all the fields of research. There have already been proposed various statistical tables to investigate the hypothesis according to the situation e.g. Gosset (1908) developed Student’s t-distribution, Snedecor (1934) proposed F distribution, according to Chaudary (1996) the chi square distribution was first obtained in 1875 by Helmert and De Moivre (1738) worked firstly on the Normal distribution but no software is available to present all the values of a table at the same time. We construct the complete statistical tables using the statistical functions which are available in the Excel

Methods
Results
Conclusion
Full Text
Published version (Free)

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call