Welcome. Hello, good morning. Thank you very much for being here today and Today's event will carry on so that I will give the floor to mr. Beena who works for the memory programs at our town hall here in Barcelona You have the floor and I actually Apologize him because he will have to be leaving us sooner than expected and we've been Well, we have to change a little bit up to this program. So sorry about that Okay Right before father. I do I would like to thank the vice Director here at the Solidarity Foundation the autumn director who Is responsible for one of the best archives on the international Brigades? and Thank you for to the town hall and the local government because they've invited me to participate in this event today in such an important and handy event, let's say for our city, Barcelona, let me specify why I say it is convenient because We are living a sort of unhappy moment bad moment I am aware that it's not very kind maybe from me to start using these words, but I mean not only What's happening in our city in our country in Europe also in the West the East in general Overall really precisely because we're living a situation totally Different to to well in this globalized world since the second world war these sort of situation had never happened before we have tense Tense relationships in this international arena and Maybe in the four and well all over the planet a very radicalized right wing Could be in power even more so than what's for the last 70 years since the end of world war 2 it's not a right-hand side politic of the sort of classic fast season like in the 30s 40s which was One militarily but not from the cultural perspective This is actually true possibility of Managing these whole politics Overall in the globe from this radical Right wing politic it manifests in very specific ways the Austria-Austria Hungarian-Italian axis in Europe, but also let's not forget also countries like governed by Netanyahu Trump or Putin which When time passes by they are destroying really annihilating anything that was left of progress is progress or Left politics Thanks to the economic models at the way of establishing social relationships it is spreading this sort of way of thinking in a very Hegemonus way all over the world for example South America the really real Possibilities by Bolsonaro, which is a really striking horrible issue this Politician who a few weeks ago told another politician a lady I'm not raping you because you don't even deserve that so We are really living a very hard Moment because culturally which is gathering us in an We find this sort of Happenings and behaviors by the European Parliament which behind its apparent Well-being or good being it should make us think I believe it was yesterday or a few days ago What was happening and approved? What was happening with regards to the facist Politics, but Let's be careful about it because it's it's a big big failure because if 40 50 60 years afterwards fascism is still scary even 70 years afterwards. It is necessary It's necessary to close this institution what's been happening for these 70 years When Austria when the government says they're gonna destroy Hitler's home because it's gonna become a fascism monument Is a sort of expression of failure We have created wonderful cultural and educational Programs in Frankfurt in Bonn for many years universities have done great great efforts to explain what Basically to give elements and even though we are scared really scared of this sort of monument or place of Devotion towards Hitler So I believe it's worth mentioning in this arena here amongst all of you academics and Interested people And with regards to Barcelona to our city this of course worries us We are anti-facists of course history proves that at the moment our government is anti-facist Facist obviously and a government which Understands that the way to stop fascism is done through social Social buildings apartments privatizing water Helping people basically Devoting on education etc. This is a way for our local government to fight against fascism and Also by remembering all those who were Mistreated who were tortured who suffered to defend our liberties and in that sense next Thursday, I can let you know that the town hall here in Barcelona. We will approve a new law Specifying that people who have been persecuted by the Franco regime since the 60s until the 78 Will guarantee this law That all those residents in Barcelona who were tortured by because of their Struggle to To build the democracy they will be listened and welcomed and their needs will be solved By by all of us. This is not a law though for victims There were people Represiliated people who were Who were actually Retaliated sorry people who who had been retaliated and It's really worth remembering all of them These struggle has really helped us reach equality Levels and this person who's been retaliated. It's because he's adopted an ethic Decision which has cost him all this suffering. So this is what the town council wants to to recognize and to honor So after having shared with you this sort of mooring reflections, I admit I Would like to you to remember this Antifascism nature of our local politics here in Barcelona I'm really sure that this event Organized thanks to the Eurom and the UB will be really fruitful interesting and I suggest all of you Can join us on Sunday at noon in front of the International Brigades Monument Which was given by the Abraham Lilcom Brigadiers and We will organize this official recognition Ceremony and we will remember the departure of the Brigadier's 80 years ago. Thank you very much Thank you very much, mr. Venus. I now get the floor to mr. Jordan He is the director of the European Observatory of solidarity the memories of the University of Barcelona called a room Flores yours Jordi. Thank you very much by Stan Salor by director Carbinas Dear friends. I see many friendly faces in the audience coming from different Associations and the academic wall. It's been a long time Since we started working with the history the memory Transfer and the dissemination of our violent past events that represent and With us as something that has consequences in the in the present I will start with you very end because the director of the foundation mr. Javier Lopez gave me the document and the Resolution from the observatory of the Solidarity Foundation of the University This resolution that Ricard Venus was referring about of the European Parliament It is worrisome. It is something that worries me And I just come from Madrid. I took the high-speed train. We had a Congress at the University Carlos Tercero And there was a round table with a colleague of mine Coming from home Rick a Hungarian colleague And there was also Josefina Cuesta and some experts in Spain on memory transfer and In this discussion round table he presented three memorials and discussions the university discussions on this memory and what he did was to just Do I have to speak Spanish? Oh, by the way, apologies. I'm going to switch to Spanish. I have some Accent a bit of an accent from the Pyrenees, but I do my best in any case. I just want that to To share with you something we had to stop the camera We couldn't record anymore when this when this profession this Hungarian colleague had to discuss the situation teachers and professors and because the day after tomorrow the Central University of Barcelona in Budapest will close and from the top management they are manipulating the The historic approaches so it's not just a fear of these increase of neo fascism and far Ring-wing parties, but also this ultra-right political parties that do invest in memory policies in history policies the Rajoy did not invest in that but I Don't know if the civil society the university and the transnational Associations are the ones who need to develop projects and act Along with the civil society and different institutions as we are doing Today as a matter of fact, I try to be brief But I would like to congratulate Lourdes Prada's and the organizers because at the Republic pavilion We got together and of course as a foundation for solidarity of the University of Barcelona we join these events of reflection and of this 80th anniversary of the farewell of the international brigades This program well today we will have Some discussions and round tables and those of us who have been working with monuments will and have published articles in Poland and we did With it want to speak not just about gender issues in the brigades But also we would like to start a discussion on something that is really important Which is the memorial competence between the East and the West and the Narrative in Europe in the case of international brigades these narrative can be a big problem as in Poland for example and We will have a professor and an expert on these topics two years ago We also celebrated The acts the events with George mink and his dad was one of the brigades of the botwin brigade Representative with a new origin Polish also and he came to the people's Olympiates and he stayed in Barcelona as many athletes and then in September of the October They joined the international brigades and they fought in the civil war until 1938 And then they were in the French battles and he even was in Auschwitz, but he was free afterwards His memorial task was a great example and his biography is real really and a very good Proof of the 20th century because we all have Disconflicts still in our history and I would just like to thank all the speakers professor scotelski Who along with Robert Frank? Has been working and maybe he will not remember me, but we were together in Paris a while ago and Robert koala. I don't know where he is, but It's been a while now since we didn't see each other and the rest of Experts I would like to thank them for being here at ricketer. I hope this a discussion is Fruitful and lures your project is magnificent Uriel Ricard Fernanda from the observatory team Thank you all and Juanjo Romero from the casas study abroad program with four universities And I'm surely forgetting somebody, but I would like to thank you all and welcome you all to this session Okay, thank you very much Jordi now I give the floor to miss lourdes She's the cry responsible the librarian from the Republic pavilion at the UP. Thank you very much Thank you very much for being here today in this commemoration Event Remembering the 80th anniversary. This is a historian memory act But also recognition act for all those who abandoned their families and the commodities to fight a war which was not theirs Everybody's intention today is Remembering from our collective memory all those who came to fight for those ideals leaving here a few of them Many of them their lives. I would like to thank to the vice-rector Bilalta who has Wanted to inaugurate this act and dr. Gischee the Rome and specially Fernanda Nouriel Because working with them has been a great pleasure. Thanks to their patience dedication phone calls many last-minute changes and a great thanks for the cry That direction and management because they've allowed the library to be coordinating this seminar Also, we'd like to thank the vice-rector of dr. Sprue because of his research and interest in our project and website and he's 100% Confidence and trust in our team because voluntarily we have been working really hard Thank you to the vice-rector dr. Pujol and professors of the IT and mathematics faculties because they've also helped us in this adventure and Without fun also, I would like I would like to thank the seed dream Thank you for your enthusiasm and being here today. I believe this session will be Really really a great success because it's the common result of our common work We've been working really hard for the last months to make this seminar possible and As a Brigadier's would say Adelante. Let's go Thank you Just a few words, please to conclude these welcome speeches Let me talk to you on behalf of the rector the vice-rector the director of the solidarity Foundation Jordi Lourdes. Thank you all for being here. First of all, I would like to congratulate the organizers team because Very often We say that we do need these sort of events, but someone needs to make the phone calls and Organize the spaces and as Lourdes mentioned, it's obviously Really hard organizing something like this. So thank you very much for having done so and really What I would like to tell you it has been written in the Catalan I come from Vic from rural, Catalonia So you will hopefully be able to translate Almost 35,000 volunteers from more than 50 50 different countries They came to Spain to help the Republic and to fight against fascism the liberal democracies had abandoned through an intervention agreement which It just so happened to favor the rebel troops who had been fought Against the Republican Republic under the international the communist international the international Brigades started up being organized. They were military units organized by these Anti-fascist groups and a few names But most of the volunteers came from the working class And Approximately 10,000 lost their lives on 21st of September 1938 Juanne Grinda president announced on the Society of Nations Their retreat hoping that Italy and Germany would also return theirs But it was useless act in order to save to farewell them a great party was organized on the 28th of October 1938 so It's almost 80 years and three days or less than three days And I would like to highlight La Pasionaria's words Dolores Irraroli. We will not forget you She said and when the When we forget you Please when the Republic is born again like a flower, please come back. We have not forgotten you This is why we're here today We're here to remember you and we do so in this great wonderful room one of the most noble and beautiful spaces in such a historical building because we want to recover and Remember history not to reopen wounds not to be nostalgic but to understand what happened To also understand what is happening at the moment so that some of these things never ever happen again and also to Repair to honor to build And We need to do that, you know associations foundations institutions and of course the university Being a social agent with a great Responsibility not only because what we teach because of what we teach and transmit This is why it's a an act of justice We must do it within these university walls So it's a great privilege to be able to do it here at the University of Barcelona This university the UB is a really committed one and one of its major Objectives is the promotion of liberty liberty of thought in an in a self-critical way So I believe whatever happens today is illuminated by this will of Speaking in a self-critical way with liberty with freedom having a look at today's program I would like to highlight a few aspects. First of all, I would like to thank all of our speakers today I would like to congratulate who's managed to bring here today The wonderful speakers. Thank you very much. It's very important for for us your participation in this meeting And secondly, I would like to thank and congratulate the organizers for the topics that have been Selected because it's not usual to find in round tables speeches and discourses who speak on women specifically the case of the Arabs, for example, or be the working class Far too often we don't talk about the weak ones. We make them invisible. So thank you very much because you have wanted to highlight these issues and finally with regards to today's program our round table Will allow us for the current research being done by Youngsters from our university. We will give them we will have their voice heard today This will allow us to ensure these memories kept alive and the topics that Will be talked about Actually do interest the youngsters. So this new generation is actually Doing this research, which is wonderful and finally we'd like to thank for the people here having this room full This actually proves that the that this topic was necessary. We are really anxious to be able to to Talk about it and to do so with the guarantees and the freedom that these university walls Ensure as thank you very much for being here So without further ado, let's enjoy today's work. Let's enjoy it all of you. Thank you very much


