contestada

I need help with this. in excel for my project i need to find the % of fish caught with the table hooks (185 and 568). I have to use formulas,functions and have the answer in percentage style. I know how to do that but the answer is suppose to be an average of 35% and i keep getting 62% for the first row and 59% for the second. Here is the table:
Thanks in advance, will give branliest answer.

I need help with this in excel for my project i need to find the of fish caught with the table hooks 185 and 568 I have to use formulasfunctions and have the an class=

Respuesta :

iraipkids

Answer:

223 hooks

Explanation:

i belive so yeah man

MrRoyal

Excel formulas are expressions used to perform computation.

The Excel formulas to enter in column F are = B5/(SUM(C5:E5)) and = B6/(SUM(C6:E6))

From the question, we can assume the following:

  • Column B represents the fish caught with table hook
  • The sum of entries in columns C through E represent the total number of fish caught

The percentage of fish caught with table hook is then calculated as:

Percentage = Hook/Total

Rewrite properly as:

Percentage = B/(C + D + E)

Using the cell names, we have:

Percentage = B5/(C5 + D5 + E5)

Using the sum function, we have:

Percentage = B5/(SUM(C5:E5))

So, the formulas to enter in cells F5 and F6 are:

= B5/(SUM(C5:E5)) and = B6/(SUM(C6:E6))

Read more about Excel formulas at:

https://brainly.com/question/14820723

Otras preguntas