Statistics Exercise Module 4 (1)

IE 7361 Statistics Exercise Module 4 JMP Data Tables This exercise focuses on setting up tables of data, which is the first step to performing statistical analysis. Module 5 contains an assignment analyzing data with JMP, and this exercise will be used to set up the tables needed to complete that assignment. This exercise covers the following module 4 objectives: - Set up data collection tables in JMP - Discuss other issues of experiment design including selecting sample sizes and defining data types in JMP Prerequisite: Install JMP on your computer. JMP is available through TigerWare. Login to your myLSU account and click on Tigerware in the top left menu. From there, search for JMP. This is free to LSU students. Resources for using JMP and setting up tables: Use this resources from JMP to view videos and one-page guides on the following topics needed for this exercise https://www.jmp.com/en_us/learning-library/using-jmp.html Opening JMP and Getting Started Importing Data from Excel JMP Data Tables Directions: For each problem, set up the data table in JMP as described. Save each data table to use in the Module 5 Statistics Exercise assignment.

Problem 1: Use of a medication organization tool on ambulances The goal of this project was to reduce the time paramedics spent reordering supplies for ambulances at the start of shifts for the East Baton Rouge Parish Emergency Medical Services. One idea was to provide better organization in the medication drawer such that paramedics could easily visualize which medications needed to be ordered. The team times to complete the ordering process with and without the organization tool, and the data is provided below. By completing analysis, you will be able to answer the question: Does the organization tool save ordering time? Figure 1: Drawer before organization tool Figure 2: Drawer using organization tool Table 1: Time study data Time Study Before Tool Time Study After Tool Observation # Time (sec) Observation # Time (sec) 1 461.0 1 401.0 2 284.1 2 255.1 3 414.1 3 391.0 4 378.0 4 348.1 5 371.1 5 275.1 6 262.1 6 276.1 7 490.1 7 308.0 8 285.1 9 350.0 1. Set up a data table using two columns: Column 1 label: Before/After Column 2 label: Times (sec) Column 1 entries will simply be words: “Before” or “After.” You should have 9 rows with “Before” and 7 rows with “After”. Column 2 entries will be the corresponding times, which you can copy and paste from the table here.

Problem 2: Hospital Transporters Staffing Hospitals make use of transporters to deliver patients between departments. A previous project evaluated the staffing levels of transporters at Our Lady of the Lake hospital in Baton Rouge. Researchers observed times to transport patients from the emergency department triage to treatment center or ED room and to return. The goal of the project was to provide an accurate estimate of transport times, which can then be used in conjunction with patient volumes to determine transporter staffing needs. Use JMP to complete the items below. Receive Request Call patient in the lobby/ triage room Begin patient transport to Treatment Center Arrive to TC and hand patient chart and ID stickers to secretary Place papers in correct bin/ Give to nurse Treatment Center or ED room Return to triage Begin patient transport To ED room Arrive to ED room and give the ID stickers to nurse Place papers in correct bin/ Give to nurse Figure 1: Triage Patient Transport Process Flow

