DESCRIPTIVE STATISTICS USING PIVOT TABLES PART-1 | WPS SPREADSHEET
HTML-код
- Опубликовано: 7 фев 2025
- This video is about performing descriptive statistics with the help of Pivot Tables using WPS Spreadsheet. This function also applies to google sheets and Microsoft excel as well.
#pivottable #spreadsheet #wps
Nice video. FYI, I just found a faster/easier way to do this in WPS for very basic descriptive stats: Whenever you highlight cells, it automatically gives you descriptive stats at the bottom of the spreadsheet window--by default it only shows sum, count, and average, but if you right-click that area of the window, it shows you the other options, which include min and max.
You are welcome thanks for the nice comment and info about that functionality to get basic descriptive statistics.
In excel i usualy write sum(Table1[Total]) to sum column total in Table1 but in wps it doesn't work??
Hi i am unable to activate ad ins in my wps xls . Can u help. I dont see option of adding ad ins
thank you so muchhh. its really helpful :)
You are welcome thanks for the feedback
Hi, do you think WPS "Excel" is underappreciated in terms of functionality?
Well I would say it's not really popular among other office packages. Functionality wise is equally good compared to other spreadsheets software's. Thanks
hi how to add the values of median, mode, skewness and range?
Thank you for this nice question. For info currently i am preparing a youtube video on descriptive statistics series involving the median, mode, skewness and other topics. So stay tuned for these videos, don't forget to press the bell icon so that you can get the notification of new videos.
Descriptive Statistics Part-2 Pivot Table Alternative to Caculate Median ...
See the link below 👇
ruclips.net/video/EgswYLmKVew/видео.html
do wps office have data analysis toolkit add on?
Well not really but it offers All the data analysis options and Features required for the data analytics, thanks.
@@Simulation-Engineer where can i find that? Do you have a video about it
@@prekrasnyy8728 well you can get all the functions via formula bar in wps spreadsheet, thanks.
@@Simulation-Engineer I remember doing t test and anova in wps. It includes the t stat, p value and all. Do you know how to do that cause I forgot how I did it.
@@prekrasnyy8728 well have a look athe wps spreadsheet documentation for details.