World Clock

Monday, May 25, 2015

Basic Statistics on Excel

I am always fascinated with Excel and its power. You think of something, you will find it in excel when it comes to analysis. Ofcourse it might be necessary to get some online help as well.

I always use excel to plot  graphs with  trend lines along with line equation and R.Squares. Today, I just wanted to get excel to give me the results in a table with basic statics and not on a graph.

The "Linest" formula does that magic pretty much easily with some twigs.

I found an online help that was very good.
http://burro.cwru.edu/academics/Astr222/UsingLINEST.pdf

No comments:

Post a Comment