Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: cdj01
  • Order by date
  1. cdj01

    Crystal Reports Standard Deviation

    I don't have anything set to be supressed. It's a very simple report. It is basically a straight table pull (of the table RESULT_VIEW) with the following in the selection expert: {RESULT_VIEW.MNEMONIC}='WAL' AND {RESULT_VIEW.TESTSEQ}='1' AND {RESULT_VIEW.TESTCODE} IN...
  2. cdj01

    Crystal Reports Standard Deviation

    I got excited, not knowing about the population stdev (I know nothing about statistics, I was just asked for the standard deviation) but unfortunately the results were the same or very close to it when I ran a populationstdev.
  3. cdj01

    Crystal Reports Standard Deviation

    No actually that was it, I missed a couple of words when I trimmed something. Basically it's all there, using the same set of data with Excel, I get a drastically different standard deviation than when I compute it in Crystal 8.
  4. cdj01

    Crystal Reports Standard Deviation

    I use Crystal 8 connected to an Oracle database to analyze laboratory results. I have come to the conclusion that the standard deviation function is flawed. It seems that the larger our sample population, the farther off the standard deviation becomes, which does not fit our data. To confirm...
  5. cdj01

    Help with arranging table data

    If there was a normal test with a higher sequence number, then it would be invalid for my criteria. I managed to get the data I needed through Toad, our oracle application, by running an sql query there.
  6. cdj01

    Help with arranging table data

    What I am trying to do is find out which labnumbers have test results where test 10001 is 'abnormal' AND test 07001 is 'ff'. I don't want the other results. It's this combination of different test results that I need. This database contains about 300,000 different labnumbers for each year...
  7. cdj01

    Help with arranging table data

    I am running CR 8 off of an oracle database. The data I need is in the table result_archive. It is arranged like this: labnumber test sequence value mnemonic (many more fields but these are the ones of interest) This is a database of laboratory test results. Each labumber may have several...
  8. cdj01

    Standard Deviation

    This keeps getting better. I added a hotfix, cr85mainwin_en.zip, which came up when I searched for updates for Crystal 8, hoping this would resolve any issues, and now when I load crystal, it is asking for a keycode again, which would be fine. However it doesnt match the length of the keycode...
  9. cdj01

    Standard Deviation

    I am having a problem using the StDev function in Crystal 8.0. I am trying to determing the mean and stdev of lab values for specimens. The mean comes out fine, but the stdev comes out far above what is expected. However, when I run the report for a smaller number of samples, it comes out...
  10. cdj01

    Standard Deviation

    To further explain my problem, I just ran a report calculating the mean and standard deviation of test results for about 120,000 specimens. When I ran the report for all the specimens at once, I got a mean of ~14.5 and a standard deviation of ~40. I reran the report using the specimens one...
  11. cdj01

    Standard Deviation

    I am having a problem using the StDev function in Crystal 8.0. I am trying to determing the mean and stdev of lab values for specimens. The mean comes out fine, but the stdev comes out far above what is expected. However, when I run the report for a smaller number of samples, it comes out...

Part and Inventory Search

Back
Top