02_city New logo.jpg

Excel Statistics Workshop 

Date and time: November 29 from 9:00 am to 6:00 pm

Cost:  Free but mandatory registration

Place:  zoom

 

Enrollment  

 

 

 

 

 

 

 

 

 

 

 

General information

 

 

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.

Detailed Program:

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

16:00/16:15 Break

16:15/17:45 Macros

5:45 pm/18:00 pm Closing

Workshop Records