how to plot a graph in excel for two variables

#How to plot a graph in excel for two variables how to#

Since the two lines are mostly flat, this tells us that there is very little difference in plant growth between daily and weekly watering.

#How to plot a graph in excel for two variables how to#

Here’s how to interpret the lines in the plot: This will automatically insert the following line chart:įeel free to modify the title, axis labels and colors on the plot to make it more aesthetically pleasing: Then click the Insert tab along the top ribbon in Excel, then click the first chart option within the Line Chart group: Next, we need to highlight the values in the cell range C4:E6 as follows: The mean growth for plants that received low sunlight and weekly watering was about 5.8 inches.The mean growth for plants that received low sunlight and daily watering was about 5.3 inches.The mean growth for plants that received high sunlight and weekly watering was about 9.6 inches.The mean growth for plants that received high sunlight and daily watering was about 8.2 inches.

Here’s how to enter these mean values into Excel: Suppose we collect data on 60 plants and calculate the mean plant growth at each level of sunlight exposure and watering frequency. weekly) on the growth of a certain species of plant. Suppose we want to understand the effects of sunlight exposure (low vs. The following step-by-step example shows how to create and interpret an interaction plot in Excel. A 2×2 factorial design is used to understand how two independent variables (each with two levels) affect one dependent variable.Ī useful way to visualize the effects that the two independent variables have on the dependent variable is to create an interaction plot, which displays the mean value of the dependent variable at each level of the independent variables.