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

# Median

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.

 Product Complaint Year-Month Complaint No ABC Close 2017-02 5 ABC Close 2017-05 3 XYZ In progress 2017-01 1 XYZ In progress 2017-03 2 XYZ In progress 2017-04 1

Thanks,

• ###### 1. Re: Median

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

• ###### 2. Re: Median

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

• ###### 3. Re: Median

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?

• ###### 4. Re: Median

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)

 Product Complaint Year-Month Complaint No ABC Close 2017-02 5 ABC Close 2017-05 3 XYZ In progress 2017-01 1 XYZ In progress 2017-03 2 XYZ In progress 2017-04 1

Thanks