Dog count

408 people filled in a Web survey, typing in their favorite pet. Dog, cat, bird, whatevs. The data was put into a spreadsheet you can download. Here's part of it:


Write a program to count the number of times someone typed "dog". Or "DOG", or "Dog", or "Dog ", or " dOg ". In other words, can doesn't matter, and you need to get rid of spaces.

The Run button has been created for you, and some of the code written (the easy stuff). Complete the program.

Use a For loop.

Upload your Excel file.

(If you were logged in as a student, you could submit an exercise solution, and get some feedback.)