Question about finding electric field using slope on excel

Click For Summary
SUMMARY

The discussion focuses on calculating the electric field from voltage data using Excel by determining the slope of a potential versus distance plot. The key formula provided is dy/dx = [y(x+h) - y(x-h)] / 2h, where 'h' represents the step size between data points. Users are guided on how to implement this formula in Excel to find the slope at each position, emphasizing that y(x+h) and y(x-h) correspond to adjacent cells in the worksheet. This method allows for precise calculation of the electric field at each measured position.

PREREQUISITES
  • Basic understanding of electric fields and voltage measurements
  • Familiarity with Excel functions and cell referencing
  • Knowledge of numerical differentiation techniques
  • Understanding of data plotting and graph interpretation
NEXT STEPS
  • Learn how to implement the slope formula in Excel using cell references
  • Explore Excel's built-in functions for data analysis and graphing
  • Research numerical differentiation methods for more complex datasets
  • Investigate how to visualize electric fields using Excel charts
USEFUL FOR

Students in physics or engineering courses, lab technicians analyzing voltage data, and anyone interested in applying Excel for scientific data analysis.

MaryCate22
Messages
22
Reaction score
0

Homework Statement


I have a list of data, positions and measured voltages at each position. As part of my lab analysis I have to find the electric field at each position. I know that the slope of a potential versus distance plot is the electric field, but I have no clue how to find not the average slope, but the slope at each position in excel.

Homework Equations


In my lab handout says the most useful formula for finding slope from data is dy/dx=[y(x+h)-y(x-h)]/2h

The Attempt at a Solution


My question is basically how to find the slope at each position. How do I make use of the above formula in excel?
My worksheet is attached. I'm sorry if this is the wrong board for this type of question.
 

Attachments

Physics news on Phys.org
MaryCate22 said:
How do I make use of the above formula in excel?
Let h be the step size of your data. Which means y(x+h) is one cell away from y(x) and y(x-h) is one cell in the opposite direction.
 

Similar threads

  • · Replies 7 ·
Replies
7
Views
3K
Replies
4
Views
4K
  • · Replies 2 ·
Replies
2
Views
3K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 1 ·
Replies
1
Views
3K
  • · Replies 2 ·
Replies
2
Views
6K
  • · Replies 22 ·
Replies
22
Views
4K
  • · Replies 1 ·
Replies
1
Views
2K
Replies
9
Views
1K
  • · Replies 16 ·
Replies
16
Views
2K