Function name Function variables
[Link] [Link](x, mean, standard deviation, cumulative)
[Link] [Link](probability, mean, standard deviation)
[Link] [Link](z,cumululative)
[Link] [Link](probability)
[Link] [Link](array, population mean, population SD)
[Link] [Link](alpha, population SD, Sample Size)
Output Use case for Hypothesie testing
a. Use the value in a LT test as p-value
if x is the sample mean, mean is the
population mean and standard
deviation is the population
SD/sqrt(sample size)
Returns the probability b. In a RT test, use this value and
P(X<=x) in a given subtract 1 from it ([Link]) to get
distribution when Cumulative the p-value with the same conditions
= TRUE for the variables.
c. In a 2T test, use min ([Link],1-
[Link]) and multiply it with 2 to
calculate the p-value for same
conditions as mentioned above
a. In a LT test- use this value as X-
cutoff where probability is alpha, mean
is population mean and standard
deviation is population standard
deviation/sqrt(sample size)
b. For a RT test- use the vale of
Returns the X-value for a
[Link](1-alpha, population mean,
given probability
population SD) to calculate X-cutoff.
c. For a 2T test, use the value of
[Link](alpha/2, [Link], [Link])
to calculate the absolute value of X-
cutoff(negative X-cutoff on left side,
positive X-cutoff on right side)
a. In a LT test, use this value to
calculate p-calulate where z= z-
statistic
Returns the probablity for b. For a RT-test, use [Link] to
P(Z<=z) when cumulative is calculate p-value where z is a Z-
TRUE statitistic.
c. For a 2T test, use the minimum value
of [Link] and [Link] to
calculate the value of p/2
a. In a LT test, use this value to
calculate Z-cutoff where probability is
alpha
b. In a RT test, use this value to
calculate Z-cutoff where probability is
Returns the Z-value for a
1-alpha.
given probability
C. For a 2T test- use the value of
[Link](alpha/2) to calulate the left
side Z-cutoff and [Link](1-
(alpha/2)) to calculate the right side Z-
cutoff
a. In a LT test- this value is equal to P-
value
Simplified function if you
b. In a RT test, [Link] is equal to P-
have been given an array of
value
data
c. In a 2t test, min of ([Link], [Link]) is
equal to p/2
Calculates MOE that should
Calculates MOE that should be added
be added and subtracted
and subtracted from sample mean to
from sample mean to
calculate Upper and Lower limit of
calculate Upper and Lower
population mean
limit of population mean
Function name Function variables
[Link] [Link]([Link], degree of freedom, Cumulative)
[Link] [Link]([Link],degree of freedom)
[Link].2t [Link].2t([Link],degree of freedom)
[Link] [Link](alpha,degree of freedom)
[Link].2T [Link].2t(alpha,df)
confidence.t confidence.t(alpha, sample standard deviation, samplesize)
Imprortant relations
[Link](t,df,TRUE)+[Link](t,df) = 1
[Link].2t(alpha, df) = abs([Link](alpha/2,df))
Output Use case for Hypothesie testing
Gives left side probability for a T- distribution when
For a LT test, use this value as p-value
cumulative is true
Gives the right side probability for a T-distribution For a RT test, use this value as p-value
Gives the probability on both left and right side For a 2T test, use this value as p-value
a. For a LT test, use this as T-cutoff for
a given alpha
b. For a RT test, use the
Returns the Left side T-value for a given probability
abs([Link](alpha,df)) or [Link](1-alpha,df)
to calculate the T-cutoff for a given
alpha
For a 2T test, use the negative value of
this to find the left side T-cutoff and
Returns the Left and Right side T-value for a 2T test
positive value of this to find the right
side T-cutoff
Calculates MOE that should be added and subtracted from
sample mean to calculate Upper and Lower limit of
population mean
