MOD()

MOD() - This function returns the remainder when one integer is divided by another.

Syntax:

MOD(Dividend;Divisor)


Example:

=MOD(25;4) returns 1
=MOD(38;9) returns 2

How To Create a Random Set of Data

Here is an easy way to create a random set of data using the RANDBETWEEN() Funciton.

RANDBETWEEN(Bottom;Top) - This function returns a random integer between the bottom and top numbers inclusive that you specify. Inclusive means the two numbers you specify are included.

The example I am using lists the heights (in inches) of females and males.

Cell B2 contains the formula =RANDBETWEEN(54;75)

Cell C2 contains the formula =RANDBETWEEN(66,77)

Here is a screen shot. Click on the image for a larger view.




If you would like to remove the formula and just keep the data, highlight all of the cell that contain the formulas.

Right click on the data and click copy.

Right click on the data and hit Paste Special. When the Paste Special box comes up, make sure Numbers is the only item selected in the Selection group.

See the screen shot below. You can click the image for a larger view.

COUNTIF()

Here is an example of the COUNTIF() function in Open Office Calc. I have set up a spreadsheet that contains them model and color of various cars. We will use Validity from the Data menu and the COUNTIF() function to determine number sold.

Here is a screen shot of my spreadsheet.



You can type the two columns like I have it or you can use your own data. Column A contains the model of different cars and column B contains the color.

Click on cell D2 and click Validity on the Data menu. When the dialog box comes up, select List from the drop down box next to Allow on the Criteria tab and type in the different models.

Next, click on cell D5 and do the same thing. But type in the different colors. Note: You do not have to type them in alphabetical order. If you want the list to appear in alpahbetical order in the drop down list in the cell, simply check Sort entries ascending.

Here is a screen shot for the models list.



It is now time to enter the COUNTIF() function.

COUNTIF(range, criteria)
range = What yo want to search through.
criteria = What you want to count.

Now, click on cell E2 and enter the following formula.
=COUNTIF(A2:A21;D2)

Now, click on cell E5 and enter the following formula.
=COUNTIF(B2:B21;D5)


You are now ready to use your worksheet. Cells D2 and D5 have drop downs. Just select in one of those cells and drop down arrow will appear. Click on the drop down arrow and select what you want to count.


If you have a large amount of data for your list, instead of typing each entry, you can reference a cell range. See my videos on You Tube.

Video #1 - This video shows how to use Validity in Data menu by referencing a list on another sheet in the same file.

Video #2 - This video shows how to use Validity in the Data menu referencing a list on a sheet in another file.

Hope this helps. If there is a certain feature you would like explained in Calc please leave comments explaining what you would like.

ATAN2

ATAN2 - This function return the inverse tangent of the specified x and y coordinates. This function gives the angle between the line passing through some point and the origin with the x-axis. The value that is returned is in radians.

Syntax:
ATAN2(number_x;number_y)

number_x - value of the x-coordinate
number_y - value of the y-coordinate

Example:
Suppose we have the point (10,20). What is the angle between the line passing through the given point and the origin with the x-axis.

=ATAN2(10,20) will return 1.10714872

Screen shot:

ACOSH, ASINH, ATANH

ACOSH - Returns the inverse hyperbolic cosine of a number.
ASINH - Returns the inverse hyperbolic sine of a number.
ATANH - Returns the inverse hyperbolic tangent of a number.

Syntax:

ACOSH(number)
ASINH(number)
ATANH(number)

number represent the cosh, sinh, or tanh of a number.

The number you are taking the inverse hyperbolic cosine of must be greater than or equal to 1.
The number you are taking the inverse hyperbolic tangent of must be greater than -1 and less than 1.

Here is a link explaining the hyperbolic functions.
http://en.wikipedia.org/wiki/Hyperbolic_function

Examples:

=ACOSH(5) will return 2.29243167
=ASINH(-2.2) will return -1.52966050
=ACOSH(.35) will return .36544375


Screen Shot of ACOSH():

ACOS, ASIN, ATAN

arccosine - The inverse function of cosine.
arcsine - The inverse function of sine.
arctangent - The inverse function of tangent.

Syntax:

ACOS(number)
ASIN(number)
ATAN(number)

number represents the cosine of an angle.

Example:



Now let's use calc to evaluate the arccosine of 3/5, arcsine of 4/5, and arctangent of 4/3.

=ACOS(3/5) will return .92729522
=ASIN(4/5) will return .92729522
=ATAN(4/3) will return .92729522

Note: The ACOS, ASIN, ATAN functions return the angle in radian measure. We will talk about getting an answer is degrees later with the DEGREE function.

Screen Shot of ACOS():

abs (Absolute Value)

Absolute Value - Represents the distance from one point to another on the number line. Absolute value is always returns a positive number.

Syntax:

ABS(number)

number represents what you are taking the absolute value of.

Examples:

ABS(-35) will return 35

ABS(23) will return 23

ABS(0) will return 0

Screen Shot: