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
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