Department of Citywide Administrative Services

Course Statistical Analysis I with Excel - (CMPD-8248-SU25)

Portfolio Management & Supervision

Cost $ 250.00 Per Participant

Prerequisite(s) None

Credits CEU:0.6, CPE:8, PDC:6

Modality Instructor Led Classroom Training

Instructor(s) Elizabeth DiLuzio, Christian Martinez

Class Description

A practical, one-day course covering the basics of descriptive statistics with open data, including basic statistical measures such as mean, median, standard deviation, and variance. The course also covers correlation, linear regression, and introduces decision modeling using open data. This course introduces participants to the use of statistics for understanding and communicating city data. Using Excel, participants will learn how to use measures like mean, median, mode, standard deviation, and variance interval to understand the content of city data for making operational decisions. Participants will also learn how to display statistical information in meaningful ways. 

Objectives: 

• Learn common statistical measures including mean, median, mode, standard deviation, and variance 
• Calculate correlation coefficients for bivariate data and apply the technique of simple regression analysis 
• Demonstrate techniques used for forecasting 
• Communicate data meaningfully to a broad audience using charts and graphs in Microsoft Excel 

Target Audience: 

Managers, Supervisors, and Team Leaders involved in data analysis