You can utilize either the dataset obtained in previous labs or the provided sample dataset to create the following Excel graphs. Part 1: Creating a Scatter Plot in Excel Organize the Voltage and current values for R1 resistors in a table. Follow these steps to create a basic scatter plot: Input the voltage and current values of R1 resistor into an Excel spreadsheet, with voltage in the x-axis column and current in the y-axis column. Select the data range. Navigate to the "Insert" tab and select "Scatter," then choose "Scatter with Straight Lines and Markers." Customize the chart title and axis titles as needed. Right-click on a data point in the chart and opt for "Add Trendline." Choose the "Linear" option. g. Check the "Display equation on chart" checkbox. Right-click on the equation, select "Format trendline label" (choose the "Number" category, and adjust decimal places). Utilize the slope of the graph to calculate the R1 resistance value