I think the minority has the "answer", being 42... percent.
Seriously, it's a complex subject because
different kinds of projects require different environment.
different kinds of people require different environments.
different kinds of work require different environments.
And unfortunately offices are associated with status so some people who don't care about quiet are going to require an office if others are getting offices.
Plus offices are more expensive and even cubes cost about $5k the last time I saw costs 5 years ago. Crazy eh? So offices must cost even more to provision at a big company.
My last job, we had "bubblers" and and they really did cut down on background noise a lot. For highly collaborative projects, we went to the collaborative floor and worked in rooms with 30-40 people. Noisy, fast access to every team on the project.
For less collaborative projects, we worked in our own area and had meetings in one of the 8 tiny meeting rooms on the floor or one of the 2 big meeting rooms. The bigger rooms required formall booking while the smaller ones did not.
Our walls were high enough for privacy but didn't go to the cieling.
Working from home was an option but I never really got used to it. I'd do 1 day out of 10 at most.