Jump to content
We've recently updated our Privacy Statement, available here. ×

Median for duplicated data


Ken Suga

Recommended Posts

Hi,

When considering the median of product sales, if there is a duplicate product between product category "B" and "C",

the median sales of their upper product category A is the value which counts the duplicate product twice.

How can I remove the duplicated value

Example data.

 

 

 

3rd Product Category

2nd Product Category

1st Product Category

Product Number

Sales ($)

 

 

Sports wears

Sports goods

Hobby & Daily

A1

10

 

 

Sports wears

Sports goods

Hobby & Daily

A2

11

 

 

Sports wears

Clothes

Hobby & Daily

A1

10

 

 

Sports wears

Clothes

Hobby & Daily

A2

11

 

 

Woking clothes

Clothes

Hobby & Daily

B1

15

 

 

Rackets

Sports goods

Hobby & Daily

C1

12

 

 

Rackets

Sports goods

Hobby & Daily

C2

13

 

 

 

In this case, product "A1" and "A2" areduplicated products within "Hobby & Daily" category.

When considering the median of sales of "Hobby & Daily", the median is $11 if no operation would bedone.

But correct median is $12.

Does Spotfire have any functions for this matterOr shold I modify and adjust the original dataSpotfire

Sincerely,

Kei

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...