#ANALYTIC SOLVER PLATFORM FOR EDUCTION INSTALL#
#ANALYTIC SOLVER PLATFORM FOR EDUCTION TRIAL#

The projects count for 10 points each, and the lowest grade will be dropped. They are due in Blackboard by midnight on the class day (Wednesday). You will have three weeks from the assignment date to complete the project. There will be eight projects assigned during the course. Only when you work through the problems, view the videos, and experiment with your hands on the keyboard will you discover misunderstandings and mistakes. Students are expected to keep up with all assigned readings in advance of classroom discussions, and to explore the examples for the class.

#ANALYTIC SOLVER PLATFORM FOR EDUCTION INSTALL#

You will need to purchase a copy of the book in order to get the software codes to install ASPE. I will use Management Science, The Art of Modeling with Spreadsheets, 4th Edition, (2014) by Stephen Powell and Kenneth Baker. The techniques, however, remain universal. Your company might have licensed software from other vendors, or it may have developed some of these analytic capabilities in a home-grown application. I have learned from experience that getting the wrong вЂњtrial versionвЂќ is a complicated error to recover from! You should also know that these are not the only data manipulation packages вЂ“ ASPE is not the only game in town. NOTE: FOLLOW THE DIRECTIONS CAREFULLY IN INSTALLING THE SOFTWARE.

#ANALYTIC SOLVER PLATFORM FOR EDUCTION TRIAL#

The two packages are slightly different, and you will be working with the educational trial version of the Analytic Solver package. Note that this is often referred to by the name of the commercial products, Analytic Solver Platform or Risk Solver. We will also be using a student edition of an Excel-based analytic package called Analytic Solver Platform for Education. Nowadays, software (when properly applied!) can provide a short cut to getting the answers. In the past, answering these questions required several courses in theory and extensive mathematical treatment.

I will present various data sets and ask you to use these to answer questions that are highly typical of managerial problems. This is a course in which you will practice building a variety of models in Excel spreadsheets. An answer to the decision-makerвЂ™s question is far more valuable before the decision than after it! And, even if an enterprise has licensed the large-scale packages, the licenses may be limited and may not be available to you as an analyst in a reasonable time frame. Thus, every laptop and desktop across the institution can load and manipulate an analytic program in Excel. Excel has one advantage over the purpose-built analytic packages, however: it is installed on every computer that has Microsoft Office. This creates a market for large-scale statistical packages (SAS, SPSS, MiniTab, S-plus, etc.) in the commercial and government sector and purpose-built open-source statistical software (R) in the academic world. And, even if a spreadsheet can handle the data (Excel worksheets have 1,000,000 lines by default!), the process of manipulating, visualizing, and evaluating the data can become quite cumbersome. Spreadsheets become unwieldy with large data sets. In reality, you will learn that most important analytic methods can be implemented in a spreadsheet. Unlike other, more complicated methods such as system dynamics models or discrete-event simulations, spreadsheets are often believed to be simplistic in their ability to support decisions for a large enterprise. This course is designed to provide a solid grounding in the theory and practice of modeling using the most common tools available: Microsoft Excel spreadsheets. Overview Greetings! IвЂ™m excited to offer this course on analytics for decision analysis. Wednesday: 4:30 вЂ“ 7:10pm, Founders Hall 475Дepartment of Systems Engineering Operations Research Volgenau School of Engineering

Analytic solver platform for eduction