What is the chance to transfer to UC Berkeley after two years from a small private school in California if the transferee is a california resident, a psychology major and has a 3.94 GPA?
This may help, UC transfer GPA by campus and major: https://www.universityofcalifornia.edu/infocenter/transfers-major
I think they accept transfers in this order of priority:
CCC to UC
UC to UC
CSU to UC
Other schools in California to UC
Out of state to UC
It’s a pretty low chance to be honest. Going off this website for data(https://www.universityofcalifornia.edu/infocenter/transfers-major). UCB accepted 4,301 students last year out of 19,053 applicants, and 2,407 students were accepted from CCC. For psychology there was only a 8% admit rate for that major(all applicants).
If you really want to transfer to Berkeley I would suggest going a CCC then transfer, as it is a lot easier and you have the work ethic to get the GPA. I wish you luck and hope you get in with whatever you decide to do!