How Do You Use Excel For Data Analysis?
Introduction – Excel, which is merely used for saving data and preparing graphs and charts, has much more utility than an average person would know. It is a powerful tool for evaluating statistics and analyzing the statistical data. If you haven’t yet discovered the power of excel, it is time to explore this unknown world. Its features will amaze you. Excel is a computer program that has spreadsheets for calculations and data analysis. The uses of excel are many and only if you enter this world of spreadsheets will you realize its value. There are several ways in which excel supports collation of data. It further helps in analyzing the collated data. Once you have the numbers handy, you can run macros to perform various activities with the click of a mouse. Here, we intend to throw light on the graphical use of excel for data analysis. • Convert the regular charts into Shewhart control charts. Yes you can convert the simple excel charts into a Shewhart control chart in a flash. The dat
