how to draw this for physics lab in excel program I need the steps to do it ?
Section 2 this section, you will apply the information in section 1 to create several spreadsheets. Create a spreadsheet that reproduces the ball thrown upwards as in the example in section 1 but on is spreadsheet add x motion to it. Remember to add constants for initial x velocity and position. Make plots of x vs. t, y vs. t and x vs. y 3 Make a spreadsheet that produces a "wiremesh plot of the potential of a dipole. Remember the equation for the potential of a dipole is V =- 4ne, Remember the. Steps: 1. Keep everything in the region of the x-y plane bounded by x = (-2,2] y=[-2,2]. 2. Offset your grid so the charges don't sit precisely on grid points. Set your first point at (2.001,2.001). 3. Set up constants, k=9e9, 41, 42, xl, x2, yl, y2 (the charges and locations of your two charges) and delta (the step size in x and y-should be between 0.1 and 0.3). 4. Create a horizontal range representing x values. 5. Create a vertical range representing the y values. 6. Create a formula that will calculate the potential due to ql at the origin. Fill your x-y region and check the results. Check to be sure the automatic increment feature is working the way you want it to. 7. Modify your formula to move ql to a value on the +x axis, recheck. Does the graph make sense? 8. Now, modify to move q1 to a point with positive x and y, recheck. Does the graph make sense? 9. Add in the other charge. 10. Excel has a "surface plot" feature in the chart wizard. 11. Plot and print wiremesh plots of your charges in quadrants I &III and I &II. The following is an example of a wire mesh plot with charges at (0.5,0.5) and (-0.5,-0.5). 8000.00 6000.00 4000.00 2000.00 0.00 -2000.00 -4000.00 -6000.00 -8000.00 S12 87 Section 2 this section, you will apply the information in section 1 to create several spreadsheets. Create a spreadsheet that reproduces the ball thrown upwards as in the example in section 1 but on is spreadsheet add x motion to it. Remember to add constants for initial x velocity and position. Make plots of x vs. t, y vs. t and x vs. y 3 Make a spreadsheet that produces a "wiremesh plot of the potential of a dipole. Remember the equation for the potential of a dipole is V =- 4ne, Remember the. Steps: 1. Keep everything in the region of the x-y plane bounded by x = (-2,2] y=[-2,2]. 2. Offset your grid so the charges don't sit precisely on grid points. Set your first point at (2.001,2.001). 3. Set up constants, k=9e9, 41, 42, xl, x2, yl, y2 (the charges and locations of your two charges) and delta (the step size in x and y-should be between 0.1 and 0.3). 4. Create a horizontal range representing x values. 5. Create a vertical range representing the y values. 6. Create a formula that will calculate the potential due to ql at the origin. Fill your x-y region and check the results. Check to be sure the automatic increment feature is working the way you want it to. 7. Modify your formula to move ql to a value on the +x axis, recheck. Does the graph make sense? 8. Now, modify to move q1 to a point with positive x and y, recheck. Does the graph make sense? 9. Add in the other charge. 10. Excel has a "surface plot" feature in the chart wizard. 11. Plot and print wiremesh plots of your charges in quadrants I &III and I &II. The following is an example of a wire mesh plot with charges at (0.5,0.5) and (-0.5,-0.5). 8000.00 6000.00 4000.00 2000.00 0.00 -2000.00 -4000.00 -6000.00 -8000.00 S12 87
