charts, graphs and tables
Instructions
- Review the portion of the Week 1 PPTs addressing graphs and charts.
- Review the Workshop 1 videos
- Review the YouTube videos about graphs and charts as needed according to your level of experience with using Microsoft Excel®.
- Complete the assigned textbook reading and review the textbook PPTs. Some PPTs have links inserted to provide more information or explanations from other sources for you to use as needed. Some PPTs are used in several workshops and not all of the chapter PPT content may apply for each workshop. Therefore, be sure and follow any hyperlinks to the additional material, but only as pertinent to the workshop content.
Refer to the following table of the rate of congenital anomalies in the United States from 1985 through 2008 for the six questions shown on page two.
|
White |
White |
Black |
Black |
Other (American Indian/AK Native, Asian/Pacific Islander) |
Other (American Indian/AK Native, Asian/Pacific Islander) |
|
|
Male |
Female |
Male |
Female |
Male |
Female |
|
|
1985-2008 |
4.4 |
3.9 |
5.1 |
4.4 |
2.9 |
2.7 |
|
1985 |
5.4 |
4.5 |
5.9 |
5.5 |
4 |
3.6 |
|
1986 |
5.2 |
4.5 |
6.2 |
5.3 |
4.2 |
4.1 |
|
1987 |
5.1 |
4.3 |
6 |
5.3 |
2.9 |
3.9 |
|
1988 |
5.2 |
4.5 |
5.8 |
5 |
3.9 |
3.7 |
|
1989 |
5.1 |
4.5 |
6.1 |
5.2 |
4 |
3.6 |
|
1990 |
5.2 |
4.3 |
6 |
4.9 |
3.6 |
3.5 |
|
1991 |
5 |
4.1 |
6.2 |
4.9 |
3.5 |
3.1 |
|
1992 |
4.9 |
4.1 |
5.8 |
5 |
3.5 |
3.5 |
|
1993 |
5 |
4.2 |
5.9 |
4.9 |
3.2 |
3.3 |
|
1994 |
4.7 |
4.2 |
5.3 |
4.7 |
3.2 |
3.4 |
|
1995 |
4.8 |
4.1 |
5.3 |
4.5 |
3.1 |
3 |
|
1996 |
4.8 |
4 |
5.4 |
4.9 |
3.2 |
2.7 |
|
1997 |
4.9 |
4 |
5.1 |
4.5 |
3.3 |
2.7 |
|
1998 |
4.7 |
4.1 |
5.4 |
4.5 |
2.9 |
2.8 |
|
1999 |
3.9 |
3.5 |
4.7 |
4.1 |
2.5 |
2.7 |
|
2000 |
3.9 |
3.5 |
4.7 |
4.1 |
2.7 |
2.5 |
|
2001 |
3.8 |
3.4 |
4.3 |
3.9 |
2.4 |
2.3 |
|
2002 |
3.9 |
3.5 |
4.6 |
4 |
2.3 |
2.2 |
|
2003 |
3.7 |
3.4 |
4.6 |
3.7 |
2.8 |
2.2 |
|
2004 |
3.6 |
3.4 |
4.5 |
3.7 |
2.3 |
2.2 |
|
2005 |
3.7 |
3.3 |
4.2 |
3.7 |
2.5 |
2.2 |
|
2006 |
3.7 |
3.2 |
4.4 |
3.8 |
2.4 |
2.1 |
|
2007 |
3.5 |
3.1 |
4.1 |
3.8 |
2.3 |
2.2 |
|
2008 |
3.5 |
3.1 |
3.8 |
3.4 |
2.4 |
2 |
|
Underlying mortality data provided by NCHS (www.cdc.gov/nchs). |
||||||
|
Rates are per 100,000 and age-adjusted to the 2000 US Std Population (19 age groups – Census P25-1130) standard. |
||||||
Directions: Use Excel to create charts and graphs requested below using the data above.Be sure to label each one accurately. (4 points each) (Tutorials may be accessed at https://support.office.com/en-us/article/Excel-training-9bc05390-e94c-46af-a5b3-d7c22f6990bb)
- Construct an arithmetic-scale line graph of the rates for each race-sex combination by time.
- Construct a logarithmic-scale line graph of the rates for each race-sex combination by time.
- Construct a simple bar chart showing the rates for the different race-sex combinations for the combined years 1985-2008.
- Construct a bar chart grouped by sex showing the rates for the different racial groups for the combined years 1985-2008.
- Construct a stacked bar chart showing the rates for males and females by racial group for the combined years 1985-2008.
- Construct a pie chart showing the rates according to racial group for males for the combined years 1985-2008.
Directions: Indicate the type of graph described by each of the following five statements.
(2 points each)
- Useful for describing the trend of a continuous variable over time, where changes in the variable are relatively gradual.
- It shows how a total population is subdivided into mutually exclusive groups by a characteristic.The groups add to 100 percent.
- Multiple sets of data are displayed as groups of side-by-side bars.
- Useful for describing the trend of a continuous variable over time, where changes in the variable are dramatic.
- A graph in which two continuous variables are charted against each other to illustrate correlation between them.
Directions: Create as indicated. (6 points)
- Create a table of statistical calculators for your use through the remainder of the course, being sure to list Excel as an option.Minimally, include Mean, Median, Mode, Range, Variance, Standard Deviation, Standard Error.Incorporate others as you go.
"You need a similar assignment done from scratch? Our qualified writers will help you with a guaranteed AI-free & plagiarism-free A+ quality paper, Confidentiality, Timely delivery & Livechat/phone Support.
Discount Code: CIPD30
Click ORDER NOW..
