Week 3

Class Overview

  • Emphasis on preparation for due dates

    • Important assignments are coming up, specifically a reading assignment due on February 3rd.

    • Encouragement to practice extensively before the due date.

Reading Assignment

  • Focus on understanding concepts rather than just moving through questions.

  • Reminder of the importance of reviewing material by checking questions and revisiting reading.

Data Analysis Assignment

  • Introduction to a table with 3 variables and 5 observations (variables being X1, X2, and X3).

    • Importance of identifying complete cases within observations.

    • Discussion on how many complete observations are present, confirming there were 2 complete observations.

Handling Missing Values

  • Simple mean imputation strategy discussed to handle missing values.

  • Students asked to identify missing values visually as well as using function count.

  • Example problem presented involving missing values.

Statistics Questions

  • Various statistics calculations involving summary data

    • Detailed steps outlined to calculate averages and manage decimals through example calculations.

  • Importance of rounding averages to specified decimal places.

Practical Applications with Data Sets

  • Use of real-world examples, such as analyzing NFL quarterbacks during the 2017 season.

    • Discussion about outlier removal related to touchdowns and interceptions.

Using Excel for Filtering Data

  • Steps for filtering relevant data, including using the function to find players with less than 5 touchdowns and more than 20 interceptions.

    • Demonstrations on how to set up filters effectively using Excel.

  • Importance of actively participating in data cleaning to ensure accuracy in results.

Return to Original Dataset

  • Use of median values for imputation when handling missing data.

    • Directions on how to traverse data entries for replacing missing values.

  • Recap on overall steps to calculate mean and median for touchdowns and interceptions.

Student Engagement in Class

  • Encouragement to interact and participate in the class discussions and exercises.

  • Recognition of students’ efforts with positive affirmations throughout the session, fostering a supportive learning environment.

Homework Assignment Preparation

  • A follow-up for additional practice for the next week's assignment.

  • Reminder to sign in for attendance and ensure readiness for upcoming classes.