California Population Data
VitalWeb Wizard
Online Help



Table of Contents
  1. Introduction

    1. Wizard starts in step-by-step mode
    2. Wizard also runs in jump-to-page mode

  2. Table settings

    1. Primary statistic, such as population
    2. Table axes (rows and columns)
    3. Statistic / axis conflicts

  3. Data variables

    1. Categorical variables, such as race
    2. Range variables, such as age
    3. Other settings, such as confidence intervals

  4. Graphic settings

    1. Pie chart settings
    2. Line chart settings
    3. Bar chart settings
    4. Map settings
    5. Map color palettes

  5. Producing and using results

    1. Getting results
    2. Viewing results
    3. Printing results
    4. Saving results

  6. Other Information

    1. Glossary
    2. County groupings
    3. Statistical Methods
    4. Confidence Intervals
    5. Data sources and limitations
    6. Links to related resources
    7. Department of Health Services contacts
    8. Legal information




Step-by-Step Mode


Screenshot of Basic Wizard

Instructions for using Step-by-Step Mode:

  1. Make selections - At each step, make selections.
  2. Go to next step - Click "Next Step" for next step.
  3. Make output - At last step, produce output table (or map).
  4. Return to wizard - Click browser "Back Button" to return from output.
  5. Revise selections - Click "Restart" to start again at first step.

To go back one step, click "Previous Step" button (not browser "Back Button").

· Table of Contents · Glossary ·



Jump-to-Page Mode


Screenshot of Advanced Wizard

Instructions for using Jump-to-Page Mode:

  1. Jump to page - Click on page names from top or selections at right side of interface.
  2. Make selections - Make selections on pages. Each page is different.
  3. Make output - When satisfied with selections, click "Make Table" or "Make Map".
  4. Revise selections - After viewing output, click browser "Back Button" to return to program.
  5. Maybe switch - You may switch back to Step-by-Step mode at any time.

· Table of Contents · Glossary ·



Primary Statistic

Population
Median Population Age
Percent Total Population In Age Group

Sample Statistic Selector

· Table of Contents · Glossary ·



Rows, Row Sort, Columns, Multi-Tables

Selecting - Click on desired setting, such as "Age" or "Race".

Age
Geographic Area
Race
Sex
Year

Sample Row, Column, or Multi-Table Selector

· Table of Contents · Glossary ·



Statistic, Row, Column, and Multi-Table Conflicts

If a conflict between primary statistic and axis variable:

Examples of conflicting settings:

· Table of Contents · Glossary ·



Selecting Data Variables


Sample Data Variable Selector (for Age)

· Table of Contents · Glossary ·



Selecting Data Variable Groupings

Certain data variables allow different "groupings".
For example, 5-year or 10-year age groups.

To change the grouping in actual interface:

5-Year Age Groups
10-Year Age Groups, Lowest 0-9
10-Year Age Groups, Lowest 0-4
20-Year Age Groups
Age-Adjustment Age Groups
All Age Groups

Sample Data Grouping Selection

· Table of Contents · Glossary ·



Other Settings


Other Settings include the following options:

· Table of Contents · Glossary ·



Pie Chart Settings


Pie Chart


Pie charts show the parts of a whole.

Ways to customize Vitalnet pie charts:

Note: Pie charts are made ONLY if following conditions met:

· Table of Contents · Glossary ·



Bar Chart Settings


Bar chart


Bar charts compare amounts of different things.

Ways to customize Vitalnet bar charts:

Note: Black and white chart uses hatch and gray-scale patterns.

Note: Bar charts are made ONLY if following conditions met:

· Table of Contents · Glossary ·



Line Chart Settings


Line Chart


Line charts show movement or change.

Ways to customize Vitalnet line charts:

Note: Black and white lines are rendered as dot and dash patterns.

Note: Line charts are made ONLY if following conditions met:

· Table of Contents · Glossary ·



Map Settings


VitalWeb Map


Maps display results geographically.

Ways to customize Vitalnet maps:

Time trend maps require:

· Table of Contents · Glossary ·



Map Color Palettes


Color mix palettes:

                                          Summer Colors  
                                          Earth Tones  


