{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel_functions_004

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

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

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 CHITEST CHITEST(actual range,expected range) =CHITEST(H4:H7,E4:E7) 0.87

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### 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
Ask a homework question - tutors are online