<![CDATA[Math Is Fun Forum / Discussions About The Formulas]]> 2017-01-05T08:43:57Z FluxBB http://www.mathisfunforum.com/viewtopic.php?id=3306 <![CDATA[Re: Discussions About The Formulas]]> Hi everyone, I have a formula in an Excel sheet which works fine to find the sum of two cells, (      =ABS(C26-D26)*100    ) which would have say 150.25 or 1.2609.However, although it shows the sum,

1   I would like a formula that would show the answer as either positive or negative depending whether the 2nd cell is lower or higher than the primary cell?

2   I would like the same in another cell to show the difference as a percentage + or -  ?

3   Also i would like to know a good place to learn more about Excell formula's?

Thanks

]]>
http://www.mathisfunforum.com/profile.php?id=213423 2017-01-05T08:43:57Z http://www.mathisfunforum.com/viewtopic.php?pid=392900#p392900
<![CDATA[Re: Discussions About The Formulas]]> Let the equation be

Look at Vieta's Formula

]]>
http://www.mathisfunforum.com/profile.php?id=95904 2014-02-16T03:01:05Z http://www.mathisfunforum.com/viewtopic.php?pid=301403#p301403
<![CDATA[Re: Discussions About The Formulas]]> Can anyone please help me to solve cubic equations?I mean,what are the formulae for product and sum of the roots?Thanking you;Sutapa

]]>
http://www.mathisfunforum.com/profile.php?id=203940 2014-02-16T02:34:37Z http://www.mathisfunforum.com/viewtopic.php?pid=301401#p301401
<![CDATA[Re: Discussions About The Formulas]]> what about einstein's famous equation = e=mc²

]]>
http://www.mathisfunforum.com/profile.php?id=201638 2013-05-24T14:56:32Z http://www.mathisfunforum.com/viewtopic.php?pid=269485#p269485
<![CDATA[Re: Discussions About The Formulas]]> Barbie's profile says she has 2 posts, when she only has one. And chemistry is very interesting (yet my least favorite science).

]]>
http://www.mathisfunforum.com/profile.php?id=97578 2013-05-24T13:45:37Z http://www.mathisfunforum.com/viewtopic.php?pid=269471#p269471
<![CDATA[Re: Discussions About The Formulas]]>

And thanks for taking my "LaTex" goof up off the posts!

]]>
http://www.mathisfunforum.com/profile.php?id=33790 2012-07-28T05:11:20Z http://www.mathisfunforum.com/viewtopic.php?pid=227758#p227758
<![CDATA[Re: Discussions About The Formulas]]> Yes indeedy!  Combinatoris predates computers bunches.  I probably should have said something like "Regarding awareness of multisets, the percent of CS folks that are aware is greater than the percent of mathematicians that are aware."

Ah yes! Generating Functions.  Like x/(x^2-x-1) generates the Fibonacci sequence if you carry the division on forever past the decimal.

And as an attempt to answer your question, stefy, about introducing multisets vs GFs into  math curricula, multisets fit "hand in glove" with basic arithmetic and provide "written manipulatives" for understanding arithmetic.  GFs are a bit further down the road.

Hey bobbym, I am trying with this post another attempt at having a signature.  We will see if it makes it OK. And thanks for taking my "LaTex" goof up off the posts!   I wasn't sure how to do it.  Didn't want to mess anything else up. ]]>
http://www.mathisfunforum.com/profile.php?id=191063 2012-07-27T21:11:03Z http://www.mathisfunforum.com/viewtopic.php?pid=227755#p227755
<![CDATA[Re: Discussions About The Formulas]]> My point exactly.

]]>
http://www.mathisfunforum.com/profile.php?id=118786 2012-07-27T10:09:05Z http://www.mathisfunforum.com/viewtopic.php?pid=227661#p227661
<![CDATA[Re: Discussions About The Formulas]]> Uh guys, combinatorics was around way before computers.

]]>
http://www.mathisfunforum.com/profile.php?id=33790 2012-07-27T10:05:32Z http://www.mathisfunforum.com/viewtopic.php?pid=227656#p227656
<![CDATA[Re: Discussions About The Formulas]]> GF means generating function. There is a great deal of books that dels wit/mentions them. They are mostly represented by the generatingfunctionoligy.

Just because they are forced to deal with multisets doesn't mean they are ahead with them. Mathematicians have first used them and probably expanded them in some direction and probably have many applications for them.

]]>
http://www.mathisfunforum.com/profile.php?id=118786 2012-07-27T08:22:39Z http://www.mathisfunforum.com/viewtopic.php?pid=227640#p227640
<![CDATA[Re: Discussions About The Formulas]]> Hi stefy!

What is GF?  What comes to mind for me is "Gone Fishing" or "Great Fun" but I doubt that that's it.

I don't know if computer scientists have done much theoretical work in the field, but by the very nature of their programming languages they are forced to deal with multisets extensively.  That's what I was trying to convey by "ahead in dealing with multisets." ]]>
http://www.mathisfunforum.com/profile.php?id=191063 2012-07-27T05:41:55Z http://www.mathisfunforum.com/viewtopic.php?pid=227630#p227630
<![CDATA[Re: Discussions About The Formulas]]> noelevans wrote:

