Control chart

WEBVTT 1 00:00:25.020 --> 00:00:38.430 Wilmer Pereira: Hello everyone this is Wilma data. And this is the sixth 24 quality management and the video I want to walk you through to the control char homework exercise for this week. 2 00:00:40.200 --> 00:01:00.450 Wilmer Pereira: So we are going to do a control chart or your Instagram project. So the exercises about select and create one control chart for your team project or your individual project. So we need to go through the selection three right so in this case. 3 00:01:01.830 --> 00:01:13.020 Wilmer Pereira: Let's start at the top. So we need to answer the question, what type of data we have. Let's say that we want to do a control chart to track the number of likes for posts. 4 00:01:13.770 --> 00:01:29.160 Wilmer Pereira: So the type of data is displayed. Right. So it's 12345 like is no 1.3 1.2 1.5 so we have we have interviews. So we have this great data. 5 00:01:29.880 --> 00:01:41.850 Wilmer Pereira: And then what are we going to be counted. So if we said that we want to track like their post. So that's a discrete counts, so we will go towards the right and then 6 00:01:42.960 --> 00:01:45.120 Wilmer Pereira: We, what are we going to do equal 7 00:01:47.580 --> 00:01:47.820 Do 8 00:01:48.930 --> 00:02:07.260 Wilmer Pereira: Subgroup sizes and let's say yes. So we want to plot every single likes for every single post. In this case, this group size is equal to one and they are all going to equal to one. So then we will use a C sharp 9 00:02:09.720 --> 00:02:20.910 Wilmer Pereira: And then we are going to, we need to create a charter graph we your project data. The vertical axis is the page that likes proposed. 10 00:02:21.420 --> 00:02:29.340 Wilmer Pereira: The horizontal axis. Is this the chronological time you want to calculate the Android, the mean an average target. 11 00:02:29.760 --> 00:02:40.050 Wilmer Pereira: And you want to calculate and draw the natural process Lehman so that are going to be to process limits. They offer control limits which is the mean plus 12 00:02:40.590 --> 00:02:58.560 Wilmer Pereira: Three standard deviation. So, which means that you need to calculate the standard deviation for the data points and the lower control limits is going to be equal to the main minus three standard deviation. So let's see, how do we do these in an Excel sheet. 13 00:03:33.390 --> 00:03:37.230 Wilmer Pereira: Alright, so here we are in an Excel sheet and 14 00:03:38.880 --> 00:03:58.950 Wilmer Pereira: And we have, you know, post from January 1 2023 all the way up to April eight, and we have in column be the light that those codes receive. Right. So the first thing is that we are going to create a 15 00:03:59.970 --> 00:04:04.200 Wilmer Pereira: Chronological chart. So they're going to collect that data. 16 00:04:12.810 --> 00:04:16.170 Wilmer Pereira: And then we are going to go to Insert. 17 00:04:17.250 --> 00:04:18.900 Wilmer Pereira: And then we look for the chart. 18 00:04:20.070 --> 00:04:21.000 Wilmer Pereira: And then 19 00:04:23.010 --> 00:04:29.730 Wilmer Pereira: You know, probably we can select is a line chart and let's select the Search one 20 00:04:33.000 --> 00:04:46.950 Wilmer Pereira: Right, and then they will have something like that. So when they hold its own collectors, you have day that in January 1 on the vertical axis is telling you like proposed. 21 00:04:47.730 --> 00:05:03.990 Wilmer Pereira: That then we need to add the three horizontal lines, the mean and the standard deviation. So then to calculate that we will need to go and put here in column C. So what does that mean, right. So that means is going to be 22 00:05:07.380 --> 00:05:11.460 Wilmer Pereira: Equal to 90 mean or to be average 23 00:05:14.010 --> 00:05:18.900 Wilmer Pereira: Of the numbers of the lights, starting with number one. 24 00:05:19.980 --> 00:05:21.720 Wilmer Pereira: All the way to 25 00:05:25.620 --> 00:05:44.610 Wilmer Pereira: That and let's say, according to this is 287 and yes no yes I you know this is sample data. So I have a random generator number on the on the light. So it's going to be changing, but that was for me just to quickly populate data. 26 00:05:46.050 --> 00:05:55.980 Wilmer Pereira: Just for this example, so don't worry if this number change in your column be should be static. But because I created a random 27 00:05:56.940 --> 00:06:16.980 Wilmer Pereira: Formula here that every time that I click on that column, the numbers will change. But then what I'm going to do. I am going to fix these columns, because I want the same number. So I'm going to put dollar signs on the sales that are kind of too late in the 28 00:06:18.720 --> 00:06:19.320 Wilmer Pereira: Mean 29 00:06:20.460 --> 00:06:25.260 Wilmer Pereira: And then I am going to remove some of the decimal point 30 00:06:31.260 --> 00:06:33.540 Wilmer Pereira: Yes, to make it a little bit clear 31 00:06:34.650 --> 00:06:40.200 Wilmer Pereira: And then I am going to copy that and it should be 260 to cut off. 32 00:06:41.700 --> 00:06:54.360 Wilmer Pereira: Any changes because that random generator change. Okay, so it's 254 and then I wanted to create the standard deviation that standard deviation is going to be similar. 33 00:06:59.760 --> 00:07:04.440 Wilmer Pereira: Anything three standard deviation, which is standard 34 00:07:06.780 --> 00:07:08.460 Wilmer Pereira: Check. What is the formula. 35 00:07:09.690 --> 00:07:15.840 Wilmer Pereira: And the 3060 St. 36 00:07:17.010 --> 00:07:21.960 Wilmer Pereira: St. Okay, so it's going to be the 37 00:07:28.650 --> 00:07:49.110 Wilmer Pereira: Death of that first one of the data sets of my life. Okay, so here the center and I have my standard deviation going to be the same because I want to copy and paste that down. You have to go to get 38 00:07:50.370 --> 00:07:53.130 Wilmer Pereira: Going to fix the formula. 39 00:07:54.690 --> 00:07:58.470 Wilmer Pereira: So it doesn't change. And then when to remove some of the decimals. 40 00:08:00.390 --> 00:08:07.680 Wilmer Pereira: So we have a standard deviation of 139. So now that we have 41 00:08:09.450 --> 00:08:30.600 Wilmer Pereira: We have our standard deviation, we can calculate the upper and lower control limits. So the upper control limits is going to be equal to the mean. Last three times the standard deviation. So the shark. So three times. 42 00:08:32.640 --> 00:08:39.510 Wilmer Pereira: The standard deviation. So 673 and then I will copy that down. 43 00:08:42.570 --> 00:08:57.210 Wilmer Pereira: And then we are going to 30 made the lower control limit, which is going to equal to the moon minus three times the standard deviation 44 00:08:59.310 --> 00:09:04.140 Wilmer Pereira: So this one major status, you know, 45 00:09:06.180 --> 00:09:07.350 71 46 00:09:10.080 --> 00:09:21.180 Wilmer Pereira: And then we have everything we need to finish our control chart. So now what we need to add is the, the, you know, we are missing the, the three horizontal lines. 47 00:09:22.440 --> 00:09:23.580 Wilmer Pereira: So let me 48 00:09:24.780 --> 00:09:38.100 Wilmer Pereira: don't need this anymore when you when you close this down and then we are going to click on the on on on the on the chart and we are going to see select data. 49 00:09:42.480 --> 00:09:43.470 Wilmer Pereira: And here. 50 00:09:45.510 --> 00:09:47.850 Wilmer Pereira: We have a serious that is like 51 00:09:48.870 --> 00:09:51.870 Wilmer Pereira: And the great. And then, but we need to add 52 00:09:54.150 --> 00:10:10.110 Wilmer Pereira: Three more serious right one for the mean one for the control limits and they offer control limits on the lower control limits and then to do that they need to find a way to add a serious 53 00:10:11.580 --> 00:10:13.980 Wilmer Pereira: So if I right click 54 00:10:16.350 --> 00:10:26.550 Wilmer Pereira: And select data to ensure type so format area which will be here to make data so 55 00:10:27.690 --> 00:10:37.530 Wilmer Pereira: Let's see if I click on Add yeah here it is. So I have exciting. A second serious right and it's telling me here to enter the data range. 56 00:10:37.890 --> 00:10:47.550 Wilmer Pereira: So the first thing that I'm going to address the mean. So you're going to play. Come on this bottom and I'm going to select like all the data points from the mean. 57 00:10:51.120 --> 00:10:59.190 Wilmer Pereira: When this is what it's going to do is we're going to create a horizontal chart horizontal line on the sharp eye. So I'll go back and make click here. 58 00:11:00.000 --> 00:11:18.690 Wilmer Pereira: And then went to be with a name when he says his assistant mean or I can enter the sale, with the name and click OK and then do have it here 286 but what happened with my data point they disappeared. So let me do a control me 59 00:11:20.670 --> 00:11:29.640 Wilmer Pereira: There was something there and understand why they disappear. So let's make it a little bit bigger and do another day. So to make data. 60 00:11:33.240 --> 00:11:45.360 Wilmer Pereira: We have to, like, that's great. And I want to add another series, which is my my series to explain to the my name. 61 00:11:54.540 --> 00:12:00.360 Wilmer Pereira: That they see here my life serious disappeared. So I guess that 62 00:12:01.980 --> 00:12:15.330 Wilmer Pereira: We're going to do something different. So you have to make sure that we are going to ask from the beginning. All the serious from the tables and then we're going to remove the stuff that we don't need. Okay, so let's do that. So, 63 00:12:16.830 --> 00:12:22.410 Wilmer Pereira: I'm going to click here. I'm going to select everything on the stage. 64 00:12:28.590 --> 00:12:39.060 Wilmer Pereira: And then I'm going to let Enter. And now we see that we have here. All the CDs. We want to keep like we want to keep the moon, we want to 65 00:12:39.540 --> 00:12:51.630 Wilmer Pereira: Keep the upper control limits on the lower control limits the one that we don't need is the standard deviation one so we are going to remove that one by clicking on the minus bottoms here. 66 00:12:52.140 --> 00:13:12.090 Wilmer Pereira: And we are going to select OK and now we have our control chart. So, we have here the orange line represents the mean and then we have the yellow line at the top for presents are awkward control limits which is 661 and our lower control limits that is on 67 00:13:13.980 --> 00:13:22.380 Wilmer Pereira: Minus one, or seven. Okay. And that's, you know, that's the control cherry here. We don't have any fair rule violation, which is 68 00:13:22.890 --> 00:13:38.700 Wilmer Pereira: data point outside of the control unit but the purpose of this exercise is for you to learn how to create a control chart to follow this example do it with your data for your project and then you just need to meet their control chart. 69 00:13:40.320 --> 00:13:48.090 Wilmer Pereira: For for for your data as graphic like that. I highly recommend that you spend some times always when they create a chart. 70 00:13:49.470 --> 00:13:59.280 Wilmer Pereira: It in the title I have in the legend for the vertical axis and the horizontal axis. Okay, so if you you know to do that. 71 00:14:01.050 --> 00:14:07.680 Wilmer Pereira: You can go to see you can double click on on or right click and then 72 00:14:10.890 --> 00:14:25.590 Wilmer Pereira: You can find where where to add a title and that information. So let's see a fire the chart options. So these are all about formatting text option. 73 00:14:27.450 --> 00:14:29.730 Wilmer Pereira: Really doesn't help you much. 74 00:14:31.680 --> 00:14:34.530 Wilmer Pereira: That it should be a way to 75 00:14:35.940 --> 00:14:41.610 Wilmer Pereira: To find out. Let's see, for a month. If we go to the Format menu. 76 00:14:43.560 --> 00:14:44.490 Wilmer Pereira: And then 77 00:14:47.520 --> 00:14:50.220 Wilmer Pereira: Images of range final 78 00:14:53.160 --> 00:14:54.210 Wilmer Pereira: Know that 79 00:14:55.410 --> 00:15:09.660 Wilmer Pereira: The charges sign. So we have here quickly out if we see like here, you know, this is going to read is going to have some formatting right that we can do. 80 00:15:10.530 --> 00:15:19.350 Wilmer Pereira: I am hesitant to click on that, because it's going to probably change the format that we are very creative. But here on our chart element. 81 00:15:19.800 --> 00:15:31.500 Wilmer Pereira: So we have the mania to add the Charter title. So we want definite lecture title and it's telling you where to put it. So let's say a ball so we can have here. 82 00:15:34.080 --> 00:15:35.190 Wilmer Pereira: And they be 83 00:15:36.330 --> 00:15:38.610 Wilmer Pereira: Number of likes. 84 00:15:39.690 --> 00:15:40.080 Wilmer Pereira: Curve. 85 00:15:41.370 --> 00:15:45.960 Wilmer Pereira: Both and then. So we have a title if we don't have 86 00:15:47.820 --> 00:15:55.590 Wilmer Pereira: Access title so we can have a primary vertical which is shows here. And is this one is 87 00:15:56.910 --> 00:15:59.040 Wilmer Pereira: Number of a number of likes. 88 00:16:03.660 --> 00:16:05.400 Wilmer Pereira: And then for the horizontal 89 00:16:06.720 --> 00:16:10.680 Wilmer Pereira: You know we access, we could enter a 90 00:16:11.760 --> 00:16:19.830 Wilmer Pereira: Title, but it's really self explanatory is just the chronological day and then and this will be your homework, their control chart.