Department of Citywide Administrative Services

Course Statistical Analysis I with Excel - (CMPD-4033-SU26)

Portfolio Personal Development

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, Daniella Dorancy

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

There is no cost to employees; the agency covers the cost of participation for their employees.

If you require a reasonable accommodation to attend a training, please contact the DCAS Citywide Learning and Development Center at CitywideTrainingCent@dcas.nyc.gov at least 7 days before your training start date.