Complicated Point Plotting

J

JohnOgamer

For a math project, I calculated the accuracy of a paintball gun on a
X 4 foot board. I devided this board into 16 sections (so 1 ft s
each). When the paintball hit... I marked 1) How many inches across 2
How many inches above. Therefore no point would read more than 12 b
12.

This isn't such a problem, by simply math I can find the exact point o
a 4 X 4 undevided board. It would make my job easyer if I could jus
plot the data since I have hundreads of trials :eek:

The main problem is I need to determine the distance from one point t
another. What is the best way to do this in excel? I have just recentl
started to learn how to use excel on the mac (been using window
before).

I am not sure of excel mathematical capababilities, but once I kno
this distance I can calculate the variance and Standard Deviation. I
excel can graph the areas where the paintball hit more often (b
shading or something), please tell me. I noticed on one type of barre
the paintballs curved more to the right, and if I want to make accurat
results, I need to know if the distribution is even or not.


If this is confusing, sorry.
 
P

Paul Corrado

Use the Pythagorean Theorem

For distance from the center

Distance = (x^2+y^2)^.5

For distance between any two points

((x1-x2)^2+(y1-y2)^)^.5

HTH

PC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plotting calculated point 4
Time - Distance plot... 3
Need some plotting help - determining which points are farthest apart 5
Plotting data points on 2 axis 4
Can a range be copied if it varies in size? 4
Employee Schedule not plotting properly - chart type / data series not correct 0
Plot the sin curve along the line y=x 3
use stock plot to draw point estimation with confidence interval 0

Top