|
|
|
||||||||||||||||
|
|
|
|
|||||||||||||||
in association with
Pocket WorkSheet Samples
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
Sample Miscellaneous/Statistical
This example is specific to Pocket Worksheet for Pocket PC 2002. This sample worksheet contains examples of the PERCENT (%) operator and the COUNT (Cnt) operator, of interest in retail applications.
It also demonstrates computing the Mean, Variance, and Standard Deviation of a sample, using the SQUARE (Sq), COUNT (Cnt), and SUM OF VALUES (Sum) operations.
A short and long form of the worksheet are shown below. Commentary text is removed in the short form to emphasize functional content.
Short Sample Misc/Stat
0 C ShortMisc
PERCENT
OF
A TOTAL
$ 100.00 +
20 %
$ 20.00 =
0 C
SUBTRACT A
PERCENTAGE
OF A
TOTAL
$ 100.00 +
20% -
$ 80.00 =
0 C
COUNT AND
TOTAL
ITEMS IN A
BATCH
$ 100.25 +
$ 200.00 +
$ 14.95 +
$ 1.99 +
4 Cnt
$ 317.19 =
$ 1.99 +
$ 69.95 +
$ 14.50 +
$ 403.63 = Total Checks
7 Cnt
Cnt(7) /
$ 57.66 = Average Check Amount
0 C
SAMPLE
STANDARD
DEVIATION
Sq(1) +
Sq(2) +
Sq(3) +
Sq(4) +
Sq(5) +
55 = Sum of squares of values*
5 Cnt Count of values*
15 Sum Sum of values*
0 C
15 + *Sum of values
5 / *Count of values
MEAN
3 = Mean
0 C
Sq(15) + *Sum of values
5 / *Count of values
45 = Mean of sum squared*
0 C
55 + *Sum of squares of values
45 - *Mean of sum squared
SUM OF
SQUARES
10 = Sum of Squares*
0 C
5 + *Count of values
1 - Adjust population for sample
SAMPLE
SIZE
4 = "Sample" Size*
0 C
10 + *Sum of Squares
4 / *"Sample" Size
VARIANCE
2.5 = Variance
STD
DEVIATION
1.58113883008419 Sqrt Std Deviation
Sample Misc/Stat with Full Commentary Text
0 C SampleMisc
Pocket WorkSheet (c) Publish or Perish Software
Press, 2002
SAMPLE
MISC
This sample worksheet contains examples of the
PERCENT (%) operator and the COUNT (Cnt) operator,
of interest in retail applications, and
computation of MEAN, VARIANCE, and STANDARD
DEVIAION, using the Sq, Cnt, and Sum operations.
PERCENT
OF
A TOTAL
Compute a percentage of a total.
First, enter a value to create a total.
Tap the Format button until the Currency Symbol appears
($).
Tap the number buttons 1 0 0 then tap the + operator.
$ 100.00 +
The current total is 100.
Let's take 20% of that value. Tap 2 0 then tap the
PERCENT (%) button.
20 %
Next tap the = operator to display the result.
$ 20.00 =
Tap the CLEAR (C) button to clear the total.
0 C
SUBTRACT A
PERCENTAGE
OF A
TOTAL
First, enter a value to create a total.
Tap the number buttons 1 0 0 then tap the + operator.
$ 100.00 +
The current total is 100. Next tap the MINUS (-)
button, tap the number buttons 2 0. Finally tap
the % button, as in "Minus 20 Percent". This subtracts
20% of the current Total from the current Total.
20% -
Tap the = button to display the result.
$ 80.00 =
Tap the C button to clear the total.
0 C
COUNT AND
TOTAL
ITEMS IN A
BATCH
Total a batch of checks. Use the Count operator to
help verify the item count.
Tap the number buttons 1 0 0 . 2 5 followed by + and
repeat this to create a series of entries.
$ 100.25 +
$ 200.00 +
$ 14.95 +
$ 1.99 +
Open menu View/Advanced Keys and tap the COUNT
(Cnt) button.
4 Cnt
Tap the = button to display the current total.
$ 317.19 =
Tap menu View/Standard Keys to hide the Advanced Keys.
Continue entering "checks".
$ 1.99 +
$ 69.95 +
$ 14.50 +
Tap the Text Entry Box and type "Total Checks". Tap
the = button to display the total.
$ 403.63 = Total Checks
Next we'll get the final Count and compute the
average.
First tap menu View/Advanced Keys. Tap the
Cnt button to display the final Count in the
worksheet. This will not affect the current total.
7 Cnt
Next compute the average of each entry. Tap the DIVIDE
(/) button and then tap the COUNT (Cnt) button. The
current Total is divided by the final Count, giving the
average.
Cnt(7) /
Tap the = button to display the average in the
worksheet.
$ 57.66 =
0 C
Tap the Format button until "#" appears, to switch to
non-Currency number format.
SAMPLE
STANDARD
DEVIATION
Here we'll compute the Mean, Variance , and
Standard Deviation of a set of values, 1, 2, 3, 4, and
5. To do this, we'll first enter the Square of each
value.
Tap the + button, tap the 1 button for our first value,
then tap the SQUARE (Sq) button on Advanced keypad.
Sq(1) +
Repeat as above for values 2 through 5.
Sq(2) +
Sq(3) +
Sq(4) +
Sq(5) +
Type "Sum of squares of values" in the Text Entry
box then tap the EQUAL (=) button to display the
result.
55 = Sum of squares of values*
Type "Count of values" in the Text Entry box then tap
the COUNT (Cnt) button on the Advanced keypad.
5 Cnt Count of values*
Type "Sum of values" in the Text Entry box then tap the
SUM (Sum) button on the Advanced keypad to display
the simple (non-squared) total of the series of
values entered above.
15 Sum Sum of values*
Tap the CLEAR (C) button to clear the current total.
0 C
Next we'll compute the Mean.
Tap the row labeled "Sum of values" above to select it.
Tap the "Use" button, then tap the + button.
15 + *Sum of values
Tap the row labeled "Count of values" above to select
it then tap the DIVIDE (/) button.
5 / *Count of values
Type "Mean" in the Text Entry box, then tap the
EQUAL (=) button to display the result in the
worksheet.
MEAN
3 = Mean
Tap the CLEAR (C) button to clear the current Total.
0 C
Next we'll take the square of the sum of the values.
Tap the PLUS (+) button. Tap the row labeled "Sum of
values" above. Tap the SQUARE (Sq) button on the
Advanced keypad to complete the combined operation.
Sq(15) + *Sum of values
Next we'll compute the mean of this squared value. Tap
the row labeled "Count of values" above to select it.
Tap the DIVIDE (/) button.
5 / *Count of values
Type "Mean of sum squared" in the Text Entry box and
tap the EQUAL (=) button to display the result in the
worksheet.
45 = Mean of sum squared*
Tap the CLEAR (C) button to clear the current total.
0 C
Next we'll compute the "Sum of Squares", or the sum of
squared differences from the mean.
Tap the row labeled "Sum of squares of values" above to
select it then tap the + button.
55 + *Sum of squares of values
Tap the row labeled "Mean of sum squared" above to
select it, then tap the MINUS (-) button.
45 - *Mean of sum squared
Type "Sum of Squares" in the Text Entry box then tap
the EQUAL (=) button to display the result in the
worksheet.
SUM OF
SQUARES
10 = Sum of Squares*
Tap the CLEAR (C) button to clear the current total.
0 C
Next we'll reduce the "Count of values" by 1.
This is done if the values represent a "Sample" rather
than the entire "Population" of values.
Tap the row labeled "Count of values" above to select
it. Tap the + button.
5 + *Count of values
Next we'll subtract 1. Tap the 1 button then tap the
MINUS (-) button.
1 -
Type "Sample" Size in the Text Entry box then tap the
EQUAL (=) operator to display the result in the
worksheet.
SAMPLE
SIZE
4 = "Sample" Size*
Tap the CLEAR (C) button to clear the current total.
0 C
Next we'll compute the Variance and Std Deviation.
Tap the row labeled "Sum of Squares" above to select it
then tap the + button.
10 + *Sum of Squares
Tape the row labeled "Sample" Size above to
select it the tap the DIVIDE (/) button.
4 / *"Sample" Size
Type "Variance" in the Text Entry box and tap the EQUAL
(=) button to display the result in the worksheet.
VARIANCE
2.5 = Variance
Type "Std Deviation" in the Text Entry box. Next tap
the SQUARE ROOT (Sqrt) button on the Advanced
keypad. This will take the square root of the current
total, which is the Variance, and will
automatically display the result in the worksheet.
STD
DEVIATION
1.58113883008419 Sqrt Std Deviation
Copyright © 2004 Publish or Perish Software Press. All rights reserved.
