calculating roots greater than 2
 

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

calculating roots greater than 2
 

Try this:

=A1^(1/12)

Regards,
KL

"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

calculating roots greater than 2
 

thanks

"KL" wrote:

Try this:

=A1^(1/12)

Regards,
KL

"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