please help
i have to make data tables
and i dont know how to find
the averages
2007-12-10 14:05:40 · 6 answers · asked by Anonymous in Computers & Internet ➔ Software
=avg(a1:an)
2007-12-10 14:13:54 · answer #1 · answered by Anonymous · 0⤊ 0⤋
i could be VERY careful approximately working a regression in excel. rather in case your tips is poorly conditioned. Numerical blunders isn't as heavily watched in Excel. you will ought to lots of the time do your regression assessment in R, SAS, Matlab, or SPSS.
2016-10-11 00:50:36 · answer #2 · answered by parson 3 · 0⤊ 0⤋
Go Insert_choose function. There will have average function that you can choose. If you can not find it, just go to search for function and type average.
2007-12-10 14:14:09 · answer #3 · answered by Ritchie B 1 · 0⤊ 0⤋
Let's say your numbers are in column A. Such as:
.......A
1....49
2....50
3....48
And you want your formula in cell B1. Your formula would be:
=avg(A1:A3)
Cheers.
2007-12-10 14:10:26 · answer #4 · answered by Typing Tornado 4 · 1⤊ 0⤋
i believe its
=AVG(cells like a1),(another),(another)
2007-12-10 14:09:21 · answer #5 · answered by hacker 2 · 0⤊ 0⤋
=(AVG(cells:cells))
2007-12-10 14:15:37 · answer #6 · answered by John S 7 · 0⤊ 0⤋