Lecture Notes: Pivot Tables, Scatter Plots, and Trend Lines

Introduction

Click Up: Location for continuous assessment info, practicals, and extra resources
- Microsoft Excel help and additional resources
- Video resources for excel functionality
- Practical files: Includes due dates, instructions, and data sets for practicals
- Important docs: Data set description, histogram tool guidance
Announcement Page: Lists the sessions, case studies to work through, and preparation guidelines

Focus sections for practicals: 1, 2.1, 2.4, 2.5
- Section 1: Basics of Excel
- Section 2.1: Cross Tabulations and Frequency Distributions
- Section 2.4: Histogram Tool
- Section 2.5: Scatter Plots
Practical files include exercises and datasets
Importance of sample vs population data

Case Study 1: Cross Tabulations
- Using Excel Pivot Tables: Insert Pivot Table > Highlight cell > Rows: Type of dwelling > Columns: Home Phone > Values
- Adjusting columns and filtering out blanks
- Calculating percentages: Right-click values > Show Values As > Percentage of Grand Total/Row/Column
Case Study 2: Scatter Plots
- Using Columns BQ & BW for land transport and shopping during trips
- Creating the scatter plot in Excel: Insert > Charts > Scatter
- Ensure axes are correct by switching columns if needed
- Visual representation of relationship between two variables

Copying Columns: Use Ctrl to select multiple columns
Formulas: Use max function to confirm ranges
Percentage Calculations: Show Values As options in Pivot Tables
Adjusting Decimal Places: Use home tab > number > increase/decrease decimals
Missing Values: Default to ignoring missing values in practicals
Posting on Discussion Board: Tips on including screenshots and browsing previous questions

Addressing Mac users: Pivot Table options might be different, refer to specific video resources
Posting screenshots for assistance on the discussion board