Improving Math Study Skills in Excel

suzzy · 2009-08-26 22:34:49

Hi All,

I think this is a great forum to exchange personal experiences with math. I enjoyed reading the posts here, so I decided to share some things I have discovered lately which I think would be very useful for anyone here. Specifically I'd like to recommend you a website where you can find very helpful and free math learning tools such as "Base System Conversion", "Goodness of Fit Tester" and "Test of Independence".

With all this said, I will write down all the tools and their links you will find at the website.

- Base System Conversion:
http://spreadsheetzone.com/templateview.aspx?i=234

- Basics of Exponential Functions:
http://spreadsheetzone.com/templateview.aspx?i=265

- Basics of Logarithmic Functions:
http://spreadsheetzone.com/templateview.aspx?i=266

- Cartesian Coordinates:
http://spreadsheetzone.com/templateview.aspx?i=267

- Derivatives:
http://spreadsheetzone.com/templateview.aspx?i=268

- Polar Coordinates:
http://spreadsheetzone.com/templateview.aspx?i=274

- Goodness of Fit Tester:
http://spreadsheetzone.com/templateview.aspx?i=197

- Simple Linear Regression:
http://spreadsheetzone.com/templateview.aspx?i=204

- Standart Normal Distribution
http://spreadsheetzone.com/templateview.aspx?i=104

- Test of Independence:
http://spreadsheetzone.com/templateview.aspx?i=206

- Basics of Trigonometric Functions
http://spreadsheetzone.com/templateview.aspx?i=276

I want to emphasize that you will work with these tools in Excel. You can preview the templates before downloading and see how they work.
I think they are really very helpful in showing the basic concepts and processes about specific math topics. So I think everyone interested in math and science should take a look at them.

If you have any problems with them, you can send me a message.

Cheers,

Suzzy

ahmad01 · 2009-09-29 22:55:10

If Fuzzy theory maybe you know? spreadsheet?

andrewharry · 2011-03-07 22:06:48

I am starting to learn Excel and I am pretty good at maths as well. I checked out a few of these templates and found them very useful. I am looking for some market data excel templates. I searched withing the templates but did not find an apt one can you provide me some to choose from.

Last edited by andrewharry (2011-03-07 22:07:37)

gAr · 2011-03-07 22:34:08

Hi,

What you need to use is a software specifically to do mathematics. Use a CAS to learn math.
Try software like maxima.
I'm not sure whether that allows scripting. I found one that does it, try: http://eumat.sourceforge.net/

andrewharry · 2011-03-09 22:18:11

gAr wrote:

Hi,
What you need to use is a software specifically to do mathematics. Use a CAS to learn math.
Try software like maxima.
I'm not sure whether that allows scripting. I found one that does it, try: http://eumat.sourceforge.net/

Thanks for the help I will use CAS to learn what is required for options excel and also check out maxima. I hope it works out for me.

Last edited by andrewharry (2011-03-09 22:18:47)

bobbym · 2011-03-09 22:43:01

Hi andrewharry;

Or see if you can google around and find an old copy of Mupad lite 2.53. It is free and almost as strong as Mathematica or Maple.

gAr · 2011-03-09 22:55:46

Hi bobbym,

I searched for Mupad lite a few days back, it's not available for download in its official site.
I wouldn't really trust an execuatable found anywhere else!

bobbym · 2011-03-09 23:13:25

Hi gAr;

The old Mupad site or even the scilab sites are not live anymore. Matlab, I think bought Mupad which is a shame.

I wouldn't really trust an execuatable found anywhere else!

That is an interesting point. Just let me say that the worst attacks I have ever seen on someone else's machine were programs that came from respectable sites. One is a famous antivirus program that claims to have 100 million users. There really is no guarantee that any program is safe. There are lots of things you can do to have your own personal peace of mind about a new program.

