Results 1 to 5 of 5

Math Help - Summarizing multiple sets of data for review.

  1. #1
    Newbie
    Joined
    Jan 2014
    From
    United States
    Posts
    3

    Summarizing multiple sets of data for review.

    I have a database that tracks the lab testing that my employees perform on a daily basis. This data is divided first by Type(XP-**). Each of which is subject to a battery of tests (8 tests). MY boss wants a monthly report that lists all of the types of foam tested in the last month with some indicator of where the last testing data falls in relation to the trend for that material over the last year. I currently have the data base set up to generate a full set of graphs for each type of material (inside Access), which is not ideal for given general trend info to management. Its far to clunky to print or even email as the data is pulled directly from the database to generate the report.

    I am hoping for some ideas on how to better present this data and the trend in each type/test result. Is there some way to plot the changes in each test results in a single graph?
    Follow Math Help Forum on Facebook and Google+

  2. #2
    MHF Contributor
    Joined
    Nov 2010
    Posts
    1,932
    Thanks
    782

    Re: Summarizing multiple sets of data for review.

    Can you give results for the past 12 months for each test individually? Possibly as a bar graph? I am not sure what you are trying to do, so it is difficult for me to give anything more. I don't know if anyone else has anything.
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Jan 2014
    From
    United States
    Posts
    3

    Re: Summarizing multiple sets of data for review.

    Currently I am providing graphical data for 20 SKU at 9 graphs per SKU. Its very cumbersome and makes it difficult for management to identify significant changes in the test results. I am currently trying to put together some prediction interval. If my understanding of this is correct, the prediction intervals will provide a upper and lower boundary that tells me where the next result should fall with a given provability?
    Follow Math Help Forum on Facebook and Google+

  4. #4
    MHF Contributor
    Joined
    Nov 2010
    Posts
    1,932
    Thanks
    782

    Re: Summarizing multiple sets of data for review.

    Have you looked this up in Wikipedia? It may give you a place to start: (link)

    Is the data generally normally (or near normally) distributed? If not, then you may want to evaluate the data with a different probability distribution. There are many different distributions. Whichever one provides the best fit for the data will be the one that you should use. You may want to look at Wikipedia's entry for data analysis for more information on how to determine an appropriate distribution under which to evaluate the data. Different distributions offer different methods of determining probable data. For instance, a Poisson distribution may have multiple ranges of probable data: (link). This link offers very general information. From there, hopefully you can find information pertaining to the specifics of what you are trying to do. Here is general information on probability distributions: (link).

    Beyond that, without studying the data myself for a while, there is not much I could help you with.
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Jan 2014
    From
    United States
    Posts
    3

    Re: Summarizing multiple sets of data for review.

    Thank you for the information. I have already read some of it before I came here but the specific direction is helpful. Again thank you for your efforts on behalf of a random stranger.
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. Replies: 9
    Last Post: November 6th 2010, 01:47 PM
  2. Replies: 2
    Last Post: July 6th 2010, 07:33 PM
  3. Sets Review *screams*
    Posted in the Calculus Forum
    Replies: 1
    Last Post: April 7th 2010, 07:22 AM
  4. Help! Sets Review.
    Posted in the Algebra Forum
    Replies: 1
    Last Post: April 7th 2010, 06:56 AM
  5. prob and stat inference-sets review
    Posted in the Advanced Statistics Forum
    Replies: 2
    Last Post: August 21st 2008, 04:52 PM

Search Tags


/mathhelpforum @mathhelpforum