Well, I thought I had DataPage on the computer, but apparently it's not licensed. I get a missing authorization code error.
At any rate, I measured 6 identical parts (1222 points on each part). I exported the data to a CSV and imported the data into Excel, one worksheet per part. I wrote a macro to get just the Deviation (T) for each part on one worksheet. My data looks like:
Point Part1 Part2 Part3 Part4 Part5 Part6
1 value value value value value value
2 value value value value value value
3 value value value value value value
4 value value value value value value
...
1219 value value value value value value
1220 value value value value value value
1221 value value value value value value
1222 value value value value value value
The values are the actual deviations at each point for each part.
What kind of statistics can this data show? I can find Max and Min for each part and for each point, but I'm not sure what that tells me. I guess what I'm saying is that I don't know what to do statistically to show something meaningful. How can I show which part is closest to CAD? Compare Mean value? Average values? Create a histogram?
I have the Data Analysis Pack installed, if there is something in there I that would help.
Thanks in advance,
Keith
At any rate, I measured 6 identical parts (1222 points on each part). I exported the data to a CSV and imported the data into Excel, one worksheet per part. I wrote a macro to get just the Deviation (T) for each part on one worksheet. My data looks like:
Point Part1 Part2 Part3 Part4 Part5 Part6
1 value value value value value value
2 value value value value value value
3 value value value value value value
4 value value value value value value
...
1219 value value value value value value
1220 value value value value value value
1221 value value value value value value
1222 value value value value value value
The values are the actual deviations at each point for each part.
What kind of statistics can this data show? I can find Max and Min for each part and for each point, but I'm not sure what that tells me. I guess what I'm saying is that I don't know what to do statistically to show something meaningful. How can I show which part is closest to CAD? Compare Mean value? Average values? Create a histogram?
I have the Data Analysis Pack installed, if there is something in there I that would help.
Thanks in advance,
Keith
Comment