Excel_functions_004 - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel functions and some mathematical formulae E2: 3 E3: E4: 2 5 1 2 11 Abbreviations used: CI = Confidence interval E5: 4 5 4 3 33 E6: 5 5 6 2 55 E7: 9 -9 5 9 3 78 Calculation wanted Excel code Syntax Example of syntax Average AVERAGE AVERAGE(range) =AVERAGE(E4:E7) 5 5 5 2.5 44.25 Median MEDIAN MEDIAN(range) =MEDIAN(E4:E7) 4.5 Addition of cells SUM SUM(range) =SUM(E4:E7) 20 Square root SQRT SQRT(cell or range) =SQRT(E7) 3 Power ^ cell1^cell2 =E4^E5 16 Natural logarithm LN LN(cell) =LN(E7) 2.2 e EXP EXP(cell) =EXP(E7) 8103.1 Forcing a cell to return a number >=0 ABS ABS(cell or range) =ABS(F7) 9 Counting cells with an entry COUNT COUNT(range) =COUNT(E2:E7) 5 Standard deviation STDEV STDEV(range) =STDEV(E4:E7) 2.94 Inverse of the t-statistic TINV TINV(probability, degrees of freedom) =TINV(0.05,5) 2.57 =TINV(0.05,100) 1.98 =TINV(0.05,500) 1.96 T-distribution TTEST TTEST(array1,array2,tails,type) =TTEST(E4:E7,G4:G7,2,2) 1.00 =TTEST(E4:E7,H4:H7,2,2) 1.00 =TTEST(E4:E7,I4:I7,2,2) 0.15 =TTEST(E4:E7,J4:J7,2,2) 0.03 Probability of a Chi-square distribution
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/01/2011 for the course CHEM 3332 taught by Professor Thummel during the Spring '08 term at University of Houston.

Page1 / 2

Excel_functions_004 - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online