4 Replies Latest reply on Sep 7, 2018 8:27 AM by Pearl.pat.0

    Median

    Pearl.pat.0

      Hi

       

      I would like to calculate median I have only months which has complaint number. Is there a way I can calculate median for 12 months which don't have complaint number.

       

       

      ProductComplaintYear-MonthComplaint No
      ABCClose2017-025
      ABCClose2017-053
      XYZIn progress2017-011
      XYZIn progress2017-032
      XYZIn progress2017-041

       

      Thanks,

        • 1. Re: Median
          Hari Ankem

          It would depend on whether you consider that the other 10 months have 0 complaints or null complaints.

          • 2. Re: Median
            Pearl.pat.0

            So the other complain are 0 for 10 months or 8 months.

            • 3. Re: Median
              Hari Ankem

              Assuming this can be done, the values for every month with and without the products are as given below, and the median is zero in either case. Is that correct, or are you expecting it to be done some other way?

              1.png1.png

              • 4. Re: Median
                Pearl.pat.0

                So I have data without 0  Lets say i have product ABC and XYZ so i have data , whatever month has value in it not the data with other month which dont have data. Like below.

                (With this data i would like to calculate median for 12 month . For example ABC has complaint no for February and May but i want to calculate median for 12 months)

                 

                ProductComplaintYear-MonthComplaint No
                ABCClose2017-025
                ABCClose2017-053
                XYZIn progress2017-011
                XYZIn progress2017-032
                XYZIn progress2017-041

                 

                Thanks