Gray scale palettes:

                                          Gray Scale #1  
                                          Gray Scale #2  


One-color scales:

                                          Purple Scale  
                                          Brown Scale  


Two-color scales:

                                          Red-Yellow Scale  
                                          Red-Blue Scale  
                                          Brown-Blue Scale  
                                          Brown-Green Scale  


Recommendations for selecting color palette:

References and research used to help design Vitalnet palettes:

· Table of Contents · Glossary ·



Getting Results

· Table of Contents · Glossary ·



Viewing Results

If graphics do not display in the output, try refreshing the browser.

· Table of Contents · Glossary ·



Printing Results

To print results from your browser, do one of the following:

If too wide or long:

Spreadsheet or word processor printing:

· Table of Contents · Glossary ·



Saving Results

To save results displayed in a browser, do one of the following:

To save alternate data format, click on footnote links:

To save a map as an image file, minus surrounding text:

Suggestions on naming files:

· Table of Contents · Glossary ·



Glossary

Area set - One or more areas combined.

ASCII file - A text file, with only alphabetical, numerical, and punctuation characters, like you would see in normal text. Vitalnet can produce output in ASCII format.

Bar graphs - A section of a Vitalnet table. Gives a useful graphical representation of the data. May be omitted from the output table.

CDC - Centers for Disease Control and Prevention. US federal health agency.

Cell - A space for a single numerical result in a table, at a row-column intersection.

Cell suppression - An asterisk "*" is placed in cells with fewer deaths than a limit set by the user. Row / column totals with exactly one suppressed cell in the row / column are also suppressed. If more than one cell in the row / column is suppressed, the row / column total is displayed.

Columns - Vertical groupings of data in a Vitalnet table, such as a column for each race group.

CSV format - Also called comma-separated-value format. A type of computer output that is readily imported into other software, especially spreadsheet software. Each output item is separated by a comma from surrounding items, and each output text item is surrounded by "double quotes". Vitalnet produces CSV output. A comma-separated-value file has "csv" extension.

Data mining - Finding unexpected relationships in a data set. Similar to exploratory data analysis. Vitalnet is excellent at data mining. Of course, keep in mind that the more you look, the more unusual events you will find, just by chance.

Data warehouse - Software system, such as Vitalnet, making large complex databases readily available for querying and analysis.

dBASE III format - A widely used file format derived from the database software of the same name. Files in this format may be readily imported into almost any data analysis, graphing, mapping, or other presentation software. Has dbf extension. Suppressed cells are represented as the number "-1". Vitalnet produces dBASE III output.

Denominator - The number on the bottom of a fraction. Population data are often referred to as "denominator data", as they are used as denominators to calculate population-based rates.

Export - Produce output that can be read into other computer programs. Vitalnet produces ASCII text, comma-separated-value (csv extension), HTML (htm extension), and dBASE III (dbf extension) files for export.

Filter variable - A variable solely used to filter which records are included in the output. For example, for a single table with race rows and sex columns, age is a filter variable.

Footer - Last part of a Vitalnet table. Lists other details of the analysis, such as the date and time produced, and the data sources. Each table is assigned a unique ID, listed in the footer, to assist you in keeping track of and organizing analyses.

Header - First part of a Vitalnet table. Lists basic parameters you selected to define the table, such as years analyzed.

HSA - Health Service Area. Groupings of California counties. There are 14 HSA's.

Import - Read information into a computer program. ASCII text, CSV files, HTML, and dBASE III files from Vitalnet are easily imported into word processing, spreadsheet, data analysis, mapping, graphing, and other presentation software programs.

Least-squares - A standard method for fitting the best straight line to a set of points. Produces a Y-intercept and a slope defining the least-squares line.

Median population age - A measure of the overall age of a population. Half the population is younger than the median, half is older. Assuming a population of 100,000 people, 50,000 people would be older than the median age, 50,000 younger.

Multiple age groups - One age group for each row or column of a table. Example: Birth-19, 20-39, 40-59, 60-99+.

NCHS - National Center for Health Statistics. US health statistics agency. Part of the CDC.

