Can you go to college if you're stupid?

People do shit like biochemistry and accounting and all that, and I just feel way too stupid to do anything. I hate being around my smarter friends because it makes me feel useless, but I don't like being around dumb people either because I noticed dumb people aren't as fun or nice as smart people tend to be.