Using Excel to Graph Data Eastern Michigan University使用优于图形数据东密歇根大学.pptVIP

Today, you will learn how to: Make a constant value a cell instead of a number Create a scatter plot for your data Insert a trendline into your graph Format your graph with gridlines and axes titles First, you will enter your given set of data into an Excel spreadsheet. Make sure you put your mass value in it’s own cell. We will use this value as a constant in your equation. Usually, when you copy a formula, it will change the row/column as you copy the formula. To prevent this, put a $ in front of both the column letter and the row number (ex. $A$4) Enter the force equation using the mass from the cell instead of typing the number As you can see in the picture below, the $ does not let the cell with the $ change: To calculate an average in Excel, you will want to type AVERAGE(), and put the cells you would like to average inside the parentheses. Excel also allows us to create graphs for data analysis To graph, start by highlighting two columns of data Click on the “Insert” tab, then click the scatterplot button. The first column you highlight will appear on the horizontal axis of the graph. The second column you highlight will appear on the vertical axis of the graph For the majority of your graphs, you will want to graph points, not lines. Your graph should look like this: You should delete both instances of “Force (N)” from the graph, since you will put titles under graphs. (Only delete the title if you have multiple sets of data on a single graph) Click on your graph The “Chart Tools” menu will show Select the “Layout Tab” Click on the “Axes Titles” button to add horizontal and vertical axes titles. For the horizontal axis, your title should read “Radius(m)” For the vertical axis, your title should read “Force (N)” You will also want to add both major minor gridlines for both the horizontal and vertical axes In the same menu, click the “Gridlines” button, then insert the appropriate gridlines on your graph Your graph should now look like this: G