California Population Data - VitalWeb Wizard - Online Help




Vitalnet Logo

Table of Contents

  1. Introduction

    Wizard Starts in Step-by-Step Mode
    Wizard also Runs in Jump-to-Page Mode
  2. Table Settings

    Primary Statistic
    Table Axes (Rows and Columns)
    Statistic / Table Axis Conflicts
  3. Data Variables

    Categorical Variables
    Range Variables
    Statistic / Variable Conflicts
    Other Settings
  4. Graphic Settings

    Pie Chart Settings
    Line Chart Settings
    Bar Chart Settings
    Map Settings
    Map Color Palettes
  5. Producing and Using Results

    Getting Results
    Viewing Results
    Printing Results
    Saving Results
  6. Other Information

    Glossary
    County Groupings
    95% Poisson Confidence Limits
    Statistical Methods
    Confidence Intervals
    Data Sources and Limitations
    Links to Related Resources
    Whom to Contact
    Legal Information



Wizard Starts in 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").



Wizard also Runs in 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.



Primary Statistic

Primary Statistic - The basic numerical result in the output.

Primary statistics include: Population · Median Age · Percent in Age Group

Selecting - Click on desired setting, such as Population.




Example Statistic Selector



Table Axes (Rows and Columns)

Rows - Are horizontal lines of data, such as the row for 1991.
Row Sort - Rows can be sorted, low to high, or high to low.
Columns - Go up and down, such as the column for "White" race.
Multi-Tables - Also called "By Variable". Make a series of tables.

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




Example Row, Column, or Multi-Table Selector



Statistic / Table Axis Conflicts

If a conflict between primary statistic and axis variable:

Examples of conflicting settings:



Selecting Data Variables

Data variables include - age, race, sex, year, county.

Selecting - Click on one or more values.


Example Data Variable Selector (for Age)



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:





Example Data Grouping Selection



Statistic / Variable Conflicts

Sometimes, a conflict exists between a variable and a population-based rate. Vitalnet automatically prevents this from producing misleading output.

This is best shown with an example: Suppose there are 408,000 births, and the population is 12,000,000 females. The birth rate is 34 births per 1,000 females (408,000 / 12,000,000). Now, suppose we limit the analysis to women with 12 years education, with 108,000 births to such women. The result would seem to be 9 births per 1,000 such women (108,000/ 12,000,000). But of course this is totally wrong. The problem is caused because the denominator is not adjusted.

To resolve this problem, when Vitalnet makes a rate calculation, it automatically adds all categories to demographic variables that are not included in the population data set.



Other Settings

Other Settings include the following options:



Pie Chart Settings


Pie Chart

Using pie charts:

Ways to customize Vitalnet pie charts:

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



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:



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:



Map Settings


VitalWeb Map


Maps display results geographically.

Ways to customize Vitalnet maps:

Time trend maps require:



Map Color Palettes

                                                        Brown-BlueGreen  
                                                        Pink-Green  
                                                        Purple-Green  
                                                        Purple-Orange  
                                                        Red-Blue  
                                                        Red-Grey  
                                                        Red-Yellow-Blue  
                                                        Red-Yellow-Green  
                                                        Spectral  
                                                        Blue  
                                                        Blue-Green  
                                                        Blue-Purple  
                                                        Green-Blue  
                                                        Green  
                                                        Grey  
                                                        Orange  
                                                        Orange-Red  
                                                        Purple-Blue  
                                                        Purple-Blue-Green  
                                                        Purple-Red  
                                                        Purple  
                                                        Red-Purple  
                                                        Red  
                                                        Yellow-Green  
                                                        Yellow-Green-Blue  
                                                        Yellow-Orange-Brown  
                                                        Yellow-Orange-Red  

References and research used to help design Vitalnet palettes:



Getting Results

Go Sign To produce results:



Viewing Results

Binoculars To view results:

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



Printing Results

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

If too wide or long:

Spreadsheet or word processor printing:



Saving Results

File Cabinet 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:



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 1 -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.



County Groupings



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.



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.



95% Poisson Confidence Limits

Events Lo Factor Hi Factor Events Lo Factor Hi Factor Events Lo Factor Hi Factor
1 0.025318 5.571647 70 0.779549 1.263440 4,000 0.969250 1.031230
2 0.121104 3.612346 80 0.792938 1.244587 5,000 0.972473 1.027911
3 0.206224 2.922426 90 0.804118 1.229170 6,000 0.974857 1.025464
4 0.272466 2.560398 100 0.813640 1.216268 7,000 0.976711 1.023564
5 0.324697 2.333667 200 0.866209 1.143395 8,000 0.978207 1.022034
6 0.366982 2.176580 300 0.890041 1.116362 9,000 0.979446 1.020767
7 0.402052 2.060382 400 0.904401 1.100401 10,000 0.980496 1.019696
8 0.431729 1.970399 500 0.914267 1.089575 20,000 0.986189 1.013907
9 0.457263 1.898312 600 0.921584 1.081617 30,000 0.988716 1.011348
10 0.479539 1.839036 700 0.927291 1.075453 40,000 0.990224 1.009824
20 0.610826 1.544419 800 0.931904 1.070497 50,000 0.991254 1.008785
30 0.674696 1.427562 900 0.935734 1.066400 60,000 0.992014 1.008018
40 0.714415 1.361716 1,000 0.938980 1.062941 70,000 0.992606 1.007422
50 0.742219 1.318376 2,000 0.956653 1.044307 80,000 0.993082 1.006942
60 0.763105 1.287198 3,000 0.964536 1.036105 90,000 0.993477 1.006544



Data Sources and Limitations

VitalWeb Wizard uses data from authoritative sources.

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



Links to Related Resources

Internet resources related to Population Data:



Whom to Contact

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



Legal Information

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

Vitalnet uses GD and Ploticus, under the terms of the copyright owners.


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