Activity: Your case study includes an Excel dataset. Use the dataset to complete the following: 0 Calculate the mean time for each of the patient visit components in the dataset (Columns M through 8) Determine for each patient visit component whether the activity is a value-added, non-value- added, or non-valueadded but essential activity (Hint - you will find the definition of these categories in your module readings). Calculate the average throughput time of a patient (Hint - throughput is the total average time spent from the start of the visit to the end of the visit) ' Assuming the data provided, calculate the average throughput time using Little's Law as discussed in the text (Hint - Chapter #11 in the textbook). Your task is to analyze the patient throughput flow using the data, tools, and techniques learned in this module and the information above. Your assignment is to create a Microsoft Word document (your document must be Microsoft Word compatible) including all of the following: 0 Data Analysis Summary - Discuss each patient visit component in the dataset and summarize your findings. Include whether or not each activity is value-added, non-valueadded, or non-value- added but essential. Also, indicate the mean time for each component in the patient visit. Calculate the average total value-added, non-valueadded, and non-value-added but essential times and discuss the importance of each in relation to the mean total time patients spend in the clinic. 0 Wait Time Analysis - Based on your findings in the Data Analysis Summary: 0 Identify and discuss areas of the patient process about which Dr. Millwood should be concerned (i.e., where are outliers or mean times that can impact the patient experience). 0 Identify bottlenecks and constraints as evidenced by data from your analysis. 0 What are the mean total and individual component wait times for patients in the clinic across the patient experience (i.e., are there specific process steps where wait times are higher, indicating a bottleneck)? 0 Identify specific concerns about individual physicians. Drawing conclusions per physician will require you to analyze wait times by physician. There are multiple ways you can perform this analysis in Excel, such as the subtotal function or a pivot table. 0 What is the mean time physicians and MAs spend with patients delivering care? How are these metrics important to the patient experience? 0 Do average patient wait and care times differ significantly by physician? (Additional credit is available for statistical analysis but is not required.)