Think about the electroscope that we used in the first lab. Hopefully, you noticed that the more charge wastransferred to the electroscope, the higher the gold foil leaf was rising. Let's see if we can use that to verifyCoulomb's law, while practicing working with various Excel commands and option.Recall that the entire body of the electroscope (not including the casing) is metallic - and thus the charge that youtransfer to the ball will be uniformly spread throughout the electroscope. Basically, that means that q₁ = q₂ = ½ q,where q₁ is the charge on the metal plate, q2 is the charge on the gold foil, and q is the total charge transferred tothe electroscope. Below is the data representing the charge transferred to the electroscope vs. the separationbetween the tip of the gold foil and the tip of the metallic plate. We will use this distance to represent r inCoulomb's law, although, strictly speaking, it's not quite correct as the charges we are using are not point charges.q [pc]0.800.901.001.10r [cm]0.0500.0600.0750.080q [pc]1.201.501.601.70r [cm]0.0900.1000.1200.130q [pc]1.801.851.952.00r [cm]0.1300.1400.1500.1501. Transfer this data into Excel or Google sheets (make columns 1 and 2). Label the columns!2.Convert cm to m, and pC to C (1 pC= 10-¹² C) - do this using formulas in Excel, not by hand (columns 3 and 4).Calculate q₁ (column 5). Again, don't forget to label the columns (with units).3.Use Excel formulas to calculate Coulomb force for each case (column 6).4. Plot F vs. r (Chart 1, leave in Sheet 1). Remember to label the graph, and both axes with units.5. What shape did you expect for your plot in #4? What shape did you get?6. Calculate r² (column 5) and 1/r² (column 7).7. Plot F vs. (1/r²) (Chart 2, leave in Sheet 1). Remember to label the graph, and both axes with units.8. What shape did you expect for your plot in #7? What shape did you get?12. Based on your answer to # 11, calculate the Coulomb force. Show your work.9. Plot q² vs. r² (Chart 3 - put in separate sheet). Remember to label the graph, and both axes with units. Yourgraph should be linear. Create a best-fit line, and display the equation and the R² value on the graph.10. Make a second q² vs. r² (Chart 4 - put in separate sheet), this time make the line go through the origin. Again,create a best-fit line, and display the equation and the R² value on the graph.11. Think about the slope of the two lines in #9 and #10. What does the slope represent? Think about the physicsof this problem. Which of the two graphs is more appropriate, and why?

Your question has 12 subparts. As per the guidelines, we can solve 3 subparts. But I will solve…

Think about the electroscope that we used in the first lab. Hopefully, you noticed that the more charge was transferred to the electroscope, the higher the gold foil leaf was rising. Let's see if we can use that to verify Coulomb's law, while practicing working with various Excel commands and option. Recall that the entire body of the electroscope (not including the casing) is metallic - and thus the charge that you transfer to the ball will be uniformly spread throughout the electroscope. Basically, that means that q₁ q2 = ½ q, where q₁ is the charge on the metal plate, q2 is the charge on the gold foil, and q is the total charge transferred to the electroscope. Below is the data representing the charge transferred to the electroscope vs. the separation between the tip of the gold foil and the tip of the metallic plate. We will use this distance to represent r in Coulomb's law, although, strictly speaking, it's not quite correct as the charges we are using are not point charges. q [pc] 0.80 0.90 1.00 1.10 r [cm] 0.050 0.060 0.075 0.080 q [pc] 1.20 1.50 1.60 1.70 r [cm] 0.090 0.100 0.120 0.130 q [pc] 1.80 1.85 1.95 2.00 r [cm] 0.130 0.140 0.150 0.150 1. Transfer this data into Excel or Google sheets (make columns 1 and 2). Label the columns! 2. Convert cm to m, and pC to C (1 pC= 10-¹2 C) - do this using formulas in Excel, not by hand (columns 3 and 4). Calculate q₁ (column 5). Again, don't forget to label the columns (with units). 3. Use Excel formulas to calculate Coulomb force for each case (column 6). 4. Plot F vs.r (Chart 1, leave in Sheet 1). Remember to label the graph, and both axes with units. 5. What shape did you expect for your plot in #4? What shape did you get? 6. Calculate r² (column 5) and 1/r² (column 7). 7. Plot F vs. (1/r²) (Chart 2, leave in Sheet 1). Remember to label the graph, and both axes with units. 8. What shape did you expect for your plot in #7? What shape did you get? 12. Based on your answer to #11, calculate the Coulomb force. Show your work. 9. Plot q² vs. r² (Chart 3 - put in separate sheet). Remember to label the graph, and both axes with units. Your graph should be linear. Create a best-fit line, and display the equation and the R² value on the graph. 10. Make a second q² vs. r² (Chart 4 - put in separate sheet), this time make the line go through the origin. Again, create a best-fit line, and display the equation and the R2 value on the graph. 11. Think about the slope of the two lines in #9 and # 10. What does the slope represent? Think about the physics of this problem. Which of the two graphs is more appropriate, and why?

Think about the electroscope that we used in the first lab. Hopefully, you noticed that the more charge was transferred to the electroscope, the higher the gold foil leaf was rising. Let's see if we can use that to verify Coulomb's law, while practicing working with various Excel commands and option. Recall that the entire body of the electroscope (not including the casing) is metallic - and thus the charge that you transfer to the ball will be uniformly spread throughout the electroscope. Basically, that means that q₁ q2 = ½ q, where q₁ is the charge on the metal plate, q2 is the charge on the gold foil, and q is the total charge transferred to the electroscope. Below is the data representing the charge transferred to the electroscope vs. the separation between the tip of the gold foil and the tip of the metallic plate. We will use this distance to represent r in Coulomb's law, although, strictly speaking, it's not quite correct as the charges we are using are not point charges. q [pc] 0.80 0.90 1.00 1.10 r [cm] 0.050 0.060 0.075 0.080 q [pc] 1.20 1.50 1.60 1.70 r [cm] 0.090 0.100 0.120 0.130 q [pc] 1.80 1.85 1.95 2.00 r [cm] 0.130 0.140 0.150 0.150 1. Transfer this data into Excel or Google sheets (make columns 1 and 2). Label the columns! 2. Convert cm to m, and pC to C (1 pC= 10-¹2 C) - do this using formulas in Excel, not by hand (columns 3 and 4). Calculate q₁ (column 5). Again, don't forget to label the columns (with units). 3. Use Excel formulas to calculate Coulomb force for each case (column 6). 4. Plot F vs.r (Chart 1, leave in Sheet 1). Remember to label the graph, and both axes with units. 5. What shape did you expect for your plot in #4? What shape did you get? 6. Calculate r² (column 5) and 1/r² (column 7). 7. Plot F vs. (1/r²) (Chart 2, leave in Sheet 1). Remember to label the graph, and both axes with units. 8. What shape did you expect for your plot in #7? What shape did you get? 12. Based on your answer to #11, calculate the Coulomb force. Show your work. 9. Plot q² vs. r² (Chart 3 - put in separate sheet). Remember to label the graph, and both axes with units. Your graph should be linear. Create a best-fit line, and display the equation and the R² value on the graph. 10. Make a second q² vs. r² (Chart 4 - put in separate sheet), this time make the line go through the origin. Again, create a best-fit line, and display the equation and the R2 value on the graph. 11. Think about the slope of the two lines in #9 and # 10. What does the slope represent? Think about the physics of this problem. Which of the two graphs is more appropriate, and why?