Lab 10

Today in the lab, we used Excel to figure out the probabilities of the grade distribution in a class. In order to find these probabilities, we had to first write algorithims to return the correct grades pending on a student's test score. Luckily for me, I took K201 in the fall and have had experience working with Excel so I found this task to be very easy. We also learned about the Shannon and Harltey measure of probability and information. The Shannon measure is a lot more accurate and precise. The Hartley measure is almost an average and will return the same number no matter how many numbers you are trying to find the Entropy of.

Data Analysis

In Friday's lab, we learned how to use Excel to analyze large groups of data. I'm currently in Finite mathmatics and we have been studying linear models and graphs. There are equations to finding slopes of equations as well as other information. With the aid of Microsoft's Excel however, these functions can be performed much more easier. Actually, with Excel, you can figure out even more information in the time of a couple clicks, such as Coefficiants, Intercepts, and etc.