Question 1

Perform linear regression modelling to predict the delay in days (between the Planned and Actual date) in processing the claims, explaining the approach taken, including any further data pre-processing needed for modelling

Question 2

Discuss the results obtained from the modelling and state the linear regression equation.

Kindly show the entire code with graphs and explanation indicated

Claim_ID	Policy_No	Name	Planned	Actual	Created	Amount	Paid	Category	Terms	Region	Type
2928509866	300764795	Roger Torres	17/1/2021	18/1/2021 0:00	20210112	3072.349	Yes	AT	AD23	LOC	L001
2928511094	300434439	Jason Jones	5/2/2021	16/1/2021 0:00	20210130	910.944	Yes	AT	EC05	LOC	L001
2928516927	300769623	Robert Martin	18/1/2021	14/1/2021 0:00	20210113	567.936	Yes	AT	AB27	LOC	L001
2928517338	300794332	Stacy Anderson	15/1/2021	18/1/2021 0:00	20210110	181.651	Yes	AT	AE14	LOC	L001
2928518375	300792283	Mr. Adam Whitaker III	5/2/2021	8/2/2021 0:00	20210131	238.74	Yes	AT	EC05	LOC	L001
2928518381	300782669	Robert James	18/1/2021	22/1/2021 0:00	20210113	772.492	Yes	AT	AD23	LOC	L001
2928521263	300739006	Amanda Garza	17/1/2021	23/1/2021 0:00	20210112	2854.26	Yes	AT	AD23	LOC	L001
2928528363	300729942	Courtney Robbins	17/1/2021	22/1/2021 0:00	20210112	2898.78	Yes	AT	AD23	LOC	L001
2928528375	300778870	Jonathan Peterson	19/1/2021	5/2/2021 0:00	20210115	5742.653	Yes	AT	AD23	LOC	L001
2928531494	300742521	Mrs. Donna Keller	4/2/2021	22/1/2021 0:00	20210130	371.7	Yes	AT	EC05	LOC	L001
2928532226	300756072	Lisa Vincent	23/1/2021	29/1/2021 0:00	20210118	1457.347	Yes	AT	DE16	LOC	L001
2928532560	300718130	Andre Gonzalez	3/2/2021	23/1/2021 0:00	20210129	758.015	Yes	AT	EC05	LOC	L001
2928532814	300418007	Joan Elliott	19/1/2021	22/1/2021 0:00	20210114	183.71	Yes	AT	AD23	LOC	L001
2928532814	300418007	Joan Elliott	19/1/2021	22/1/2021 0:00	20210114	183.71	Yes	AT	AD23	LOC	L001
2928533426	300769623	Troy Phillips	14/1/2021	9/1/2021 0:00	20210109	4271.192	Yes	AT	AB27	LOC	L001
2928533509	300418007	Megan Hendricks	19/1/2021	22/1/2021 0:00	20210114	293.001	Yes	AT	AD23	LOC	L001
2928533987	300726979	Denise Higgins	17/1/2021	22/1/2021 0:00	20210112	5558.286	Yes	AT	AD23	LOC	L001
2928534458	300718130	Kathleen Parker	23/1/2021	29/1/2021 0:00	20210118	194.206	Yes	AT	DE16	LOC	L001
2928535047	300290370	Sean Brown	16/1/2021	26/2/2021 0:00	20210112	1648.274	Yes	AT	AD23	LOC	L001
2928536356	300762301	Chelsea Ibarra	14/1/2021	15/1/2021 0:00	20210109	503.221	Yes	AT	CD89	LOC	L001
2928536361	300739044	Donna Bennett	22/1/2021	23/1/2021 0:00	20210117	2227.36	Yes	AT	AD23	LOC	L001
2928536837	300755701	Joshua Riddle	14/1/2021	15/1/2021 0:00	20210109	1921.377	Yes	AT	AD23	LOC	L001
2928537125	300752302	Julian Gilbert	14/1/2021	14/1/2021 0:00	20210109	4897.767	Yes	AT	AD23	LOC	L001
2928537408	300455322	Christopher Johnson	29/1/2021	11/2/2021 0:00	20210124	5381.605	Yes	AT	DE49	LOC	L001
2928537754	300763152	Stephen Tucker	1/2/2021	4/2/2021 0:00	20210127	1885.316	Yes	AT	EC05	LOC	L001
2928537796	300769623	Regina Huynh	14/1/2021	9/1/2021 0:00	20210109	144.033	Yes	AT	AB27	LOC	L001
2928537859	300769623	Troy Phillips	14/1/2021	15/1/2021 0:00	20210109	1002.998	Yes	AT	AB27	LOC	L001
2928537861	300769623	Taylor Campbell	14/1/2021	9/1/2021 0:00	20210109	70.109	Yes	AT	AB27	LOC	L001
2928537865	300769623	Paul Chase	14/1/2021	9/1/2021 0:00	20210109	3409.522	Yes	AT	AB27	LOC	L001
2928538287	300762301	Nancy Becker	14/1/2021	15/1/2021 0:00	20210109	419.732	Yes	AT	CD89	LOC	L001
2928538472	300769623	Regina Huynh	16/1/2021	18/1/2021 0:00	20210111	3304.949	Yes	AT	AB27	LOC	L001
2928538553	300865666	Donna Snow	15/1/2021	15/1/2021 0:00	20210110	198.708	Yes	AT	AD23	LOC	L001
2928538568	300726979	Bryan Turner	14/1/2021	15/1/2021 0:00	20210109	58.975	Yes	AT	AD23	LOC	L001
2928538588	300769623	Taylor Campbell	14/1/2021	9/1/2021 0:00	20210109	4519.298	Yes	AT	AB27	LOC	L001
2928539220	300769623	Joseph Werner	14/1/2021	9/1/2021 0:00	20210109	5483.457	Yes	AT	AB27	LOC	L001
2928539297	200000533	Kendra Cooper	29/1/2021	14/1/2021 0:00	20210123	118.3	Yes	AT	DE49	LOC	L001
2928539523	300769623	Deborah Decker	14/1/2021	15/1/2021 0:00	20210109	2438.453	Yes	AT	AB27	LOC	L001
2928539654	300769623	Deborah Decker	14/1/2021	17/1/2021 0:00	20210109	1202.545	Yes	AT	AB27	LOC	L001
2928539751	300769623	Shane Perez	14/1/2021	9/1/2021 0:00	20210109	3196.733	Yes	AT	AB27	LOC	L001
2928540004	300759878	Brittany Cardenas	16/1/2021	17/1/2021 0:00	20210111	1493.816	Yes	AT	AB27	LOC	L001
2928540125	300769623	David Anthony	17/1/2021	14/1/2021 0:00	20210112	3742.49	Yes	AT	AB27	LOC	L001
2928540195	300792293	Brian Espinoza	15/1/2021	15/1/2021 0:00	20210110	15395.87	Yes	AT	AD23	LOC	L001
2928540608	300767729	Joann Young	15/1/2021	11/1/2021 0:00	20210110	2497.087	Yes	AT	AD23	LOC	L001
2928540962	300726979	Denise Higgins	15/1/2021	15/1/2021 0:00	20210110	68.927	Yes	AT	AD23	LOC	L001
2928541048	300780383	Alex Bishop	15/1/2021	16/1/2021 0:00	20210110	195.939	Yes	AT	AD23	LOC	L001
2928541198	300722369	Patricia Marshall	17/1/2021	15/1/2021 0:00	20210112	5911.183	Yes	AT	AD23	LOC	L001
2928541205	300729290	Rebecca Sosa	14/1/2021	14/1/2021 0:00	20210109	1752.572	Yes	AT	AD23	LOC	L001
2928541227	300769623	Deborah Decker	15/1/2021	16/1/2021 0:00	20210110	124.733	Yes	AT	AB27	LOC	L001
2928541344	300769623	Donna Mitchell	14/1/2021	16/1/2021 0:00	20210109	4236.551	Yes	AT	AB27	LOC	L001
2928541430	300756072	Tony Jackson	23/1/2021	10/1/2021 0:00	20210118	470.94	Yes	AT	AD23	LOC	L001
2928541502	300769623	Regina Huynh	14/1/2021	10/1/2021 0:00	20210109	3454.119	Yes	AT	AB27	LOC	L001
2928541785	300726979	Jessica Graham	15/1/2021	22/1/2021 0:00	20210110	72.74	Yes	AT	AD23	LOC	L001
2928542058	300466603	Colleen Thomas	14/1/2021	14/1/2021 0:00	20210109	3784.144	Yes	AT	AD23	LOC	L001
2928542101	300769623	Regina Huynh	14/1/2021	9/1/2021 0:00	20210109	430.684	Yes	AT	AB27	LOC	L001
2928542169	300769623	Taylor Campbell	14/1/2021	10/1/2021 0:00	20210109	4931.133	Yes	AT	AB27	LOC	L001
2928542172	300769623	Hayley Dennis	15/1/2021	10/1/2021 0:00	20210110	6204.281	Yes	AT	AB27	LOC	L001
2928542560	300793830	Corey Conner	14/1/2021	7/1/2021 0:00	20210109	3966.527	Yes	AT	AD23	LOC	L001
2928542641	300769623	Taylor Campbell	14/1/2021	10/1/2021 0:00	20210109	2668.842	Yes	AT	AB27	LOC	L001
2928542679	300744019	Calvin Clark	15/1/2021	22/1/2021 0:00	20210110	7676.444	Yes	AT	AD23	LOC	L001
2928542739	300769623	Robert Martin	16/1/2021	11/1/2021 0:00	20210111	6185.88	Yes	AT	AB27	LOC	L001
2928542792	300769623	Donna Mitchell	17/1/2021	14/1/2021 0:00	20210112	801.08	Yes	AT	AB27	LOC	L001
2928542870	300769623	Robert Martin	16/1/2021	11/1/2021 0:00	20210111	665.981	Yes	AT	AB27	LOC	L001
2928542971	300769623	Troy Phillips	15/1/2021	10/1/2021 0:00	20210110	278.091	Yes	AT	AB27	LOC	L001
2928543306	300689451	Kristen Webb	17/1/2021	17/1/2021 0:00	20210112	13541.04	Yes	AT	AD23	LOC	L001
2928543345	300769623	Regina Huynh	16/1/2021	11/1/2021 0:00	20210111	1104.062	Yes	AT	AB27	LOC	L001
2928543358	300769623	David Anthony	16/1/2021	11/1/2021 0:00	20210111	1621.214	Yes	AT	AB27	LOC	L001
2928543367	300769623	Regina Huynh	15/1/2021	14/1/2021 0:00	20210110	284.761	Yes	AT	AB27	LOC	L001
2928543371	300769623	Shane Perez	15/1/2021	22/1/2021 0:00	20210110	127.514	Yes	AT	AB27	LOC	L001
2928543400	300769623	Donna Mitchell	15/1/2021	10/1/2021 0:00	20210110	76.84	Yes	AT	AB27	LOC	L001
2928543416	300769623	Troy Phillips	16/1/2021	11/1/2021 0:00	20210111	1527.06	Yes	AT	AB27	LOC	L001
2928543473	300255310	Michael Elliott	14/1/2021	14/1/2021 0:00	20210109	248.796	Yes	AT	CB37	LOC	L001
2928543484	300769623	Donna Mitchell	16/1/2021	11/1/2021 0:00	20210111	753.556	Yes	AT	AB27	LOC	L001
2928543486	300786288	Heidi Mckenzie	15/1/2021	11/1/2021 0:00	20210110	661.915	Yes	AT	CD89	LOC	L001
2928543490	300769623	Shane Perez	15/1/2021	15/1/2021 0:00	20210110	5044.306	Yes	AT	AB27	LOC	L001
2928543525	300769623	Troy Phillips	16/1/2021	11/1/2021 0:00	20210111	954.271	Yes	AT	AB27	LOC	L001
2928543701	300769623	Robert Martin	14/1/2021	9/1/2021 0:00	20210109	2414.738	Yes	AT	AB27	LOC	L001
2928543902	300769623	Paul Chase	15/1/2021	11/1/2021 0:00	20210110	2289.836	Yes	AT	AB27	LOC	L001
2928543930	300769623	Regina Huynh	16/1/2021	15/1/2021 0:00	20210111	4673.327	Yes	AT	AB27	LOC	L001
2928543941	300769623	Taylor Campbell	16/1/2021	11/1/2021 0:00	20210111	2850.119	Yes	AT	AB27	LOC	L001
2928544274	300764795	James Wade	4/2/2021	8/2/2021 0:00	20210130	6162.481	Yes	AT	EC05	LOC	L001
2928544322	300769623	David Anthony	15/1/2021	11/1/2021 0:00	20210110	2493.664	Yes	AT	AB27	LOC	L001
2928544559	300769623	David Anthony	15/1/2021	11/1/2021 0:00	20210110	4128.831	Yes	AT	AB27	LOC	L001
2928544582	300769623	Joseph Werner	15/1/2021	16/1/2021 0:00	20210110	2044.051	Yes	AT	AB27	LOC	L001
2928544625	300769623	Deborah Decker	14/1/2021	10/1/2021 0:00	20210109	881.809	Yes	AT	AB27	LOC	L001
2928544653	300729290	Rebecca Sosa	16/1/2021	16/1/2021 0:00	20210111	2874.89	Yes	AT	AD23	LOC	L001
2928544676	300560331	Samantha Gonzalez	31/3/2021	5/3/2021 0:00	20210325	3517.524	Yes	AT	CC48	LOC	L001
2928544838	300756072	Cynthia Mcguire	15/1/2021	16/1/2021 0:00	20210110	2462.124	Yes	AT	AD23	LOC	L001
2928545087	300763814	Kathleen Parker	15/1/2021	15/1/2021 0:00	20210110	4949.946	Yes	AT	AD23	LOC	L001
2928545356	300769623	Donna Mitchell	18/1/2021	14/1/2021 0:00	20210113	1736.856	Yes	AT	AB27	LOC	L001
2928545516	300769623	Regina Huynh	15/1/2021	10/1/2021 0:00	20210110	249.235	Yes	AT	AB27	LOC	L001
2928545521	300769623	Paul Chase	17/1/2021	14/1/2021 0:00	20210112	1642.659	Yes	AT	AB27	LOC	L001
2928545537	300126819	William Fisher	19/1/2021	18/1/2021 0:00	20210114	3608.325	Yes	AT	AD23	LOC	L001
2928545634	300722444	Patricia Marshall	17/1/2021	17/1/2021 0:00	20210112	5068.761	Yes	AT	AD23	LOC	L001
2928545775	300769623	David Anthony	16/1/2021	11/1/2021 0:00	20210111	3211.953	Yes	AT	AB27	LOC	L001
2928545841	300744019	Calvin Clark	16/1/2021	22/1/2021 0:00	20210111	467.348	Yes	AT	AD23	LOC	L001
2928545982	300900909	Douglas Jones DDS	15/1/2021	18/1/2021 0:00	20210110	521.228	Yes	AT	AD23	LOC	L001
2928546146	300769623	Troy Phillips	15/1/2021	11/1/2021 0:00	20210110	232.196	Yes	AT	AB27	LOC	L001
2928546188	300769623	Deborah Decker	16/1/2021	17/1/2021 0:00	20210111	86.148	Yes	AT	AB27	LOC	L001
2928546589	300707005	Antonio Gonzales	18/1/2021	18/1/2021 0:00	20210113	3227.029	Yes	AT	AD23	LOC	L001

Appendix: APPENDIX 1 - DATA DICTIONARY Variable Claim_ID Policy No Name Planned Actual Created Amount Paid Category Terms Region Description Unique identifier of claim Unique identifier of corporate policy tied to an organization Name of claimant Planned date of claim settlement Actual date of claim settlement Claim settlement record creation date Payout amount Status of payment (Yes or No) Internal categorization code Internal terms and conditions code Internal region classification code Internal type classification code Note: The meaning of each value for the internal codes of the organization is unknown.