This article discusses basic data analysis in excel.
In order to improve your Quality Assurance you must be able to measure and then interpret that data. Data analysis in excel can help you interpret that data.
This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.
In the discussions below, we use Office 365 version. Earlier versions can also be used.
Calculating Mean or Average of the Data Set
Click the cell where you want the average to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click Average
Highlight all the numbers that need to be averaged
Click Ok
Calculating Mode of the Data Set
Click the cell where you want the mode to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click mode.sngl
Highlight all the numbers that need to find the mode
Click Ok
This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.
Highlight all the numbers that need to find the median
Click Ok
Calculating the Standard Deviation of the Data Set
Click the cell where you want the standard deviation to go.
Type = in the desired cell
Click the formulas tab
Click More Functions
Click Statistical
Click STDev.S (sample population)
Highlight all the numbers that are needed for standard deviation
Click Ok
This Data Analysis Video teaches you the basic tools for understanding, summarizing, and making future predictions with your collected data. Includes MS Excel templates.
Download Today. Don’t take chances without understanding your data. Data drives business decisions. But how does this work? This introduction to Data Analysis Video shows you how to gather, summarize, and present data to management and your team. $59.00. Satisfaction guaranteed.