How would I plot the graphs on excel Also please include a s

How would I plot the graphs on excel? Also, please include a sketch of how the graphs would look like;you do not have to necessarily plot it on excel. Your help is GREATLY appreciated. Thanks.

Plot the following data in Microsoft Excel as a grouped bar graph. You will need two different graphs based on the measurement being plotted. Be sure to put the correct data on the Xand Y axis (dependent data on the Yaxis and independent data on the X Scanned by CamScann axis). Correctly lab each axis and include units. Show your instructor your completed graph Table 1. Researchers tested the impact of fungus (an on the heat tolerance of a grass species. They grew plants without (E-) and with (E+) fungus at different temperatures and measured plant mass and the number of new shoots the plants produced. (R. S. Redman et al. 2002. Thermotolerance generated by plant/fungal symbiosis, Science 298:1581.) Soil Fungi Plant Mass Number of New Temperature presence Shoots 30 C 16.2 22.8 35 C 21.7 28.4 40 C LEN 122.2 37 45 C 15.1 Q23: What data goes on the X axis? Q24: What data goes on the Y Axis? Q25: Once the data is graphed, what conclusion can you drawfrom the data?

Solution

23, The X axis contains the independent variable which will not change according to situation. So here on X axis, we will take TEMPERATURE.

24. On Y axis, dependent variable is taken. Like in one graph, Y axis will contain plant mass and in another graph Y axis will have Number of new shoots.

To plot the graph in Excel first of all make table in the excel sheet. Mention the headers like temperture and plant mass with and without fungi. Then click on Insert, then Bar graph. Graph will be plotted by the system.