"

7. Prepare Survey Data for Analysis and Visualize Data

7.0 Introduction

You may have administered survey questionnaires with closed-ended questions to collect data during projects involving evaluation, performance analysis, or instructional design. In the final How step of the survey design and data analysis process (Figure 43), the focus shift to analyzing the quantitative data obtained from your surveys. One commonly used tool for this purpose is Excel, which offers practical features for analyzing quantitative survey data.

Figure 43 The How Step in the Survey Design and Data Analysis Process

Cyclical graphic representing the six key questions to consider when designing a survey. Each slice of the pie is labeled with a step in a clockwise sequence starting from the top: 1. Why, 2. Who, 3. What, 4. Where, 5. When, and 6. How. An arrow points at 6. How (Determine how you will analyze the data).

Learning Objectives

After completing this chapter, you will be able to:

  • Explain the purpose of data screening
  • Identify common methods used in data screening
  • Describe the benefits of visually presenting data
  • Identify data visualization techniques using Excel

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Survey Design and Data Analysis Copyright © 2025 by Seung Youn (Yonnie) Chyung, Ed.D. is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book