That is why I did not direct him to a specific link that I know of. If something were to go wrong then it would be my fault for recommending the link. Like I said there are no guarantees even from the best sites or even the homepage of the app.

gAr · 2011-03-09 23:23:50

Well, yes. Any executable found around isn't safe. But I'd trust a software if many people are using it.
Anyway, was there anything extra in mupad which is not found in other free CAS?

bobbym · 2011-03-09 23:40:10

Hi gAr;

Mupad is high quality, with the best graphics of any of the CAS. It had more commands than say Maxima. Several books have been written about it. It is essentially a clone of Maple. I would place it as stronger than Maxima. Maxima uses lisp as its basic language, Mupad uses a procedural language. So if you are coming off of a language like C++ or some BASIC it is easier to migrate to Mupad.

Like all CAS it is very difficult to get started with. It has 4 - 5 thousand commands. The help is huge. Anyone could clearly spend their entire life on one version without ever knowing anything more than a small part.

gAr · 2011-03-09 23:47:35

Hi bobbym,

Oh, I see. I didn't know that.

bobbym · 2011-03-09 23:55:04

Hi gAr;

A CAS is a like a gun. Some are better than others but in a duel more often than not the better man and not the better weapon wins. Any CAS is good and in the right hands it does not matter much whether you use Maple, Mupad, Sage, Mathematica, Maxima or Derive. The best man wins with any package.

Also the converse is true, in the hands of a bungler no package will help.

gAr · 2011-03-10 00:12:46

Hi bobbym,

You said it!
And I mainly use Sage because I like the python scripting, which I find it to be an easy and clear syntax. But yes, ultimately it depends on the user.

bobbym · 2011-03-10 00:21:23

Python is pretty popular for the scripting. They also are producing their own CAS. They call it sympy.

gAr · 2011-03-10 00:39:28

Yes, I'm aware of that. And sympy, numpy, scipy are all included in sage too.

bobbym · 2011-03-10 00:54:38

We should be very grateful for the fact that we live in a time when there are such things to help us do math.

gAr · 2011-03-10 01:04:27

Indeed, so much is available in those packages. I wonder if I'll ever know what are included, and they keep on adding more functions.
Algorithms and hardwares just keep improving, really great

bobbym · 2011-03-10 01:18:16

I keep looking at a different subject in the help mostly everyday. There is no way for anyone to know a whole CAS.

Math Is Fun Forum

#1 2009-08-26 22:34:49

Improving Math Study Skills in Excel

#2 2009-09-29 22:55:10

Re: Improving Math Study Skills in Excel

#3 2011-03-07 22:06:48

Re: Improving Math Study Skills in Excel

#4 2011-03-07 22:34:08

Re: Improving Math Study Skills in Excel

#5 2011-03-09 22:18:11

Re: Improving Math Study Skills in Excel

#6 2011-03-09 22:43:01

Re: Improving Math Study Skills in Excel

#7 2011-03-09 22:55:46

Re: Improving Math Study Skills in Excel

#8 2011-03-09 23:13:25

Re: Improving Math Study Skills in Excel

#9 2011-03-09 23:23:50

Re: Improving Math Study Skills in Excel

#10 2011-03-09 23:40:10

Re: Improving Math Study Skills in Excel

#11 2011-03-09 23:47:35

Re: Improving Math Study Skills in Excel

#12 2011-03-09 23:55:04

Re: Improving Math Study Skills in Excel

#13 2011-03-10 00:12:46

Re: Improving Math Study Skills in Excel

#14 2011-03-10 00:21:23

Re: Improving Math Study Skills in Excel

#15 2011-03-10 00:39:28

Re: Improving Math Study Skills in Excel

#16 2011-03-10 00:54:38

Re: Improving Math Study Skills in Excel

#17 2011-03-10 01:04:27

Re: Improving Math Study Skills in Excel

#18 2011-03-10 01:18:16

Re: Improving Math Study Skills in Excel

Board footer