You are a second-year staff member at a public accounting firm who is assigned to the Kindred Hospitals engagement, which is a new engagement for the firm. You have been asked to perform descriptive, diagnostic, and predictive analytics for your engagement team. The audit senior provided you with an Excel file that includes gross patient revenue by hospital location from 2013 to 2019. The senior asked you to perform exploratory data analytics and outline an audit plan, which you recognize is similar to outlining objectives, questions, and sub-questions for data analysis. Before you can fully explore the data, you must understand it, so you begin with descriptive statistics. Complete the chart. Objective Initial Question Sub-questions Possible Measures Descriptive Analysis: Understand gross patient revenue (GrossPatientRevenue) for the year 2019, which is the year under audit. What happened to gross patient revenue during 2019? 1. 2. Diagnostic Analysis: Understand what happened to gross patient revenue for the year 2019 compared to 2018, Specifically, GrossPatientRevenue, GrossInpatientRevenue, and GrossOutpatientRevenue data points. Which locations had changes in revenue from 2018 to 2019? 3. 4. Predictive Analysis: Develop an expectation for gross patient revenue in 2019 based on the components patient days, out patient visits, and average length of stay. What factors drive changes in gross revenue? 5. 6. 7. Perform the possible analytics as described for each measure.