Percent total population in age group - A population statistic. Useful for assessing the relative age of the population. If the total population is 100,000, and 8,000 are under age 10, the percent of the total population under 10 is 8 percent.

Population - The number of people living in an area.

Primary Statistic - The basic type of numerical result displayed in a table, chart, or map. For example, population.

Rows - Horizontal lines in a Vitalnet table, such as a row for each race group.

Row sort settings - Vitalnet rows may be sorted in ascending or descending order.

Set - A combination of one or more things. For example, several areas may be combined into an area set.

Single age group - Only one age group (30-49, for example) is selected. A single age group is used for tables that do not have age columns or age rows.

Statistic - See "Primary Statistic".

Table - A set of results produced by Vitalnet. A table has several parts:

  1. Header - lists basic analysis settings
  2. Data section - numerical results
  3. Horizontal bar graphs - graphical representation of the data
  4. Footer - lists other analysis settings

UNIX - A widely used computer operating system. Vitalnet can run on UNIX, either remotely, locally, or by client-server.

Windows - A widely used set of PC operating systems, including Windows 3.1, 95, 98, NT, 2000, and XP. Vitalnet will run under any version of Windows.

World Wide Web (WWW) - A widely used part of the internet that may be easily accessed with a web browser. Vitalnet runs on the WWW.

· Table of Contents · Glossary ·



County groupings

· Table of Contents · Glossary ·



Statistical Methods

The "Primary Statistic" (numerical outcome) is the basic type of number in a Vitalnet table. It is best understood by looking at the examples below.

Population - The number of people living in an area.

Median Population Age - The age at which half of the population is older, and half younger. For example, a median age of 42.3 indicates that 50% are younger than 42.3 years, 50% older. Median population age is a good indicator of the overall youth or age of the population.

Percent Total Population in Age Group - For example, the age group birth-4 is selected, and 7.2% of the population is less than five years old. This statistic may be used to assess trends in population age distribution.

· Table of Contents · Glossary ·



Confidence Intervals

Definition - A "confidence interval" is a range of values within which the true value of a variable is thought to lie, with a certain degree of confidence (80%, 90%, 95%, etc). A "confidence level" is the degree of confidence, such as 95%.

Selection - A larger percentage (such as 99%) is more stringent than a smaller percentage (such as 80%). Use 95% if you are unsure.

Interpretation - The smaller the interval, the more reliable the result. Two results that overlap at the 95% level are less likely to be significantly different than results which don't overlap.

Methods - The method Vitalnet uses to calculate confidence intervals depends on the context. The method is listed in the footnotes to the table.

Z * Rate / Sqrt (Events) - This method is recommended by the NCHS. Technical Appendix of the Vital Statistics of the United States, Vol II, Mortality, Part A

Poisson distribution - This method is valid if events are relatively rare, which usually applies to health events. Scientific Tables, Diem and Lentner (ed), Giegy, 1970, page 189.

· Table of Contents · Glossary ·



Data Sources and Limitations


VitalWeb Wizard uses data from authoritative sources.

Population data - All California population data were provided by the Department of Finance.

· Table of Contents · Glossary ·



Links to Related Resources

· Table of Contents · Glossary ·



Department of Health Services Contacts


For additional assistance with analyzing and interpreting the data, contact:

· Table of Contents · Glossary ·



Legal Information

Trademarks - "Discover the future of health data", "We care about your health data", Birtha, Epidemic, Epigram, Medtrend, Multicod, Oncogram, Poptrend, Pregdata, Vitalnet, VitalPro, VitalPro for Unix/Windows, VitalPro for Windows, VitalWeb, VitalWeb Standard, and VitalWeb Wizard are trademarks of Expert Health Data Programming, Inc. (EHDP). Vitalnet® and VitalWeb® are registered trademarks.

Other copyright owners - Vitalnet uses the GD graphics library, and the Ploticus data display engine, under the terms of the copyright owners. GD and Ploticus source code are freely available.

· Table of Contents · Glossary ·


Copyright 1999-2007 - Expert Health Data Programming, Inc; - All rights reserved.   Contact EHDP