Welcome to the Six Sigma Green Belt training. On the last video, I presented you how to create a data collection plan. And now it's a moment when you have data in front of you. And so you have a data in Excel spreadsheet for example. And based on the project objectives, and based on the data collection plan, you have a data, raw data. And now is a moment when we need to look at the data and present them and so they're more valuable for us and for our product for our customers as well.
So, please use very simple Excel functions here. You can start with a minimum and maximum. So, if you can select all the data you collected and choose minimum function in Excel and later choose maximum value in Excel. So you will see what's the minimum value and maximum value and why it's important because it will give you a comfort of understanding what is the range of the process. So, for example, if the waiting time for pizza delivery and is minimum 15 minutes and maximum two hours, it will give you a very specific knowledge about how the process behaves. And later in analyze phase, it will be very important to look at the data as well.
Okay, so you have minimum and maximum. The next step is you can select all the data you have And choose what's the average. So, what is the average value in this situation? So, for example, you have a back to the time of pizza delivery you have a minimum of 15 minutes, maximum two hours, but the average is for example 20 or 20 minutes. So, it means that customer is waiting for pizza on average 20 minutes. So, you may ask why it's two hours.
So, what happened that it is almost It was like two hours and you will look at the situation later in analyze phase and to improve the process to improve the time of pizza delivery, okay. So, you have a data you have a minimum you have a maximum, you have also an average. So, you know, what does that mean? What is that and the mean of the of the process As the next step, you can select all the data you have and choose the function in Excel as well. That is called standard deviation. Or the standard deviation is about how and our process how results of our process and are different from the mean.
So there's like a specific way to calculate this standard deviation and but are not presented to you now as it's really like a very basic level of six sigma. So it's your first six sigma project and they don't want to make a very complicated so just trust Excel and choose their your data in and calculate the standard deviation of your data. The standard deviation will be needed later to understand what's the voice of the process. So you can very easily create the graph where you can show what is the voice of the process. Okay, so before we create a graph, and before we go to this calculation level, think about what's the voice of the customer. So what is the voice of customer?
If the pizza delivery time is a problem? And you have no data now you know that what's the minimum value minimum value, what is maximum value? And you know, what is the average? You can go to your customer now and ask okay, but what is what is your expectation? I have a data I collected data for three months, and based on the data collection plan, I have this results, but now tell me What is your expectation? You have you see that you can see the data as a customer.
And you tell me what is my, what's the objective of my project? Why, why it's done here now on this level, not in the Define phase, because very often in define phase we don't have a data. So even for the customer is hard to decide what is read expectation. Sometimes the customer is not, doesn't even know what the expectation about the process now we have specific data and we can ask the customer so for example, if the and average time of the pizza delivery is 20 minutes, and in the same time can ask the customer. Okay, so what is the time, from your perspective, you would like to get the pizza, the customer can say that okay, but it's 20 minutes now, but my expectation is to have it between five and 10 minutes. So it's really like a very important to understand what is the voice of the customer.
Why? Because later I'll show you how to compare the voice of the customer with the voice of the process and looking at the data you have a cohort, what is their goal of your project or the really the objective you are going to achieve as your project is completed. Okay, and now we are going to look at the data. So I'm going to show you a very simple example how to present the data, how to create like the voice of the process and how to add the voice of the customer to that to the graph. Okay, so let's think let's think that on the project charter, we have an objective related with the pizza delivery time so you want to decrease time spent on the pizza delivery to the customer. We created a data collection plan based on the data collection plan.
We measured that they taught for three months. And so how much time the customer was waiting for each order. And it was about one restaurant. So the variables from one specific restaurant, and we measured the time in minutes, that one pizza. We measured the number of pizza per per per day as well. And what we also measure was the type of pizza.
So we defined four types of pizza. And we measured the data about those specific four times of pizza. And now we have a data, Excel spreadsheet when you can see all the data we collected And now, I'm going to select all the data. In Excel, I'm going to calculate mean value. I'm going to calculate maximum value and as well as average and standard deviation. So please look at the data.
Now we have not only data but some information about what the data and are about or the order the data specifically. Now we are going to create a very simple wrong chart in Excel to see how our data behaves. During three months, we have and based on the calculations we have, we can create the line on the graph that Is that the line that will show us what is that average value. So, what is the mean of the of the process? Now, we have the mean and based on the standard deviation calculated and we can decide what is the voice of the process, voice of the process is about lower control limits and upper control limits. upper control limit and lower control limits are calculated as a free standard deviation.
So, it means that three standard deviation from the mean from the from the line we just created. So, now we are going to add two additional lines to the graph and the first line is lower control limit. That second line is upper control limit Why and this is the voice of the process. So, it shows us how the process behaves. And what are the limits the process change changes itself why we need this and it's about understanding the variation of the process. So, how each individual result is different from the mean from the average value.
Now, with this graph, we can ask the customer Okay, please look, this is how our process behaves. And tell me what is your expectation? So, what is your expectation as a customer, what is the value you are happy with? And the customer can tell you that, for example, that expectation is about 10 minutes or the range between five And 10 minutes of the very sampling the customer expects. And then you can add the customer expectation Voice of the Customer on the graph as well. And you have come forward to understand where we are with the process and where we should be with the process.
The way we compare voice of the customer with the voice of the process, it's called process capability. And as it's like your first six sigma project, our not concentrate here about details. There is a very great program called me top when you can very easily calculate all this information. And if you want I can support you to do all those calculations in meetup and if you want some please contact me However, for the first Greenberg project, I just want you to understand the basic rules. So it's better to create the graph by your own on your own instead of calculating it immediately, because now we have a conflict that you understand how to create the graph and how to how it works in details. Okay, so, now we have a voice of the customer voice of the process and and you understand what is the minimum value of your process, what is the maximum what is the average.
So, we are done with this part of measure face. And the next video is about Pareto. Pareto is really like a very powerful tool and it can be used everywhere. So I will show you how to use Pareto charts in your project. So thank you very much, and please create your Voice of the Customer and voice of the process graph for your product now. Thank you