limitations of spreadsheet

[transkawa]

I was reading a document, produced by Mathcad, on the limitations of
spreadsheet for mathematical calculations.
Can someone help me in this regard:
1. If I want to extend Excel for mathematical calculations, how can this
be done?
2. Can Excel also be extended for graphing?
Thanks in Advance

 

[Stan Brown]

I was reading a document, produced by Mathcad, on the limitations of
spreadsheet for mathematical calculations.
Can someone help me in this regard:
1. If I want to extend Excel for mathematical calculations, how can this
be done?
2. Can Excel also be extended for graphing?

You'll need to define your terms for both of these.

For (1), there are literally thousands of add-ins, some free and some
selling for thousands of dollars. If you have a particular
calculation in mind, you want to create a user-defined function,
which is not particularly hard to do if you have even rudimentary
Visual Basic skills. (If you don't, there are zillions of books and
Web sites to help you.)

For (2), of course Excel makes some kinds of graphs natively. For
others, a good starting point is to Google for

graph normal distribution excel

because most solutions posted are not specific to the normal
distribution.