Excel Statistics Workshop
Date and time: November 29 from 9:00 am to 6:00 pm
Cost: Free but mandatory registration
Objective: Introduce the basic functions of Excel with particular emphasis on useful tools for the analysis of urban mobility systems. At the end of the workshop, participants will have basic knowledge of handling and formatting Excel files, operation with tables, graphs, statistical analysis, introduction to optimization, introduction to macros.
Target Audience: This initiation workshop is aimed at undergraduate or graduate students and professionals in the fields of engineering, urbanism, as well as the general public interested in this topic. There will be a minimum of 15 participants and a maximum of 20. The material required for participation is a personal computer with an Internet connection and Microsoft Office installed.
Official language: Portuguese.
Guest Speakers: Vasco Reis and Liliana Magalhães.
09:00/09:15 Welcome and go-around session
09:15/10:15 Introduction to Excel (formulas, tools, basic commands, formatting, graphs…)
10:15/10:30 am Break
10:30/12:00 Linear Regression - Trend Lines
12:00/13:00 Statistics in Excel (average, mode, add-on, …)
13:00/14:00 Lunch break
14:00/15:00 Pivot Table
15:00/16:00 Goal seek and solver
5:45 pm/18:00 pm Closing