WPS Academy
Free Download
Top Searches
    Login/Sign up
    Login/Sign up
    Top Searches

        1414 results for construct a boxplot for a data set

        • All Tutorials
        • Video Tutorials
        • Quick Tutorials
        • All
        • Spreadsheet
        • Presentation
        • Writer
        • PDF

        1414 results for construct a boxplot for a data set

        Set transparent color for pictures in a slide

        1. Open the document in WPS Presentation. 2. Left-click the target picture. Then we can see the Picture Tools tab in the upper menu. 3. Click Set Transparent Color, and use the pen tool to click on the picture to select the transparent color to be set.You will be the amazing reporter with WPS Presentation, which could be an alternative to Microsoft PowerPoint.

        ppt Presentation 11.2K views

        How to set a trigger for animation in slides show

        When using WPS Presentation to, we can set an inserted object as a trigger of animation. The effect is showed below. In this example, when we click the picture set as the trigger, the animation of the text box will present. How can we realize it? Follow these few steps. 1. Right-click an added animation option in the Custom Animation window. 2. Choose Timing3. Click the Triggers button → Start Effects on Clock of … → choose an object to be set as the animation trigger → OKYou will be ....

        ppt Presentation 13.0K views
        How to create a scatter chart in WPS Spreadsheet

        How to create a scatter chart in WPS Spreadsheet

        02:53

        How to create a scatter chart in WPS Spreadsheet

        A scatter chart in WPS Spreadsheet is normally called an X-Y graph. It presents all the data as points on rectangular coordinates, showing the relationships between variables. The scatter plot is a great graphical tool that we often use for statistical modelling. Take this table as an example. This is a set of height and weight data of boys and girls. If we want to observe the relationship between the two variables: height and weight, with the help of a scatter chart, how can we do tha....

        Spreadsheet 10.2K views
        Most-used Statistical Functions

        Most-used Statistical Functions

        11:28

        Most-used Statistical Functions

        1. The SUMIF function can be used for single condition summation; according to the use of different ways, the SUMPRODUCT function can be the product of data, but also the product of the sum.2. introduced the use of the AVERAGE function, you can set a single condition to find the average, you can also set multiple conditions to find the average.3. to help you find the difference between "COUNTA", "COUNTBLANK", "COUNTIF" and "COUNTIFS

        Spreadsheet 7.8K views
        Quickly filter classified data

        Quickly filter classified data

        01:41

        Quickly filter classified data

        How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....

        Spreadsheet 36.5K views
        How to add text superscript and subscript

        How to add text superscript and subscript

        01:11

        How to add text superscript and subscript

        When editing chemistry and mathematics data, we often use superscript or subscript to represent special symbols. Take this document as an example, m2 represents the square in the unit area. How can we set the number 2 as a superscript? Select the number 2. In the Home tab, click the Superscript button. Or we can use the shortcut key Ctrl+Shift+= to set the number as a superscript.Numbers in some chemical symbols need to be set as subscripts, such as O2, N2. Select the number 2 in O2. I....

        Writer 29.1K views
        How to set the header row across pages

        How to set the header row across pages

        00:50

        How to set the header row across pages

        When using WPS Writer to create a table, except for the first page, the table on other pages does not display the header row, so we don't know what the data represents in each column. Take this document as an example. Only the first page has the header row. For beginners, they will choose to add a header row above each table manually. It's too much trouble. Today I will teach you a method to quickly set the header row across pages. At this point, we can select the header row, c....

        Writer 9.2K views
        Format cells

        Format cells

        04:42

        Format cells

        Cell formatting is very important in data processing. We often need to set a proper cell format when entering data in WPS Spreadsheet. Let's talk about the differences between each format. Take this table as an example. Most of the cells in column B of the table are in general format. General format cells have no specific number format, which are simply displayed as numbers. In this table, most of the Column B cells are in general format. The format of cell C2 is a numeric format.....

        Spreadsheet 19.6K views
        Prev 1 2 3 ... 176 177 Next
        WPS Academy
        Products
        WPS Office for Windows
        WPS Office for Mac
        WPS Office for Android
        WPS Office for iOS
        WPS Office for Linux
        Partners
        Links
        OEM Partners
        Strategic partners

        Follow us

        WPS Office Official Twitter

        WPS Office Official Facebook

        WPS Office Official YouTube