Computer scientists are way ahead of the mathematicians when it comes to dealing with multisets.  For example Visual Studio 12 has a list of 42 functions that operate on multisets.  However there seems to be quite an analogy between LaTex/PrettyMath and VisualStudio12/PrettyMultisets.  The encoding of Visual Studio 12 is much more complicated than the plain mathematical writing of multisets and their operations.  That seems quite analogous to the complicated coding in LaTex vs its output.  The basics of multiset theory have been known since the 1960's and maybe awhile longer.  The ideas are catching on finally in the mathematical community, but have not been introduced into curricula up through at least high school.

There are some interesting correlations between multisets and prime factors of a number M.  For example If M=12 then the multiset of prime factors of M is PM={2,2,3}.  The number of distinct subsets of PM is always equal to the number of factors of M (FM={1,2,3,4,6,12} has 6 elements).
Also a number M is a perfect square if and only if the number of distinct subsets of PM is odd.
Also HCF(M,N) = X(PMnPM);  LCM (M,N)=X(PMuPN);  MxN=X(PM+PN) where
X and x indicate products, n is for intersection and u is for union, + dumps PM and PN together.
The list is much longer than this, but this is enough to give the flavor of the correlation.

Why would they introduce multisets into curriculum if they haven't done so with GF's yet?

I am really amused thaou think there is anything theorethic that computer scientists found before mathematicians. One of the first mentions of multisets in math was by Dedekind in a paper of his in from 1888.

]]>
http://www.mathisfunforum.com/profile.php?id=118786 2012-07-25T14:43:19Z http://www.mathisfunforum.com/viewtopic.php?pid=227432#p227432
<![CDATA[Re: Discussions About The Formulas]]> Computer scientists are way ahead of the mathematicians when it comes to dealing with multisets.  For example Visual Studio 12 has a list of 42 functions that operate on multisets.  However there seems to be quite an analogy between LaTex/PrettyMath and VisualStudio12/PrettyMultisets.  The encoding of Visual Studio 12 is much more complicated than the plain mathematical writing of multisets and their operations.  That seems quite analogous to the complicated coding in LaTex vs its output.  The basics of multiset theory have been known since the 1960's and maybe awhile longer.  The ideas are catching on finally in the mathematical community, but have not been introduced into curricula up through at least high school.

There are some interesting correlations between multisets and prime factors of a number M.  For example If M=12 then the multiset of prime factors of M is PM={2,2,3}.  The number of distinct subsets of PM is always equal to the number of factors of M (FM={1,2,3,4,6,12} has 6 elements).
Also a number M is a perfect square if and only if the number of distinct subsets of PM is odd.
Also HCF(M,N) = X(PMnPM);  LCM (M,N)=X(PMuPN);  MxN=X(PM+PN) where
X and x indicate products, n is for intersection and u is for union, + dumps PM and PN together.
The list is much longer than this, but this is enough to give the flavor of the correlation.

]]>
http://www.mathisfunforum.com/profile.php?id=191063 2012-07-25T00:30:07Z http://www.mathisfunforum.com/viewtopic.php?pid=227378#p227378
<![CDATA[Re: Discussions About The Formulas]]> Hi noelevans;

Multisets or families as they are sometimes called are used in combinatorics.

]]>
http://www.mathisfunforum.com/profile.php?id=33790 2012-07-24T03:34:13Z http://www.mathisfunforum.com/viewtopic.php?pid=227334#p227334
<![CDATA[Re: Discussions About The Formulas]]> Regarding post #11 about sets:  I vote for doing just sets and not include real analysis.

But I would include formulas about the other half of set theory --- multisets.  Not many folks are aware of multisets.  Sets which allow only one copy of each type of element (typesets) form the set theory that corresponds to two valued (T/F) logic.  Multisets which have at least two of al tleast one type of object (Eg.  {x,x,y,z,z,z,t}, {x,x,y,z}, {x,y,y,y}, etc.) together with typesets forms a bigger set theory in which we have extra operations and relationships.  Eg. addition: {x,y,y}+{y,z,z} = {x,y,y,y,z,z}.  Similarity: A and B are similar if they have the same types of objects but not necessarily the same number of each type.  typeset operator T:  T{x,x,y,z,z,z} = {x,y,z} outputs one of each type of object.   Likeset operator L:  L{x,x,y,z,z,z} = {o,o,o,o,o,o}  changes all objects into one generic type object named "o".

Of course we still have union (based on maxima) and intersection (based on minima) and equality of sets.  Also there are subsets and differences of sets.

Restricting the types to "o" alone we obtain { }, {o}, {o,o}, {o,o,o}, ... to which we can give the names 0, 1, 2, 3, ...  These fit "hand in glove" with basic whole number arithmetic.  These sets can be used for "written manipulatives".  For example {o,o}+{o,o,o}={o,o,o,o,o} written in terms of their names is 2+3=5.  Inequalities come from the subset relationships.

One might have a bit of trouble finding much about these on the internet.  Most of the work done on these basic concepts has been done by computer sicentists since their programming languages usually include strings that may or may not have multiple copies of some symbols.

I'd be interested to know what you find out about multisets if you are so inclined.

]]>
http://www.mathisfunforum.com/profile.php?id=191063 2012-07-24T03:29:39Z http://www.mathisfunforum.com/viewtopic.php?pid=227333#p227333