Excel
sum: =SUM( array of data )
minimum: =MIN( array of data )
maximum: =MAX( array of data )
Mean: =AVERAGE( )
Median: =Median( )
Quartile: =QUARTILE.INC(array of data , which quartile )
Percentile: =PERCENTILE.EXEC(array of data , which quartile )
St. Dev.: =STDEV.S(array of data)
Variance: =VAR.S.(array of data)
=NORM.DIST
=NORM.INV
=T.DIST.2T(mean, deg. freedom)
=T.TEST(array1, array2, tails, type)
=CHISQ.DIST.RT(chi, df)
=CHIQS.INV.RT(probability, df)
=CHISQ.TEST(actual range, expected range)
=CORREL
Know how to change between general and number.
Know how to use the autosum.
Know how to sort/order some data in ascending and descending order.
Standard deviation: =STDEV.S( )
n choose k: =COMBIN(n,k)
to return the percentile of a given data point x with a mean μ and a st. dev σ: =NORM.DIST(x,μ, σ, TRUE)
to return the percentile of a given z-score: =NORM.S.DIST(zx, TRUE)
to return the score from a given percentile with a mean μ and a st. dev σ: =NORM.INV(p,μ, σ)
to return the z-score from a given percentile: =NORM.S.DIST(p)
to return the z-score of a given data point x with a mean μ and a st. dev σ: =STANDARDIZE(x,μ, σ)
We discussed how to insert a graph: pie graph, bar graph, histogram, as well as how to manipulate the axis: get to format axis
TI-84
How to input data into a list and compute its 1-var stats, which includes the five number summary. (Check p. 17 of the class text as well a p. 24.)
The standard deviation is always the sample standard deviation not the population: Sx not σx
How to order the data in ascending and descending order.
Given a binomial experiment/distribution
P(X=k) = binompdf(n,p,k)
P(X ≤ k) = binomcdf(n,p,k)
Normal Distribution
normalcdf(lower,upper, μ , σ)
invnorm(p,μ, σ)