Hello,
I was wondering how I would go about taking the log10 of a few of my columns and then having the data posted.
E.g. For Column X, take the values (Y) and perform log10(Y) and save values under Column X Log
If I understand you correctly, this is quite easy. Create the new column logX. Create a formula for the column (right click on the column and select Formula). In the left column select Transcendental and you will see log10 option. Simply put the column you want to transform in the parentheses.
Hi @SI-2000
for me the fastest way would be to select the columns you want to transform right click them and follow the menu in the picture: New formula column >> transform >> log
you can do that to as many columns you select in one go.
let us know if it works for you,
ron
Ron's method is definitely my favorite interactive method. If you need to script this, the 3rd line in the script below gives an example--the line before that just makes a table so we have something to work with. This gets a good bit trickier when you don't know the name of the column you're transforming ahead of time. (See "expression handling" in the scripting guide for details.)
Names Default To Here(1); dt = as table(J(20,1,randomuniform()), << column names({"X"})); dt << new column ("log10x", formula(log10(:x)));
@SI-2000
Your request has been answered by multiple community members. However, I think coming to the community on such a fundamental JMP function will be very efficient for your JMP learning and usage. There are such tools as the Discovering JMP document, JMP tutorials and the New User Welcome Kit that will introduce you to JMP much faster. I encourage you to take the time to explore these items. I believe that will make your entry into the JMP world far more enjoyable.
Help=>Discovering JMP
Help=>Tutorials=>Beginners Tutorial
Help=>JMP on the Web=>JMP Welcome Kit
