Lab 14 C22 ->Calculating Potential due to Ring and Rod( Excel and Calculus methods), Electric Potential Laboratory/Activity,

Calculating Potential due to Ring and Rod( Excel and Calculus methods) 
    Potential from a continuous charge distribution can be calculated in different ways, most common way engineers used is through excel spreadsheet because it is easy to quantify and make changes is various ranges of dq(s). The other methods yield approximately the same result.
First, we used an integral method in which the potential dV from each element of charge dq is integrated mathematically to give a total potential at the location of interest.  Second, we can approximate the value of the potential V by summing up several finite elements of charge Dq by using a computer spreadsheet or hand calculations.  Finally, we can use Gauss’ law to find the electric field along with the defining equation for potential difference to set up the appropriate line integral. Thus finding the potential difference due to continuous charge distribution of a ring geometry.
Here is a example problem done using Ring integration method.

    

Ring solved integration method symbolically

Potential solved by seperate dq(s) solved by excel

Need my pictures from the Excel data base

A positive charge and negative charge interactions with shown field lines to illustrate them.

Equation for showing charge and E field can be treated with scalar factors as delta r and delta u becomes x and y axis.

2 types of Graph on the right normal which is the same in trend with the graphs in excel shown below.

Equipotential dipole explained in graphs of two point particles. 

General equations 

Data Gathered

Equations solved in lab

Even more questions answered in Lab

Last question 

Comparison of two graphs from data and from book.