The purpose of this Blog

I created this blog back in 2005 because I had to for a class in College, but since then I have used to talk about various topics. It may not have anything interesting for most people, but that's because I am not catering to the masses. I am basically talking about whatever comes to mind when I think I know enough to talk about it. You will see that the topics are a scope of things that usually impact me. If you want more information and stories then you can stop by my website linked on the left. Feel free to comment and browse. I think some spam bots may have beaten you to it though.

Saturday, March 25, 2006

Lab 8 Data Analysis

Yesterday's lab was using Excel to perform linear regression and analize data to find the slope, y-intercept and error of our best fit line. Our analysis involved multipling the x,y coordinates and and squaring them. I used Excel to solve my equations. I learned to construct the equation in a cell and labeled my work. I found the square root function in Excel which I have never used. It was useful in finding r. I did not find it necessary to use a calculator to check my work because of the other new feature we learned. Data Analysis is a great feature in Excel. It does the work in 3 seconds with a lot more analysis. My steps followed the directions pretty closely eventhough I use Excel quite frequently. I decided to break up the formula by numerator and denominator and then use a third cell to divide them. Except to find r, in which I used four cells. The first cell found my numerator and the second found the denominator before being square rooted. The third then square rooted the denominator. And the fourth cell then divided them to get my error from the best fit line. Overall this was a good lab personally because it taught me things I did not know about a prorgam I use almost daily.

Friday, March 03, 2006