I’m working on a physics question and need an explanation and answer to help me learn.
For each charge separation, measure the value of and note the value of the force meter. Pause the video to take careful measurements. Measure to at least three sig. figs. (if possible)
Place position () values in meters in column A, in column B, and force () in column C. All of these values should be SI base units.
1.Place column labels in cell 1. Start placing values in cell 2.
In Column B, you are merely multiplying the constant by the inverse of column B: =8.99E09*B2. Copy the formula down.
Plot . Make sure you insert the correct graph! Label the graph for presentation. Afterwards, run a trendline by right-clicking the data. Chose power fit. Place the equation on the graph. Note the power it fit the curve with.
Plot . Is it linear? Label the graph for presentation. Run a LINEST by highlighting a 2 x 5 matrix starting around a15 or so. The theoretical slope should be the product of the two charges. So the slope should have units of . Note the value of the slope and its uncertainty.
In the summary tab, address these questions:
From the data (you) collected, does the power fit indeed illustrate the inverse-square Law? Explain.
We don’t know the charge on either sphere. But, we DO KNOW the product. Determine the product of the charges. Does your result seem reasonable?
List all random error in this lab that you can identify. Would these account for any discrepancies for the power fit?