PLEASE HELP, using excel I need to create THREE properly formatted, separate graphs using the data below:

• Create a graph summarizing the families as the independent variable, and the number of individuals as the dependent variable. Again, how you choose to display this data is up to you (i.e., frequency, averages, total counts).
• A rank abundance graph (as described above).
• A graph displaying any trends in color preference, or the number of individuals found in each color pan. Remember, you have three colors of pans (so each should be on one graph). You will need to determine which is your independent/dependent variable and determine how you want to display the number of individuals (frequency, averages, total counts).

• will also need to calculate the Shannon's Index AND the Simpson's Index using the class data.

Student 1 PANS Blue Student 2 PANS Blue Student 3 PANS Blue Student 4 PANS Blue Student 5 PANS Blue Student 6 PANS Blue Student 7 PANS Blue Family or Super-family Yellow White Yellow White Yellow White Yellow White Yellow White Yellow White Yellow White 1 9 10 3 1 5 3 24 8 8 1 2 3 4 7 3 1 1 5 3 0 5 2 0 2 8 1 1 1 0 1 0 6 3 2 0 0 1 3 4 0 1 3 0 0 4 1 1 1 16 5 4. 9 1 Agromyzidae Formicidae Megachilidae Chironomidae Nematocera Aphididae Noctuidae Apoidea Dorsophilidae Muscidae Syrphidae Crabronidae Calliphoridae Vespidae Coccinellidae Culicidae Diptera Lipidotera Sphecidae Sphingidae Tipuloidea Chalcidoidea Curculionidae 1 1 33 3 3 0 1 34 0 0 0 32 0 0 2 1 3 1 1 4 3 6 2 1 0 3 3 5 3 6 8 3 6 3 2. Student 8 PANS Blue Student 9 PANS Blue Student 10 PANS Blue Student 11 PANS Blue White Student 12 PANS Blue White Student 13 PANS Blue White Student 14 PANS Blue White Yellow White Yellow White Yellow White Yellow Yellow Yellow Yellow 3 20 30 18 9 8 8 2 22 6 10 3 5 2 15 11 5 4 38 43 9 5 21 9 3 4 0 0 10 1 0 0 0 22 28 17 4 0 0 12 6 3 10 8 0 19 4 12 5 1 0 7 0 2 3 0 2 8 8 0 13 43 6 4 9 4 4 7 2 6 3 2 16 11 0 10 3 9 0 0 1 8 0 1 1 1 0 0 21 7 4 13 22 1 3 1 0 0 16 0 7 0 1 2. 19 Student 15 PANS Blue White Student 16 PANS Blue White Student 17 PANS Blue White Student 18 PANS Blue Student 19 PANS Blue White Student 20 PANS Blue White Student 21 PANS Blue White Yellow Yellow Yellow Yellow White Yellow Yellow Yellow 15 3 22 3 8 3 6 5 3 2 2 0 5 32 23 0 1 2 2 3 8 2 2 3 14 8 1 2 19 10 13 23 1 5 1 20 11 1 5 9 7 2 1 0 9 1 2 11 6 11 9 10 11 6 9 2 2 1 2 2 0 Student 22 PANS Blue White Student 23 PANS Blue White Student 24 PANS Blue White Yellow Yellow Yellow 10 0 5 9 15 2 1 5 2 16 4 0 3 13 2 3 5 3 1 1 1 6 17 1 1 1 1 12 11 7 2 5 1 11 0 0 Student 1 PANS Blue Student 2 PANS Blue Student 3 PANS Blue Student 4 PANS Blue Student 5 PANS Blue Student 6 PANS Blue Student 7 PANS Blue Family or Super-family Yellow White Yellow White Yellow White Yellow White Yellow White Yellow White Yellow White 1 9 10 3 1 5 3 24 8 8 1 2 3 4 7 3 1 1 5 3 0 5 2 0 2 8 1 1 1 0 1 0 6 3 2 0 0 1 3 4 0 1 3 0 0 4 1 1 1 16 5 4. 9 1 Agromyzidae Formicidae Megachilidae Chironomidae Nematocera Aphididae Noctuidae Apoidea Dorsophilidae Muscidae Syrphidae Crabronidae Calliphoridae Vespidae Coccinellidae Culicidae Diptera Lipidotera Sphecidae Sphingidae Tipuloidea Chalcidoidea Curculionidae 1 1 33 3 3 0 1 34 0 0 0 32 0 0 2 1 3 1 1 4 3 6 2 1 0 3 3 5 3 6 8 3 6 3 2. Student 8 PANS Blue Student 9 PANS Blue Student 10 PANS Blue Student 11 PANS Blue White Student 12 PANS Blue White Student 13 PANS Blue White Student 14 PANS Blue White Yellow White Yellow White Yellow White Yellow Yellow Yellow Yellow 3 20 30 18 9 8 8 2 22 6 10 3 5 2 15 11 5 4 38 43 9 5 21 9 3 4 0 0 10 1 0 0 0 22 28 17 4 0 0 12 6 3 10 8 0 19 4 12 5 1 0 7 0 2 3 0 2 8 8 0 13 43 6 4 9 4 4 7 2 6 3 2 16 11 0 10 3 9 0 0 1 8 0 1 1 1 0 0 21 7 4 13 22 1 3 1 0 0 16 0 7 0 1 2. 19 Student 15 PANS Blue White Student 16 PANS Blue White Student 17 PANS Blue White Student 18 PANS Blue Student 19 PANS Blue White Student 20 PANS Blue White Student 21 PANS Blue White Yellow Yellow Yellow Yellow White Yellow Yellow Yellow 15 3 22 3 8 3 6 5 3 2 2 0 5 32 23 0 1 2 2 3 8 2 2 3 14 8 1 2 19 10 13 23 1 5 1 20 11 1 5 9 7 2 1 0 9 1 2 11 6 11 9 10 11 6 9 2 2 1 2 2 0 Student 22 PANS Blue White Student 23 PANS Blue White Student 24 PANS Blue White Yellow Yellow Yellow 10 0 5 9 15 2 1 5 2 16 4 0 3 13 2 3 5 3 1 1 1 6 17 1 1 1 1 12 11 7 2 5 1 11 0 0