Physics Question

1) The module is dealing with charges and their interactions with each other. The student will:
Review some basic concepts of Coulomb’s Law.
Analyze SIMULATED Coulomb force data in Excel using both the trendline function and LINEST.
Demonstrate fundamental knowledge of vector diagrams with regards to charge interactions.
Note: Please review your textbook for Coulomb’s Law and charge interactions. It might also be helpful to review basics of force diagrams. These concepts may be used to address some key questions.
Watch the instructional (brief) video
Read over and prepare your spreadsheet. [Ask questions if something is NOT clear!]
Collect data from the macro system and then the micro system. Make sure there is a separate tab for each in the spreadsheet.
Follow the analysis instructions. Presentation is key in this module as well as reviewing the concepts of vectors.
2) video 1:
https://we.tl/t-Nezi9SK8IG
3) In these calculations, the Coulomb constant has a value of 8.99×109𝑁⋅𝑚2𝐶2
8.99×109N⋅m2C2
Part I (Label the tab “macro”): This is the macroscopic data. Note that: 𝑞1=𝑞2=𝑞.q1=q2=q.
Starting in cell D2, record all of your force measurements down the D column. In cell A1, record the initial position of q1. In cell A2, record the initial position of q2. The difference in those positions is the first separation between the charges. Place this value in B2. In cell B3, type (without quotes) “B2 0.1”. Hit enter. Copy the formula down to the last force measurement. Finally, in cell C2, type “B2/100”, and copy the formula down.
1.Place column labels in cell 1. In cell C1, it is 𝑟(𝑚)r(m). In D1, it is 𝐹(𝑁)F(N).
2. Plot 𝐹(𝑟)𝑣𝑠.𝑟F(r)vs.r . Make sure you insert the correct graph! It looks like in inverse-square curve. Label the graph for presentation. Afterwards, run a trendline by right-clicking the data. Chose power fit. Place the equation on the graph and enhance the size. Note the power of the fit. Record and label on the spreadsheet close to the graph the power obtained and the coefficient. Note: Do NOT run a LINEST or linear fit here!!!!!
For this analysis, using the Coulomb equation and this coefficient, calculate q. Record this value in SI based units as well as in micro-Coulombs.
Part II (Label a new tab “micro”): You are given that 𝑞2=4𝑒q2=4e. Note that this scale is now in picometers.
Starting in cell D2, record all of your force measurements down the D column. In cell A1, record the initial position of q1. In cell A2, record the initial position of q2. The difference in those positions is the first separation between the charges. Place this value in B2. In cell B3, type (without quotes) “B2 0.1”. Hit enter. Copy the formula down to the last force measurement. Finally, in cell C2, convert first value to meters, and copy the formula down.
1.Place column labels in cell 1. In cell C1, it is 𝑟(𝑚)r(m). In D1, it is 𝐹(𝑁)F(N).
2. Plot 𝐹(𝑟)𝑣𝑠.𝑟F(r)vs.r . Make sure you insert the correct graph! It looks like in inverse-square curve. Label the graph for presentation. Afterwards, run a trendline by right-clicking the data. Chose power fit. Place the equation on the graph and enhance the size. Note the power of the fit. Record and label on the spreadsheet close to the graph the power obtained and the coefficient. Note: Do NOT run a LINEST or linear fit here!!!!!
For this analysis, using the Coulomb equation and this coefficient, calculate 𝑞1q1. Record this value in SI based units as well as in micro-Coulombs. Also, record the polarity. Is it is negative or positive ion? How do you know?
4. Plot 𝐹(𝑟)𝑣𝑠.1𝑟2F(r)vs.1r2. Is it linear? Label the graph for presentation. Run a LINEST by highlighting a 2 x 5 matrix starting around cell A15 or so. Record the value of the slope and the uncertainty (e.g. 2.5±0.12.5±0.1).
For this analysis, using the slope and the Coulomb constant, calculate 𝑞1q1. Record this value in SI based units as well as in micro-Coulombs. Also, compare with your first calculation and comment.
Part III (Create a tab called “summary”): Insert large text boxes to type in.
In the summary tab, address these questions:
From the data (you) collected, does the power fit indeed illustrate the inverse-square Law?
Suppose you placed another charge (𝑞3q3) on the opposite end of the ruler of (a) equal value as 𝑞1q1and with the same sign and (b) a charge 𝑞3=2𝑞1q3=2q1 .
Describe how the force on 𝑞2q2 would look as a function of position starting at the original point as before, and then moving towards the right for both scenarios (a) and (b)? Analyze one scenario at a time! Take a stab at it. How would you begin to investigate this?
Suppose you were in a lab doing these measurements, assuming well-calibrated equipment, list some random errors you would encounter.

4)Video 2:
https://we.tl/t-yvnZAIk78G

5) Video 3:
https://we.tl/t-Va708MyajE
Please follow these all instructions and steps to understand what you need to do in this assignment.