What's going on everybody? My name is Alex Freberg. And in today's video, we're going to be going over the select and the from statement. So if you joined us for our last video, we went over creating our tables and inserting data into those tables. And so we have this employee demographics table. And we also have this employee salary table. And today we're going to be walking through the select statement and the from statement on these tables. So here's some of the concepts that we're going to be going over today. Let's just get it started by doing select everything. And let's do this from the employee demographics table. So let's execute this. If we want to only show the first names, we can just do first name and run that. And if we want first name and last name, we can just separate that by using a comma. And it will return those. Well, if we want to return all columns and all rows, then all we have to do is use this star. So that's what the star does now we have nine rows of data here. And if we only wanted to return, let's say the top five, we can easily do that. And we can just say top five of everything. Now the reason this could be useful is say you have a table that has millions of rows in it and you only want a small sample, you can say select top 1000. And when you do that, it will only select the top five rows. Now let's get everything back in here really quick, because we're going to move on to this distinct feature. So when we use distinct, we're actually saying that we want the unique values in a specific column. So if we say distinct, and then let's do employee ID, everything should be returned. So all nine rows should be returned. And that's because every single one of these are unique. Now let's try gender. So there's only going to be two results, the male and the female. And that's because there's only two distinct values in that column. Now let's look at all of our data again. So now we want to look at count. Now count is very simple. All is going to do is going to show us all the non null values in a column. So let's look at last name, for example, if we do count of last name, all that's going to give us is a count of nine, because we have nine last names. If, for whatever reason, somebody's last name was left out and that was null, then it would have returned maybe eight or seven, depending on how many were actually in there. So if an entire column was null, it would be returned to zero. And if you notice, we are not given a column name. That's because this is derived information based off the last name. So if we want to actually give this a name so that that column does not say no column name, we can use this as right here. So once you put as you can actually name it. So since this is the count of the last name, we'll write last name count. Keep it simple. And if we execute that, as you can see, we have last name count right there. So that's how you use that as let's look at all of our data again. We want to look at some max minns and averages right now. And the only column here where it would be useful to do it on his age, but let's actually go over and let's look at our salary table. And at our salary table, we have some really interesting salaries that I think will be a little bit more useful for this information. So let's go over to employee salary. All right, and let's look at this table really quick. So we have our salary. Now we want to look at the maximum salary that is in that column. And that is going to be $65,000. Now let's say we wanted to know what the minimum salary was. Let's execute this and the person who makes the least money is making $36,000. Now what's the average? What is the average salary for all employees? That's going to be $48,555. So super easy to use all of these things. They're extremely useful. I use them every single day. So I know that each of these are very, very useful and are definitely among the basics that you have to know. Let's look real quick at everything really quick. So we just learned the select statement, but learning this from statement really quick is also important. Up here, this actually shows us that we're already hitting off the SQL tutorial database, but let's say we change it to master. When we try to run this, it's going to give us an error. And that's because now we're hitting off this database and this database does not have this table in it. So in order to do this, in order to still hit off that table while up here we're actually hitting off a different table, we can change this information. So the from statement, you have to specify three separate things. The first thing that you need to specify is the database. So let's say we want to hit off the SQL tutorial database. Now we want to select what table we're going to do. This is actually a .dbo. So let's put .dbo. There's a lot that can go into that. It's not worth getting into now, but .dbo. And let's do employee salary. When we execute this, our information comes up, even though up here we're still hitting off the master database. When we specify it right here, then we actually are choosing what database and what table to hit off of. And so it does not matter what it is up here. So that's how you use the from statement. In the next video, we're going to be going over the where statement. And then after that, you group by an order by statement, and that will be the complete basics of SQL tutorial. And then we'll start getting into a little bit more fun stuff, some more advanced concepts, which I think would be really, really exciting for everybody to learn. Thank you guys so much for joining me. I really appreciate it. I hope this has been helpful. If you like this type of content, subscribe below and I'll see you in the next video. Thanks and goodbye.


