Skip to main content

How to Forecast Stock Prices XOPT 1051

Operations Management Microcredential Course

Course details

​How to forecast stock market prices is not an easy task. This course will get you started by providing you with 3 key methods used. No prior statistics, economics or Excel knowledge is necessary to complete this course. Additional course topics include: learning about average returns, volatility of stocks, using Excel's charting tools and using the Data Analysis Toolpak. The methods we will learn are moving averages, linear regression and the random walk method. In addition we will use what are called lagged variables


  • No prerequisites are required for this course.



Not offered this term
This course is not offered this term. Please check back next term or subscribe to receive notifications of future course offerings and other opportunities to learn more about this course and related programs.

Learning Outcomes

Upon successful completion of this course, the student will be able to:

  • Understand and perform the moving average method
  • Understand and perform the random walk method
  • Understand and calculate correlation coefficients and perform the linear regression method
  • Understand, use and calculate lagged variables.

Effective as of Winter 2021

Related Programs

How to Forecast Stock Prices (XOPT 1051) is offered as a part of the following programs:

School of Business + Media

  1. Digital Transformation
    Microcredential Part-time


Interested in being notified about future offerings of How to Forecast Stock Prices (XOPT 1051)? If so, fill out the information below and we'll notify you by email when courses for each new term are displayed here.

  • Privacy Notice: The information you provide will be used to respond your request for BCIT course information and is collected under Section 26(c) of the Freedom of Information and Protection of Privacy Act (FIPPA). For more information about BCIT’s privacy practices contact: Associate Director, Privacy, Information Access & Policy Management, British Columbia Institute of Technology, 3700 Willingdon Ave. Burnaby, BC V5A 3H2, email: