Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello,
I am currently undertaking some statistical analysis in excel but have encountered a data problem, my data is annual, and i need it monthly, hence need to take the 12th root of the numbers, but this doesnt seem available in excel, can you please advise kind regards |
#2
![]() |
|||
|
|||
![]()
How about:
=YourNumber^(1/12) or =POWER(YourNumber,1/12) tj "Mark" wrote: Hello, I am currently undertaking some statistical analysis in excel but have encountered a data problem, my data is annual, and i need it monthly, hence need to take the 12th root of the numbers, but this doesnt seem available in excel, can you please advise kind regards |
#3
![]() |
|||
|
|||
![]()
Mark,
The root of a number in XL is the reciprocal of the root that you want ie =YourNumber^(1/12) Please do not multi-post to different newsgroups it is not encouraged for various reasons Regards Sandy -- to e-mail direct replace @mailinator.com with @tiscali.co.uk "Mark" wrote in message ... Hello, I am currently undertaking some statistical analysis in excel but have encountered a data problem, my data is annual, and i need it monthly, hence need to take the 12th root of the numbers, but this doesnt seem available in excel, can you please advise kind regards |
#4
![]() |
|||
|
|||
![]()
thank you, i should have thought of that
"Mark" wrote: Hello, I am currently undertaking some statistical analysis in excel but have encountered a data problem, my data is annual, and i need it monthly, hence need to take the 12th root of the numbers, but this doesnt seem available in excel, can you please advise kind regards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Does Excel 2000 have a 'datedif' function to calculate the number. | Excel Worksheet Functions | |||
Excel Send To function problem | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Missing function in Excel 2003 | Excel Discussion (Misc queries) |