A dialog box will appear. Mean Sum of All Data Points Number of Data Points There is another way of calculating mean which is not very commonly used. After the data have been entered place the cursor where you wish to have the mean average appear and click the mouse button.
2 Calculate mean by formula.
If you want the Median select MEDIAN. Formula to Calculate Mean of Data using SUM and COUNTA SUMB2B6COUNTAA2A6. The following formula is used to calculate the mean piston speed. F i frequency of ith class.