Interpret Statistical Output

banhkeovn
GameData.xlsx

VisitTime & Advertising

Sum of VisitTime Advertising
Date No Yes
Sunday 0 2.05
Monday 1.16 6.41
Tuesday 1.33 4.39
Wednesday 2.88 0
Thursday 0 5.25
Friday 0 1.68
Saturday 0 5.87

Sum of VisitTime by Date and Advertising

No Sunday Monday Tuesday Wednesday Thursday Friday Saturday 0 1.1599999999999999 1.33 2.88 0 0 0 Yes Sunday Monday Tuesday Wednesday Thursday Friday Saturday 2.0499999999999998 6.41 4.3899999999999997 0 5.25 1.68 5.870000000000001

VisitTime & Game

Sum of VisitTime Game
Date Police Theif
Sunday 0.82 1.23
Monday 3.26 4.31
Tuesday 4.31 1.41
Wednesday 0 2.88
Thursday 2.4 2.85
Friday 0 1.68
Saturday 0.76 5.11

Sum of VisitTime by Date and Game

Police Sunday Monday Tuesday Wednesday Thursday Friday Saturday 0.82 3.26 4.3100000000000005 0 2.4 0 0.76 Theif Sunday Monday Tuesday Wednesday Thursday Friday Saturday 1.23 4.3100000000000005 1.41 2.88 2.85 1.68 5.1100000000000003

Total Time and Advertising

Sum of TotalTime Advertising
Date No Yes
Sunday 0 2.05
Monday 1.16 44.26
Tuesday 3.99 19.12
Wednesday 2.88 0
Thursday 0 45.28
Friday 0 1.68
Saturday 0 5.87

Sum of TotalTime by Date and Advertising

No Sunday Monday Tuesday Wednesday Thursday Friday Saturday 0 1.1599999999999999 3.99 2.88 0 0 0 Yes Sunday Monday Tuesday Wednesday Thursday Friday Saturday 2.0499999999999998 44.26 19.12 0 45.28 1.68 5.870000000000001

VideoGameData

Date Visits VisitTime TotalTime Game Advertising
Friday 0 0 0 Police Yes
Saturday 1 0.76 0.76 Police Yes
Sunday 0 0 0 Police Yes
Monday 0 0 0 Police No
Tuesday 0 0 0 Police No
Wednesday 0 0 0 Police No
Thursday 0 0 0 Police No
Friday 0 0 0 Police No
Saturday 0 0 0 Police No
Sunday 0 0 0 Police No
Monday 6 1.33 7.95 Police Yes
Tuesday 5 2.98 14.9 Police Yes
Wednesday 0 0 0 Police Yes
Thursday 7 2.4 16.83 Police Yes
Friday 0 0 0 Police Yes
Saturday 0 0 0 Police Yes
Sunday 1 0.82 0.82 Police Yes
Monday 8 1.93 15.45 Police Yes
Tuesday 3 1.33 3.99 Police No
Wednesday 0 0 0 Police No
Thursday 0 0 0 Police No
Friday 0 0 0 Police No
Friday 1 1.68 1.68 Theif Yes
Saturday 1 0.67 0.67 Theif Yes
Sunday 0 0 0 Theif Yes
Monday 1 1.16 1.16 Theif No
Tuesday 0 0 0 Theif No
Wednesday 1 2.88 2.88 Theif No
Thursday 0 0 0 Theif No
Friday 0 0 0 Theif No
Saturday 0 0 0 Theif No
Sunday 0 0 0 Theif No
Monday 8 1 7.97 Theif Yes
Tuesday 3 1.41 4.22 Theif Yes
Wednesday 0 0 0 Theif Yes
Thursday 10 2.85 28.45 Theif Yes
Friday 0 0 0 Theif Yes
Saturday 1 4.44 4.44 Theif Yes
Sunday 1 1.23 1.23 Theif Yes
Monday 6 2.15 12.89 Theif Yes
Tuesday 0 0 0 Theif No
Wednesday 0 0 0 Theif No
Thursday 0 0 0 Theif No
Friday 0 0 0 Theif No

Data Assorted