Gang, majority of what you do in your life does not define you, right? 99.99% of what you do in your life is not a deal breaker, will not make or break you, right? It's that 1% or 0.01% of the time of your actions. Those are the ones that really define who you are and we are in those times right now, okay? What you do right now, okay, to fight totalitarianism, to prevent what the globalists have in store for humanity, okay? Your actions will define who you are for years, if not decades, if not until the day you take your last breath. Think wisely, choose wisely, act wisely. Really, I'm saying this because there's going to be a lot of people that have a lot of regrets in their lives. Soon and in the near future, you don't want to be one of them.


Hello everyone, welcome to the session 4 of Quality Control and Improvement Using Minitab. I am Professor Indrajit Mukherjee, Chair of HMA, the School of Management, IIT Bombay. So today our agenda will be to understand how to visualize the data basically. So last session what we have done is that we have discussed about Canon models, QFD and we have tried to link between CTQs and voice of the customers like that. We are interested totally now on CTQs. So quality of conformance is important for us, control and conformance and improvement of the CTQ is our agenda. So quality is all about improving CTQs. So either I control or I improve the CTQs like that. So we will discuss more about that. So last time we have talked about some aspects of CTQs and we have used a diagram to represent that one. So this is the diagram that we are using that there will be inputs and there will be control variables which can be monitored and can be changed. There will be some noise factors which we do not have any control as such, but we want to minimize their effects and we want the quality output CTQ to be close to the target that is defined by the designer and with minimum variability we want, we want to measure that one. What is happening? What is the outcome like that? So whenever we measure we have some data on CTQs and then we are going to visualize the data or CTQs. So what is the status of the data? So for that we have shown that strength is CTQ then we can draw a histogram over here and histograms are like this. So there will be frequency axis on one direction and there will be strength in one direction. So this will give you some idea where is the mean of the data set and what is the spread of the data set basically? What is the spread of the data set? So mean of the data set of a sample data set we can express by using a symbol rotation that x bar and the spread of the data set can be expressed as standard deviation of the data set and I am assuming that basic idea of mean and standard deviation is already you have and so we will go ahead with that idea that I understand mean and standard deviation. So but in quality concept what mean and standard deviation means basically that will be our discussion on session 4 and what are the what are the techniques that is used to minimize the mean variance and also bring the mean to targets that that is our overall objective. So let us try to understand one important thing in quality which is known as accuracy and precisions like that. So when we talk about accuracy we are talking about the mean of the data set or center of gravity of the data sets like that or we can we can we can think of the location of the data sets basically ok. So CG of the data set center of gravity of the data set central tendency of the data set you can you can give different names like that ok. So one is mean how close is that to the target values and what is what is precision basically. Whenever I am talking about precision we are talking about variance over here. So variance is expressed as a square like that and if you make a square root of that that will give you the sample standard deviations ok. So so this is a bullseye kind of scenario so where target value is already defined so you have to if you are hitting this point you are getting the maximum score like that ok. So but people generally tries to miss the miss the target so they will there will be variations from person to person and in process also like that. So there will be inputs and there will be process settings, there will be noises and that will create variations in the outcome that is CTQ outcomes like that ok. So there can be different types of variation there can be different types of errors in either in accuracy part or in precision part like that ok. So if you see the diagram over here the one axis is accuracy over here and one axis is precision over here that is shown on the x axis like that ok. So whenever my accuracy and precision both are high in that case I will hit the target and with minimum variability that is the diagram that is the most best scenario we can we can we can think of best scenario we can think of. So what is what scenario over here what scenario is not accurate not precise so accuracy is also low and precision is also low like that. So this is what scenario we can think of over here ok. So here what you can see is that I am hitting the target with minimum variation over here variability is very less over here ok. And over here the other diagram what is case is not accurate not even variability you can see much larger variability what you can see over here and off target is I am not hitting the target so overall average is also off centered like that. So it will come to be off centered like that. So variation is also high so that is the worst case. So what can happen in between is that so I have precision I have high end precision but I am off centered like that. So this kind of scenario can be improved if my process locations can be shifted that means the setting can be changed so that only my location is shifted the outcome CTQ the average outcome of the CTQ is near to the target like that. So now I am precise in the outcomes of the CTQs but I am not accurate basically so I can change that one. So this kind of correction is quite easy in manufacturing process. So in this case this is high precision but low accuracy so I have to improve the accuracy over here. And here what happens is that the average comes out to be near the target but variability high this is also not a favorable situation for us. So in this case what I have to do is that I have to reduce the variability like that. So in any processes our objective in quality is to increase the accuracy and increase the precision that means mean should be in the target value and target means what designer has defined the target value or customer has defined the target value like that. So I want to be in a process precise and accurate both the things are important. So both are important. So let us take an example let us give an example like Piano Manufacturing. So this was an evidence case where a well known company was manufacturing Piano for high end customers like that. So they wanted to launch a new model which is at the low end like that not on high end products like that. So they want to something which is in between products which is which is not so high quality like that. So they want to sell those products also. So that category of products they want to sell like that. So and they have a competitor also because competitors are giving them that pressure they are feeling that those companies are and those companies agenda was to confirm to the products specification like that. But this Piano Manufacturing what they are doing they are customizing the products like that then they are selling to the high end customers or who are knowledgeable customers like that. And for every customer Piano sound quality is very important like that. So and the performance of the Piano across checks inspection was there R and D was there to improve that one they have a high end quality like that. So in that case what comes out of that there are two definitions what comes out of that one is conformance to quality and one is performance that means what what we have defined is quality of design and quality of performance basically. When it goes to the end users how it is performing basically and conformance means I have the design quality of design and then I am manufacturing that one. So the competitors are they are having they are focused on conformance basically. So I am within the specification. So in this case they are manufacturing some products which is within the specification and they are doing it consistently like that. And this is not to the high end customers. So customer segment is different over here. So in this case what was happening they are confirming but what happens is that in Piano manufacturing thousands of components goes into manufacturing of the pianos like that. So in that case what happens is that there will be interplay between the parts like that. So if the parts are only confirming to specification one is at the extreme end of the specification this can be upper specification this can be lower specification. So one component may be manufactured at this range and some other component. So component one like this some other component may be manufactured at this zone at the lower end like that. So different components so when this component C2 and C1 when you when you assemble both those parts what will happen is that all are in the extreme of the specifications like that. So the we will get more noises over here. So in this case what will happen is that overall performance will deteriorate like that. So there will be interplay between this component one and component two. So but what is required is basically component one should also fulfill targets it is having a target one like that it will having a target two. So if everything is on target component one and component two what will happen is that the overall performance of the process overall performance of the products will be will be the best.  So ultimately the performance will improve. So any company's objective is to any component that is coming out of the process should be accurate and precise like that. So if I only confirm that will not help basically to bring out high performance like that. So conformance means within specification and they are consistently doing that. So consistency in that doing conformance does not ensure performance like that. So whenever you have to perform so it has to be high end performance in quality. So in that case every component is important to me every component is important to me. So both accuracy and precision of every parts is important basically we cannot ignore any of the parts and say conformance. So that cold post mentality we cannot we cannot believe in that. So only within specification will not help. So every product should be manufactured on the target and the accuracy of the product and precision of the product should be very high like that. Then only the performance will come or on-road performance of a car will happen only if each of the components are manufactured with accurate with ah with near to the targets and also the precision of the or variability of the components that are coming out of the process is very less very very less like that ok. So that is the overall idea. So in quality also accuracy and precision is very important accuracy and precision both are important to us ok. So you you may have different types of data and measure of accuracy can be different measure of precision can be different like that. But anyhow we are assuming that CTQ can be measured and that way we can improve the accuracy and we can improve the precision also ok. So whenever the CTQ is we are measuring the CTQs what will happen there will be variation in the CTQs like that. So there can be different types of variability what what generally quality persons are interested into. So one of the one of the variability is known as common cause variability or sample to sample variability. So this kind of variability is very very much it is very difficult to reduce this kind of variabilities like that and this is when the input condition changes it will it will influence whether whether your setting condition is same. But because the inputs has changed certain amount of inputs has changed or noise condition has changed. So that will impact the outcomes or CTQs like that and there will be variation like that. So this is small small variation what happens in the process that is common cause variability. So we initially we we do not consider of this kind of variabilities like that later on we will consider this kind of variabilities. But then there are other kinds of variability which is which can be easily handled or which can be we can deal with those things that is that is known as special cause variability or abnormal variability. You go to a process and what you see is that abnormal vibration is happening on the machines or the operator has completely changed like that there were skilled operators now there is new operator like that operator does not know how to set the machine what will happen is that the process behavior will change centering will change like that. Similarly you can catch hold of those things that this as this is going wrong basically. So abnormal variability is easy to detect and then you have to take action over there to reduce that kind of variability like that. Although it is time consuming you need to eliminate basically abnormal variations like that this are known as special cause variability and there are quality tools to address this one and special cause we can think of abnormal variations or assignable cause variations assignable cause special cause variations like that we can we can we can name that in different ways like that there are different names for this type of variability. So so these are very very peculiar type of variations. So suddenly behavior abruptly changes like that so ok. So this can be we we use a special kind of techniques in quality which is known as statistical process control to identify which is normal and which is abnormal like that. So there will be common variations within the circles that you are seeing. So these variations are common variability we will try to decrease that one after means in using different techniques like that. But currently I want to differentiate between let us say common variability and special cause. So I have a yellow yellow zone what you see over here. So I can define a zone like that whenever it falls beyond this blue zone over here we say that there is something going wrong in the process that means suddenly abrupt something has happened in the process like that. So that is a special cause and immediately the process will be stopped diagonalized like that and we will take some corrective action like that. So so so alarm will we will set an alarm like that. So it is like signaling system also we can think of. So whenever it is yellow we should be very precautious like that we should say take some corrective actions like that. But red zone what does it indicate maybe out of spec out of specifications basically ok. So in yellow zone over here we we we get concerned and we we try to eliminate why this is happening like that. And if it is red zone product maybe discarded all together like that it has gone out of specification what is defined by the design and like that. So there will be common cause variation there will be special cause variation which we want to block like that and if it goes beyond certain extent the product may be rejected like that rejected like that. So one is common cause variations which generally happens in a process for sample to sample variation we can think of one is special cause variation that are that are detectable. So in that case and that can be eliminated if I if I can eliminate recurrence of those time those kind of causes like that some amount of variability can be reduced over here. And the third one is systematic variation that means I intentionally induce variability in the process. So that is known as experimentation in the process. What we try to do over here is that basically there is a process over here and there will be what diagram what we have shown is y is coming out of the process there will be x variables over here. This is the CTQ that we are measuring over here. So what we try to do by experimentation is that we try to build a function between y and x over here and then try to determine what is the optimal condition of x that will give me the best y or y hitting the target value with minimum variation that s is over here and the average value is coming to look close to the target values over here. So what should be the condition of x? But first what we need is that what is the functional relationship? If I get a function then I can optimize that function like that. So systematic cause or intentional variation is induced to understand the behavior and understand the relationship between y and x and so that we can model that one and we can optimize that one. So that is known as design of experiment part. So we have a control part which is known as statistical process control. We have an experimentation part and control part together over here which there is a we are doing experimentation. We are setting the process. We are setting the standard operating practice and we are controlling that also. So that is the ultimate thing that in quality people tries to achieve like that ok. So and this systematic experimentation how it will help is that it will even reduce the common cause variability over here. So that you see a common cause variations can with the influence even even with the influence of common cause variability the outcome will be very precise and very accurate like that ok. So that is the overall idea. Now all this variability when I am talking about variability in the CTQs like that then I need to visualize the variations like that. I need to visualize the variation so that I can do something on that. So visualization is very important. So our overall objective is to reduce variation. I told that quality objective is to reduce variation assuming that it is on the target. So I want to reduce the variation. So variation reduction there are different ways of doing that. One of the I told that we we are talking about statistical process control which helps into eliminating the special cause or abnormal causes like that or assignable causes like that and design of experiment can also reduce the variations like that. Common cause variations can also go down when I am using design of experiments. And and we have one phase at the initial starting point of quality we have a acceptance sampling that means we are doing inspections we are trying to eliminate good pads and separate good pads good good good products with the bad products like that. So in this case what happens is that we try to segregate that one and we have certain plans acceptance sampling plan which is used which is also using statistical techniques. So over here and which gives you a a basis of selecting an item and not selecting an item from the vendor or suppliers like that ok. So this is only post modeling products have been produced by the vendor and it has come to your end and I want to reduce the variation over here. So I I tell them that you segregate this is not good and so in that case you give me good products like that I have a acceptable quality label. So you have to achieve that one then only I will accept your product. There can be small rejections like that but there is always a probability of rejection but we will if you reach this this quality label and then only we will we will do sampling inspection. Inspections can be 100 percent inspection also totally segregate good and bad like that but because of economic constraints sometimes what we do is that and also suppliers improves like that. So we go for sampling inspections like that. So in that case not all complete products will be taken some part of that will be taken and based on that I will make a decision whether to accept but I am taking a risk over there ok. So one is to reduce the variability in the input conditions what we can do is that we can implement inspection over here. So inspection is one of the quality aspects which generally the implements inequality program. So we start a quality initiative. So initially you may you may do inspections like that. Then you implement statistical process control to remove SNA will cause then design of experiments to do further improvements like that. So that way we are reducing variability like that ok. So but remember that inspection is a post-mortem activity nothing is done on the process so only thing is segregation is happening over here but other things are happening in the process statistical process control design of experiments all are happening in the process ok. So now what that is diagrammatically illustrated over here what you see is that variability of the process this is like a normal distribution you have heard of this in statistical codes like that which is having a mean of mu over here this population mean over here and with a standard deviation sigma like that. So this is just population information over here what you see diagrammatically and there will be specification limits over here upper and lower limits what is specified over here what will happen in inspection there will be rejection because I am not doing 100 percent over here. So there will be products which are bad like that so there will be. But some amount of variation can be reduced over here so overall variation will be high if I am doing only inspection over here sampling inspections like that. So I cannot do much on these variations over here but when I am using statistical process control like that applications of this type of techniques over here what I can do is that I can eliminate special cause variability like supplier to supplier there is huge variation over here I can remove a supplier which is a giving a high variability products like that so I can remove that one that is the assignable cause or special cause what we can eliminate out of the process ok. So that way we can identify which is creating more problems they uses a visualize to visualization tool in statistical process control and that will indicate which is normal which is abnormal scenarios and those abnormal scenarios we take action so that it does not recur. So that is known as that tool is known as statistical visually we can we can differentiate between normal scenario and abnormal scenarios like that that is known as statistical process control technique that we use over here. And the third one what we do is that we have a design of experiment that I want to reduce it further. So in that case what is required is systematic experimentation or statistical experimentation that is known as design of experiment DOE we can we can write over here as design of experiments over here that is the final phase of quality. So we we do design of experiments over here ok. So our objective is to understand so you see that the variation is represented like normal distribution but we have shown also histogram as the variation. I want to see where is the where is the mean where how much is the standard deviation like that. So visualization and also try to figure out the what is the value of mean what is the value of standard deviation like that. So for that visualization of the data is important so what we will do is that we will try to use visual tools try to understand how to visualize using a specific software which is over here Minitab but there are other softwares where we can visualize like that R interface can be used like that and you can use SAS or any other interface but here we will talk about how do you use Minitab in quality control and improvements like that ok. So first we will try to do basic things visualization of the data that means we will try to draw a histogram in Minitab that will give you some sense and then we will go ahead. So for this session we will we will discuss about how to implement how to visualize using Minitab some data set which is which we want to which can be a CTQs like that so ok. So histogram what we have what we have told is that it will have frequencies on one axis over here and it will have CTQs defined on this axis x axis will be CTQs and y axis will be frequency observations over here. So there will be this will be bins like that and in this case class number of class will be there 1, 2, 3, 4 like this n number of classes will be there and interval will be there in a class there will be intervals like that and there were highest frequency will be plotted over here. So this will be like and if you join the midpoints over here you can you can see some some belt shape kind of curve that you can see over here which may be in normal distributions like that. So if you join the midpoints of the histogram each of the bins like these midpoints you can you can you can just join them and you can see what is the shape of the or shape of the data set basically of the data set like that ok. So in this case frequency on one axis and one axis is CTQs like that. So let us try to plot this one in Minitab. So I will just introduce the Minitab software to you and then in next session we may go ahead with using that ok. So when this Minitab software can be downloaded from websites like that so I am showing you the websites maybe from Minitab used you can start a 30 days free trial like that and try to download the Minitab software and 19 version is available I think. So this Minitab 19 version there can be earlier versions also somebody may have installed earlier versions like that and maybe 17, 15 like that. So it is they continuously update the recent one like that 17, 18, 19. So I will use the 19 one more or less that is the latest one what I can understand at present. So that that we are for academic purpose we are using this Minitab 19 for illustration over here ok. So whenever you install Minitab from that website you download that one and you install that one what will happen you get a icon over here in the desktop like that. So if you double click that icon what will happen is that interface will open and in that interface we will be working using that interface to visualize the data over here ok. So there are three areas over here what you can see is that this is one of the area where the data set can be can be you can write down the data sets over here or name the data set as X over here and you can write the numbers over here. So see this row one here from here the data will start basically it is the column headings that you can provide over here X and Y like that we can provide headings over here you can write the numbers over here whatever number you think out and you can also paste it from excel sheets like that. So if we take it from excel let us say some Minitab files and you can open some excel files maybe a quality course marks we want to paste that one in this. So what we will do is that we can we can just this is in excel sheets what we are I can copy this column over here control C and then what I can do is that I can I can paste the data sets over here and control V over here always remember that the first first row over here is the title of the column like that. So you cannot paste number over here. So number starts from row number 1 like this 1 2 whenever 1 here from you can write the numbers like that you cannot paste numbers over here and Minitab cannot analyze that one. So in this case so these are the here you can place the data like this. So in this case I have placed in C 3 columns like that and then I can save this file also that means I can save this this is known as worksheet in Minitab this worksheet can be saved. So if you go to file and then you go to save worksheet as and let us say I am I am saving it in desktop and I am naming it some test files like that. So whenever you do that you save that one so this will be saved as test MVX what you see on the on the below over here and this files can be called time and again to do the analysis like that. So and if you close this one let us say I am closing this one and they it will ask projects can also be saved. So we will talk about projects but I am not interested in projects at this time point because I want the data set only to analyze because analysis can be done multiple times like that. So if I get the data that is sufficient for me to analyze like that. So I am saying no to the project savings like that. So I go out of this and then what I can do is that later on I want to see the data set and again analyze this one. So I open so this is saved in desktop and with a file name test over here and I have opened that file by double clicking that file over here. You can see that the marks are stored over here. So if you change the marks over here let us say 66 and then I want to save this one what you can do is that go to file save worksheet as and then just replace this file over here test and you replace the file it will ask whether you want to replace that one. You replace that one and immediately what you see is that it is replaced it has become 66 now and now you can analyze analyze the data like that. So if you have to do the analysis on the top you will find options over here statistics and there are various options that you can see over here like graphs you have many options one of the options is histogram over here. So whenever you click histogram then we can draw histogram of this data set like that and whenever you click histogram over here and then analyze and then click ok like that and what will happen is that that we will take in the next session what will happen this session window here you will get the data sets like that. So I am just showing you just for illustration over here more details we will do it afterwards. So I am clicking histogram over here from the top down menus over here I want the graph histogram of this data set of quality marks. So I will go to histogram and I will say simple histogram draw the histogram of quality codes like that. So then it will ask which variables over here. So I will double click this variable my cursor should be over here in graph variables. So it will blink in this graph variables then what I will do I will hide double click this one C3 and I do not I am keeping all as default in mini tabs like that later on we will see what are the options that we have then I click ok over here immediately this in the session window that you see this is the session window what you see. So this is the session window of this projects over here. So this is the distribution of marks or histogram mini tab has drawn automatically. So if you double click this one in the graph so immediately it will enlarge this one and you can enlarge this one you can copy the graphs also. So you can you can edit the graph also. So if you want to edit just click double click this one and if you want to change this histogram of marks you can do that and click ok. So many possibilities I can change frequency if you want to see in one column what is the data values within that bins like that. So the bin is starting from if you if you click this one the bin is starting from over here 62 this is coming out to be this is coming out to be this bin will come out to be. So in this case let us let us enlarge this one so that we can. So this bin is giving you 67.5 to 72.5 like that. Mini tab does it automatically histogram there are rules to define class and class intervals like that number of class and class interval based on the data set. So those calculations can be seen in books. So in this case what I am interested you know where is the central tendency of the data around 70 we can see the central tendency of mean of the data set. I need to understand the varying variants of these data so that we will talk about how to see that one. So only thing is that what I am saying is that you can draw the the diagrams will be plotted in the session window then you can copy this graph like copy if I want to copy this one and paste it in some other interface. So if you want to I have copied this one I want to paste it in excel like that. So I will right click this one and I will paste this one so automatically mini tab this diagram has come in the excel like that ok. So in reports any reports you want to place what file or any other files you can just paste it pen shop anywhere you can take this one and you can just paste this diagram like that ok. So that is all what we want to discuss in this session for this session 4. So we will continue with visualization of the data so we are talking about accuracy and precision for that we are using histogram one thing we should remember that this is for continuous data that we are doing over here. So in this case what we are doing is that we are assuming so in this case what we are doing is that we are assuming this data set what we have CTQs that we have written over here. So this CTQ is basically is a continuous variable. So this is continuous so that means within the scale it has infinite possibility number has infinite possibility only the least count of the instrument that is measuring this strength and that data I am I am just monitoring like that. So in this case maybe second place of decimal or one place of decimal like that so it depends on risk count but there are infinite possibilities of measurement within a range of let us say 150 to 170 infinite possibilities of numbers can be measured. So this is a continuous data and that is why I am drawing a histogram. Histogram is for continuous data whenever I have a continuous data I can use histogram to see the mean and variation of the data. How is the spread of the data what is the shape of the data like that where is the central tendency like that all these things can be seen visualized like that numbers can be calculated numbers can be seen by some other options like that and spread also can be seen by some other options like box plot what we will discuss in the next session like that. So we are discussing our visualization of the data. So we will continue because this data visualization is very important in quality if I can visualize then I can I can take some corrective actions based on the data and then I can interpret something like that. So this is known as we can say descriptive statistics of visualization of the data and based on that we we make some initial conclusion about the data or make some initial assessment of the data basically ok. So we will continue from here in session 5. Thank you for listening so we will continue with data visualization in quality. Thank you.