Descriptive Statistics Lab Outline by 1t94zsh0

VIEWS: 7 PAGES: 1

									Descriptive Statistics Lab
PART 1: TABLE OPERATIONS
Format a Block of Text as a Table
Sorting the Rows
Counting Frequencies in Sorted Data
                                                                                    Increasing
Turn the Drop-Down Arrows On and Off                                             Sophistication
Computing Statistics with a Total Row
Statistics at the Bottom of the Document Window
Sorting on Two Columns
Counting Data for a Cross-Tab

PART 2: FILTERING
Perspective
        Sorting sorts the rows and leaves all rows visible.
        Filtering only shows some rows, for easier visualization.
The Down Arrow Options
Clearing Filters
Text Filter Options
Number Filter Options (For Numerical Columns)

PART 3: CONDITIONAL FORMATTING
Perspective
        Sorting sorts rows, showing all rows.
        Filtering shows only selected rows.
        Conditional formatting only changes the format of cells, for easier visualization.
Beginning Conditional Formatting
Data Bars
“Top 10” Conditional Formatting

PART 4: PIVOTTABLES
Perspective
        Doing sorting and then counts is time-consuming and error-prone.
        PivotTables automate many aspects of creating frequency distributions and cross tabs.
Creating Frequency Distributions with PivotTables
Change Sum to Average
Cross Tabs with Pivot Tables

								
To top