library(readr)
## Warning: package 'readr' was built under R version 4.2.3
insurance <- read_csv("C:/Users/m0952408/Desktop/insurance.csv")
## Rows: 1338 Columns: 7
## ── Column specification ────────────────────────────────────────────────────────
## Delimiter: ","
## chr (3): sex, smoker, region
## dbl (4): age, bmi, children, charges
##
## ℹ 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.
head(insurance)
## # A tibble: 6 × 7
## age sex bmi children smoker region charges
## <dbl> <chr> <dbl> <dbl> <chr> <chr> <dbl>
## 1 19 female 27.9 0 yes southwest 16885.
## 2 18 male 33.8 1 no southeast 1726.
## 3 28 male 33 3 no southeast 4449.
## 4 33 male 22.7 0 no northwest 21984.
## 5 32 male 28.9 0 no northwest 3867.
## 6 31 female 25.7 0 no southeast 3757.
df = insurance
num_cols <- unlist(lapply(df, is.numeric))
plot(df[,num_cols])
#EDA 3: Correlation matrix for the numeric columns of the dataset. Round to two decimal places.
round(cor(df[,num_cols]),2)
## age bmi children charges
## age 1.00 0.11 0.04 0.30
## bmi 0.11 1.00 0.01 0.20
## children 0.04 0.01 1.00 0.07
## charges 0.30 0.20 0.07 1.00
#EDA 4:These boxplots depict how medical charges vary among smokers vs. non-smokers, different genders, and various regions.
smoker = as.factor(df$smoker)
sex = as.factor(df$sex)
region = as.factor(df$region)
boxplot(df$charges ~ smoker, main ='Smoker')
boxplot(df$charges ~ sex, main ='sex')
boxplot(df$charges ~ region, main ='region')
#Linear regression model to predict medical charges using all available predictor variables in the dataset
model1 = lm(charges ~. , data =df)
summary(model1)
##
## Call:
## lm(formula = charges ~ ., data = df)
##
## Residuals:
## Min 1Q Median 3Q Max
## -11304.9 -2848.1 -982.1 1393.9 29992.8
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -11938.5 987.8 -12.086 < 2e-16 ***
## age 256.9 11.9 21.587 < 2e-16 ***
## sexmale -131.3 332.9 -0.394 0.693348
## bmi 339.2 28.6 11.860 < 2e-16 ***
## children 475.5 137.8 3.451 0.000577 ***
## smokeryes 23848.5 413.1 57.723 < 2e-16 ***
## regionnorthwest -353.0 476.3 -0.741 0.458769
## regionsoutheast -1035.0 478.7 -2.162 0.030782 *
## regionsouthwest -960.0 477.9 -2.009 0.044765 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 6062 on 1329 degrees of freedom
## Multiple R-squared: 0.7509, Adjusted R-squared: 0.7494
## F-statistic: 500.8 on 8 and 1329 DF, p-value: < 2.2e-16