Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

how to draw this for physics lab in excel program I need the steps to do it ? Section 2 this section, you will apply

how to draw this for physics lab in excel program I need the steps to do it ?

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essentials of Database Management

Authors: Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman

1st edition

133405680, 9780133547702 , 978-0133405682

More Books

Students also viewed these Databases questions

Question

=+ Are they breakable for any reason?

Answered: 1 week ago