Date Visits VisitTime TotalTime Game Advertising
Friday 0 0 0 1 1
Saturday 1 0.76 0.76 1 1
Sunday 0 0 0 1 1
Monday 0 0 0 1 0
Tuesday 0 0 0 1 0
Wednesday 0 0 0 1 0
Thursday 0 0 0 1 0
Friday 0 0 0 1 0
Saturday 0 0 0 1 0
Sunday 0 0 0 1 0
Monday 6 1.33 7.95 1 1
Tuesday 5 2.98 14.9 1 1
Wednesday 0 0 0 1 1
Thursday 7 2.4 16.83 1 1
Friday 0 0 0 1 1
Saturday 0 0 0 1 1
Sunday 1 0.82 0.82 1 1
Monday 8 1.93 15.45 1 1
Tuesday 3 1.33 3.99 1 0
Wednesday 0 0 0 1 0
Thursday 0 0 0 1 0
Friday 0 0 0 1 0
Friday 1 1.68 1.68 0 1
Saturday 1 0.67 0.67 0 1
Sunday 0 0 0 0 1
Monday 1 1.16 1.16 0 0
Tuesday 0 0 0 0 0
Wednesday 1 2.88 2.88 0 0
Thursday 0 0 0 0 0
Friday 0 0 0 0 0
Saturday 0 0 0 0 0
Sunday 0 0 0 0 0
Monday 8 1 7.97 0 1
Tuesday 3 1.41 4.22 0 1
Wednesday 0 0 0 0 1
Thursday 10 2.85 28.45 0 1
Friday 0 0 0 0 1
Saturday 1 4.44 4.44 0 1
Sunday 1 1.23 1.23 0 1
Monday 6 2.15 12.89 0 1
Tuesday 0 0 0 0 0
Wednesday 0 0 0 0 0
Thursday 0 0 0 0 0
Friday 0 0 0 0 0

Advertising = "Yes" then equals 1 If "No" then equals 0

Game = "Police" then equals 1 If "Thief" then equals 0

DESCRIPTIVE STATISTICS

Visits VisitTime TotalTime Game Advertising
Mean 1.4545454545 Mean 0.705 Mean 2.8702272727 Mean 0.5 Mean 0.5
Standard Error 0.402758125 Standard Error 0.1644307562 Standard Error 0.9059571165 Standard Error 0.0762492852 Standard Error 0.0762492852
Median 0 Median 0 Median 0 Median 0.5 Median 0.5
Mode 0 Mode 0 Mode 0 Mode 1 Mode 1
Standard Deviation 2.6715951637 Standard Deviation 1.0907102444 Standard Deviation 6.009439663 Standard Deviation 0.5057805389 Standard Deviation 0.5057805389
Sample Variance 7.1374207188 Sample Variance 1.1896488372 Sample Variance 36.1133650634 Sample Variance 0.2558139535 Sample Variance 0.2558139535
Kurtosis 2.6019074862 Kurtosis 2.2214251402 Kurtosis 7.5522362568 Kurtosis -2.0975609756 Kurtosis -2.0975609756
Skewness 1.93103248 Skewness 1.6210035039 Skewness 2.6705723526 Skewness 2.70486229698266E-17 Skewness -5.40972459396533E-18
Range 10 Range 4.44 Range 28.45 Range 1 Range 1
Minimum 0 Minimum 0 Minimum 0 Minimum 0 Minimum 0
Maximum 10 Maximum 4.44 Maximum 28.45 Maximum 1 Maximum 1
Sum 64 Sum 31.02 Sum 126.29 Sum 22 Sum 22
Count 44 Count 44 Count 44 Count 44 Count 44
Largest(1) 10 Largest(1) 4.44 Largest(1) 28.45 Largest(1) 1 Largest(1) 1
Smallest(1) 0 Smallest(1) 0 Smallest(1) 0 Smallest(1) 0 Smallest(1) 0
Confidence Level(95.0%) 0.8122391688 Confidence Level(95.0%) 0.3316062233 Confidence Level(95.0%) 1.8270366496 Confidence Level(95.0%) 0.1537713386 Confidence Level(95.0%) 0.1537713386

ANOVA

Anova: Two-Factor With Replication
SUMMARY Visits VisitTime TotalTime Game Advertising Total
Friday
Count 44 44 44 44 44 220
Sum 64 31.02 126.29 22 22 265.31
Average 1.4545454545 0.705 2.8702272727 0.5 0.5 1.2059545455
Variance 7.1374207188 1.1896488372 36.1133650634 0.2558139535 0.2558139535 9.6457894956
Total
Count 44 44 44 44 44
Sum 64 31.02 126.29 22 22
Average 1.4545454545 0.705 2.8702272727 0.5 0.5
Variance 7.1374207188 1.1896488372 36.1133650634 0.2558139535 0.2558139535
ANOVA
Source of Variation SS df MS F P-value F crit
Sample 0 0 65535 65535 ERROR:#NUM! ERROR:#NUM!
Columns 179.4892109091 4 44.8723027273 4.9911283493 0.0007247266 2.4136389418
Interaction 0 0 65535 65535 ERROR:#NUM! ERROR:#NUM!
Within 1932.9386886364 215 8.9904125053
Total 2112.4278995455 219