Hi,

I need some help with the below set up for Mode.

Insert a new tab labeled MMM and set up an empty table like the one in the Data tab. Populate the table by linking the cells to the data in the Data tab. Then, complete the following:

1. Figure out the mean, median, and mode of the hourly wages. Then multiply the total project hours times each one.
2. type a rationale statement for how you calculated the mean, median, and mode.
3. submit a summary describing how each measure (mean, median, and mode) could be used for this project. Include your recommendation on which is the most appropriate and why.

I have tried these 2 formuals and I am not able to get an actual number. I am not sure if it matters, all the of the data is copied from another worksheet by using =data!A1

=MODE.SNGL(C2:C9)

=MODE.SNGL("C2:C9")