7. Prepare Survey Data for Analysis and Visualize Data
7.4 Chapter activity: How would you visually present the data?
In this activity, you will practice creating visual representations of descriptive data using Excel charts.
Open the file Ch7 Data Screening and Charts.xlsx, and use the remaining 6 tabs provided.
As illustrated in Section 7.3, create the following charts in the remaining 6 tabs:
- Pie chart (age group)
- Bar graph (race)
- Bar graph (satisfaction)
- Line graph (trend)
- Line graph (before and after)
- Scatter plot (age x value)
