2. Define each component of the DATA Analytics Framework in the AnswerSheet worksheet. Read the assignment description before typing a response for each component of the framework 3. The description provided for this assignment states that two additional years of data will be added to this workbook. When considering the Data Design component of the Data Analytics Model, where should totals or a summary of the data be placed in this work- book? Type your answer in the AnswerSheet worksheet. 4. Briefly explain how you would conduct a basic data audit based on the description for this assignment. Type your answer in the AnswerSheet worksheet. A1 x fx fx Expense Category B G H o o O O B C D E F 1 Expense Cal Year Cost Type Spend Plan SvP 2 Salaries 2017 F 300000 300000 0 3 Medical Su 2017 V 74500 75000 -500 4 Medicatior 2017 V 122500 125000 -2500 5 Rent 2017 F 60000 60000 0 6 Office Supp 2017 M 20500 20500 0 7 Utilities 2017 F 2700 2700 0 8 Laundry Se 2017 M 24750 25250 -500 9 Patient Sur 2017 V 49000 50000 -1000 10 Salaries 2018 F 345000 345000 0 11 Medical Su 2018 V 75000 75000 12 Medication 2018 V 125000 125000 0 13 Rent 2018 F 60000 60000 0 14 Office Supp 2018 M 20500 20500 0 15 Utilities 2018 F 2900 2900 0 16 Laundry Se 2018 V 25300 25250 50 17 Patient Sur 2018 V 50000 50000 0 18 Salaries 2019 F 400000 400000 0 19 Medical Su 2019 V 90000 75000 15000 20 Medicatior 2019 V 150000 125000 25000 21 Rent 2019 F 60000 60000 0 22 Office Supp 2019 M 24500 20500 4000 23 Utilities 2019 F 3100 3100 0 24 Laundry Se 2019 V 36350 25250 11100 25 Patient Sur 2019 V 60000 50000 10000 26 27 Fixed Cost VCPU 300000 0 0 15 0 25 60000 500 2700 250 5 0 10 345000 0 0 15 0 25 60000 0 500 4 2900 0 300 5 0 10 400000 0 15 0 25 60000 500 4 3100 350 6 0 10 oooo Use this worksheet to answer any written questions for this exercise. Type your answer in the Reponse column. Questions 2,3, and 4 Response 5 5 D 7 8 9 10 11 12 A 13 T 14 15 16 17 18 19 20 21 Data Design 22 23 24 25 Data Audit 26 NN 00 27 28 2. Define each component of the DATA Analytics Framework in the AnswerSheet worksheet. Read the assignment description before typing a response for each component of the framework 3. The description provided for this assignment states that two additional years of data will be added to this workbook. When considering the Data Design component of the Data Analytics Model, where should totals or a summary of the data be placed in this work- book? Type your answer in the AnswerSheet worksheet. 4. Briefly explain how you would conduct a basic data audit based on the description for this assignment. Type your answer in the AnswerSheet worksheet. A1 x fx fx Expense Category B G H o o O O B C D E F 1 Expense Cal Year Cost Type Spend Plan SvP 2 Salaries 2017 F 300000 300000 0 3 Medical Su 2017 V 74500 75000 -500 4 Medicatior 2017 V 122500 125000 -2500 5 Rent 2017 F 60000 60000 0 6 Office Supp 2017 M 20500 20500 0 7 Utilities 2017 F 2700 2700 0 8 Laundry Se 2017 M 24750 25250 -500 9 Patient Sur 2017 V 49000 50000 -1000 10 Salaries 2018 F 345000 345000 0 11 Medical Su 2018 V 75000 75000 12 Medication 2018 V 125000 125000 0 13 Rent 2018 F 60000 60000 0 14 Office Supp 2018 M 20500 20500 0 15 Utilities 2018 F 2900 2900 0 16 Laundry Se 2018 V 25300 25250 50 17 Patient Sur 2018 V 50000 50000 0 18 Salaries 2019 F 400000 400000 0 19 Medical Su 2019 V 90000 75000 15000 20 Medicatior 2019 V 150000 125000 25000 21 Rent 2019 F 60000 60000 0 22 Office Supp 2019 M 24500 20500 4000 23 Utilities 2019 F 3100 3100 0 24 Laundry Se 2019 V 36350 25250 11100 25 Patient Sur 2019 V 60000 50000 10000 26 27 Fixed Cost VCPU 300000 0 0 15 0 25 60000 500 2700 250 5 0 10 345000 0 0 15 0 25 60000 0 500 4 2900 0 300 5 0 10 400000 0 15 0 25 60000 500 4 3100 350 6 0 10 oooo Use this worksheet to answer any written questions for this exercise. Type your answer in the Reponse column. Questions 2,3, and 4 Response 5 5 D 7 8 9 10 11 12 A 13 T 14 15 16 17 18 19 20 21 Data Design 22 23 24 25 Data Audit 26 NN 00 27 28