Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
miaoj5
 
Posts: n/a
Default Statistical tests and data type


I have data in log2 format. I just came across some article which says
that logged data should be avoided for statistical tests like T-tests,
F-tests or Mann-Whitney tests.

I am doing these tests in excel so wondering if anybody who performs
such tests regularly in excel can flash some light??


--
miaoj5
------------------------------------------------------------------------
miaoj5's Profile: http://www.excelforum.com/member.php...o&userid=27690
View this thread: http://www.excelforum.com/showthread...hreadid=472073

  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

What was the context of that statement? If the data were lognormally
distributed, taking logs before doing these tests would be mandatory.

Jerry

miaoj5 wrote:

I have data in log2 format. I just came across some article which says
that logged data should be avoided for statistical tests like T-tests,
F-tests or Mann-Whitney tests.

I am doing these tests in excel so wondering if anybody who performs
such tests regularly in excel can flash some light??


  #3   Report Post  
miaoj5
 
Posts: n/a
Default


Actually, the data that I am working with is a microarray data and I
have log2 transformed as well as natural data. Log 2 tranformation was
used for better normalisation in the data series.
Is this what you wanted to know?

The article that I talked about was explaning these tests in general


--
miaoj5
------------------------------------------------------------------------
miaoj5's Profile: http://www.excelforum.com/member.php...o&userid=27690
View this thread: http://www.excelforum.com/showthread...hreadid=472073

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
How to Calculate a sum between a rolling data range. Charles Johnston Excel Discussion (Misc queries) 3 June 1st 05 08:29 PM
Statistic: Problem with two one sided t-test Rosario Excel Discussion (Misc queries) 4 May 5th 05 05:23 PM
Please help me, losing hair (chart with 2 data against time) Satraver Charts and Charting in Excel 2 February 4th 05 06:35 PM
Effect of Conditional Formatting, Data Validation Bill Sturdevant Excel Discussion (Misc queries) 1 January 25th 05 11:50 PM


All times are GMT +1. The time now is 03:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"