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
Summary
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
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have