#load Packages
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr 1.2.1 ✔ readr 2.2.0
## ✔ forcats 1.0.1 ✔ stringr 1.6.0
## ✔ ggplot2 4.0.3 ✔ tibble 3.3.1
## ✔ lubridate 1.9.5 ✔ tidyr 1.3.2
## ✔ purrr 1.2.2
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag() masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(readxl)
Stadium <- read_csv("us_sportsvenues1909_2027.csv")
## Rows: 219 Columns: 11
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (3): venuename, teams, source
## dbl (8): year, totalcost, publiccost, totalcost2020, publiccost2020, pubpct1...
##
## ℹ Use `spec()` to retrieve the full column specification for this data.
## ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
data<- Stadium %>% na.omit
summary(data$publiccost2020)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.0 0.0 156.2 190.1 286.2 1228.5
hist(data$publiccost2020)

plot(data$publiccost,data$totalcost2020)

cor(data$publiccost2020,data$totalcost2020)
## [1] 0.4671439