ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Need help simplifying t test information (https://www.excelbanter.com/new-users-excel/88419-need-help-simplifying-t-test-information.html)

jnoding

Need help simplifying t test information
 
I am needing more simplified information on how to produce a t test in Excel.

Alex

Need help simplifying t test information
 
'jnoding'

Maybe you could give more information as to what you need?

As a starting point a t-test can be done in Excel using =TTEST. The
arguments a

=TTEST(array1, array2, tails, type).

'Array1' and 'Array2' are the two sets of data that you want to 'compare.
'Tails' is for whether you want a one-tailed or two-tailed test.
'Type' is whether your sample is array1 and array2 are paired, have equal
varaince, or unequal variance.

Does this help any? I would also add that:

(1) Excel is not strong with statisitcal analysis but can handle most basic
stuff.
(2) If you actually want to learn more about the ttest as a statistical
procedure then I would 'google ttest. There is a welath of info out there.

Regards


Alex





"jnoding" wrote:

I am needing more simplified information on how to produce a t test in Excel.



All times are GMT +1. The time now is 04:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com