When you are finding median manually, you need to sort the data in an ascending order but in Excel, you can simply use the Median function and select the range and you will find your median. Median is a function which is used to find the middle number in a given range of numbers. In the example below we want to know the average of the marks obtained by the students so we use =AVERAGE(B2:B12). Simply use the Average function and select the range which needs to be averaged. Calculating the Average in Excel is much simpler than it was in the school. One of the most used statistical functions in Excel is Average. So today, we bring to you the most used statistical functions of Excel. But when you are working on statistics in Excel, things are simpler and less complicated. When you get your formulas right you are in love with it and when your answers go wrong, your feelings take the opposite route. People usually have love-hate relationship with statistics.
0 kommentar(er)
