Skip to header Skip to Content Skip to Footer

Business Analytics Series - Predictive Analytics

Course Dates Coming Soon!

Think ahead! Register for Predictive Analytics, Power Query, and PivotTables & Visualization and save $198!

$399

Course fee includes:

  • Course slides and handouts
  • Online Access to Course
  • Certificate

$999 for all three courses: Predictive Analytics, Power Query, and PivotTables & Visualization

UNCW Faculty/Staff/Students/Alum receive a 25% discount. Email swain@uncw.edu providing your name and desired course and departmental fund to charge to initiate billing to your department with an IDI (internal Invoice). You can not pay with a UNCW Purchasing Card.

Active military members, veterans and spouses receive a 25% discount off of the course fee! Email the Swain Center directly for the discount code.

UNCW Swain Center is recognized by SHRM to offer SHRM-CP or SHRM-SCP Professional Development Credits (PDC). This program is valid for 4 PDCs toward SHRM-CP and SHRM-SCP recertification. For more information about certification or recertification, please visit SHRM Certification website.

Fully Online (Details will be emailed one week prior to start date.)

  • Find/Replace
  • Sorting data
  • Filtering data
  • Creating charts
  • Writing “If” statements
  • DateDif
  • Data analysis took data
  • Solver
  • Summary statistics
  • Correlation analysis
  • t-test for difference between means
  • Regression analysis
  • Objectives

    By the end of this hands-on course, you will be able to:

    • Sort and filter data
    • Create "indicator" variables
    • Create scatter plots and time series plots
    • Calculate summary statistics to describe data
    • Calculate and interpret correlation coefficients
    • Calculate and interpret the line of best fit
    • Forecast/predict future values
  • This program is designed for people who:

    • need to quickly producing reports in Excel
    • have basic exposure to Excel
    • need to analyze data in Excel to improve decision-making
  • Goals for Prediction

    • Defining the project and selecting the dependent variable
    • Forecasting vs. interpolation

    Data Collection and Dataset Preparation

    • Sampling
    • Types of data
    • Data transformation and preparation
    • Outliers and missing values

    Model Development and Model Selection

    • The ordinary least squares regression model
    • Selecting independent variables
    • Understanding goodness of fit
    • Interpreting the impact of independent variables

    Using the Model to Make Prediction and Inference

    • Forecasting and calculating fitted values
    • Margins of error – specifying confidence in your predictions
    • Cautions, caveats and concerns
  • Peter Schuhmann, PhD

    Professor of Economics in Economics and Finance Department
    Cameron School of Business at the University of North Carolina Wilmington

    Dr. Schuhmann earned his Ph.D. in economics from North Carolina State University in 1996 with field concentrations in environmental economics and statistics.

    Dr. Schuhmann has taught six unique undergraduate courses, three graduate-level courses and has supervised over 100 graduate and undergraduate independent studies and theses. He teaches traditional face-to-face courses, hybrid courses, and fully online courses and was the co-organizer of an annual regional economics teaching workshop held in Wrightsville Beach, North Carolina for 15 years.

    Dr. Schuhmann's primary area of research is the non-market valuation of environmental goods and services, largely focused on coastal and marine resources in North Carolina and the Caribbean. His research includes analysis of willingness to pay for changes in coastal and marine resource quality, including beach width, beach amenities, reef health and species diversity, as well as examinations of the costs and benefits of fisheries policy and shoreline management.

    Dr. Schuhmann's work has been published in journals such as Ecological Economics, Land Economics, Marine Resource Economics, Marine Policy, Natural Resource Modeling, and the Journal of Environmental Management.