0
$\begingroup$

I have collected a set of data of 52 weeks of actual output and demand.

Actual 1100 1300 1400 1500 1600 1100 1200 1600 2100 1300 1600 1300 1600 2200 2300 1700 1800 800 1400 900 2100 1400 1800 1900 1000 1800 1700 2100 800 1100 900 1600 1700 1400 1100 1200 1700 900 700 900 1300 700 1500 700 1300 1100 1700 1600 1800 2000 1500 2100

Demand 1500 2100 1600 1500 2000 1600 1200 2000 2200 2000 2200 2000 2000 2500 2500 2000 2000 1000 2000 1500 2500 1500 2500 2500 2000 2000 2500 2500 1500 1500 1400 2000 2000 2000 1500 1500 2500 1500 1500 1500 2500 1500 2000 1500 1500 2000 2000 2500 2500 2500 2500 2500

Now I am having question in what test should I used and I I found out that one is normally distributed and the other one is not.

$\endgroup$
11
  • $\begingroup$ Have you considered the Wilcoxon test? If you are comparing the means between output and demand and the normality assumption is violated you could always just use the wilcoxon test. $\endgroup$
    – cdeterman
    Nov 7, 2014 at 16:50
  • $\begingroup$ Is that Wilcoxon test is only can be used if output and demand data are both violated the normality assumption ? Or it can just be used when either one violate the normality assumption? $\endgroup$ Nov 7, 2014 at 16:54
  • $\begingroup$ Are your weeks sequential? Ie, week1 A D, then week2 A D..., etc. You will almost certainly have serial correlation, which needs to be taken into account or your answer will be incorrect. $\endgroup$ Nov 7, 2014 at 16:57
  • $\begingroup$ Yes, they are sequential... From 1st week - 52nd week.... Now I got to prove the actual output are having a significant difference compared to the demand. I have no idea where to start with.... any guidance? $\endgroup$ Nov 7, 2014 at 17:00
  • $\begingroup$ Given the sequential aspect, which I regrettably overlooked, you may want to look into repeated measures anova. The Friedman test is typically considered the nonparametric equivalent. $\endgroup$
    – cdeterman
    Nov 7, 2014 at 17:07

1 Answer 1

2
$\begingroup$

My suggestion: For each week compute the difference between demand and supply (production), then analyze that list of 52 differences either with a one sample t test or a Wilcoxon rank sum test.

But there is no real reason to do any statistics, as Demand exceeds Supply every single week: enter image description here

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.