I am looking to stat test share of preference between SKUs and within subgroups in an Excel based simulator, based on a volumetric CBC. I used the Volumetric CBC .CHS converter, resulting in volumetric weights. How do I account for the weights in the stat testing? I currently have a one-sample t-test as a placeholder with the below formula:
Thanks in advance!