analysis for merged data