Hi, My Son has some home work to work out the frequency of occurrence in some data and to work out the Mode. He is 9 years old and we are going to do this in his school note book. However I use spreadsheets at work and wanted to try and work this out using excel, more for my own interest than anything else but am struggling with getting the formulat correct. I have read the help file but it hasn't helped me. I have a medium knowledge of Excel better than basic but i am not an expert.
I have attached the spreadsheet i am using and would appreciate any help.
Bookmarks