Here's what I am working with at the moment re: ratio normalization. What dates would you use for summer and christmas? Is there anything else you think I am missing?
TIA
|
# All |
Ratio All |
# R |
Ratio R |
# PG |
Ratio PG |
| Action/Adventure |
7 |
2.17 |
5 |
2.16 |
2 |
2.19 |
| Animated |
4 |
2.75 |
0 |
#DIV/0! |
4 |
2.75 |
| Comedy |
8 |
3.33 |
1 |
2.50 |
7 |
3.45 |
| Documentary |
3 |
2.12 |
1 |
2.81 |
2 |
1.78 |
| Drama |
13 |
3.29 |
9 |
3.22 |
4 |
3.44 |
| Family |
1 |
4.62 |
0 |
#DIV/0! |
1 |
4.62 |
| Fantasy |
3 |
2.84 |
0 |
#DIV/0! |
3 |
2.84 |
| Horror |
4 |
2.03 |
3 |
2.10 |
1 |
1.82 |
| Musical |
1 |
1.39 |
0 |
#DIV/0! |
1 |
1.39 |
| Romance/RomCom |
3 |
2.56 |
2 |
2.77 |
1 |
2.15 |
| Sci-Fi |
5 |
2.62 |
3 |
2.49 |
2 |
2.82 |
| Thriller |
8 |
2.22 |
5 |
2.14 |
3 |
2.36 |
|
60 |
2.72 |
29 |
2.59 |
31 |
2.84 |
|
|
|
|
|
|
|
|
# Christmas |
Ratio Christmas |
# Summer |
Ratio Summer |
# Genre -xmas -summer |
Ratio Genre -xmas -summer |
| Action/Adventure |
0 |
#DIV/0! |
1 |
2.07 |
6 |
2.18 |
| Animated |
0 |
#DIV/0! |
1 |
3.28 |
3 |
2.57 |
| Comedy |
3 |
3.45 |
1 |
4.00 |
4 |
3.07 |
| Documentary |
1 |
1.97 |
1 |
1.58 |
1 |
2.81 |
| Drama |
4 |
4.75 |
2 |
2.99 |
7 |
2.54 |
| Family |
1 |
4.62 |
0 |
#DIV/0! |
0 |
#DIV/0! |
| Fantasy |
1 |
2.73 |
1 |
2.68 |
1 |
3.11 |
| Horror |
0 |
#DIV/0! |
1 |
2.54 |
3 |
1.86 |
| Musical |
0 |
#DIV/0! |
0 |
#DIV/0! |
1 |
1.39 |
| Romance/RomCom |
0 |
#DIV/0! |
0 |
#DIV/0! |
3 |
2.56 |
| Sci-Fi |
0 |
#DIV/0! |
2 |
2.66 |
3 |
2.59 |
| Thriller |
0 |
#DIV/0! |
3 |
1.86 |
5 |
2.44 |
|
10 |
3.87 |
13 |
2.54 |
37 |
2.47 |
|
"1 week prior" to 31 dec |
1 June to 31 August |
|
|