Bài về nhà
Xuân Huyền
2023-07-04
library(readxl)
d <- read_excel("C:/RRR/dulieu_thuchanh4.xlsx", sheet = "Sheet1")
d## # A tibble: 579 × 7
## movie_title release_date genre mpaa_rating total_gross
## <chr> <dttm> <chr> <chr> <dbl>
## 1 Snow White and the Seven D… 1937-12-21 00:00:00 Musi… G 184925485
## 2 Pinocchio 1940-02-09 00:00:00 Adve… G 84300000
## 3 Fantasia 1940-11-13 00:00:00 Musi… G 83320000
## 4 Song of the South 1946-11-12 00:00:00 Adve… G 65000000
## 5 Cinderella 1950-02-15 00:00:00 Drama G 85000000
## 6 20,000 Leagues Under the S… 1954-12-23 00:00:00 Adve… G 28200000
## 7 Lady and the Tramp 1955-06-22 00:00:00 Drama G 93600000
## 8 Sleeping Beauty 1959-01-29 00:00:00 Drama G 9464608
## 9 101 Dalmatians 1961-01-25 00:00:00 Come… G 153000000
## 10 The Absent Minded Professor 1961-03-16 00:00:00 Come… G 25381407
## # ℹ 569 more rows
## # ℹ 2 more variables: inflation_adjusted_gross <dbl>, doanhthu <chr>1 Ước lượng mô hình hồi quy
1.1 Ước lượng hàm hồi quy cho biến doanh thu, phụ thuộc vào biến genre và mpaa_rating
DT <- d$doanhthu
GE <- d$genre
MP <- d$mpaa_rating
# Xác định thứ tự các phạm trù của biến doanhthu
levels(factor(DT))## [1] "cao" "thap"1.1.1 Mô hình hồi quy logit
HQ1 <- glm(factor(DT) ~ GE + MP, family = binomial(link = 'logit'), data = d)
summary(HQ1)##
## Call:
## glm(formula = factor(DT) ~ GE + MP, family = binomial(link = "logit"),
## data = d)
##
## Deviance Residuals:
## Min 1Q Median 3Q Max
## -1.6894 -1.0448 -0.8518 1.1912 1.6248
##
## Coefficients:
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) -0.23475 0.39396 -0.596 0.5513
## GEAdventure -0.42445 0.38622 -1.099 0.2718
## GEBlack Comedy -0.68106 1.27366 -0.535 0.5928
## GEComedy 0.08250 0.35600 0.232 0.8167
## GEConcert/Performance 14.80081 624.19395 0.024 0.9811
## GEDocumentary 1.38734 0.68273 2.032 0.0421 *
## GEDrama 0.42172 0.36811 1.146 0.2520
## GEHorror 0.76931 0.92564 0.831 0.4059
## GEMusical -0.60645 0.64476 -0.941 0.3469
## GERomantic Comedy 0.13341 0.52553 0.254 0.7996
## GEThriller/Suspense -0.77762 0.54910 -1.416 0.1567
## GEWestern -0.76375 0.89506 -0.853 0.3935
## MPPG -0.16791 0.25707 -0.653 0.5136
## MPPG-13 0.06893 0.29060 0.237 0.8125
## MPR 0.22266 0.30615 0.727 0.4670
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 781.07 on 567 degrees of freedom
## Residual deviance: 749.66 on 553 degrees of freedom
## (11 observations deleted due to missingness)
## AIC: 779.66
##
## Number of Fisher Scoring iterations: 13Kết quả ước lượng cho thấy giá trị Pr(>|z|) của các biến thu nhập trung bình của khách hàng trong 1 tháng, biến thể loại và biến mpaa_rating đều nhỏ hơn 5% cho thấy mỗi biến trên đều có ý nghĩa thống kê trong mô hình. Từ đó ta có hàm dữ liệu nhị phân logit:
\(DT= -0.23475-0.42445Ad-0.68106BC+0.08250C+14.80081C/P+1.38734D+0.42172Dr+0.76931H-0.60645M +0.13341RC-0.77762T/S-0.76375W-0.16791G+0.068939(PG-13)+0.22266R\)
1.1.2 Mô hình hồi quy probit
HQ2 <- glm(factor(DT) ~ GE + MP, family = binomial(link = 'probit'), data = d)
summary(HQ2)##
## Call:
## glm(formula = factor(DT) ~ GE + MP, family = binomial(link = "probit"),
## data = d)
##
## Deviance Residuals:
## Min 1Q Median 3Q Max
## -1.6859 -1.0459 -0.8524 1.1927 1.6218
##
## Coefficients:
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) -0.15019 0.24550 -0.612 0.5407
## GEAdventure -0.26214 0.24009 -1.092 0.2749
## GEBlack Comedy -0.42582 0.77976 -0.546 0.5850
## GEComedy 0.05041 0.22258 0.226 0.8208
## GEConcert/Performance 4.96938 103.91251 0.048 0.9619
## GEDocumentary 0.85185 0.40941 2.081 0.0375 *
## GEDrama 0.26263 0.23005 1.142 0.2536
## GEHorror 0.47283 0.56692 0.834 0.4043
## GEMusical -0.36850 0.39268 -0.938 0.3480
## GERomantic Comedy 0.08247 0.32878 0.251 0.8019
## GEThriller/Suspense -0.48596 0.33504 -1.450 0.1469
## GEWestern -0.47524 0.54056 -0.879 0.3793
## MPPG -0.09886 0.15842 -0.624 0.5326
## MPPG-13 0.04526 0.18023 0.251 0.8017
## MPR 0.14528 0.19007 0.764 0.4447
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 781.07 on 567 degrees of freedom
## Residual deviance: 749.65 on 553 degrees of freedom
## (11 observations deleted due to missingness)
## AIC: 779.65
##
## Number of Fisher Scoring iterations: 12Kết quả ước lượng cho thấy giá trị Pr(>|z|) của các biến thu nhập trung bình của khách hàng trong 1 tháng, biến thể loại và biến mpaa_rating đều nhỏ hơn 5% cho thấy mỗi biến trên đều có ý nghĩa thống kê trong mô hình. Từ đó ta có hàm dữ liệu nhị phân probit:
\(DT= -0.15019-0.26214Ad-0.42582BC+0.05041C+4.96938C/P+ 0.85185D+0.26263Dr+0.47283H-0.36850M +0.08247RC-0.48596T/S-0.475245W-0.09886G+0.04526(PG-13)+0.14528R\)
1.1.3 Mô hình hồi quy cloglog
HQ3 <- glm(factor(DT) ~ GE + MP, family = binomial(link = 'cloglog'), data = d)
summary(HQ3)##
## Call:
## glm(formula = factor(DT) ~ GE + MP, family = binomial(link = "cloglog"),
## data = d)
##
## Deviance Residuals:
## Min 1Q Median 3Q Max
## -1.6841 -1.0494 -0.8538 1.1999 1.6187
##
## Coefficients:
## Estimate Std. Error z value Pr(>|z|)
## (Intercept) -0.54005 0.29397 -1.837 0.0662 .
## GEAdventure -0.34124 0.29494 -1.157 0.2473
## GEBlack Comedy -0.49790 1.03926 -0.479 0.6319
## GEComedy 0.06440 0.26452 0.243 0.8076
## GEConcert/Performance 3.22988 48.54732 0.067 0.9470
## GEDocumentary 0.88935 0.41488 2.144 0.0321 *
## GEDrama 0.30416 0.26801 1.135 0.2564
## GEHorror 0.51864 0.57972 0.895 0.3710
## GEMusical -0.49591 0.52566 -0.943 0.3455
## GERomantic Comedy 0.09543 0.38750 0.246 0.8055
## GEThriller/Suspense -0.60438 0.44547 -1.357 0.1749
## GEWestern -0.60238 0.74631 -0.807 0.4196
## MPPG -0.12105 0.19467 -0.622 0.5341
## MPPG-13 0.06377 0.21646 0.295 0.7683
## MPR 0.13523 0.22402 0.604 0.5461
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## (Dispersion parameter for binomial family taken to be 1)
##
## Null deviance: 781.07 on 567 degrees of freedom
## Residual deviance: 750.03 on 553 degrees of freedom
## (11 observations deleted due to missingness)
## AIC: 780.03
##
## Number of Fisher Scoring iterations: 12Kết quả ước lượng cho thấy giá trị Pr(>|z|) của các biến thu nhập trung bình của khách hàng trong 1 tháng, biến thể loại và biến mpaa_rating đều nhỏ hơn 5% cho thấy mỗi biến trên đều có ý nghĩa thống kê trong mô hình. Từ đó ta có hàm dữ liệu nhị phân probit:
\(DT= -0.54005-0.34124Ad-0.49790BC+0.06440C+3.22988C/P+0.88935D+0.30416Dr+0.51864H-0.49591M +0.09543RC--0.60438T/S-0.60238W-0.12105G+0.06377(PG-13)+0.13523R\)
1.2 Lựa chọn mô hình phù hợp
1.2.1 Dựa vào tiêu chí AIC
AIC được đề xuất bởi Akaike Hirotugu, một nhà thống kê học người Nhật. AIC là một tiêu chí được sử dụng một cách phổ biến để đánh giá một mô hình hồi quy được ước lượng bởi phương pháp Maximum Likekihood (ML). Một cách chung chung giá trị của AIC càng nhỏ thì mô hình càng tốt. Ta có:
\(AIC (logit)= 779.66\)
\(AIC (probit) = 779.65\)
\(AIC (cloglog) = 780.03\)
Kết quả cho thấy mô hình hồi quy logit có giá trị AIC nhỏ nhất, vì vậy mô hình logit là phù hợp nhất
1.2.2 Brier Score
library (DescTools)## Warning: package 'DescTools' was built under R version 4.2.3BrierScore(HQ1)## [1] 0.2341005BrierScore(HQ2)## [1] 0.2341095BrierScore(HQ3)## [1] 0.2342221Kết quả cho thấy BrierScore của mô hình logit có giá trị nhỏ nhất 0.2341005 nghĩa là mô hình này là tốt nhất.
1.2.3 Ma trận nhầm lẫn
library(caret)## Warning: package 'caret' was built under R version 4.2.3## Loading required package: ggplot2## Warning: package 'ggplot2' was built under R version 4.2.3## Loading required package: lattice##
## Attaching package: 'caret'## The following objects are masked from 'package:DescTools':
##
## MAE, RMSE2 Thống kê mô tả
2.1 Ta sử dụng dữ liệu thông tin về các bộ phim của Disney như sau:
library(readxl)
d <- read_excel("C:/RRR/dulieu_thuchanh4.xlsx", sheet = "Sheet1")
str(d)## tibble [579 × 7] (S3: tbl_df/tbl/data.frame)
## $ movie_title : chr [1:579] "Snow White and the Seven Dwarfs" "Pinocchio" "Fantasia" "Song of the South" ...
## $ release_date : POSIXct[1:579], format: "1937-12-21" "1940-02-09" ...
## $ genre : chr [1:579] "Musical" "Adventure" "Musical" "Adventure" ...
## $ mpaa_rating : chr [1:579] "G" "G" "G" "G" ...
## $ total_gross : num [1:579] 1.85e+08 8.43e+07 8.33e+07 6.50e+07 8.50e+07 ...
## $ inflation_adjusted_gross: num [1:579] 5.23e+09 2.19e+09 2.19e+09 1.08e+09 9.21e+08 ...
## $ doanhthu : chr [1:579] "cao" "cao" "cao" "cao" ...2.2 Bảng tần số:
- Ta có bảng tần số cho biến inflation_adjusted_gross (doanh thu đã điều chỉnh lạm phát)
table(d$doanhthu)##
## cao thap
## 314 265table(d$doanhthu)/sum(table(d$doanhthu))##
## cao thap
## 0.5423143 0.4576857Theo kết quả, ta thấy có 54,23% số bộ phim đã phát hành của disney có doanh thu cao, 45,78% bộ phim có doanh thu thấp. Đồ thị của biến doanh thu như sau:
library("ggplot2")
d |> ggplot(aes(doanhthu))+geom_bar(color='red', fill='pink')
- Bảng tần số cho biến genre (thể loại)
table(d$genre)##
## Action Adventure Black Comedy Comedy
## 41 131 3 183
## Concert/Performance Documentary Drama Horror
## 2 16 115 6
## Musical Romantic Comedy Thriller/Suspense Western
## 17 23 24 7table(d$genre)/sum(table(d$genre))##
## Action Adventure Black Comedy Comedy
## 0.072183099 0.230633803 0.005281690 0.322183099
## Concert/Performance Documentary Drama Horror
## 0.003521127 0.028169014 0.202464789 0.010563380
## Musical Romantic Comedy Thriller/Suspense Western
## 0.029929577 0.040492958 0.042253521 0.012323944Theo kết quả ta thấy có 7,11% số bộ phim thuộc thể loại phim hành động; 22,95% số bộ phim thuộc thể thoại phim phiêu lưu; 0,53% số bộ phim thuộc thể loại hài kịch châm biếm; 32,38% số bộ phim thuộc thể loại hài kịch; 0,35% số bộ phim thuộc thể loại hòa nhạc - biểu diễn; 2,84% số bộ phim thuộc thể loại nhạc kịch; 2,84% phim tài liệu; 4,09% phim hài kịch lãng mạn; 20,28% phim truyền hình; 4,27% phim thể loại kinh dị/hồi hộp; 1,07% phim kinh dị và 1,24% phim về miền viễn Tây.
Biểu đồ:
d |> ggplot(aes(genre))+geom_bar(color='darkgreen', fill='green')
- Bảng tần số của biến mpaa_rating (đánh giá phân loại phim theo hệ thóng MPAA)
table(d$mpaa_rating)##
## G PG PG-13 R
## 116 199 145 119table(d$mpaa_rating)/sum(table(d$mpaa_rating))##
## G PG PG-13 R
## 0.2003454 0.3436960 0.2504318 0.2055268Theo kết quả, ta thấy có 20,03% số bộ phim được đánh giá là G (dành cho mọi đối tượng khán giả); 34,36% bộ phim được đánh giá PG (dành cho trẻ em có sự giám sát của phụ huynh); 25,04% số bộ phim được đánh giá là PG-13 (dành cho người từ 13 tuổi trở lên) và 20,55% số bộ phim được đánh giá là R (không dành cho trẻ dưới 17 tuổi xem mà không có sự giám sát của người lớn).
Biểu đồ:
d |> ggplot(aes(mpaa_rating))+geom_bar(color='darkblue', fill='skyblue')
2.3 Thống kê mô tả cho 2 biến
2.3.1 Lập bảng ngẫu nhiên 2 chiều cho biến genre, biến doanhthu và tần suất biên tương ứng.
xh <- table(d$genre, d$doanhthu)
xh##
## cao thap
## Action 22 19
## Adventure 88 43
## Black Comedy 2 1
## Comedy 99 84
## Concert/Performance 0 2
## Documentary 4 12
## Drama 51 64
## Horror 2 4
## Musical 12 5
## Romantic Comedy 12 11
## Thriller/Suspense 17 7
## Western 5 2xh <- prop.table(xh)
xh##
## cao thap
## Action 0.038732394 0.033450704
## Adventure 0.154929577 0.075704225
## Black Comedy 0.003521127 0.001760563
## Comedy 0.174295775 0.147887324
## Concert/Performance 0.000000000 0.003521127
## Documentary 0.007042254 0.021126761
## Drama 0.089788732 0.112676056
## Horror 0.003521127 0.007042254
## Musical 0.021126761 0.008802817
## Romantic Comedy 0.021126761 0.019366197
## Thriller/Suspense 0.029929577 0.012323944
## Western 0.008802817 0.003521127addmargins(xh)##
## cao thap Sum
## Action 0.038732394 0.033450704 0.072183099
## Adventure 0.154929577 0.075704225 0.230633803
## Black Comedy 0.003521127 0.001760563 0.005281690
## Comedy 0.174295775 0.147887324 0.322183099
## Concert/Performance 0.000000000 0.003521127 0.003521127
## Documentary 0.007042254 0.021126761 0.028169014
## Drama 0.089788732 0.112676056 0.202464789
## Horror 0.003521127 0.007042254 0.010563380
## Musical 0.021126761 0.008802817 0.029929577
## Romantic Comedy 0.021126761 0.019366197 0.040492958
## Thriller/Suspense 0.029929577 0.012323944 0.042253521
## Western 0.008802817 0.003521127 0.012323944
## Sum 0.552816901 0.447183099 1.000000000Dựa vào kết quả, ta thấy bảng tần suất bao gồm tỷ lệ phần trăm số bộ phim có doanh thu cao, thấp và tổng của 2 tỷ lệ này ở mỗi thể loại phim. Trong đó thể loại phim nhận được doanh thu cao nhiều nhất là thể loại Comedy, thể loại có doanh thu cao ít nhất là Concert/Performance
Biểu đồ tần suất:
ggplot(d, aes(doanhthu, fill = genre)) + geom_bar(position = 'dodge')
Rủi ro tương đối
library(epitools)
epitab(xh,method='riskratio',rev='c')## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## $tab
##
## thap p0 cao p1 riskratio
## Action 0.033450704 0.4634146 0.038732394 0.5365854 1.0000000
## Adventure 0.075704225 0.3282443 0.154929577 0.6717557 1.2519084
## Black Comedy 0.001760563 0.3333333 0.003521127 0.6666667 1.2424242
## Comedy 0.147887324 0.4590164 0.174295775 0.5409836 1.0081967
## Concert/Performance 0.003521127 1.0000000 0.000000000 0.0000000 0.0000000
## Documentary 0.021126761 0.7500000 0.007042254 0.2500000 0.4659091
## Drama 0.112676056 0.5565217 0.089788732 0.4434783 0.8264822
## Horror 0.007042254 0.6666667 0.003521127 0.3333333 0.6212121
## Musical 0.008802817 0.2941176 0.021126761 0.7058824 1.3155080
## Romantic Comedy 0.019366197 0.4782609 0.021126761 0.5217391 0.9723320
## Thriller/Suspense 0.012323944 0.2916667 0.029929577 0.7083333 1.3200758
## Western 0.003521127 0.2857143 0.008802817 0.7142857 1.3311688
##
## lower upper p.value
## Action NA NA NA
## Adventure 8.002383e-04 1.958510e+03 1
## Black Comedy 2.016324e-09 7.655606e+08 1
## Comedy 5.640577e-04 1.802051e+03 1
## Concert/Performance 0.000000e+00 NaN 1
## Documentary 2.533399e-10 8.568380e+08 1
## Drama 1.948103e-04 3.506349e+03 1
## Horror 5.205195e-13 7.413833e+11 1
## Musical 6.142119e-05 2.817531e+04 1
## Romantic Comedy 9.566155e-06 9.883068e+04 1
## Thriller/Suspense 1.427400e-04 1.220821e+04 1
## Western 2.824949e-06 6.272718e+05 1
##
## $measure
## [1] "wald"
##
## $conf.level
## [1] 0.95
##
## $pvalue
## [1] "fisher.exact"Odd ratio
epitab(xh, method = 'oddsratio', rev='c')## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## $tab
##
## thap p0 cao p1 oddsratio
## Action 0.033450704 0.074803150 0.038732394 0.070063694 1.0000000
## Adventure 0.075704225 0.169291339 0.154929577 0.280254777 1.7674419
## Black Comedy 0.001760563 0.003937008 0.003521127 0.006369427 1.7272727
## Comedy 0.147887324 0.330708661 0.174295775 0.315286624 1.0178571
## Concert/Performance 0.003521127 0.007874016 0.000000000 0.000000000 0.0000000
## Documentary 0.021126761 0.047244094 0.007042254 0.012738854 0.2878788
## Drama 0.112676056 0.251968504 0.089788732 0.162420382 0.6882102
## Horror 0.007042254 0.015748031 0.003521127 0.006369427 0.4318182
## Musical 0.008802817 0.019685039 0.021126761 0.038216561 2.0727273
## Romantic Comedy 0.019366197 0.043307087 0.021126761 0.038216561 0.9421488
## Thriller/Suspense 0.012323944 0.027559055 0.029929577 0.054140127 2.0974026
## Western 0.003521127 0.007874016 0.008802817 0.015923567 2.1590909
##
## lower upper p.value
## Action NA NA NA
## Adventure 7.198315e-08 4.339697e+07 1
## Black Comedy 3.909554e-26 7.631231e+25 1
## Comedy 9.496329e-08 1.090983e+07 1
## Concert/Performance 0.000000e+00 NaN 1
## Documentary 1.363140e-14 6.079653e+12 1
## Drama 2.694928e-08 1.757499e+07 1
## Horror 8.977679e-20 2.077006e+18 1
## Musical 6.134582e-13 7.003245e+12 1
## Romantic Comedy 2.441187e-11 3.636117e+10 1
## Thriller/Suspense 1.639237e-11 2.683624e+11 1
## Western 1.626351e-18 2.866340e+18 1
##
## $measure
## [1] "wald"
##
## $conf.level
## [1] 0.95
##
## $pvalue
## [1] "fisher.exact"2.3.2 Lập bảng ngẫu nhiên 2 chiều cho biến mpaa_rating, biến doanhthu và tần suất biên tương ứng
xh1 <- table(d$mpaa_rating, d$doanhthu)
xh1##
## cao thap
## G 64 52
## PG 118 81
## PG-13 76 69
## R 56 63xh1 <- prop.table(xh1)
xh1##
## cao thap
## G 0.11053541 0.08981002
## PG 0.20379965 0.13989637
## PG-13 0.13126079 0.11917098
## R 0.09671848 0.10880829addmargins(xh1)##
## cao thap Sum
## G 0.11053541 0.08981002 0.20034542
## PG 0.20379965 0.13989637 0.34369603
## PG-13 0.13126079 0.11917098 0.25043178
## R 0.09671848 0.10880829 0.20552677
## Sum 0.54231434 0.45768566 1.00000000Dựa vào kết quả bảng tần suất, ta nhận được tỷ lệ phần trăm doanh thu của các bộ phim theo đánh giá phân loại hệ thống MPAA. Trong đó, các bộ phim được phân loại là PG có mức doanh thu cao nhiều nhất, tiếp đó là phim được phân loại PG-13. Phim có doanh thu thấp nhiều nhất là phim được phân loại G.
Biểu đồ tần suất:
ggplot(d, aes(mpaa_rating, fill = doanhthu)) + geom_bar(position = 'dodge')
Rủi ro tương đối
library(epitools)
epitab(xh1,method='riskratio',rev='c')## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## $tab
##
## thap p0 cao p1 riskratio lower
## G 0.08981002 0.4482759 0.11053541 0.5517241 1.0000000 NA
## PG 0.13989637 0.4070352 0.20379965 0.5929648 1.0747487 0.008652788
## PG-13 0.11917098 0.4758621 0.13126079 0.5241379 0.9500000 0.004156041
## R 0.10880829 0.5294118 0.09671848 0.4705882 0.8529412 0.002010509
##
## upper p.value
## G NA NA
## PG 133.4928 1
## PG-13 217.1538 1
## R 361.8530 1
##
## $measure
## [1] "wald"
##
## $conf.level
## [1] 0.95
##
## $pvalue
## [1] "fisher.exact"Tỷ lệ phim được đánh giá là PG-13 có doanh thu cao bằng 95% phim được đánh giá G và PG Tỷ lệ phim được đánh giá R có doanh thu cao bằng 85,29% phim được đánh giá G và PG
Odd ratio
epitab(xh1, method = 'oddsratio', rev='c')## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(xx): 'x' has been rounded to integer: Mean relative
## difference: 1## Warning in chisq.test(xx, correct = correction): Chi-squared approximation may
## be incorrect## Warning in fisher.test(x, or = or, alternative = "l"): 'x' has been rounded to
## integer: Mean relative difference: 1## Warning in fisher.test(x, or = or, alternative = "g"): 'x' has been rounded to
## integer: Mean relative difference: 1## $tab
##
## thap p0 cao p1 oddsratio lower
## G 0.08981002 0.1962264 0.11053541 0.2038217 1.0000000 NA
## PG 0.13989637 0.3056604 0.20379965 0.3757962 1.1836420 1.739173e-05
## PG-13 0.11917098 0.2603774 0.13126079 0.2420382 0.8949275 6.776930e-06
## R 0.10880829 0.2377358 0.09671848 0.1783439 0.7222222 3.123673e-06
##
## upper p.value
## G NA NA
## PG 80556.01 1
## PG-13 118179.67 1
## R 166984.47 1
##
## $measure
## [1] "wald"
##
## $conf.level
## [1] 0.95
##
## $pvalue
## [1] "fisher.exact"Tỷ lệ phim có doanh thu cao được đánh giá PG-13 so với phim có doanh thu thấp được đánh giá PG-13 bằng 89,49% phim được đánh giá G và PG. Tỷ lệ phim có doanh thu cao được đánh giá R so với phim có doanh thu thấp được đánh giá R bằng 72% phim được đánh giá G và PG.
2.3.3 Lập bảng ngẫu nhiên 2 chiều cho biến mpaa_rating, biến genre và tần suất biên tương ứng
xh2 <- table(d$genre, d$mpaa_rating)
xh2##
## G PG PG-13 R
## Action 3 5 19 14
## Adventure 47 61 17 6
## Black Comedy 0 0 0 3
## Comedy 26 81 37 39
## Concert/Performance 2 0 0 0
## Documentary 11 5 0 0
## Drama 12 32 37 34
## Horror 1 0 1 4
## Musical 12 4 1 0
## Romantic Comedy 1 7 12 3
## Thriller/Suspense 0 1 13 10
## Western 0 1 4 2xh2 <- prop.table(xh2)
xh2##
## G PG PG-13 R
## Action 0.005281690 0.008802817 0.033450704 0.024647887
## Adventure 0.082746479 0.107394366 0.029929577 0.010563380
## Black Comedy 0.000000000 0.000000000 0.000000000 0.005281690
## Comedy 0.045774648 0.142605634 0.065140845 0.068661972
## Concert/Performance 0.003521127 0.000000000 0.000000000 0.000000000
## Documentary 0.019366197 0.008802817 0.000000000 0.000000000
## Drama 0.021126761 0.056338028 0.065140845 0.059859155
## Horror 0.001760563 0.000000000 0.001760563 0.007042254
## Musical 0.021126761 0.007042254 0.001760563 0.000000000
## Romantic Comedy 0.001760563 0.012323944 0.021126761 0.005281690
## Thriller/Suspense 0.000000000 0.001760563 0.022887324 0.017605634
## Western 0.000000000 0.001760563 0.007042254 0.003521127addmargins(xh2)##
## G PG PG-13 R
## Action 0.005281690 0.008802817 0.033450704 0.024647887
## Adventure 0.082746479 0.107394366 0.029929577 0.010563380
## Black Comedy 0.000000000 0.000000000 0.000000000 0.005281690
## Comedy 0.045774648 0.142605634 0.065140845 0.068661972
## Concert/Performance 0.003521127 0.000000000 0.000000000 0.000000000
## Documentary 0.019366197 0.008802817 0.000000000 0.000000000
## Drama 0.021126761 0.056338028 0.065140845 0.059859155
## Horror 0.001760563 0.000000000 0.001760563 0.007042254
## Musical 0.021126761 0.007042254 0.001760563 0.000000000
## Romantic Comedy 0.001760563 0.012323944 0.021126761 0.005281690
## Thriller/Suspense 0.000000000 0.001760563 0.022887324 0.017605634
## Western 0.000000000 0.001760563 0.007042254 0.003521127
## Sum 0.202464789 0.346830986 0.248239437 0.202464789
##
## Sum
## Action 0.072183099
## Adventure 0.230633803
## Black Comedy 0.005281690
## Comedy 0.322183099
## Concert/Performance 0.003521127
## Documentary 0.028169014
## Drama 0.202464789
## Horror 0.010563380
## Musical 0.029929577
## Romantic Comedy 0.040492958
## Thriller/Suspense 0.042253521
## Western 0.012323944
## Sum 1.000000000Dựa vào kết quả của bảng tần suất, ta thấy tỷ lệ phần trăm số bộ phim của từng thể loại được đánh giá phân loại theo hệ thống MPAA.
Biểu đồ tần suất:
ggplot(d, aes(mpaa_rating, fill = genre)) + geom_bar(position = 'dodge')
3 Thống kê suy diễn cho dữ liệu định tính
3.1 Kiểm định tính độc lập cho 2 biến định tính
- Kiểm định tính độc lập cho biến genre và doanhthu
xh <- table(d$genre, d$doanhthu)
xh##
## cao thap
## Action 22 19
## Adventure 88 43
## Black Comedy 2 1
## Comedy 99 84
## Concert/Performance 0 2
## Documentary 4 12
## Drama 51 64
## Horror 2 4
## Musical 12 5
## Romantic Comedy 12 11
## Thriller/Suspense 17 7
## Western 5 2chisq.test(xh)## Warning in chisq.test(xh): Chi-squared approximation may be incorrect##
## Pearson's Chi-squared test
##
## data: xh
## X-squared = 27.726, df = 11, p-value = 0.003565Kết quả kiểm định cho thấy có sự độc lập giữa thể loại phim với doanh thu
- Kiểm định tính độc lập cho biến mpaa_rating và doanhthu
xh1 <- table(d$mpaa_rating, d$doanhthu)
xh1##
## cao thap
## G 64 52
## PG 118 81
## PG-13 76 69
## R 56 63chisq.test(xh1)##
## Pearson's Chi-squared test
##
## data: xh1
## X-squared = 4.7577, df = 3, p-value = 0.1904Kết quả kiểm định cho thấy chưa có đủ cơ sở để chỉ ra rằng 2 biến mpaa_rating và doanhthu không liên quan đến nhau
- Kiểm định tính độc lập cho biến genre và mpaa_rating
xh2 <- table(d$genre, d$mpaa_rating)
xh2##
## G PG PG-13 R
## Action 3 5 19 14
## Adventure 47 61 17 6
## Black Comedy 0 0 0 3
## Comedy 26 81 37 39
## Concert/Performance 2 0 0 0
## Documentary 11 5 0 0
## Drama 12 32 37 34
## Horror 1 0 1 4
## Musical 12 4 1 0
## Romantic Comedy 1 7 12 3
## Thriller/Suspense 0 1 13 10
## Western 0 1 4 2chisq.test(xh2)## Warning in chisq.test(xh2): Chi-squared approximation may be incorrect##
## Pearson's Chi-squared test
##
## data: xh2
## X-squared = 212.64, df = 33, p-value < 2.2e-16Kết quả kiểm định cho thấy 2 biến genre và mpaa_rating độc lập với nhau
3.2 Khoảng ước lượng cho tỷ lệ
- Ước lượng tỷ lệ phim có doanh thu lớn hơn 310094574 đồng thời ước lượng xem tỷ lệ phần trăm số bộ phim có doanh thu lớn hơn 310094574 có phải là 5% không?
rm<- d[d$inflation_adjusted_gross > 1362870985,]
prop.test(length(rm$inflation_adjusted_gross), length(d$inflation_adjusted_gross), p = 0.05)##
## 1-sample proportions test with continuity correction
##
## data: length(rm$inflation_adjusted_gross) out of length(d$inflation_adjusted_gross), null probability 0.05
## X-squared = 23.551, df = 1, p-value = 1.217e-06
## alternative hypothesis: true p is not equal to 0.05
## 95 percent confidence interval:
## 0.001339103 0.016385693
## sample estimates:
## p
## 0.005181347- Ước lượng sự chênh lệch về tỷ lệ bộ phim có doanh thu lớn hơn 1362870985 giữa phim được đánh giá G và phim được đánh giá PG-13. Đồng thời thực hiện bài toán kiển định sự chênh lệch này
rmm <- d[d$genre == 'G',]
rmf <- d[d$genre == 'PG-13',]
rmm1 <- rmm[rmm$inflation_adjusted_gross > 1362870985,]
rmf1 <- rmf[rmf$inflation_adjusted_gross > 1362870985,]
a <- c(nrow(rmm), nrow(rmf))
b <- c(nrow(rmm1), nrow(rmf1))
prop.test(b,a)## Warning in prop.test(b, a): Chi-squared approximation may be incorrect##
## 2-sample test for equality of proportions without continuity correction
##
## data: b out of a
## X-squared = NaN, df = 1, p-value = NA
## alternative hypothesis: two.sided
## 95 percent confidence interval:
## 0 0
## sample estimates:
## prop 1 prop 2
## 1 14 Chọn 1 hoặc 2 biến định tính và 1 biến định lượng làm biến phụ thuộc để phân tích, giải thích lý do.
Với mục đích tìm ra 10 bộ phim được ưa chuộng nhất của hãng phim Disney, tôi chọn biến như sau
4.1 Biến định lượng:
Tôi chọn biến định lượng là biến inflation_adjusted_gross (doanh thu đã điều chỉnh lạm phát) để phân tích dễ dàng và chính xác hơn do luôn có sự thay đổi về lạm phát theo thời gian.4.2 Biến định tính:
Tôi chọn biến định tính là genre (thể loại) và movie tittle (tên phim) để phục vụ cho mục đích phân tích.Với mục đích tìm ra 10 bộ phim được ưa chuộng nhất của hãng phim Disney dựa vào việc phân tích doanh thu của từng bộ phim, để phù hợp với yêu cầu phân tích dữ liệu định tính tôi chuyển biến inflation_adjusted_gross (doanh thu đã điều chỉnh lạm phát) sang biến doanhthu có dữ liệu nhị thức với 2 mức là cao và thấp.
5 1. Bộ dữ liệu môn “Phân tích dữ liệu định tính”
library(readxl)
d <- read_excel("C:/RRR/dulieu_thuchanh4.xlsx", sheet = "Sheet1")
print.data.frame(d)## movie_title release_date genre
## 1 Snow White and the Seven Dwarfs 1937-12-21 Musical
## 2 Pinocchio 1940-02-09 Adventure
## 3 Fantasia 1940-11-13 Musical
## 4 Song of the South 1946-11-12 Adventure
## 5 Cinderella 1950-02-15 Drama
## 6 20,000 Leagues Under the Sea 1954-12-23 Adventure
## 7 Lady and the Tramp 1955-06-22 Drama
## 8 Sleeping Beauty 1959-01-29 Drama
## 9 101 Dalmatians 1961-01-25 Comedy
## 10 The Absent Minded Professor 1961-03-16 Comedy
## 11 Babes in Toyland 1961-12-14 Musical
## 12 Bon Voyage! 1962-05-17 Comedy
## 13 The Sword in the Stone 1963-12-25 Adventure
## 14 The Jungle Book 1967-10-18 Musical
## 15 Blackbeard's Ghost 1968-02-08 Comedy
## 16 The Aristocats 1970-04-24 Musical
## 17 The Boatniks 1970-07-01 Comedy
## 18 Bedknobs and Broomsticks 1971-10-07 Musical
## 19 The Apple Dumpling Gang 1975-07-01 Comedy
## 20 Freaky Friday 1977-01-21 Comedy
## 21 The Many Adventures of Winnie the Pooh 1977-03-11 Comedy
## 22 The Rescuers 1977-06-22 Adventure
## 23 Herbie Goes to Monte Carlo 1977-06-24 Action
## 24 The Black Hole 1979-12-21 Drama
## 25 Midnight Madness 1980-02-08 Adventure
## 26 The Last Flight of Noah’s Ark 1980-06-25 Adventure
## 27 The Devil and Max Devlin 1981-01-01 Musical
## 28 Amy 1981-03-20 Drama
## 29 The Fox and the Hound 1981-07-10 Comedy
## 30 Condorman 1981-08-07 Action
## 31 Night Crossing 1982-02-05 Drama
## 32 Tron 1982-07-09 Action
## 33 Tex 1982-11-19 Drama
## 34 Trenchcoat 1983-03-11 Comedy
## 35 Something Wicked This Way Comes 1983-04-29 Horror
## 36 Never Cry Wolf 1983-10-07 Drama
## 37 Running Brave 1983-11-04 Drama
## 38 Splash 1984-03-09 Comedy
## 39 Country 1984-09-29 Drama
## 40 Baby: Secret of the Lost Legend 1985-03-22 Adventure
## 41 Return to Oz 1985-06-21 Adventure
## 42 The Black Cauldron 1985-07-24 Adventure
## 43 My Science Project 1985-08-09 Comedy
## 44 The Journey of Natty Gann 1985-09-27 Drama
## 45 One Magic Christmas 1985-11-22 Drama
## 46 Down and Out in Beverly Hills 1986-01-31 Comedy
## 47 Off Beat 1986-04-11 Comedy
## 48 Ruthless People 1986-06-27 Comedy
## 49 The Great Mouse Detective 1986-07-02 Adventure
## 50 Flight of the Navigator 1986-07-30 Adventure
## 51 Tough Guys 1986-10-03 Comedy
## 52 The Color of Money 1986-10-17 Drama
## 53 Outrageous Fortune 1987-01-30 Comedy
## 54 Tin Men 1987-03-06 Comedy
## 55 Ernest Goes to Camp 1987-05-22 Comedy
## 56 Benji the Hunted 1987-06-05 Adventure
## 57 Adventures in Babysitting 1987-07-03 Comedy
## 58 Stakeout 1987-08-05 Comedy
## 59 Can't Buy Me Love 1987-08-14 Romantic Comedy
## 60 Hello Again 1987-11-06 Comedy
## 61 3 Men and a Baby 1987-11-25 Comedy
## 62 Good Morning Vietnam 1987-12-23 Comedy
## 63 Shoot to Kill 1988-02-12 Action
## 64 D.O.A. 1988-03-18 Thriller/Suspense
## 65 Return to Snowy River 1988-04-15 Adventure
## 66 Big Business 1988-06-10 Comedy
## 67 Who Framed Roger Rabbit? 1988-06-22 Comedy
## 68 Cocktail 1988-07-29 Drama
## 69 The Rescue 1988-08-05 Action
## 70 Heartbreak Hotel 1988-09-30 Comedy
## 71 The Good Mother 1988-11-04 Drama
## 72 Ernest Saves Christmas 1988-11-11 Comedy
## 73 Oliver & Company 1988-11-18 Adventure
## 74 Beaches 1988-12-21 Drama
## 75 Three Fugitives 1989-01-27 Comedy
## 76 New York Stories 1989-03-01 Drama
## 77 Disorganized Crime 1989-04-14 Comedy
## 78 Dead Poets Society 1989-06-02 Drama
## 79 Honey, I Shrunk the Kids 1989-06-23 Adventure
## 80 Turner & Hooch 1989-07-28 Comedy
## 81 Cheetah 1989-08-18 Adventure
## 82 An Innocent Man 1989-10-06 Drama
## 83 Gross Anatomy 1989-10-20 Drama
## 84 The Little Mermaid 1989-11-15 Adventure
## 85 Blaze 1989-12-13 Drama
## 86 Stella 1990-02-02 Drama
## 87 Where the Heart Is 1990-02-23 Comedy
## 88 Pretty Woman 1990-03-23 Romantic Comedy
## 89 Ernest Goes to Jail 1990-04-06 Comedy
## 90 Spaced Invaders 1990-04-27 Comedy
## 91 Fire Birds 1990-05-24 Action
## 92 Dick Tracy 1990-06-15 Action
## 93 Betsy's Wedding 1990-06-22 Comedy
## 94 Arachnophobia 1990-07-18 Thriller/Suspense
## 95 DuckTales: The Movie - Treasure of th… 1990-08-03 Adventure
## 96 Taking Care of Business 1990-08-17 Comedy
## 97 Mr. Destiny 1990-10-12 Comedy
## 98 The Rescuers Down Under 1990-11-16 Adventure
## 99 3 Men and a Little Lady 1990-11-21 Comedy
## 100 Green Card 1990-12-25 Romantic Comedy
## 101 White Fang 1991-01-18 Adventure
## 102 Scenes from a Mall 1991-02-22 Comedy
## 103 Haakon Haakonsen 1991-03-01 Adventure
## 104 The Marrying Man 1991-04-05 Romantic Comedy
## 105 Oscar 1991-04-26 Comedy
## 106 One Good Cop 1991-05-03 Action
## 107 What About Bob? 1991-05-17 Comedy
## 108 Wild Hearts Can't Be Broken 1991-05-24 Drama
## 109 The Rocketeer 1991-06-21 Action
## 110 The Doctor 1991-07-24 Drama
## 111 Paradise 1991-09-18 Drama
## 112 Deceived 1991-09-27 Thriller/Suspense
## 113 Ernest Scared Stupid 1991-10-11 Comedy
## 114 Billy Bathgate 1991-11-01 Drama
## 115 Beauty and the Beast 1991-11-13 Musical
## 116 Father of the Bride 1991-12-20 Comedy
## 117 The Hand That Rocks the Cradle 1992-01-10 Thriller/Suspense
## 118 Medicine Man 1992-02-07 Drama
## 119 Blame it on the Bellboy 1992-03-06 Comedy
## 120 Noises Off... 1992-03-20 Comedy
## 121 Straight Talk 1992-04-03 Comedy
## 122 Newsies 1992-04-08 <NA>
## 123 Passed Away 1992-04-24 <NA>
## 124 Encino Man 1992-05-22 Comedy
## 125 Sister Act 1992-05-29 Comedy
## 126 Honey I Blew Up the Kid 1992-07-17 Comedy
## 127 A Stranger Among Us 1992-07-17 Drama
## 128 3 Ninjas 1992-08-07 Action
## 129 A Gun in Betty Lou's Handbag 1992-08-21 <NA>
## 130 Captain Ron 1992-09-18 Comedy
## 131 Sarafina! 1992-09-18 Drama
## 132 Innocent Blood 1992-09-25 Horror
## 133 The Mighty Ducks 1992-10-02 Comedy
## 134 1492: Conquest of Paradise 1992-10-09 Adventure
## 135 Consenting Adults 1992-10-16 Drama
## 136 Aladdin 1992-11-11 Comedy
## 137 The Distinguished Gentleman 1992-12-04 Comedy
## 138 The Muppet Christmas Carol 1992-12-11 Comedy
## 139 Alive 1993-01-15 Adventure
## 140 Aspen Extreme 1993-01-22 Romantic Comedy
## 141 Homeward Bound: The Incredible Journey 1993-02-03 Adventure
## 142 The Cemetery Club 1993-02-03 Comedy
## 143 Swing Kids 1993-03-05 Musical
## 144 A Far Off Place 1993-03-12 Adventure
## 145 Born Yesterday 1993-03-26 Romantic Comedy
## 146 The Adventures of Huck Finn 1993-04-02 Adventure
## 147 Bound by Honor 1993-04-16 <NA>
## 148 Indian Summer 1993-04-23 Comedy
## 149 Super Mario Bros. 1993-05-28 Action
## 150 Guilty as Sin 1993-06-04 Thriller/Suspense
## 151 Life With Mikey 1993-06-04 Comedy
## 152 What's Love Got to Do With It 1993-06-09 Drama
## 153 Son in Law 1993-07-02 Comedy
## 154 Hocus Pocus 1993-07-16 Comedy
## 155 Another Stakeout 1993-07-23 Comedy
## 156 My Boyfriend's Back 1993-08-06 <NA>
## 157 Father Hood 1993-08-27 <NA>
## 158 The Joy Luck Club 1993-09-08 Drama
## 159 Money for Nothing 1993-09-10 Comedy
## 160 The Program 1993-09-24 Action
## 161 Cool Runnings 1993-10-01 Comedy
## 162 The Nightmare Before Christmas 1993-10-13 Musical
## 163 The Three Musketeers 1993-11-12 Adventure
## 164 Sister Act 2 Back in the Habit 1993-12-10 Comedy
## 165 Tombstone 1993-12-25 Western
## 166 The Air Up There 1994-01-07 Comedy
## 167 Cabin Boy 1994-01-07 Comedy
## 168 Iron Will 1994-01-14 Drama
## 169 Red Rock West 1994-01-28 <NA>
## 170 Blank Check 1994-02-11 Comedy
## 171 Angie 1994-03-04 Comedy
## 172 The Ref 1994-03-09 Comedy
## 173 D2: The Mighty Ducks 1994-03-25 Comedy
## 174 Holy Matrimony 1994-04-08 Comedy
## 175 White Fang 2: Myth of the White Wolf 1994-04-15 Adventure
## 176 The Inkwell 1994-04-22 Comedy
## 177 When a Man Loves a Woman 1994-04-29 Drama
## 178 3 Ninjas Kick Back 1994-05-06 Action
## 179 Renaissance Man 1994-06-03 Comedy
## 180 The Lion King 1994-06-15 Adventure
## 181 I Love Trouble 1994-06-29 Romantic Comedy
## 182 Angels in the Outfield 1994-07-15 Comedy
## 183 In the Army Now 1994-08-12 Comedy
## 184 Color of Night 1994-08-19 Thriller/Suspense
## 185 Camp Nowhere 1994-08-26 Comedy
## 186 It's Pat 1994-08-26 Comedy
## 187 A Simple Twist of Fate 1994-09-02 Drama
## 188 Quiz Show 1994-09-14 Drama
## 189 Terminal Velocity 1994-09-23 Action
## 190 Ed Wood 1994-09-30 Comedy
## 191 The Puppet Masters 1994-10-21 Horror
## 192 Squanto: A Warrior's Tale 1994-10-28 Drama
## 193 The Santa Clause 1994-11-11 Comedy
## 194 A Low Down Dirty Shame 1994-11-23 Action
## 195 The Jungle Book 1994-12-25 Adventure
## 196 Houseguest 1995-01-06 Comedy
## 197 Bad Company 1995-01-20 Thriller/Suspense
## 198 Miami Rhapsody 1995-01-27 Romantic Comedy
## 199 The Jerky Boys 1995-02-03 Comedy
## 200 Heavy Weights 1995-02-17 Comedy
## 201 Man of the House 1995-03-03 Comedy
## 202 Roommates 1995-03-03 Comedy
## 203 Tall Tale 1995-03-24 Western
## 204 A Pyromaniac's Love Story 1995-03-28 Romantic Comedy
## 205 Jefferson in Paris 1995-03-31 Drama
## 206 Funny Bones 1995-03-31 Comedy
## 207 A Goofy Movie 1995-04-07 Comedy
## 208 While You Were Sleeping 1995-04-21 Romantic Comedy
## 209 Crimson Tide 1995-05-12 Action
## 210 Mad Love 1995-05-26 Drama
## 211 Pocahontas 1995-06-10 Adventure
## 212 Judge Dredd 1995-06-30 Action
## 213 Operation Dumbo Drop 1995-07-28 Adventure
## 214 Dangerous Minds 1995-08-11 Drama
## 215 A Kid in King Arthur's Court 1995-08-11 Adventure
## 216 The Tie That Binds 1995-09-08 Thriller/Suspense
## 217 Unstrung Heroes 1995-09-15 Drama
## 218 The Big Green 1995-09-29 Comedy
## 219 Dead Presidents 1995-10-04 Drama
## 220 The Scarlet Letter 1995-10-13 Drama
## 221 Feast of July 1995-10-13 Drama
## 222 Powder 1995-10-27 Drama
## 223 Toy Story 1995-11-22 Adventure
## 224 Father of the Bride Part II 1995-12-08 Comedy
## 225 Nixon 1995-12-20 Drama
## 226 Tom and Huck 1995-12-22 Adventure
## 227 Mr. Holland's Opus 1995-12-29 Drama
## 228 White Squall 1996-02-02 Adventure
## 229 Muppet Treasure Island 1996-02-16 Adventure
## 230 Mr. Wrong 1996-02-16 Romantic Comedy
## 231 Before and After 1996-02-23 Drama
## 232 Up Close & Personal 1996-03-01 Drama
## 233 Homeward Bound II: Lost in San Franc… 1996-03-08 Adventure
## 234 Two Much 1996-03-15 Romantic Comedy
## 235 Un indien dans la ville 1996-03-22 Comedy
## 236 James and the Giant Peach 1996-04-12 Adventure
## 237 Celtic Pride 1996-04-19 Comedy
## 238 Last Dance 1996-05-03 Drama
## 239 Boys 1996-05-10 Drama
## 240 Spy Hard 1996-05-24 Comedy
## 241 Eddie 1996-05-31 Comedy
## 242 The Rock 1996-06-07 Action
## 243 The Hunchback of Notre Dame 1996-06-21 Adventure
## 244 Phenomenon 1996-07-05 Drama
## 245 Kazaam 1996-07-17 Comedy
## 246 Jack 1996-08-09 Drama
## 247 First Kid 1996-08-30 Comedy
## 248 The Rich Man's Wife 1996-09-13 Thriller/Suspense
## 249 D3: The Mighty Ducks 1996-10-04 Comedy
## 250 The Associate 1996-10-25 Comedy
## 251 Ransom 1996-11-08 Action
## 252 The War at Home 1996-11-20 <NA>
## 253 101 Dalmatians 1996-11-27 Comedy
## 254 The Preacher's Wife 1996-12-13 Drama
## 255 Evita 1996-12-25 Musical
## 256 Metro 1997-01-17 Action
## 257 Prefontaine 1997-01-24 Drama
## 258 Shadow Conspiracy 1997-01-31 Thriller/Suspense
## 259 That Darn Cat 1997-02-14 Comedy
## 260 Jungle 2 Jungle 1997-03-07 Comedy
## 261 The Sixth Man 1997-03-28 Comedy
## 262 Grosse Pointe Blank 1997-04-11 Black Comedy
## 263 Romy and Michele's High School Reunion 1997-04-25 Comedy
## 264 Gone Fishin' 1997-05-30 Comedy
## 265 Con Air 1997-06-06 Action
## 266 Hercules 1997-06-13 Adventure
## 267 George Of The Jungle 1997-07-16 Comedy
## 268 Nothing To Lose 1997-07-18 Comedy
## 269 Air Bud 1997-08-01 Comedy
## 270 G.I. Jane 1997-08-22 Drama
## 271 A Thousand Acres 1997-09-19 Drama
## 272 Washington Square 1997-10-05 Drama
## 273 Rocket Man 1997-10-10 Comedy
## 274 Playing God 1997-10-17 Thriller/Suspense
## 275 Flubber 1997-11-26 Comedy
## 276 An American Werewolf in Paris 1997-12-25 Horror
## 277 Mr. Magoo 1997-12-25 Comedy
## 278 Kundun 1997-12-25 Drama
## 279 Deep Rising 1998-01-30 Action
## 280 Krippendorf's Tribe 1998-02-27 Comedy
## 281 An Alan Smithee Film: Burn Hollywood … 1998-02-27 Comedy
## 282 Meet the Deedles 1998-03-27 Comedy
## 283 He Got Game 1998-05-01 Drama
## 284 The Horse Whisperer 1998-05-15 Drama
## 285 Six Days, Seven Nights 1998-06-12 Romantic Comedy
## 286 Mulan 1998-06-19 Adventure
## 287 Armageddon 1998-07-01 Adventure
## 288 Jane Austen's Mafia 1998-07-24 Comedy
## 289 The Parent Trap 1998-07-29 Comedy
## 290 Firelight 1998-09-04 Drama
## 291 Simon Birch 1998-09-11 Drama
## 292 Holy Man 1998-10-09 Comedy
## 293 Beloved 1998-10-16 Drama
## 294 The Waterboy 1998-11-06 Comedy
## 295 I'll Be Home For Christmas 1998-11-13 Comedy
## 296 A Bug's Life 1998-11-20 Adventure
## 297 Enemy of the State 1998-11-20 Action
## 298 Rushmore 1998-12-11 Black Comedy
## 299 A Civil Action 1998-12-25 Drama
## 300 Mighty Joe Young 1998-12-25 Adventure
## 301 My Favorite Martian 1999-02-12 Comedy
## 302 The Other Sister 1999-02-26 Romantic Comedy
## 303 Doug's 1st Movie 1999-03-26 Adventure
## 304 Ten Things I Hate About You 1999-03-31 Romantic Comedy
## 305 Endurance 1999-05-14 <NA>
## 306 Instinct 1999-06-04 Drama
## 307 Tarzan 1999-06-16 Adventure
## 308 Summer of Sam 1999-07-02 Drama
## 309 Inspector Gadget 1999-07-23 Comedy
## 310 The Sixth Sense 1999-08-06 Thriller/Suspense
## 311 The 13th Warrior 1999-08-27 Action
## 312 Breakfast of Champions 1999-09-17 Comedy
## 313 Mumford 1999-09-24 Comedy
## 314 Mystery, Alaska 1999-10-01 Comedy
## 315 The Straight Story 1999-10-15 Drama
## 316 The Insider 1999-11-05 Drama
## 317 Toy Story 2 1999-11-19 Adventure
## 318 Cradle Will Rock 1999-12-08 Drama
## 319 Deuce Bigalow: Male Gigolo 1999-12-10 Comedy
## 320 Bicentennial Man 1999-12-17 Drama
## 321 Play it to the Bone 1999-12-24 Comedy
## 322 Fantasia 2000 (IMAX) 2000-01-01 Musical
## 323 Gun Shy 2000-02-04 Comedy
## 324 The Tigger Movie 2000-02-11 Adventure
## 325 Mission to Mars 2000-03-10 Adventure
## 326 High Fidelity 2000-03-31 Comedy
## 327 Keeping the Faith 2000-04-14 Romantic Comedy
## 328 Dinosaur 2000-05-19 Adventure
## 329 Shanghai Noon 2000-05-26 Western
## 330 Gone in 60 Seconds 2000-06-09 Action
## 331 Fantasia 2000 (Theatrical Release) 2000-06-16 Musical
## 332 The Kid 2000-07-07 Comedy
## 333 Coyote Ugly 2000-08-04 Drama
## 334 The Crew 2000-08-25 Comedy
## 335 Duets 2000-09-15 Drama
## 336 Remember the Titans 2000-09-29 Drama
## 337 Unbreakable 2000-11-22 Thriller/Suspense
## 338 102 Dalmatians 2000-11-22 Comedy
## 339 The Emperor's New Groove 2000-12-15 Adventure
## 340 O Brother, Where Art Thou? 2000-12-22 Comedy
## 341 Double Take 2001-01-12 Action
## 342 Recess: School's Out 2001-02-16 Comedy
## 343 Just Visiting 2001-04-06 Comedy
## 344 Pearl Harbor 2001-05-25 Action
## 345 Atlantis: The Lost Empire 2001-06-08 Adventure
## 346 crazy/beautiful 2001-06-29 Drama
## 347 The Princess Diaries 2001-08-03 Comedy
## 348 Bubble Boy 2001-08-24 Comedy
## 349 Max Keeble's Big Move 2001-10-05 Comedy
## 350 Corky Romano 2001-10-12 Comedy
## 351 High Heels and Low Lifes 2001-10-26 <NA>
## 352 Monsters, Inc. 2001-11-02 Adventure
## 353 Out Cold 2001-11-21 Comedy
## 354 The Royal Tenenbaums 2001-12-14 Black Comedy
## 355 Beauty and the Beast (IMAX) 2002-01-01 Musical
## 356 Frank McKlusky C.I. 2002-01-01 <NA>
## 357 Snow Dogs 2002-01-18 Comedy
## 358 The Count of Monte Cristo 2002-01-25 Drama
## 359 Peter Pan: Return to Neverland 2002-02-15 Adventure
## 360 Reign of Fire 2002-02-19 Action
## 361 Sorority Boys 2002-03-22 Comedy
## 362 The Rookie 2002-03-29 Drama
## 363 Big Trouble 2002-04-05 Comedy
## 364 ESPN's Ultimate X - The Movie 2002-05-10 Documentary
## 365 Bad Company 2002-06-07 Action
## 366 Lilo & Stitch 2002-06-21 Adventure
## 367 The Country Bears 2002-07-26 Adventure
## 368 Signs 2002-08-02 Thriller/Suspense
## 369 Sen to Chihiro no Kamikakushi 2002-09-20 Adventure
## 370 Sweet Home Alabama 2002-09-27 Comedy
## 371 Moonlight Mile 2002-09-27 Drama
## 372 Tuck Everlasting 2002-10-11 Drama
## 373 The Santa Clause 2 2002-11-01 Comedy
## 374 Treasure Planet 2002-11-27 Adventure
## 375 The Hot Chick 2002-12-13 Comedy
## 376 25th Hour 2002-12-19 Drama
## 377 The Recruit 2003-01-31 Thriller/Suspense
## 378 Shanghai Knights 2003-02-07 Adventure
## 379 The Jungle Book 2 2003-02-14 Adventure
## 380 Bringing Down the House 2003-03-07 Comedy
## 381 Piglet's Big Movie 2003-03-21 Comedy
## 382 Ghosts of the Abyss 2003-04-11 Documentary
## 383 Holes 2003-04-18 Drama
## 384 The Lizzie McGuire Movie 2003-05-02 Comedy
## 385 Finding Nemo 2003-05-30 Adventure
## 386 Pirates of the Caribbean: The Curse o… 2003-07-09 Adventure
## 387 Freaky Friday 2003-08-06 Comedy
## 388 Open Range 2003-08-15 Western
## 389 Cold Creek Manor 2003-09-19 Thriller/Suspense
## 390 Under the Tuscan Sun 2003-09-26 Comedy
## 391 Veronica Guerin 2003-10-17 Drama
## 392 Brother Bear 2003-10-24 Adventure
## 393 The Haunted Mansion 2003-11-26 Comedy
## 394 Calendar Girls 2003-12-19 Comedy
## 395 Young Black Stallion 2003-12-25 Adventure
## 396 Teacher's Pet: The Movie 2004-01-16 Comedy
## 397 Miracle 2004-02-06 Drama
## 398 Confessions of a Teenage Drama Queen 2004-02-20 Comedy
## 399 Hidalgo 2004-03-05 Western
## 400 The Ladykillers 2004-03-26 Comedy
## 401 Home on the Range 2004-04-02 Comedy
## 402 The Alamo 2004-04-09 Western
## 403 Raising Helen 2004-05-28 Comedy
## 404 Around the World in 80 Days 2004-06-16 Adventure
## 405 America's Heart and Soul 2004-07-02 Documentary
## 406 King Arthur 2004-07-07 Adventure
## 407 The Village 2004-07-30 Thriller/Suspense
## 408 The Princess Diaries 2: Royal Engagement 2004-08-11 Romantic Comedy
## 409 Mr. 3000 2004-09-17 Comedy
## 410 The Last Shot 2004-09-24 Comedy
## 411 Ladder 49 2004-10-01 Action
## 412 The Incredibles 2004-11-05 Adventure
## 413 National Treasure 2004-11-19 Adventure
## 414 The Life Aquatic with Steve Zissou 2004-12-10 Comedy
## 415 Aliens of the Deep 2005-01-28 Documentary
## 416 Pooh's Heffalump Movie 2005-02-11 Adventure
## 417 The Pacifier 2005-03-04 Comedy
## 418 Ice Princess 2005-03-18 Comedy
## 419 A Lot Like Love 2005-04-22 Comedy
## 420 The Hitchhiker's Guide to the Galaxy 2005-04-29 Comedy
## 421 Hauru no ugoku shiro 2005-06-10 Adventure
## 422 Herbie: Fully Loaded 2005-06-22 Comedy
## 423 Dark Water 2005-07-08 Thriller/Suspense
## 424 Sky High 2005-07-29 Adventure
## 425 Valiant 2005-08-19 Adventure
## 426 Flightplan 2005-09-23 Thriller/Suspense
## 427 The Greatest Game Ever Played 2005-09-30 Drama
## 428 Shopgirl 2005-10-21 Drama
## 429 Chicken Little 2005-11-04 Adventure
## 430 The Chronicles of Narnia: The Lion, t… 2005-12-09 Adventure
## 431 Casanova 2005-12-25 Drama
## 432 Glory Road 2006-01-13 Drama
## 433 Annapolis 2006-01-27 Drama
## 434 Roving Mars 2006-01-27 Documentary
## 435 Eight Below 2006-02-17 Adventure
## 436 The Shaggy Dog 2006-03-10 Comedy
## 437 Stay Alive 2006-03-24 Horror
## 438 The Wild 2006-04-14 Adventure
## 439 Stick It 2006-04-28 Comedy
## 440 Goal! The Dream Begins 2006-05-12 Drama
## 441 Cars 2006-06-09 Comedy
## 442 Pirates of the Caribbean: Dead Man’… 2006-07-07 Adventure
## 443 Step Up 2006-08-11 Drama
## 444 Invincible 2006-08-25 Drama
## 445 The Guardian 2006-09-29 Action
## 446 The Prestige 2006-10-20 Thriller/Suspense
## 447 Tim Burton's The Nightmare Before Chr… 2006-10-20 Musical
## 448 The Santa Clause 3: The Escape Clause 2006-11-03 Comedy
## 449 Déjà Vu 2006-11-22 Thriller/Suspense
## 450 Apocalypto 2006-12-08 Adventure
## 451 Primeval 2007-01-12 Adventure
## 452 Bridge to Terabithia 2007-02-16 Drama
## 453 Wild Hogs 2007-03-02 Comedy
## 454 Meet the Robinsons 2007-03-30 Adventure
## 455 The Lookout 2007-03-30 Drama
## 456 The Hoax 2007-04-06 Drama
## 457 The Invisible 2007-04-27 Thriller/Suspense
## 458 Pirates of the Caribbean: At World’… 2007-05-24 Adventure
## 459 Ratatouille 2007-06-29 Comedy
## 460 Underdog 2007-08-03 Adventure
## 461 The Game Plan 2007-09-22 Comedy
## 462 Dan in Real Life 2007-10-20 Romantic Comedy
## 463 Enchanted 2007-11-21 Romantic Comedy
## 464 National Treasure 2: Book of Secrets 2007-12-21 Adventure
## 465 Hannah Montana/Miley Cyrus: Best of B… 2008-02-01 Concert/Performance
## 466 Step Up 2 the Streets 2008-02-14 Drama
## 467 College Road Trip 2008-03-07 Comedy
## 468 The Chronicles of Narnia: Prince Caspian 2008-05-16 Adventure
## 469 WALL-E 2008-06-27 Adventure
## 470 Swing Vote 2008-08-01 Comedy
## 471 Goal! 2: Living the Dream... 2008-08-29 Drama
## 472 Miracle at St. Anna 2008-09-26 Drama
## 473 Beverly Hills Chihuahua 2008-10-03 Comedy
## 474 Morning Light 2008-10-17 Documentary
## 475 High School Musical 3: Senior Year 2008-10-24 Musical
## 476 Bolt 2008-11-21 Comedy
## 477 Bedtime Stories 2008-12-25 Comedy
## 478 Confessions of a Shopaholic 2009-02-13 Romantic Comedy
## 479 Jonas Brothers: The 3D Concert Experi… 2009-02-27 Concert/Performance
## 480 Race to Witch Mountain 2009-03-13 Adventure
## 481 Hannah Montana the Movie 2009-04-10 Drama
## 482 Earth 2009-04-22 Documentary
## 483 Up 2009-05-29 Adventure
## 484 The Proposal 2009-06-19 Romantic Comedy
## 485 G-Force 2009-07-24 Adventure
## 486 Gake no ue no Ponyo 2009-08-14 Adventure
## 487 X Games 3D: The Movie 2009-08-21 Documentary
## 488 Walt and El Grupo 2009-09-10 Documentary
## 489 Surrogates 2009-09-25 Action
## 490 Toy Story 3D Double Feature 2009-10-02 Adventure
## 491 Disney's A Christmas Carol 2009-11-06 Drama
## 492 The Princess and the Frog 2009-11-25 Adventure
## 493 Old Dogs 2009-11-25 Comedy
## 494 When in Rome 2010-01-29 Romantic Comedy
## 495 Alice in Wonderland 2010-03-05 Adventure
## 496 Waking Sleeping Beauty 2010-03-26 Documentary
## 497 The Last Song 2010-03-31 Drama
## 498 Oceans 2010-04-22 Documentary
## 499 Prince of Persia: Sands of Time 2010-05-28 Action
## 500 Toy Story 3 2010-06-18 Adventure
## 501 The Sorcerer's Apprentice 2010-07-14 Adventure
## 502 Step Up 3D 2010-08-06 Drama
## 503 Gedo Senki (Tales from Earthsea) 2010-08-13 Adventure
## 504 You Again 2010-09-24 Comedy
## 505 Secretariat 2010-10-08 Drama
## 506 Tangled 2010-11-24 Adventure
## 507 Tron: Legacy 2010-12-17 Adventure
## 508 Gnomeo and Juliet 2011-02-11 Comedy
## 509 I am Number Four 2011-02-18 Adventure
## 510 Mars Needs Moms 2011-03-11 Adventure
## 511 African Cats 2011-04-22 Documentary
## 512 Zokkomon 2011-04-22 Adventure
## 513 Prom 2011-04-29 Comedy
## 514 Pirates of the Caribbean: On Stranger… 2011-05-20 Adventure
## 515 Cars 2 2011-06-24 Adventure
## 516 Winnie the Pooh 2011-07-15 Adventure
## 517 The Help 2011-08-10 Drama
## 518 Fright Night 2011-08-19 Horror
## 519 Real Steel 2011-10-07 Action
## 520 The Muppets 2011-11-23 Comedy
## 521 War Horse 2011-12-25 Drama
## 522 The Secret World of Arietty 2012-02-17 Adventure
## 523 John Carter 2012-03-09 Adventure
## 524 Chimpanzee 2012-04-20 Documentary
## 525 The Avengers 2012-05-04 Action
## 526 Brave 2012-06-22 Adventure
## 527 People Like Us 2012-06-29 Drama
## 528 The Odd Life of Timothy Green 2012-08-15 Drama
## 529 Frankenweenie 2012-10-05 Comedy
## 530 Wreck-It Ralph 2012-11-02 Adventure
## 531 Lincoln 2012-11-09 Drama
## 532 Oz the Great and Powerful 2013-03-08 Adventure
## 533 Iron Man 3 2013-05-03 Action
## 534 Monsters University 2013-06-21 Adventure
## 535 The Lone Ranger 2013-07-02 Western
## 536 Disney Planes 2013-08-09 Comedy
## 537 The Fifth Estate 2013-10-18 Drama
## 538 Thor: The Dark World 2013-11-08 Adventure
## 539 Kaze Tachinu 2013-11-08 Drama
## 540 Frozen 2013-11-22 Adventure
## 541 Delivery Man 2013-11-22 Comedy
## 542 Saving Mr. Banks 2013-12-13 Drama
## 543 Need for Speed 2014-03-14 Action
## 544 Muppets Most Wanted 2014-03-21 Comedy
## 545 Captain America: The Winter Soldier 2014-04-04 Action
## 546 Bears 2014-04-18 Documentary
## 547 Million Dollar Arm 2014-05-10 Drama
## 548 Maleficent 2014-05-30 Adventure
## 549 Planes: Fire and Rescue 2014-07-18 Adventure
## 550 Guardians of the Galaxy 2014-08-01 Adventure
## 551 The Hundred-Foot Journey 2014-08-08 Romantic Comedy
## 552 Alexander and the Terrible, Horrible,… 2014-10-10 Comedy
## 553 Big Hero 6 2014-11-07 Adventure
## 554 Into the Woods 2014-12-25 Musical
## 555 Strange Magic 2015-01-23 Adventure
## 556 McFarland, USA 2015-02-20 Drama
## 557 Cinderella 2015-03-13 Drama
## 558 Monkey Kingdom 2015-04-17 Documentary
## 559 Avengers: Age of Ultron 2015-05-01 Action
## 560 Tomorrowland 2015-05-22 Adventure
## 561 Inside Out 2015-06-19 Adventure
## 562 Ant-Man 2015-07-17 Action
## 563 Bridge of Spies 2015-10-16 Thriller/Suspense
## 564 The Good Dinosaur 2015-11-25 Adventure
## 565 Star Wars Ep. VII: The Force Awakens 2015-12-18 Adventure
## 566 The Finest Hours 2016-01-29 Thriller/Suspense
## 567 Zootopia 2016-03-04 Adventure
## 568 The Jungle Book 2016-04-15 Adventure
## 569 A Beautiful Planet 2016-04-29 Documentary
## 570 Captain America: Civil War 2016-05-06 Action
## 571 Alice Through the Looking Glass 2016-05-27 Adventure
## 572 Finding Dory 2016-06-17 Adventure
## 573 The BFG 2016-07-01 Adventure
## 574 Pete’s Dragon 2016-08-12 Adventure
## 575 The Light Between Oceans 2016-09-02 Drama
## 576 Queen of Katwe 2016-09-23 Drama
## 577 Doctor Strange 2016-11-04 Adventure
## 578 Moana 2016-11-23 Adventure
## 579 Rogue One: A Star Wars Story 2016-12-16 Adventure
## mpaa_rating total_gross inflation_adjusted_gross doanhthu
## 1 G 184925485 5228953251 cao
## 2 G 84300000 2188229052 cao
## 3 G 83320000 2187090808 cao
## 4 G 65000000 1078510579 cao
## 5 G 85000000 920608730 cao
## 6 G 28200000 528279994 cao
## 7 G 93600000 1236035515 cao
## 8 G 9464608 21505832 thap
## 9 G 153000000 1362870985 cao
## 10 G 25381407 310094574 cao
## 11 G 10218316 124841160 cao
## 12 G 9230769 109581646 thap
## 13 G 22182353 153870834 thap
## 14 G 141843000 789612346 cao
## 15 G 21540050 138612686 cao
## 16 G 55675257 255161499 cao
## 17 G 18607492 101200742 cao
## 18 G 17871174 91305448 thap
## 19 G 31916500 131246872 cao
## 20 G 25942000 98067733 cao
## 21 G 0 0 thap
## 22 G 48775599 159743914 cao
## 23 G 28000000 105847527 thap
## 24 G 35841901 120377374 thap
## 25 G 2900000 9088096 thap
## 26 G 11000000 34472116 cao
## 27 G 16000000 48517980 cao
## 28 G 0 0 thap
## 29 G 43899231 133118889 thap
## 30 G 0 0 thap
## 31 G 4500000 12903059 thap
## 32 G 26918576 77184895 cao
## 33 G 7199408 20643199 thap
## 34 G 4304286 11519089 thap
## 35 G 5656087 15136765 thap
## 36 G 27668764 70669955 cao
## 37 G 1204595 3223725 thap
## 38 PG 62599495 157057661 cao
## 39 PG 8400000 21075000 thap
## 40 PG 14276095 33900697 thap
## 41 PG 10618813 25215934 thap
## 42 PG 21288692 50553142 cao
## 43 PG 4100000 9736051 thap
## 44 PG 9468512 22302956 thap
## 45 PG 13229514 31415432 thap
## 46 R 62134225 141183693 cao
## 47 R 4842778 11003932 thap
## 48 R 71624879 162748712 cao
## 49 R 23605534 53637367 cao
## 50 R 18564613 42183197 thap
## 51 R 21458229 48758184 cao
## 52 R 52293000 117957323 thap
## 53 R 52864741 113976921 cao
## 54 R 25411386 54787202 thap
## 55 R 23509382 50686462 thap
## 56 R 15212539 32798382 thap
## 57 R 33790923 72853569 cao
## 58 R 65673233 141592160 cao
## 59 R 31623833 68181300 cao
## 60 R 20419446 44024529 thap
## 61 PG 167780960 353334607 cao
## 62 R 123922370 254414837 cao
## 63 R 29300000 60097074 thap
## 64 R 12706478 26062188 cao
## 65 PG 13687027 28073384 cao
## 66 PG 40150487 82352451 cao
## 67 PG 154112492 316250084 cao
## 68 R 78222753 160442289 cao
## 69 R 5855392 12009960 thap
## 70 R 5509417 11300331 thap
## 71 R 4764606 9772655 thap
## 72 PG 28202109 57845202 cao
## 73 G 49576671 102254492 cao
## 74 PG-13 57041866 120381757 cao
## 75 PG-13 40590000 85757817 cao
## 76 PG 10763469 22740861 cao
## 77 PG 7210149 15233465 cao
## 78 PG 95860116 202531517 cao
## 79 PG 130724172 276191669 cao
## 80 PG 71079915 150176361 cao
## 81 PG 7882250 16653473 thap
## 82 R 19397847 40983414 thap
## 83 PG-13 11346186 23972012 thap
## 84 G 111543479 223726012 cao
## 85 R 19049727 39884640 cao
## 86 PG-13 20062347 40077147 thap
## 87 R 1106475 2210321 thap
## 88 R 178406268 356389765 cao
## 89 PG 25029569 49999822 cao
## 90 PG 15000000 29964452 thap
## 91 PG-13 14760451 29485923 thap
## 92 PG 103738726 207231621 cao
## 93 R 19740070 39433357 cao
## 94 PG-13 53208180 106290270 cao
## 95 G 18075331 36107823 thap
## 96 R 20005435 39963460 cao
## 97 PG-13 15379253 30722056 thap
## 98 G 27931461 55796728 cao
## 99 PG 71609321 143108869 cao
## 100 PG-13 29804169 59679131 cao
## 101 PG 34729091 69540672 cao
## 102 PG 9563393 19149495 cao
## 103 PG 15024232 30084149 thap
## 104 R 12454768 24939118 cao
## 105 PG 23562716 47181395 cao
## 106 R 11276846 22580472 thap
## 107 PG 63710000 127571325 cao
## 108 PG 7300000 14617333 thap
## 109 PG 46573027 93256673 thap
## 110 PG-13 37497480 75084021 thap
## 111 PG-13 18634643 37313540 thap
## 112 PG-13 28738096 57544453 cao
## 113 PG 14143280 28320147 thap
## 114 R 15565363 31167691 cao
## 115 G 218951625 363017667 cao
## 116 PG 89325780 179821881 cao
## 117 R 88036683 178831137 cao
## 118 PG-13 44948240 91304495 thap
## 119 PG-13 2891055 5872667 cao
## 120 PG-13 2280148 4631720 thap
## 121 PG 21202099 43068356 cao
## 122 PG 2706352 5497481 thap
## 123 PG-13 4030793 8187848 thap
## 124 PG 40057130 81369058 cao
## 125 PG 139605150 283583472 thap
## 126 PG 58662452 119162518 cao
## 127 PG-13 12282994 24950752 thap
## 128 PG 29028000 58965304 thap
## 129 PG-13 3591460 7295423 thap
## 130 PG-13 22518097 45741576 cao
## 131 PG-13 7306242 14841352 cao
## 132 R 4877567 9907922 cao
## 133 PG 50752337 103120810 cao
## 134 PG-13 7099531 14421454 thap
## 135 R 21591728 43859823 cao
## 136 G 217350219 441969178 cao
## 137 R 46434570 94349900 cao
## 138 G 27281507 55417615 thap
## 139 R 36299670 73914543 cao
## 140 PG-13 7843388 15970955 thap
## 141 G 41833324 85182343 cao
## 142 PG-13 5583621 11369541 cao
## 143 PG-13 5632086 11468231 cao
## 144 PG 12890752 26248558 cao
## 145 PG 17760754 36165012 cao
## 146 PG 24103594 49080505 thap
## 147 R 4496583 9156084 thap
## 148 R 14717851 29968953 cao
## 149 PG 20844907 42445058 cao
## 150 R 22622537 46064723 cao
## 151 PG 12349549 25146538 cao
## 152 R 39100956 79618610 cao
## 153 PG-13 25989889 52921433 thap
## 154 PG 39360491 80147079 thap
## 155 PG-13 20107504 40943541 cao
## 156 PG-13 3218882 6554384 thap
## 157 PG-13 3268203 6654819 thap
## 158 R 32790064 66768171 cao
## 159 R 1044824 2127496 thap
## 160 R 23042200 46919256 cao
## 161 PG 68856263 140392731 cao
## 162 PG 50408318 100026637 cao
## 163 PG 53661805 109310377 cao
## 164 PG 57319029 116965668 cao
## 165 R 56505065 115781734 cao
## 166 PG 20782439 42940186 cao
## 167 PG-13 3469493 7168577 thap
## 168 PG 20623071 42610902 thap
## 169 R 2502551 5170709 thap
## 170 PG 30573770 63170804 cao
## 171 R 9252349 19116981 thap
## 172 R 11325885 23401275 thap
## 173 PG 45604206 94226333 cao
## 174 PG 713234 1473665 thap
## 175 PG 8752399 18083994 thap
## 176 R 8864699 18316030 cao
## 177 R 50021959 103354194 cao
## 178 PG 11744960 24267154 thap
## 179 PG-13 24172899 49945474 cao
## 180 G 422780140 761640898 cao
## 181 PG 30806194 63651027 cao
## 182 PG 50236831 103798152 cao
## 183 PG 28881266 59673787 cao
## 184 R 19750470 40804816 thap
## 185 PG 10442641 21576332 thap
## 186 R 60822 125666 thap
## 187 PG-13 3404935 7035189 thap
## 188 PG-13 24787282 50840394 thap
## 189 PG-13 16478900 34048315 thap
## 190 R 5828466 12042634 thap
## 191 R 8579626 17727017 thap
## 192 PG 3319344 6858345 thap
## 193 PG 144833357 298369717 cao
## 194 R 29317886 60321919 cao
## 195 PG 44342956 88930321 cao
## 196 PG 26325256 51016522 thap
## 197 R 3523909 6829092 cao
## 198 PG-13 5086578 9857435 thap
## 199 R 7555256 14641561 thap
## 200 PG 17671310 34245779 thap
## 201 PG 40029009 77573459 cao
## 202 PG 12076989 23404369 cao
## 203 PG 8247627 15983331 cao
## 204 PG 468240 907414 thap
## 205 PG-13 2461628 4770461 thap
## 206 R 529135 1025425 thap
## 207 G 35336439 68479579 cao
## 208 PG 81057016 157082900 cao
## 209 R 91387195 177102077 cao
## 210 PG-13 15446532 29934306 thap
## 211 G 141579773 274370957 cao
## 212 R 34687912 67222776 thap
## 213 PG 24670346 47809421 thap
## 214 R 84919401 164552293 cao
## 215 PG 13406717 25981285 thap
## 216 R 5762795 11167895 thap
## 217 PG 7929000 15365850 cao
## 218 PG 17736619 34372339 cao
## 219 R 24120194 46741467 cao
## 220 R 10359006 20075033 thap
## 221 R 293274 568342 thap
## 222 PG-13 30833914 59727216 cao
## 223 G 191796233 370409631 cao
## 224 PG 76578911 147658438 cao
## 225 R 13668249 26302005 cao
## 226 PG 23837227 45911517 cao
## 227 PG 82582604 157508868 cao
## 228 PG-13 10229300 19509726 thap
## 229 G 34327391 65470567 thap
## 230 PG-13 12805071 24422334 thap
## 231 PG-13 8642118 16482589 thap
## 232 PG-13 51045801 97356578 thap
## 233 G 32709423 62384706 cao
## 234 PG-13 1078555 2057055 thap
## 235 PG 1029731 1963937 cao
## 236 PG 28921264 55159783 cao
## 237 PG-13 9240378 17623615 thap
## 238 R 5857534 11171714 thap
## 239 PG-13 21930418 41826566 thap
## 240 PG-13 26936265 51373912 cao
## 241 PG-13 31369401 59828966 thap
## 242 R 134069511 255702705 cao
## 243 G 100138851 190988799 cao
## 244 PG 104636382 199559799 cao
## 245 PG 18880508 36009655 thap
## 246 PG-13 58617334 111792852 cao
## 247 PG 26465920 50465108 cao
## 248 R 8538318 16284619 thap
## 249 PG 22936273 43713554 thap
## 250 PG-13 12772657 24333094 cao
## 251 R 136492681 259807820 cao
## 252 R 34368 65543 thap
## 253 G 136189294 258728898 cao
## 254 PG 48102795 91076877 thap
## 255 PG 50047179 92077628 thap
## 256 R 32017895 58804106 cao
## 257 PG-13 590817 1085093 cao
## 258 R 2154540 3957025 thap
## 259 PG 18301828 33613158 cao
## 260 PG 59925026 110058379 cao
## 261 PG-13 14765099 27117599 thap
## 262 R 28084357 51579764 thap
## 263 R 29235353 53693680 cao
## 264 PG 19745922 36265379 thap
## 265 R 101117573 185712664 cao
## 266 G 99112101 182029412 cao
## 267 PG 105263257 193326632 cao
## 268 R 44480039 81692095 cao
## 269 PG 24646936 45266588 thap
## 270 R 48169156 88467531 thap
## 271 R 7928412 14561324 thap
## 272 PG 1775644 3257546 thap
## 273 PG 15448043 28371890 thap
## 274 R 4166918 7652965 thap
## 275 PG 92993801 170406423 cao
## 276 R 26570463 48546161 cao
## 277 PG 21437192 39145784 thap
## 278 PG-13 5686694 10236836 thap
## 279 R 11203026 20136775 thap
## 280 PG-13 7571115 13608633 cao
## 281 R 45779 82277 thap
## 282 PG 4356126 7829877 thap
## 283 R 21567853 38766948 thap
## 284 PG-13 75383563 135497531 thap
## 285 PG-13 74339294 133620516 cao
## 286 G 120620254 216807832 cao
## 287 PG-13 201578182 362324957 cao
## 288 PG-13 19843795 35668055 cao
## 289 PG 66308518 119185667 thap
## 290 R 784419 1409943 thap
## 291 PG 18253415 32809442 cao
## 292 PG 12069719 21694605 thap
## 293 R 22852487 41062682 cao
## 294 PG-13 161491646 288691833 cao
## 295 PG 12214338 21941840 thap
## 296 G 162798565 288981698 cao
## 297 R 111549836 198472008 thap
## 298 R 17105219 28392518 cao
## 299 PG-13 56709981 94139530 cao
## 300 PG 50632037 87906042 cao
## 301 PG 36850101 61150849 cao
## 302 PG-13 27807627 46145331 thap
## 303 G 19421271 32228598 thap
## 304 PG-13 38177966 63354375 thap
## 305 PG 229128 380218 thap
## 306 R 34105207 56595842 cao
## 307 G 171091819 283900254 cao
## 308 R 19288130 32007656 cao
## 309 PG 97387965 161610341 cao
## 310 PG-13 293506292 485424724 cao
## 311 R 32698899 54262148 thap
## 312 R 178287 295851 thap
## 313 R 4559569 7566363 thap
## 314 R 8891623 14755189 cao
## 315 G 6197866 10111144 thap
## 316 R 28965197 47794214 cao
## 317 G 245852179 404450426 cao
## 318 R 2899970 4609153 thap
## 319 R 65535067 106921374 cao
## 320 PG 58220776 94838225 cao
## 321 R 8427204 13180524 thap
## 322 G 60507228 94852354 cao
## 323 R 1638202 2562155 thap
## 324 G 45542421 71228678 cao
## 325 PG 60874615 95208344 thap
## 326 R 27277055 42661516 cao
## 327 PG-13 37036404 57925202 cao
## 328 PG 137748063 215438985 cao
## 329 PG-13 56932305 89042541 cao
## 330 PG-13 101643008 158970411 thap
## 331 G 9103630 14238144 thap
## 332 PG 69688384 108993148 thap
## 333 PG-13 60786269 95070168 cao
## 334 PG-13 13019253 20362201 thap
## 335 R 4734235 7404372 thap
## 336 PG 115654751 180742479 cao
## 337 PG-13 94999143 148208901 cao
## 338 G 66941559 104055039 thap
## 339 G 89296573 136789252 cao
## 340 PG-13 45506619 67922002 cao
## 341 PG-13 29823162 44418589 cao
## 342 G 36696761 54656124 thap
## 343 PG-13 4777007 7114869 thap
## 344 PG-13 198539855 295705112 cao
## 345 PG 84052762 125188122 cao
## 346 PG-13 16929123 25214223 thap
## 347 G 108244774 161218928 cao
## 348 PG-13 5002310 7450434 thap
## 349 PG 17292381 25749730 thap
## 350 PG-13 23978402 35705805 cao
## 351 R 226792 337782 thap
## 352 G 289423425 416073179 cao
## 353 PG-13 13906394 20700691 thap
## 354 R 52353636 76758193 cao
## 355 G 25487028 36980311 cao
## 356 G 0 0 thap
## 357 PG 81150692 117745317 thap
## 358 PG-13 54228104 78682079 thap
## 359 G 48430258 70269715 cao
## 360 PG-13 43061982 62480631 cao
## 361 R 10198766 14797862 thap
## 362 G 75600072 109691666 thap
## 363 PG-13 7262288 10537188 thap
## 364 PG 4197175 6089874 thap
## 365 PG-13 30157016 43756218 thap
## 366 PG 145771527 211506702 cao
## 367 G 16988996 24650121 thap
## 368 PG-13 227965690 330754439 cao
## 369 PG 10049886 14338992 thap
## 370 PG-13 127214072 184521151 cao
## 371 PG-13 6830957 9909094 thap
## 372 PG 19161999 27789959 cao
## 373 G 139225854 201959095 cao
## 374 PG 38120554 55189145 thap
## 375 PG-13 35081550 50624654 thap
## 376 R 13084595 18325463 cao
## 377 PG-13 52784696 73793522 cao
## 378 PG-13 60470220 84537962 cao
## 379 G 47901582 66966883 cao
## 380 PG-13 132675402 185481530 cao
## 381 G 23103423 32298812 thap
## 382 G 17093668 23803108 thap
## 383 PG 67383924 94203395 cao
## 384 PG 42734455 59743191 cao
## 385 G 380529370 518148559 cao
## 386 PG-13 305411224 426967926 cao
## 387 PG 110222438 154090360 thap
## 388 R 58331254 81547672 thap
## 389 R 21384035 29895090 thap
## 390 PG-13 43601508 60944053 thap
## 391 R 1569918 2194759 thap
## 392 G 85336277 119218333 cao
## 393 PG 75817994 105775678 thap
## 394 PG-13 31011616 42379650 thap
## 395 G 6751389 9254344 thap
## 396 PG 6491969 8812764 thap
## 397 PG 64378093 87392478 thap
## 398 PG 29331068 39816568 thap
## 399 PG-13 67286731 91340921 thap
## 400 R 39692139 53881593 cao
## 401 PG 50026353 67910166 cao
## 402 PG-13 22406362 30416359 cao
## 403 PG-13 37485528 50886144 thap
## 404 PG 24004159 32585356 thap
## 405 G 314000 426246 thap
## 406 PG-13 51877963 70423706 thap
## 407 PG-13 114197520 155021748 cao
## 408 G 95149435 129164207 thap
## 409 PG-13 21800302 29593641 thap
## 410 R 463730 629502 thap
## 411 PG-13 74541707 101161045 cao
## 412 PG 261441092 354488708 cao
## 413 PG 173005002 234069353 cao
## 414 R 24006726 32198655 thap
## 415 G 8968684 11740942 thap
## 416 G 18098433 23801835 cao
## 417 PG 113006880 148619029 cao
## 418 G 24381334 32064685 thap
## 419 PG-13 21835784 28716947 cao
## 420 PG 51019112 67096891 thap
## 421 PG 4710455 6194870 thap
## 422 G 66010682 86812798 thap
## 423 PG-13 25473093 33500491 thap
## 424 PG 63939454 84088854 cao
## 425 G 19478106 25616292 thap
## 426 PG-13 89706988 117960425 cao
## 427 PG 15331289 20162672 thap
## 428 R 10284523 13519621 thap
## 429 G 135386665 177954661 thap
## 430 PG 291710957 381557539 cao
## 431 R 11304403 14574087 thap
## 432 PG 42647449 54888236 cao
## 433 PG-13 17127992 22044113 cao
## 434 G 10407978 12948025 thap
## 435 PG 81612565 105037235 cao
## 436 PG 61123569 78667428 thap
## 437 PG-13 23086480 29712825 thap
## 438 G 37384046 48114115 thap
## 439 PG-13 26910736 34634731 thap
## 440 PG 4283255 5512647 thap
## 441 G 244082982 314140384 cao
## 442 PG-13 423315812 544817142 cao
## 443 PG-13 65328121 84078780 cao
## 444 PG 57806952 74398864 thap
## 445 PG-13 55011732 70801353 thap
## 446 PG-13 53089891 68289913 cao
## 447 PG 24732041 30737517 thap
## 448 G 84500122 108694869 cao
## 449 PG-13 64038616 82267038 cao
## 450 R 50866635 64959548 cao
## 451 R 10597734 12985302 thap
## 452 PG 82234139 100760721 thap
## 453 PG-13 168213584 206110533 cao
## 454 G 97822171 119860589 cao
## 455 R 4600585 5637048 thap
## 456 R 7164995 8779196 thap
## 457 PG-13 20568319 25202168 cao
## 458 PG-13 309420425 379129960 cao
## 459 G 206445654 252955933 thap
## 460 PG 43760605 53619462 thap
## 461 PG 90648202 111010758 cao
## 462 PG-13 47642963 58350234 thap
## 463 PG 127706877 156074310 cao
## 464 PG 219961501 267003525 cao
## 465 G 65281781 76646993 thap
## 466 PG-13 58017783 68118371 thap
## 467 G 45610425 53550960 cao
## 468 PG 141621490 166277038 cao
## 469 G 223808164 262771918 cao
## 470 PG-13 16289867 19125841 thap
## 471 PG-13 225067 264247 thap
## 472 R 7916887 9295171 thap
## 473 PG 94514402 110932022 cao
## 474 PG 275093 322979 thap
## 475 G 90559416 106308538 thap
## 476 PG 114053759 133702498 thap
## 477 PG 110101975 128039679 thap
## 478 PG 44277350 49767744 thap
## 479 G 38174685 38174685 thap
## 480 PG 67172594 75501997 thap
## 481 G 79576189 89443640 thap
## 482 G 32011576 35981010 cao
## 483 PG 293004164 329336681 cao
## 484 PG-13 163958031 184288829 cao
## 485 PG 119436770 134246932 thap
## 486 G 15090399 16961607 thap
## 487 PG 1391434 1563976 thap
## 488 PG 20521 23064 thap
## 489 PG-13 38577772 43361416 thap
## 490 G 30702446 34509545 thap
## 491 PG 137855863 154927105 cao
## 492 G 104400899 116316457 cao
## 493 PG 49492060 55503929 thap
## 494 PG-13 32680633 34917330 thap
## 495 PG 334191110 357063499 cao
## 496 PG 80741 86264 thap
## 497 PG 62950384 67258772 thap
## 498 G 19422319 20751600 thap
## 499 PG-13 90759676 96971361 thap
## 500 G 415004880 443408255 cao
## 501 PG 63150991 67473105 cao
## 502 PG-13 42400223 45302137 thap
## 503 PG-13 48658 51988 thap
## 504 PG 25702053 27461121 thap
## 505 PG 59699513 63781920 thap
## 506 PG 200821936 214388548 thap
## 507 PG 172062763 183619259 cao
## 508 G 99967670 106270797 cao
## 509 PG-13 55100437 58574607 thap
## 510 PG 21392758 22741603 thap
## 511 G 15428747 16401551 thap
## 512 PG 2815 2984 thap
## 513 PG 10130219 10768946 thap
## 514 PG-13 241063875 256263359 cao
## 515 G 191450875 203522177 thap
## 516 G 26692846 28375869 thap
## 517 PG-13 169705587 180404976 thap
## 518 R 18298649 19452402 thap
## 519 PG-13 85463309 90848019 cao
## 520 PG 88625922 94189503 cao
## 521 PG-13 79883359 84762149 cao
## 522 G 19192510 20325733 thap
## 523 PG-13 73058679 77372445 thap
## 524 G 28965459 30675725 thap
## 525 PG-13 623279547 660081224 cao
## 526 PG 237282182 251292441 cao
## 527 PG-13 12431792 13165822 cao
## 528 PG 51853450 54914942 cao
## 529 PG 35287788 37363513 cao
## 530 PG 189412677 200354959 cao
## 531 PG-13 182207973 192122330 cao
## 532 PG 234770996 243434130 cao
## 533 PG-13 408992272 424084233 cao
## 534 G 268488329 278395641 cao
## 535 PG-13 89302115 92597388 cao
## 536 PG 90282580 93614037 cao
## 537 R 3254172 3374251 cao
## 538 PG-13 206362140 213962184 cao
## 539 PG-13 5201879 5367415 cao
## 540 PG 400738009 414997174 cao
## 541 PG-13 30659817 31787136 cao
## 542 PG-13 83299761 86249969 cao
## 543 PG-13 43568507 44955015 cao
## 544 PG 51178893 52807594 cao
## 545 PG-13 259746958 268013076 cao
## 546 G 17780194 18346024 cao
## 547 PG 36447959 37607865 cao
## 548 PG 241407328 249089809 cao
## 549 PG 59157732 61040349 cao
## 550 PG-13 333172112 343771168 cao
## 551 PG 54235441 55961409 cao
## 552 PG 66954149 69055550 cao
## 553 PG 222527828 229249222 cao
## 554 PG 128002372 130894237 cao
## 555 PG 12429583 12429583 cao
## 556 PG 44480275 44480275 cao
## 557 PG 201151353 201151353 cao
## 558 G 16432322 16432322 cao
## 559 PG-13 459005868 459005868 cao
## 560 PG 93436322 93436322 cao
## 561 PG 356461711 356461711 cao
## 562 PG-13 180202163 180202163 cao
## 563 PG-13 72313754 72313754 cao
## 564 PG 123087120 123087120 cao
## 565 PG-13 936662225 936662225 cao
## 566 PG 27569558 27569558 cao
## 567 PG 341268248 341268248 cao
## 568 PG 364001123 364001123 cao
## 569 G 7895708 7895708 cao
## 570 PG-13 408084349 408084349 cao
## 571 PG 77042381 77042381 cao
## 572 PG 486295561 486295561 cao
## 573 PG 55483770 55483770 cao
## 574 PG 76233151 76233151 cao
## 575 PG-13 12545979 12545979 cao
## 576 PG 8874389 8874389 cao
## 577 PG-13 232532923 232532923 cao
## 578 PG 246082029 246082029 cao
## 579 PG-13 529483936 529483936 caoDữ liệu về tổng thu nhập của Disney qua các bộ phim được phát hành từ 1937-2016 gồm 579 quan sát, trong đó có 5 biến định lượng và 2 biến định tính
6 2. Mô tả bộ dữ liệu:
movie_tittle: Tên phim
release_date: Ngày phát hành
gener: Thể loại
- Musical: thể loại nhạc kịch
- Adventure: thể loại phiêu lưu
- Drama: thể loại phim truyền hình
- Comedy: thể loại hài kịch
- Action: thể loại hành động
- Horror: thể loại kinh dị
- Romantic Comedy: thể loại hài kịch lãng mạn
- Thriller/Suspense: thể loại kinh dị/ hồi hộp
- Western: thể loại miền viễn Tây
- Black Comedy: thể loại hài kịch châm biếm
- Documentary: thể loại phim tài liệu
- Concert/Performance: thể loại hòa nhạc/ biểu diễn
- mpaa_rating: đánh giá phân loại phim theo hệ thống MPAA
- G (general audiences): dành cho mọi đối tượng khán giả
- PG (parental guidance suggested): dành cho trẻ em có sự giám sát của phụ huynh
- R (restricted): không dành cho trẻ dưới 17 tuổi xem mà không có sự giám sát của người lớn
- PG-13: dành cho người từ 13 tuổi trở lên
total_gross: tổng doanh thu (triệu USD)
inflation_adjusted_gross: Tổng doanh thu đã điều chỉnh theo lạm phát (triệu USD)
str(d)## tibble [579 × 7] (S3: tbl_df/tbl/data.frame)
## $ movie_title : chr [1:579] "Snow White and the Seven Dwarfs" "Pinocchio" "Fantasia" "Song of the South" ...
## $ release_date : POSIXct[1:579], format: "1937-12-21" "1940-02-09" ...
## $ genre : chr [1:579] "Musical" "Adventure" "Musical" "Adventure" ...
## $ mpaa_rating : chr [1:579] "G" "G" "G" "G" ...
## $ total_gross : num [1:579] 1.85e+08 8.43e+07 8.33e+07 6.50e+07 8.50e+07 ...
## $ inflation_adjusted_gross: num [1:579] 5.23e+09 2.19e+09 2.19e+09 1.08e+09 9.21e+08 ...
## $ doanhthu : chr [1:579] "cao" "cao" "cao" "cao" ...summary(d)## movie_title release_date genre
## Length:579 Min. :1937-12-21 00:00:00.000 Length:579
## Class :character 1st Qu.:1993-03-29 12:00:00.000 Class :character
## Mode :character Median :1998-09-04 00:00:00.000 Mode :character
## Mean :1998-07-10 13:20:49.741
## 3rd Qu.:2006-02-06 12:00:00.000
## Max. :2016-12-16 00:00:00.000
## mpaa_rating total_gross inflation_adjusted_gross
## Length:579 Min. : 0 Min. :0.000e+00
## Class :character 1st Qu.: 12788864 1st Qu.:2.274e+07
## Mode :character Median : 30702446 Median :5.516e+07
## Mean : 64701789 Mean :1.188e+08
## 3rd Qu.: 75709033 3rd Qu.:1.192e+08
## Max. :936662225 Max. :5.229e+09
## doanhthu
## Length:579
## Class :character
## Mode :character
##
##
##