Mad As A Box Of (Soapy) Frogs

What does the idiom “Mad As A Box Of (Soapy) Frogs” mean?

Definition:

extremely mentally unstable; psychotic; detached from reality.

For example:

“Joe thinks the company could fail, but I’d say he’s mad as a box of frogs.”