• Unit 5: Deriving Data Insights

    This unit builds on the last unit by covering data distribution techniques like the mean, median, and mode, how frequency tables can be used to organize and summarize data, and how to analyze a frequency distribution, which displays the number of times an event occurs in a set of data. Frequency tables are useful for describing the number of occurrences for a specific event. Data analysts rely on frequency tables to identify trends within data. One common method for organizing data is to construct a frequency distribution. For example, a company may ask you to conduct an employee satisfaction survey. Once the survey responses are complete, frequency tables and distributions display employees' responses by age, position, race, gender, and other categories determined by the company. Companies use this data in many ways – for example, frequency tables based on age can reveal the numbers of employees retiring soon, which lets managers prepare for shortages and job vacancies. Frequency distribution is a way to tabulate and present data on a visual scale and compile and organize data meaningfully to help decision-makers glance at data to see the big picture quickly.

    Completing this unit should take you approximately 5 hours.

    • 5.1: Conducting Data Analysis

      Data analysis is a method to collect and organize data to gain insightful information. It is the process of inspecting, cleaning, transforming, and modeling data. Data analysis aims to reveal insightful information, communicate conclusions, and provide recommendations for decision-making.

        • 5.1.1: Frequency Tables

        • 5.1.2: Frequency Distributions

        • 5.1.3: Graphic Presentations

      • 5.2: Charts, Graphs, and Tables

        Charts and graphs are also known as visual (graphic) presentations. Businesses use them to make sense of data and convey information. Remember, not everyone is a data expert. Therefore, focus on providing a visual presentation decision-makers can reference and understand. Remember, simplicity is key to an excellent business presentation.

      • Study Guide: Unit 5

        We recommend reviewing this Study Guide before taking the Unit 5 Assessment.

      • Unit 5 Assessment

        • Receive a grade