Question

1 Approved Answer

Posted on Jul 21, 2024

The London Commissioning Support Unit (LCSU) has collected data concerning continuing care (CC) services across 26 of the 31 Clinical Commissioning Groups (CCGs)in London. CC

The London Commissioning Support Unit (LCSU) has collected data concerning continuing care (CC) services across 26 of the 31 Clinical Commissioning Groups (CCGs)in London. CC is long-term care (whole or in part NHS funded) provided either at home or in residentialursing homes (placement) for those patients that require any of the following categories of care (care groups):Functional mental health (FMH)Learning disability (LD)Organic mental health (OMH)Palliative care (PC)Physically disabled adult (PDA)Physically frail (PF)Aware of your expertise in data analysis, LCSU has contacted you to undertake the analysis of the data [file LCSU_CC_Data.csv]. In particular they would like you to answerthe questions below. For each question, indicate what assumptions you have made. For questions 2-10, justifywhy you choose a particular approach (graph, hypothesis test, etc.), and summarise your result in plain English (no more than 2-3 lines).1.Describe how you prepared and cleaned the data. What assumptions have you madeto do this?2.Produce suitable charts to compare:a) Split between provision types (home vs Placement) across CCGsb) Variations in care groups across CCGs3.Derive age at admission and calculate mean, min, max and median age at admission overall, overall per care group, overall per provision type. Also calculate this for each CCG.4.Produce box plots to compare age at admission across CCGs for each care group5.Produce box plots to compare weekly rateacross CCGs for each care group6.Plot histograms of age at admission and weekly rateand comment on the distributions of these variables7.Determine whether In the FMH care group, the age at admission is higher in CCGW than in CCGX.8.Determine whether the weekly rateof LD is higher in CCGW than in CCGX.9.Are females more (or less) likely than males to be cared for at home?10.Is age at admission correlated with weekly rate?

image text in transcribed