Table 1: Time Studies for Triage (minutes) Date Location Acquir e Patient Transpor t Delay Paper Handlin g Travel Back Total Time 10/18/201 3 Triage- TC 0.5 3 0 1 2.5 5 10/18/201 3 Triage- TC 0.5 2 0 1 1 4 10/18/201 3 Triage- C5 0.5 1 0 1 0.5 2 10/18/201 3 Triage- TC 0.5 2 0 1 3.5 4 10/18/201 3 Triage- TC 1 3 0 1 2.5 6 10/22/201 8 Triage- TC 0.5 3 0 0.5 1 5 10/22/201 8 Triage- TC 0.5 4 0 0.5 1 5 10/22/201 8 Triage- TC 0.5 4 0 0.5 3 5 10/22/201 8 Triage- A8 0.5 1 0 1 0.5 2 10/22/201 8 Triage- TC 0.5 3 0 0.5 2.5 4 10/22/201 8 Triage- TC 3 2 0 0.5 3 9 11/14/201 8 Triage- C6 1 1 1 1 1 3 11/14/201 8 Triage- TC 1 2 0 1 2 5 11/14/201 8 Triage- TC 4 3 3 1 1 10 11/14/201 8 Triage- TC 0.5 2 0 0.5 2 3 10/28/201 8 Triage- A10 1 1 0 1 3 5 10/28/201 8 Triage- TC 0.5 3 0 0.5 1.5 3 10/28/201 8 Triage- TC 2 3 0 2 1.5 8 10/28/201 8 Triage- TC 3 2 0 1 1.5 8 10/28/201 8 Triage- A10 1 2 0 0.5 1.5 3 10/28/201 8 Triage- TC 0.5 2 0 0.5 1.5 3 10/28/201 8 Triage- TC 0.5 3 0 1 2 4 10/28/201 Triage- 0.5 2 4 0.5 1.5 3

Problem 3: Evaluating physician performance in a primary care clinic The goal of this project was to reduce total patient flow time in a primary care clinic within the Baton Rouge General Physicians Group. Casual observations noted a great disparity in times between doctors at the same clinic. The table below presents observed times detailed by patient, physician, and by process step. There are two goals of this initial set of observations: 1) determine which physicians have longer patient flow times, and 2) determine which steps of the process are causing the differences in those flow times. Table 1: October time study (all times in minutes) Doctor Patient Check- in Waiting room Waiting in exam room for nurse Nurse intake Wait on doctor Time with doctor Lab services Total time in clinic Dr. J 1 1 18 8 15 0 21 0 63 Dr. J 2 14 0 17 19 10 15 11 86 Dr. J 3 10 7 1 30 2 17 7 74 Dr. J 4 10 21 2 17 13 12 0 75 Dr. J 5 4 20 0 14 20 14 0 72 Dr. J 6 3 3 1 11 8 17 6 49 Dr. J 7 3 2 0 10 2 7 0 24 Dr. J 8 2 0 0 9 13 5 0 29 Dr. J 9 3 2 2 16 2 11 0 36 Dr. V 10 5 0 0 7 7 6 0 25 Dr. V 11 3 9 2 14 3 5 0 36 Dr. V 12 5 5 0 9 8 11 8 46 Dr. V 13 3 4 9 15 2 9 4 46 Dr. V 14 4 0 5 8 5 6 0 28 Dr. V 15 4 0 2 11 1 3 0 21 Dr. V 16 4 9 0 9 1 5 0 28 Dr. V 17 5 1 1 11 3 8 0 29 Dr. V 18 3 2 1 7 1 5 0 19 Dr. B 19 2 6 0 14 23 6 0 51 Dr. B 20 3 7 6 11 19 13 0 59 Dr. B 21 5 15 0 4 51 13 3 91 Dr. B 22 2 13 4 8 22 18 0 67 Dr. B 23 1 18 14 14 31 12 0 80 Dr. B 24 2 9 4 19 11 3 3 51 Dr. B 25 4 13 10 11 27 12 0 77 Dr. B 26 2 4 0 9 10 22 0 47 Dr. B 27 1 21 7 9 60 32 0 130 Dr. W 28 2 1 0 7 2 12 0 24 Dr. W 29 1 4 0 6 12 21 5 49 Dr. W 30 1 6 0 8 21 18 3 57

Dr. W 31 1 12 0 14 32 14 0 73 Dr. W 32 3 28 6 8 31 26 7 109 Dr. W 33 1 1 0 17 8 25 0 52 Dr. W 34 2 2 1 11 23 22 0 61 Dr. W 35 2 5 17 19 7 27 10 87 Dr. W 36 5 26 0 7 38 17 0 93 1. Set up the data table in JMP. This is a great time to practice copying the table into Excel and then importing it into JMP (using paste with columns.) 2. Check the data type for each column and make sure it aligns properly.