You are here:

Advanced Math/Mathematical constants in Excel.

Advertisement


Question
Dear Prof Scott

http://en.wikipedia.org/wiki/Microsoft_Excel‎

http://en.wikipedia.org/wiki/Mathematical_constant

http://www.ebyte.it/library/educards/constants/MathConstants.html

http://pi.lacim.uqam.ca/eng/table_en.html‎

http://reference.wolfram.com/mathematica/tutorial/MathematicalConstants.html

http://books.google.co.in/books?id=TWiUKWP-ACIC&pg=PA5&lpg=PA5&dq=mathematical+c


1. Is it possible to input mathematical constants in cell/s using
functions in Excel ?.

For example : PI, e, Pythagoras constant, Omega Constant, Ramanujan - Soldner constant, Golden Ratio, Legendre's constant etc ?.

2. Will it be useful to create functions for inputting mathematical constants in excel spreadsheets (if not available) ?.


Thanks & Regards,
Prashant S Akerkar

Answer
The constants that Excel has are the constant π, expressed as =pi(); and e, expressed as =exp(1).

There is also some talke of Euler's number e, Feigenbaum constants α and δ, The golden ratio φ and the Euler–Mascheroni constant γ, but I never have used them or know  how to express them.

As far as the user defining constant, it is possible to name as cell and input that number there.

For example, a cell could by named Omega and the Omega Constant could be entered.
Wherever the Omega constant was used as =Omega().  Perhaps it coulD juat be Om().
Other cells could be stored similarly.

The constants could be kept in a special file called Math.xls.  When needed, just open the file and copy them in.  Also, that file could be referenced, but I find it easier to copy them in.Maybe that's because I have a massive file called characters with sheets named Symbol, Greek, Character, High Power, Math, Symbols, and DOS Commands.  The file is used to store the characters themselves so I don't have to remember the number of the character.

For example, A is 65, B is 66, return is 10-13, but it takes awhile to remember what they are.

Advanced Math

All Answers


Answers by Expert:


Ask Experts

Volunteer


Scott A Wilson

Expertise

I can answer any question in general math, arithetic, discret math, algebra, box problems, geometry, filling a tank with water, trigonometry, pre-calculus, linear algebra, complex mathematics, probability, statistics, and most of anything else that relates to math. I can also say that I broke 5 minutes for a mile, which is over 12 mph, but is that relevant?

Experience

Experience in the area; I have tutored people in the above areas of mathematics for over two years in AllExperts.com. I have tutored people here and there in mathematics since before I received a BS degree back in 1984. In just two more years, I received an MS degree as well, but more on that later. I tutored at OSU in the math center for all six years I was there. Most students offering assistance were juniors, seniors, or graduate students. I was allowed to tutor as a freshman. I tutored at Mathnasium for well over a year. I worked at The Boeing Company for over 5 years. I received an MS degreee in Mathematics from Oregon State Univeristy. The classes I took were over 100 hours of upper division credits in mathematical courses such as calculus, statistics, probabilty, linear algrebra, powers, linear regression, matrices, and more. I graduated with honors in both my BS and MS degrees. Past/Present Clients: College Students at Oregon State University, various math people since college, over 7,500 people on the PC from the US and rest the world.

Publications
My master's paper was published in the OSU journal. The subject of it was Numerical Analysis used in shock waves and rarefaction fans. It dealt with discontinuities that arose over time. They were solved using the Leap Frog method. That method was used and improvements of it were shown. The improvements were by Enquist-Osher, Godunov, and Lax-Wendroff.

Education/Credentials
Master of Science at OSU with high honors in mathematics. Bachelor of Science at OSU with high honors in mathematical sciences. This degree involved mathematics, statistics, and computer science. I also took sophmore level physics and chemistry while I was attending college. On the side I took raquetball, but that's still not relevant.

Awards and Honors
I earned high honors in both my BS degree and MS degree from Oregon State. I was in near the top in most of my classes. In several classes in mathematics, I was first. In a class of over 100 students, I was always one of the first ones to complete the test. I graduated with well over 50 credits in upper division mathematics.

Past/Present Clients
My clients have been students at OSU, people who live nearby, friends with math questions, and several people every day on the PC. I would guess that you are probably going to be one more.

©2016 About.com. All rights reserved.