Question: Step 1 : Adding your data in Excel Here is an example of how you may plot your data in Excel. If you prefer any

Step 1: Adding your data in Excel
Here is an example of how you may plot your data in Excel. If you prefer any other graphical software, it is totally up to you, just make sure that your graph contains all elements as is shown on the examples below and looks good.
Example: let's say, the data in your Table 1 looks like this
Distance : 0;1;2;3;4;5;6;7;8;9;10
Electric Potential : 0;3;6;9;12;15;18;21;24;27;30
Please note, your data values will look differently from these example values.
Enter these data in Excel, in two columns, as shown on the picture.
Please note: Distance r data need to be in the first column, while Electric Potential V data need to be in the second.
Step 2: Plotting your data in Excel
Select your data, and then go to Insert in the top menu. Go to Insert Chart, and select Scatter Chart.
Step 3: Adding the chart elements
Click on the top right of your chart and ensure that you have all necessary chart elements (Axes, Axis Titles, Chart Title, Gridlines, and Trendline) checked, as shown on the picture below. Then click on the Axis Titles, and put Voltage, V on the vertical axis, and Distance, m on the horizontal axis, as shown on the next pictures.
Now, again click on the top right of your chart and in the Chart Elements go to Trendline, and select More Options, as shown on the picture below.
Next, in the Format Trendline menu, in Trendline options, select Power. Also, click on Display Equation on chart.
page 5
Step 1 : Adding your data in Excel Here is an

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!