micro column interactions-measurement

In these calculations the Coulomb constant has a value of 8.99×109N⋅m2C28.99×109N⋅m2C2 Part I (Label the tab “macro”): This is the macroscopic data. Note that: q1=q2=q.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)r(m). In D1 it is F(N)F(N). 2. Plot F(r)vs.rF(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 q2=4eq2=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)r(m). In D1 it is F(N)F(N). 2. Plot F(r)vs.rF(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 q1q1. 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 F(r)vs.1r2F(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 q1q1. 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: Describe how the force on q2q2 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? Save the file and upload. Requirements: it should be an excel cart with supporting details | .doc file From the data (you) collected does the power fit indeed illustrate the inverse-square Law? Suppose you placed another charge (q3q3) on the opposite end of the ruler of (a) equal value as q1q1 and with the same sign and (b) a charge q3=2q1q3=2q1 . Suppose you were in a lab doing these measurements assuming well-calibrated equipment list some random errors you would encounter.