Statistical Analysis Step-By-Step Using Statistical Calculator
Int.J.Curr.Microbiol.App.Sci (2018) 7(11): 901-921
International Journal of Current Microbiology and Applied Sciences
ISSN: 2319-7706 Volume 7 Number 11 (2018)
Journal homepage:
Original Research Article
Statistical Analysis Step-By-Step Using Statistical Calculator
D.S. Dhakre* and D. Bhattacharya
Institute of Agriculture, Visva-Bharati, Sriniketan, West Bengal - 731 236, India
*Corresponding author
ABSTRACT
Keywords
Spreadsheet, Statistical
Calculator, M S Excel,
tools
Article Info
Accepted:
10 October 2018
Available Online:
10 November 2018
This paper introduces a new statistical calculator which provides a step-by-step guide to
data analysis of the research data generated in agriculture, biological sciences and in other
fields. The process used to develop the program is quite involved with statistical theories
and is not understandable to those who do not have any background in statistics and data
analysis. Here we will explain the procedure adopted and the programme used, step-bystep so that it becomes easily comprehensible. We have provided examples in each
spreadsheet for analysis. Data analysis with this statistical programme is not really
difficult. According to the draft format required for analysis, you only need to arrange and
enter the raw data. It does not require much information and knowledge about the formula
used as well as the program developed to analyze the data.
Step 1: Type sbear.in in any browser
that will open the following web page
Introduction
Any computer that has Microsoft Office Excel
in it can operate this statistical calculator.
Operating system requirement is windows7 or
its higher version. Usually looking at a data
we become nervous and start thinking that
how to analyse the data using computer
programme, how to write the report of the
research analysis etc. This newly developed
statistical calculator will remove the fear of
data analysis and make our life easy. This
calculator will get the data analysis done
within a very reasonable computing time.
Materials and Methods
We follow the steps described below to get the
data analyzed and finding its outputs:
Step 2: Then click on Statistical Analysis
which will open the page given below
Step 3: There are number of items on the
statistical calculator. You can click on any one
of them according to your need, for example,
click on Descriptive Statistics
Step 4: Then click on Statistical Calculator, it
will download the statistical calculator of
Descriptive Statistics within a second. You
can keep it in your computer or laptop forever.
Next, you click on the downloaded file, which
is an excel file, then a data spreadsheet will
open up. Here you can analyse upto 6 number
of variables with 46 observations each. Now
you can put your data directly in the given
901
Int.J.Curr.Microbiol.App.Sci (2018) 7(11): 901-921
spreadsheet or copy from other sheet and paste
it on the spreadsheet
Step 5: Now you click on print command and
then that command will start the analysis of
data and produces results in a printable format.
If a printer is attached to the computer, then
you can take a print out of the results.
Otherwise, you can see your results in a print
preview mode and the following page will
open up:
Same process will have to apply for all other
statistical
calculator
like
correlation
coefficient, completely randomozed design,
randomized
block
design,
factorial
experiement etc.
Other data analysis tools
Correlation coefficient
Step 1: Click on correlation coefficient and the
following page will show up:
Step 2: Then click on correlation coefficient,
then that will download the statistical
calculator of correlation coefficient within a
second. You can keep it in your computer or
laptop forever. Next, you click on the
downloaded file which is an excel file, a data
spreadsheet will open up.
Here you can analyse upto 11 number of
variables with 46 observations each. Now you
can enter your data directly in the given
spreadsheet or copy from other sheet and paste
it on the spreadsheet.
Step 3: Now, you click on print command,
then that command will start analysis of the
data and produces the results in a printable
format. If a printer is attached to the computer,
then you can take a print out of the results.
Otherwise, you can see your results in a print
preview mode and the following will come up:
Completely randomized design
Step 1: Click on completely randmozed design
Step 2: Here you will get two statistical
calculators, one for equal number of
replications and other for unequal number of
replications. Then click on any one them
according to your requirement and then that
command will download the statistical
calculator of completely randmozed design
within a second. You can keep it in your
computer or laptop forever. Next, you click on
the downloaded file which is an excel file, a
data spreadsheet will open up. Here you can
analyse upto 30 number of treatments with
upto 6 number of replications. Now you can
put your data directly in the given spreadsheet
or copy from other sheet and paste it here.
Step 3: Put Number of Replications = 4,
Number of Treatments =5 and Name of the
Variable = yield of wheat in the following
page.
Step 4: Now you click on print command, then
that command will start analysis of the data
and produces the results in a printable format.
If a printer is attached to the computer, then
you can take a print out of the result,
otherwise, you can see your result in a print
preview mode. See the page below:
Randomized block design
Step 1: Click on the Randomized block design
Step 2: Next, after clicking on randomized
block design, it will download the statistical
calculator for randomized block design within
a second. You can keep it in your computer or
laptop forever. After that, you click on the
downloaded file which is an excel file, then a
data spreadsheet will open up. Here you can
analyse upto 30 number of treatments with
upto 6 number of replications. Now you can
enter your data directly in the given
spreadsheet or copy from other sheet and paste
it here.
902
Int.J.Curr.Microbiol.App.Sci (2018) 7(11): 901-921
The steps described below to get the data analyzed and finding its outputs
903
Int.J.Curr.Microbiol.App.Sci (2018) 7(11): 901-921
904
Int.J.Curr.Microbiol.App.Sci (2018) 7(11): 901-921
Example.1 Find the descriptive statistics for the following data
V1= pH
V2 = EC
V3=CEC V4=Porosity V5=Sand
0.14
12.7
47.7
20.5
4.51
0.2
13.6
58.2
54.8
5.33
0.17
13.14
52.3
36.4
4.82
0.12
12.6
49.6
17.8
4.32
0.25
13.2
57
42
4.64
0.16
12.84
53.4
31
4.5
0.15
12
50.4
19.5
4.11
0.25
12.8
56
55.4
4.64
0.2
12.32
53
40.4
4.5
0.1
10.7
49.6
18.4
4.57
0.25
12.9
53.5
42.4
5.24
0.17
11.92
51.5
31.1
4.81
0.15
11.3
49.6
22
4.700.2
11.8
54.4
56
5.48
0.17
11.54
51.7
36.2
4.94
After copy pasting the data it will look like the following page:
905
V6=Silt
22
49
38
31
46.2
41.2
26.5
44.4
35.3
27.1
51.5
41.2
29.2
57
42.6
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- reasonable cost calculator idaho
- statistical analysis step by step using statistical calculator
- using your scientific calculator
- ti 83 84 calculator the basics of statistical functions
- online d d calculator step by step guide maersk
- easy steps to success a graphing calculator guide
- how to upload the data dna methylation age calculator
- steps for conducting multiple linear regression
- appendix c community survey guide a step by step
- directions for using the online w apt score calculator
Related searches
- photosynthesis process step by step easy
- step by step essay example
- step by step writing template
- step by step business plan template
- step by step cellular respiration
- step by step starting business
- photosynthesis step by step biology
- step by step protein synthesis
- step by step business plan
- step by step watercolor lessons
- step by step research paper guide
- step by step mortgage guide