turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Discussions
- :
- Log2 transformation

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 4, 2016 3:03 PM
(3990 views)

Hi I have a list of protein measurements that have a wide spread (usually on the higher end)- inorder to compress the dynamic range to look at correlations with other parameters, I want to convert it to a log2 scale (primarily to be consistent with how someone else had analyzed it). I see natural log and log10 options in the formula transfrorm but none for log2. If I try to manually edit the formula from log[x] to log2[x], it throws an error. Any ideas to be able to do this? Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

The formula is: Log(:Column, 2)

In the formula editor if you select "Log" then you see one spot for the column name. After you enter the column click on the ^ (in the top bar of formula editor) and a subscript "10" will magically appear, you can then click on the 10 to replace it with a 2.

In the formula editor if you select "Log" then you see one spot for the column name. After you enter the column click on the ^ (in the top bar of formula editor) and a subscript "10" will magically appear, you can then click on the 10 to replace it with a 2.

5 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

In the formula editor if you select "Log" then you see one spot for the column name. After you enter the column click on the ^ (in the top bar of formula editor) and a subscript "10" will magically appear, you can then click on the 10 to replace it with a 2.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Thank you. That worked!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

TRR21,

Please mark this discussion as "Solved". It really helps other users when looking for answeres

Please mark this discussion as "Solved". It really helps other users when looking for answeres

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

TRR21,

I am getting a bit picky here, but you marked your response indicating "Thank You" as the solution. Karen's answer is what needs to be marked as the solution, so the users can go directly to the solution, and so that Karen gets credit for the solution.

Jim

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content