Math 241 – EXCEL

9/30/08

 

 

You need not turn in anything new for this homework. You should have gotten all of your graded homework back. Redo all the ones you got wrong.

 

Learn to name functions better.

 

Things to try if time allows:

 

1. Study the VBA function Dot defined as follows. Try it and experiment with it.

 

 

2. Generate 10,000 numbers using rand()^2. Histogram the results. Use EXCEL’s trendline to find a good functional fit to the resulting histogram.

 

                        TEST ON THURSDAY