The majority of Americans said they would rather have their money sit in cash than endure market swings, according to a new report.