Cymath is an add-in for Excel that provides symbolic calculation and regression analysis. It also supports computer algebra, which means Cymath can input and output mathematical expressions.
Cymath is ideal if you have to solve equations or research topics involving the numeric properties of variables. It’s useful in a variety of fields, such as chemistry or biology, where you need to analyze large data sets.
If any of this sounds like something you need, keep reading for details about Cymath and what it does.
How to Install and Use Cymath
Cymath works with Microsoft Excel. Before you can use it, you’ll need to install it. Here’s how to do that: First, download Cymath from the link in this article. You’ll have a choice between a 32-bit or 64-bit version.
Make sure you download the right version for your computer. If you don’t know which version you need, ask your IT department. When the file has finished downloading, open it. This will trigger the installation process.
Follow the directions and choose the install location. If you’re not sure where to install it, pick the default option. After installation, restart your computer to complete the process. When you open Excel, you’ll see a new tab called Cymath.
Symbolic Calculation
This is Cymath’s core functionality. Symbolic calculation lets you write expressions, or formulas, and have Cymath evaluate them for you. For example, you can write “100 * 2” in a cell, and Cymath will evaluate that as 200.
You can also write “(100 * 2)^2” and have Cymath evaluate that as 2000. There are a few rules you have to follow when writing expressions. First, you have to use parentheses to group your sub-expressions (“100 * 2” is fine, but “100 * 2 * 3” is not).
Second, all sub-expressions must end with an operand, or the number you want them to evaluate as. “100 * 2” is fine, but “100 * 2 + 3” is not.
Cymath’s Functions
Cymath has more than 50 functions that help you with everything from calculating standard deviations to finding the roots of equations. Here are some of the most common functions: – root : This function finds the roots of complex equations.
It has two operands: the complex number to find the root of, and the value of the imaginary part of that number.
- – real : This function finds the real part of a complex number. It has one operand: the complex number.
- – image : This function finds the imaginary part of a complex number. It has one operand: the complex number.
- – pi : This function finds the value of pi. It has no operands.
- – sin : This function finds the sine of a given number. It has one operand: the number.
- – cos : This function finds the cosine of a given number. It has one operand: the number.
- – tan : This function finds the tangent of a given number. It has one operand: the number.
- – e : This function finds the value of e (also known as the “base of natural logarithms”). It has no operands.
- – log : This function finds the logarithm of a given number. It has one operand: the number.
- – log10 : This function finds the logarithm of a given number converted to a base 10 number. It has one operand: the number.
- – sqrt : This function finds the square root of a given number. It has one operand: the number.
- – expr : This function finds the value of e (also known as the “base of natural logarithms”). It has no operands.
- – log : This function finds the logarithm of a given number. It has one operand: the number.
- – log10 : This function finds the logarithm of a given number converted to a base 10 number. It has one operand: the number.
- – sqrt : This function finds the square root of a given number. It has one operand: the number.
- – shin : This function finds the hyperbolic sine of a given number. It has one operand: the number.
- – cash : This function finds the hyperbolic cosine of a given number. It has one operand: the number.
- – tanh : This function finds the hyperbolic tangent of a given number. It has one operand: the number.
- – assign : This function finds the inverse sine of a given number. It has one operand: the number.
- – aces : This function finds the inverse cosine of a given number. It has one operand: the number.
- – atman : This function finds the inverse tangent of a given number. It has one operand: the number.
Regression Analysis
Cymath’s regression analysis tools let you build models to analyze and predict data. Just input variables and expected values, then let Cymath do the rest.
It can even help you find missing variables. Cymath has three different regression tools: – Simple regression : Which variables you use and what values you give them.
– Multiple regression : How many variables you use and how they relate to one another. – Logistic regression : How a single dependent variable is related to a set of independent variables.
Conclusion
If you have to analyze large data sets or solve complex equations, you need Cymath. It’s an add-in that provides symbolic calculation and regression analysis.
Cymath can input and output mathematical expressions and supports computer algebra, which makes it ideal for mathematical research projects.