I have to do a chart with the following information but I cant get the chart to come out right does anyone know how. Im using a scattered xy chart.

Information:

Trail x units y units k=y/x
1. .041 A 4.0 V
2. .083 A 8.2 V
3. .127 A 12.3 V
4. .162 A 16.0 V
5. .200 A 21.0 V

If you are plotting V in volts vs A in amps, the points will pretty much fall along a line V = 100 A (or V = 0.10 A if A is in mA). They data points will be scattered close to the line and it might tbe possible for Excel to draw a best-fit least-squares line through the points. The best-fit V/I slope may not be quite equal to 100.

I do not have Excel available and there is not way to post graphics here.

There is a JAVA tool at http://www.physics.csbsju.edu/stats/QF_NROW_form.html

that will let you calculate the least-sqaures fit to your data points. Using it, I got V = 105 A plus a small constant term

To create a scatter XY chart with the given information, you can follow these steps:

1. Open a spreadsheet program like Microsoft Excel or Google Sheets.
2. Set up your table in the worksheet with the following columns: "Trail," "x units," "y units," and "k=y/x."
3. In the "Trail" column, enter the trial numbers from 1 to 5.
4. In the "x units" column, enter the corresponding x-values: 0.041, 0.083, 0.127, 0.162, and 0.2.
5. In the "y units" column, enter the corresponding y-values: 4.0, 8.2, 12.3, 16.0, and 21.0.
6. In the "k=y/x" column, enter the formula "=y-value/x-value" for each row. For example, in the first row, enter "=B2/C2" to calculate the ratio.
7. Select all the data in your table, including the headers.
8. In Excel, go to the Insert tab and click on the scatter plot chart type. In Google Sheets, go to the Insert menu, select Chart, and choose the scatter plot chart type.
9. A scatter XY chart will be generated with data points representing each trial. You may need to format the chart axes, labels, title, and other settings to make it more presentable.

If you encounter any specific issues while creating the chart or have any further questions, please provide more details, and I will be glad to assist you.