Hi
I need to determine values of the tops and bottoms of a curve in a graph. In the attachment it can be seen that the data generated produce a hill/valley like pattern. Does anyone know of a good way to find the top/bottom difference (on the y-axis) between each of the changes. I guess you could say I am looking for the amplitude changes. The actual curve is muuuch longer, hence automation is a good thing.
Regards
StefanBG
Hi
I need to determine values of the tops and bottoms of a curve in a graph. In the attachment it can be seen that the data generated produce a hill/valley like pattern.
Does anyone know of a good way to determine the absolute values of the different tops and bottoms (on the y-axis). I guess you could say I am looking for the amplitudes of the curve.
The actual curve is a lot longer, hence automation is a good thing.
Regards
StefanBG
Hello
How do you write the following formula in VBA?
PHP Code:
=RADQ(A3^2+B3^2)
Hello all,
I have a spreadsheet of co-ordinates (Eastings & Northings). Columns A & B contain the co-ordinates of school premises. Columns E & F contain the co-ordinates of anti-social behaviour incidents. In column C I'd like to show a count of anti-social behaviour incidents occuring with 100m of the school (Easting & Northings are in metres which is handy)
Easting Northing Results Easting Northing
502871 107008 ------------- 518902 116729
585461 136574 ------------- 531108 108205
487650 135334 -------------
In my actual data I have about 464 anti-social behaviour incidents and 697 schools
I've worked out how to calculate the distance between school and incident using a pythagoras formula like this...
=SQRT((ABS(A2-D2))^2+(ABS(B2-E2))^2)
...but that isn't really what I need. What I really need is a count are incidents where the answer to this formula is >100m
Please help? I've tried everything I can think of.
Morning All,
Does anyone know of a free tutorial that can explain how to get statistical data in Excel? - I have seen it done before (in excel) for 'Linear regression', I am wondering if the same can be done for "Polynomal"?
Rgs
Neville
I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.
I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.
Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?
Can this be done in excel? Should I post what I have now to work with?
I am having difficulty setting up a Excel sheet for the following problem.
An industrial Engineer at ABC Products wants to determine whether there are more units produced on PM shift then AM Shift.
Sample of 54 Am workesr with a mean number of units produced is 345 with a standard deviation of 21.
Sample of 60 PM workser with a mean number of units produced is 351 with a standard deviation of 28 units.
Significance level is .05
Trying to figure out if the PM shift is larger.
