Failing to reproduce experimental results with broken equipment then faking the data with an excel function to get the teachers off my back...
I had the exact opposite experience. I once failed to get an experiment working, but kept trying until I was the last person in the lab. Eventually the professor asked why I hadn't finished, and together we discovered the spectrometer was utterly broken.
He gave a a grade of 0-25% to everyone who got the "right" answer, depending on how realistically they faked it (some people didn't bother to add noise or quantize their answers).