using excel to create data sets

[Jess]

Hi, i'm using the cells to create data sets, however, the function i typed in
shows "#NUM!".

I checked over my function and it came down to the problem that excel
wouldn't let me calculate -0.2318^(5/4).

I don't really understand why, since I can definitely calculate the value
(to be -0.1608) using a scientific calculator.

Can someone help me?

 

[Ron@Buy]

A simple solution is to reformat your equation to (0.2318^(5/4))*-1