To use this method, these steps are followed:ġ. The m in the formula represents the slope of the line. This method makes use of the formula Y=mx+c. Method 2: Using a chart to find the slopeĪnother method of calculating the slope of a line is visual charts. inequality in values would result in #N/A error.įinally, this formula can only be used with more than one set of values. The values of y should equal the values of x. The Y and X values should be numeric when using this formula. Finally, hit the enter button, and the result of the function will be stored on the selected cell. Using a comma, separate the values of y and add values of x. Then, highlight all the columns that contain your y values. Click that cell, and then locate the formula bar. This is where you will enter the slope function.Ĥ. Then, click on the cell next to the one named slope. Select an empty cell and name it to the slope. On the second column, enter the data used as the y values.ģ.
Therefore, on the first column of the sheet, enter the data will be used as x values.Ģ.
To use this function, you need to have the y and x values. The function only requires two parameters: X and Y values.ġ. The slope function is an in-built function that returns the slope of the line when used. When calculating the slope of a line, the slope function proves to be the easiest method.
How to plot a graph in excel using a formula how to#
This means our y-axis values will be as follows: 50, 25, 12.5, 6.25, 3.125.Įxample Problem 2 - How to Plot a Half-Life GraphĬonstruct a graph for the first four points of the decay 50g of scandium-46 which has a half-life of 85 days. To plot the next five points, we need to determine the time and amount of each prior to putting them on our graph.Įach half-life takes 4.5 hours to complete, so our next x-axis values will be as follows: 4.5, 9.0, 13.5, 18, 22.5.įor each half-life that occurs, the amount of In-115m decreases by half of the previous point. After time begins to pass, the radioactive isotope will begin to lose mass through half-life decay. Prior to decaying, the maximum amount of In-115m is 100g. Additionally, we need to provide enough room for five half-lives (22.5 hours). Since our half-life is in hours, we will want to label our x-axis in hours. Since our starting mass is 100g, we will create a graph with 100g as our maximum amount. In the final question, we will construct a half-life graph of scandium-46.Įxample Problem 1 - How to Plot a Half-Life GraphĬonstruct a graph for the first six points of the decay 100g of indium-115m which has a half-life of 4.5 hours. In the first example, we will construct a graph that represents the decay of indium-115m. Next, we will look at two example problems that work on plotting a half-life graph. Radioactive Isotope: An isotope of an element that possesses an unstable number of neutrons and protons within the atom's nucleus. Half-Life: The amount of time necessary for a radioactive isotope to decay to half of its original mass. Vocabulary for Plotting a Half-Life Graph Step 4: The next point lies after one half-life time and half the mass of the previous point. Step 3: Plot the first point of your graph at time zero and the maximum amount of radioactive substance. Depending on the radioactive substance, this amount can range from seconds to millions of years. Label this section of your graph as the mass of your substance. Step 1: Construct the y-axis of the graph to have a maximum equal to your starting amount of material.
0 kommentar(er)
