---
title: "Data Analysis Project"
---


```{r setup, include=FALSE}
knitr::opts_chunk$set(echo = TRUE, 
                      message = FALSE, 
                      warning = FALSE,
                      comment = "")
```



# Student Information

**Name**: 
**G Number**:




# Introduction

This semester we will be working with a dataset of auto claims filed by customers of an automobile insurance company located in the southwest and western regions of the United States.

Insurance companies depend on accurate pricing estimates to maintain profitability. Auto policies must be priced so that the insurance company makes a profit in the long run, given the costs of their customers' payouts for accident repairs, total loss car replacements, medical fees, and legal fees.

The executives at this insurance company have noticed declining profitability over the last several years and have hired you as a data science consultant to evaluate their claims data and make recommendations on pricing, customer behavior, and car insurance policy adjustments.

The objective of this project is to perform an exploratory data analysis on the claims_df dataset and produce an executive summary of your key insights and recommendations to the executive team at the insurance company.

Before you begin, take a moment to read through the following insurance company terms to familiarize yourself with the industry:  [Auto Insurance
Terms](https://www.iii.org/article/auto-insurance-jargon-buster "Auto Insurance Terms"){target="_blank"} 



## Auto Claims Data

The `claims_df` data frame is loaded below and consists of 6,249 auto claims submitted by customers of the insurance company. The rows in this data frame represent a single claim with all of the associated features that are displayed in the table below.

**Note**: If you have not installed the `tidyverse` package, please do so by going to the `Packages` tab in the lower right section of RStudio, select the `Install` button and type `tidyverse` into the prompt. If you cannot load the data, then try downloading the latest version of R (at least 4.0). The `readRDS()` function has different behavior in older versions of `R` and may cause loading issues.


```{r}
library(tidyverse)

claims_df <- readRDS(url('https://gmubusinessanalytics.netlify.app/data/claims_df.rds'))

```


### Raw Data

```{r}

claims_df

```
<br>
<br>


# Exploratory Data Analysis


Executives at this company have hired you as a data science consultant to evaluate their claims data and make recommendations on pricing, customer behavior, and car insurance policy adjustments.

You must think of **at least 8 relevant questions** that will provide evidence for your recommendations.

The goal of your analysis should be discovering which variables drive the differences between customers with large lifetime values and
customers who cost the company more than they provide in revenue through monthly premiums.

Some of the many questions you can explore include:

-   Are there types of customers, based on their policy or demographics,
    that are highly profitable?

-   Do certain policies have a lower number of claims, leading to large
    profits?

-   Are there "problem customers" which have a large number of claims?

You must answer each question and provide supporting data summaries with either a summary data frame (using `dplyr`/`tidyr`) or a plot (using `ggplot`) or both.

In total, you must have a minimum of 5 plots and 4 summary data frames for the exploratory data analysis section. Among the plots you produce, you must have at least 4 different types (ex. box plot, bar chart, histogram, heat map, etc...)

Each question must be answered with supporting evidence from your tables and plots.





## Question 1



**Question**:



**Answer**:



To add additional R code chunks for your work, select `Insert` then `R` from the top of this notebook file.

```{r}




```



## Question 2



**Question**:



**Answer**:




```{r}




```



## Question 3



**Question**:



**Answer**:




```{r}




```




## Question 4



**Question**:



**Answer**:




```{r}




```




## Question 5



**Question**:



**Answer**:




```{r}




```


## Question 6



**Question**:



**Answer**:




```{r}




```


## Question 7



**Question**:



**Answer**:




```{r}




```



## Question 8



**Question**:



**Answer**:




```{r}




```


# Summary of Results

Write an executive summary of your overall findings and recommendations to the executives at this company. Think of this section as your closing remarks of a presentation, where you summarize your key findings and make recommendations to improve pricing, company operations, and car insurance policy adjustments.

Your executive summary must be written in a [professional tone](https://www.universalclass.com/articles/writing/business-writing/appropriate-tone-in-business-communications.htm){target="_blank"}, with minimal grammatical errors, and should include the following sections:

1.  An introduction where you explain the business problem and goals of your data analysis

    -   What problem(s) is this company trying to solve? Why are they
        important to their future success?

    -   What was the goal of your analysis? What questions were you
        trying to answer and why do they matter?

<br>

2.  Highlights and key findings from your Exploratory Data Analysis section

    -   What were the interesting findings from your analysis and **why
        are they important for the business**?

    -   This section is meant to **establish the need for your
        recommendations** in the following section

<br>

3.  Your recommendations to the company

    -   Each recommendation must be supported by your data analysis
        results

    -   You must clearly explain **why** you are making each
        recommendation and which results from your data analysis support
        this recommendation

    -   You must also describe the potential business impact of your
        recommendation:

        -   Why is this a good recommendation?

        -   What benefits will the business achieve?
      


## Executive Summary

Please write your executive summary below. If you prefer, you can type your summary in a text editor, such as Microsoft Word, and paste your final text here.