Provision start Provision end Discharge Weekly Care group Provision type DOB Gender 1 date date rate reason Palliative 28/05/2011 29/05/2011 known -in hou missing missing 2 22/10/1935 Home Care Death 3 19/08/1933 Palliative Home Care 10/05/2009 10/07/2009 Death Male 31/01/1960 4 Palliative Placement 13/05/2010 28/05/2010 Death 648.9 Male Physically Frail Death 5 26/02/1914 Placement 17/06/2009 06/09/2009 missing missing known -in hou 665.2 Male 09/10/2009 6 12/06/1917 Palliative Palliative Physically Frail Physically Disabled Adult Palliative Placement 28/08/2009 Death Male Home Care 14/10/2010 7 06/10/1925 20/09/2010 Death Male 03/05/2009 missing 8 07/04/1929 Placement ongoing Death Male 9 missing 17/04/2009 01/11/2010 Home Care Male 19/07/2007 missing known in hou Death 10 24/03/1932 Home Care 16/09/2010 Male 11 09/02/1945 Palliative Placement 08/05/2010 30/06/2010 Death 650.0 Male 21/02/2005 ongoing Organic Mental Health 12 08/04/1946 Placement ongoing Death 650.0 Male missing missing 650.0 Home Care 13 25/06/1951 Palliative 09/11/2009 19/11/2009 Male Death 14 27/08/1953 Palliative Home Care 15/08/2009 25/08/2009 Male Physically Frail Organic Mental Health 11/09/1954 Physically Disabled Adult Organic mental health palliative 01/04/2011 ongoing Male 15 26/06/1928 Placement ongoing Death 21/08/1928 09/07/2011 16 Placement 30/08/2010 667.3 Male 18/09/2009 ongoing 17 Placement ongoing Death 1,025.0 Female 18 03/08/1931 Placement 26/04/2008 25/10/2009 missing missing missing 650.0 Male 07/06/2010 03/01/1954 03/01/1954 Death 19 Home Care 17/08/2009 Male 07/06/2010 20 Palliative Placement 17/08/2009 Death Male Organic Mental Health 28/02/2010 ongoing 21 25/09/1919 Placement ongoing Death Male Female 22 29/07/1928 Palliative Home Care 02/09/2010 08/09/2010 known -in hou 650.0 Organic Mental Health palliative Organic Mental Health 14/09/2007 ongoing 23 23/08/1931 Placement ongoing Death Male 24 07/03/1939 Home Care 03/10/2009 22/10/2009 missing 379.2 Male 19/09/1944 20/11/2010 ongoing 25/01/2010 25 Home Care ongoing Death Male 26 12/04/1921 Palliative Placement 03/02/2010 missing missing known -in hou 648.9 Male Death Death 27 27/09/1928 Palliative Placement 22/02/2010 01/03/2010 Male Male Palliative Palliative 28 15/02/1929 Home Care 12/03/2011 11/03/2011 03/02/1936 Death Female 29 Placement 09/05/2010 29/05/2010 23/10/1948 27/02/1924 31/07/2009 Death 30 Palliative Home Care 14/06/2009 missing 478.5 Female Physically Frail 10/10/2010 31 Placement 15/12/2010 Death Female 32 04/05/1927 Palliative Placement 06/06/2011 02/08/2011 Death missing missing known-in hou Female known-in hou Female Female 675.0 11/07/1947 Home Care Death 33 palliative Physically Frail 12/07/2009 30/07/2009 missing 34 22/09/1937 Home Care 15/06/2009 23/02/2011 Death Home Care Death 35 21/12/1930 Palliative 21/01/2011 07/02/2011 Physically Frail 09/08/2001 ongoing 36 24/09/1922 Placement ongoing Death 548.2 37 21/01/1932 Palliative Home Care 10/06/2010 11/07/2010 Female known in hou 03/01/2010 38 21/10/1927 Palliative Placement 06/12/2009 Death missing missing 650.0 Female Organic mental health Organic Mental Health Death missing Female 39 10/08/1929 Placement 24/11/2006 20/10/2009 40 25/06/1924 Placement 17/06/2010 16/04/2011 Death missing missing Female Death 41 29/11/1934 Palliative Placement 06/11/2009 23/12/2009 missing missing known -in hou missing 20/10/2009 Palliative Palliative 42 14/07/1957 Home Care 26/09/2009 Death Home Care 43 29/12/1938 09/08/2010 30/12/2010 Death 05/06/2009 44 25/04/1945 Palliative Home Care 25/05/2009 Death missing Sheet1 Sheet2 Sheet3 Provision start Provision end Discharge Weekly Care group Provision type DOB Gender 1 date date rate reason Palliative 28/05/2011 29/05/2011 known -in hou missing missing 2 22/10/1935 Home Care Death 3 19/08/1933 Palliative Home Care 10/05/2009 10/07/2009 Death Male 31/01/1960 4 Palliative Placement 13/05/2010 28/05/2010 Death 648.9 Male Physically Frail Death 5 26/02/1914 Placement 17/06/2009 06/09/2009 missing missing known -in hou 665.2 Male 09/10/2009 6 12/06/1917 Palliative Palliative Physically Frail Physically Disabled Adult Palliative Placement 28/08/2009 Death Male Home Care 14/10/2010 7 06/10/1925 20/09/2010 Death Male 03/05/2009 missing 8 07/04/1929 Placement ongoing Death Male 9 missing 17/04/2009 01/11/2010 Home Care Male 19/07/2007 missing known in hou Death 10 24/03/1932 Home Care 16/09/2010 Male 11 09/02/1945 Palliative Placement 08/05/2010 30/06/2010 Death 650.0 Male 21/02/2005 ongoing Organic Mental Health 12 08/04/1946 Placement ongoing Death 650.0 Male missing missing 650.0 Home Care 13 25/06/1951 Palliative 09/11/2009 19/11/2009 Male Death 14 27/08/1953 Palliative Home Care 15/08/2009 25/08/2009 Male Physically Frail Organic Mental Health 11/09/1954 Physically Disabled Adult Organic mental health palliative 01/04/2011 ongoing Male 15 26/06/1928 Placement ongoing Death 21/08/1928 09/07/2011 16 Placement 30/08/2010 667.3 Male 18/09/2009 ongoing 17 Placement ongoing Death 1,025.0 Female 18 03/08/1931 Placement 26/04/2008 25/10/2009 missing missing missing 650.0 Male 07/06/2010 03/01/1954 03/01/1954 Death 19 Home Care 17/08/2009 Male 07/06/2010 20 Palliative Placement 17/08/2009 Death Male Organic Mental Health 28/02/2010 ongoing 21 25/09/1919 Placement ongoing Death Male Female 22 29/07/1928 Palliative Home Care 02/09/2010 08/09/2010 known -in hou 650.0 Organic Mental Health palliative Organic Mental Health 14/09/2007 ongoing 23 23/08/1931 Placement ongoing Death Male 24 07/03/1939 Home Care 03/10/2009 22/10/2009 missing 379.2 Male 19/09/1944 20/11/2010 ongoing 25/01/2010 25 Home Care ongoing Death Male 26 12/04/1921 Palliative Placement 03/02/2010 missing missing known -in hou 648.9 Male Death Death 27 27/09/1928 Palliative Placement 22/02/2010 01/03/2010 Male Male Palliative Palliative 28 15/02/1929 Home Care 12/03/2011 11/03/2011 03/02/1936 Death Female 29 Placement 09/05/2010 29/05/2010 23/10/1948 27/02/1924 31/07/2009 Death 30 Palliative Home Care 14/06/2009 missing 478.5 Female Physically Frail 10/10/2010 31 Placement 15/12/2010 Death Female 32 04/05/1927 Palliative Placement 06/06/2011 02/08/2011 Death missing missing known-in hou Female known-in hou Female Female 675.0 11/07/1947 Home Care Death 33 palliative Physically Frail 12/07/2009 30/07/2009 missing 34 22/09/1937 Home Care 15/06/2009 23/02/2011 Death Home Care Death 35 21/12/1930 Palliative 21/01/2011 07/02/2011 Physically Frail 09/08/2001 ongoing 36 24/09/1922 Placement ongoing Death 548.2 37 21/01/1932 Palliative Home Care 10/06/2010 11/07/2010 Female known in hou 03/01/2010 38 21/10/1927 Palliative Placement 06/12/2009 Death missing missing 650.0 Female Organic mental health Organic Mental Health Death missing Female 39 10/08/1929 Placement 24/11/2006 20/10/2009 40 25/06/1924 Placement 17/06/2010 16/04/2011 Death missing missing Female Death 41 29/11/1934 Palliative Placement 06/11/2009 23/12/2009 missing missing known -in hou missing 20/10/2009 Palliative Palliative 42 14/07/1957 Home Care 26/09/2009 Death Home Care 43 29/12/1938 09/08/2010 30/12/2010 Death 05/06/2009 44 25/04/1945 Palliative Home Care 25/05/2009 Death missing Sheet1 Sheet2 Sheet3