Optimization with Linear Programming
After completing this course students will be able to formulate linear programming models and describe the types of decisions that lend themselves to linear programming solutions. You will learn how to use spreadsheet software to implement and solve linear programming problems. You will also cover how to use sensitivity analysis and shadow prices to gain additional insights from linear programming results.
- Describe what types of decisions are amenable to linear programming solutions
- Formulate a linear programming model, and represent it graphically
- Solve the LP model with spreadsheet-based software
- Use LP models for various decisions: make or buy, where to invest,
- Use sensitivity analysis and shadow prices to gain additional information from the LP solution
Who Should Take This Course
Business analysts with responsibility for specifying, creating, deploying or interpreting quantitative decision models. Users of linear programming software who need to attain a more solid grounding in the subject.
- The role of models in decisions
- Sources of bias & error in human decision making
- Good decisions vs. good outcomes
Linear Programming Models
- Formulating linear programming models
- Graphical representations
- Solving LP models in spreadsheets
Domain Specific Illustrations
- Make or buy
- Role of sensitivity analysis in the larger decision context
- Shadow prices
- Alternate solutions
- Robust Optimization
- Simplex Method
You will need to have some facility with spreadsheet operations prior to starting this course.
The Statistics.com courses have helped me a lot, pushing me to the limit and making me learn much more than I expected I could. The knowledge I gained I could immediately leverage in my job … then eventually led to landing a job in my dream company – Amazon.
This program has been a life and work game changer for me. Within 2 weeks of taking this class, I was able to produce far more than I ever had before.
The material covered in the Analytics for Data Science Certificate will be indispensable in my work. I can’t wait to take other courses. Great work!
I learned more in the past 6 weeks than I did taking a full semester of statistics in college, and 10 weeks of statistics in graduate school. Seriously.
This is the best online course I have ever taken. Very well prepared. Covers a lot of real-life problems. Good job, thank you very much!
The more courses I take at Statistics.com, the more appreciation I have for the smart approach, quality of instructors, assistants, admin and program. Well done!
This course greatly benefited me because I am interested in working in AI. It has given me solid foundational knowledge…After completing this last course, I feel I have gained valuable skills that will enhance my employability in Data Science, opening up diverse career opportunities.
Frequently Asked Questions
What is your satisfaction guarantee and how does it work?
Can I transfer or withdraw from a course?
Who are the instructors at Statistics.com?
Visit our knowledge base and learn more.
Homework in this course consists of short answer questions to test concepts, guided data analysis problems using software, and guided data modeling problems using software.
In addition to assigned readings, this course also has supplemental readings available online.
Spreadsheet Modeling & Decision Analysis, eighth edition by Cliff Ragsdale, which can be ordered from the publisher via the previous link. This text is also used in Integer & Nonlinear Programming and Network Flow and Risk Simulation and Queueing. Note: We do not recommend using the Kindle version of this book.
The course uses Analytic Solver Platform for Education software by Frontline systems. Analytic Solver Platform for Education is an add-in for Excel that performs risk analysis, simulation, optimization, decision trees and other analytical methods. With the purchase or rental of the book, you will have a course code that will enable you to download and install the software for 140 days. If you do not have such a license, a license is also available for course registrants through Statistics.com. Please do not install the regular public trial copy of the software on your own; when the course starts we will provide you with the complete installation instructions to obtain the appropriate copy of the software.
Options for Credit and Recognition
ACE CREDIT | College Credit
This course has been evaluated by the American Council on Education (ACE) and is recommended for the upper-division baccalaureate degree, 3 semester hours in mathematics or business management. Please note that the decision to accept specific credit recommendations is up to the academic institution accepting the credit.
Literacy, Accessibility, and Dyslexia
At Statistics.com, we aim to provide a learning environment suitable for everyone. To help you get the most out of your learning experience, we have researched and tested several assistance tools. For students with dyslexia, colorblindness, or reading difficulties, we recommend the following web browser add-ons and extensions:
- Color Enhancer (for colorblindness)
- HelperBird (for colorblindness, dyslexia, and reading difficulties)
- Mobile Dyslexic
- Color Vision Simulation (native accessibility feature)
- Other native accessibility features instructions