Do Language Models Mirror Human Confidence? Exploring Psychological Insights to Address Overconfidence in LLMs