Appendix 370
Statistical Functions
*' #1)4-'.32 (/1 23#3+23+%#, (4.%3+/.2 %/.2+23 /( '+3*'1 .4-$'12 (+',&
.#-'2 /1 #&&1'22'2 /( %',,2 3*#. %/.3#+. .4-$'12 *' 1'24,32 /( 3*'2'
%#,%4,#3+/.2 #1' #,6#82 .4-$'12
Function
Description
Example
AVG
(value1,
value2,...)
Average
/( 3*' 5#,4'2 +. # ,+23 "/4 %#. 42' #2
-#.8 #1)4-'.32 #2 8/4 6#.3 +.%,4&+.) 5#,4'2
#&&1'22'2 1#.)'2 .#-'& %',,2 .#-'& 1#.)'2
#.& (+',& .#-'2 (/1 #1)4-'.32 31'#32
'-038 %',,2 #2 9'1/ 5#,4'2 "/4 %#../3 #5'1#)'
%',,2 /1 (+',&2 %/.3#+.+.) 3'73
returns
1#&'2
returns
returns
MAX
(value1,
value2,... )
Largestnumber
+. # ,+23 +23 %#. +.%,4&' 5#,4'2
/1 #&&1'22'2 2'0#1#3'& $8 %/--#2 !
+)./1'2 '-038 %',,2 #.& 31'#32 3'73 #2 # 9'1/
!
returns
!
returns
!
returns
3*' ,#1)'23 .4-$'1 +. 3*'
1#.)'
MIN
(value1,
value2,... )
Smallestnumber
5#,4' +. # ,+23 +23 %#.
+.%,4&' 5#,4'2 /1 #&&1'22'2 2'0#1#3'& $8
%/--#2 +)./1'2 '-038 %',,2 #.& 31'#32 3'73
#2 # 9'1/
returns
returns
returns
3*' 2-#,,'23 .4-$'1 +.
3*' 1#.)'
RANDOM
( )
Randomnumber
$'36''. #.&
1'341.2 # .'6 1#.&/- .4-$'1 6+3* '5'18
1'%#,%4,#3+/.
returns
# &'%+-#,
5#,4'
RANDOMN
(value)
Randomnumber between 0 and
-1
#
.4-$'1 8/4 20'%+(8 1'341.2 # .'6
1#.&/- .4-$'1 6+3* '5'18 1'%#,%4,#3+/.
returns
# .4-$'1 $'36''.
#.&
STD
(value1,
value2,...)
Standarddeviation
/( 3*' 5#,4'2 +. # ,+23 "/4
%#. 42' #2 -#.8
values
#2 8/4 6#.3
returns
n (n–1)
The formula used by the STD function:
n
∑
x
2
– (
∑
x)
2
STDP
(value1,
value2,...)
Standard deviation of a population
"/4 %#.
42' #2 -#.8
values
#2 8/4 6#.3 "/4 %#. 42'
5#,4'2 #&&1'22'2 1#.)'2 .#-'& %',,2 #.& (+',&
.#-'2 (/1 #1)4-'.32
returns
n
2
The formula used by the STDP function:
n
∑
x
2
– (
∑
x)
2
Summary of Contents for Ensemble PDP-100J
Page 11: ......
Page 71: ...Getting Started 60 Optional Accessories Fax Modem Data Modem Scanner Cut Sheet Feeder ...
Page 72: ......
Page 83: ......
Page 152: ......
Page 217: ...Spreadsheet 203 The following dialog box appears ...
Page 219: ......
Page 262: ......
Page 269: ......
Page 284: ......
Page 301: ......
Page 306: ...Calculator 287 Cut and paste Handling Error or Overflow Conditions To clear an error ...
Page 308: ...Calculator 289 Converting Measurements S S S S S S To convert ...
Page 312: ......
Page 325: ......
Page 327: ...Book Reader 306 To close a book Using Information and Text To read a book ...
Page 330: ......
Page 333: ......
Page 337: ...Text File Editor 314 ...
Page 338: ......
Page 345: ......
Page 349: ...Scanner 324 What to do if an error occurs Error Condition Message Solution ...
Page 350: ......
Page 379: ......
Page 387: ...Appendix 360 Color Clip Art SNOWMAN TEA TIGER TURTLECA WANDFLOW WATERLIL ...
Page 396: ...Appendix 369 Print Functions Function Description Example ...
Page 405: ...Appendix 378 Fonts Occidental Font Symbols keyboard International keyboard Math Symbols ...
Page 406: ...Appendix 379 Ping Pong Font Pointer keyboard Numbers keyboard Symbols keyboard Other Symbols ...
Page 407: ...Appendix 380 Shattuck Avenue Font Symbols keyboard International keyboard Math Symbols ...
Page 408: ...Appendix 381 URW Mono Font Symbols keyboard International keyboard Math Symbols ...
Page 409: ...Appendix 382 URW Roman Font Symbols keyboard International keyboard Math Symbols ...
Page 410: ...Appendix 383 URW Sans Font Symbols keyboard International keyboard Math Symbols ...
Page 414: ......
Page 418: ...Glossary 390 ...
Page 420: ...Glossary 392 0 1 1 1 ...
Page 421: ...Glossary 393 text style sheet ...
Page 422: ...Glossary 394 ...
Page 423: ......
Page 428: ...Index 399 D cont d 1 0 1 1 1 1 0 1 0 1 1 0 2 1 0 0 0 1 0 ...
Page 430: ...Index 401 F cont d 1 1 0 0 1 0 0 0 0 0 0 0 0 0 G 1 0 1 ...
Page 436: ...Index 407 S cont d 1 3 3 1 1 0 1 4 0 3 0 0 1 1 3 1 3 1 0 1 1 1 0 1 3 1 0 1 2 ...
Page 440: ......