topic Re: Find statistical dferences between days in Statistical Procedures

Find statistical dferences between days

jonatan_velarde — Tue, 20 Apr 2021 14:41:08 GMT

I have this dataset:

data have;
length day$ 20;
input week day$ sell_item;
format sell_item sell_item_.;
datalines;
1 Monday 6
1 Tuesday 51
1 Wednesday 69
1 Thursday 68
1 Friday 28
1 Saturday 16
1 Sunday 94
;
proc freq data=have;
tables day / nopercent norow nocol deviation expected chisq;
weight sell_item;
run;

here i see information of selling items in a store. Regarding chi squared test, can be found statistical significance (p<0.01), but i would like to estimate individual difference of selling between each day.

thanks in advance

Re: Find statistical dferences between days

sbxkoenk — Tue, 20 Apr 2021 16:15:26 GMT

The Chi-Square Test you do is testing for Equal Proportions.

Here's how to compare two proportions in SAS (between two days if you want):

I haven't read above blog and usage note myself (I'm in a hurry) but it may be that you still have to correct for an inflation of the TYPE-I error when doing multiple comparisons (like a BONFERRONI correction).

Cheers,

Koen

Re: Find statistical dferences between days

PaigeMiller — Tue, 20 Apr 2021 16:32:44 GMT

You can't find a statistical difference between days unless you have replicates of Monday, and replicates of Tuesday, and so on.

Re: Find statistical dferences between days

jonatan_velarde — Tue, 20 Apr 2021 17:44:26 GMT

I thought the same my friend, later i posted current question.

What can be done with this code:
data have;
length day$ 20;
input week day$ sell_item;
format sell_item sell_item_.;
datalines;
1 Monday 6
1 Tuesday 51
1 Wednesday 69
1 Thursday 68
1 Friday 28
1 Saturday 16
1 Sunday 94
2 Monday 16
2 Tuesday 41
2 Wednesday 29
2 Thursday 28
2 Friday 78
2 Saturday 6
2 Sunday 4
3 Monday 16
3 Tuesday 71
3 Wednesday 19
3 Thursday 18
3 Friday 18
3 Saturday 36
3 Sunday 64

;
proc freq data=have;
tables day / nopercent norow nocol deviation expected chisq;
weight sell_item;
run;

Re: Find statistical dferences between days

StatDave — Tue, 20 Apr 2021 17:45:31 GMT

If there is only the one predictor, then you can fit a Poisson model. Note that in this case, the model is saturated, so the predicted values are exactly the observed values.

proc genmod;
class day;
model sell_item=day/dist=poisson;
lsmeans day / diff ilink; 
run;

If there is a second categorical predictor, resulting in a 2-way table with your SELL_ITEM variable giving the cell counts, then this note shows ways you can proceed, including analyzing subtables or fitting a model.

Re: Find statistical dferences between days

PaigeMiller — Tue, 20 Apr 2021 17:49:55 GMT

Okay, what hypothesis do you want to test to determine if the difference between days is statistically significant?

Re: Find statistical dferences between days

jonatan_velarde — Tue, 20 Apr 2021 17:53:02 GMT

Hypothesis: At least 1 day has better sells at week.

Re: Find statistical dferences between days

StatDave — Tue, 20 Apr 2021 18:20:39 GMT

For that hypothesis you only need the Type 3 test for DAY from this code:

proc genmod data=have;
class day;
model sell_item=day/dist=poisson type3;
run;

Re: Find statistical dferences between days

Ksharp — Wed, 21 Apr 2021 13:11:49 GMT

Also could try TESTP= option:
proc freq data=have;
tables day / testp=(.....);
weight sell_item;
run;