|
Lecturer(s)
|
-
Urbánek Tomáš, Ing. Ph.D.
-
Kunčar Aleš, Ing.
|
|
Course content
|
The basics of numerical methods, matrix calculus, linear programming, sensitivity analysis, scenarios and simulations will be discussed in the form of practical tasks in the seminars: - Calculation of Roots of Quadratic Equations - Trend Analysis - Analysis of the Dow Jones Index - Financial Functions, Evaluation of Investment - Analysis of the Functions of Total Costs, Total Revenues, Marginal Revenues, Profit Maximization - Determination of the Optimal Equity Portfolio - Sensitivity Analysis - Integration Methods: Calculating the Price of New Paint Pool - Evaluation of Questionnaire Survey: Descriptive Statistics, Correlation Analysis - Regression Analysis, Using the Matrices - Analysis of Extracts of Telephone Calls
|
|
Learning activities and teaching methods
|
Lecturing, Exercises on PC, Practice exercises
- Participation in classes
- 26 hours per semester
- Home preparation for classes
- 13 hours per semester
- Preparation for course credit
- 62 hours per semester
|
| learning outcomes |
|---|
| Knowledge |
|---|
| Defines the principle of questionnaire survey |
| Defines the principle of questionnaire survey |
| Clarifies the differences between data types |
| Clarifies the differences between data types |
| Defines the principle of statistical hypothesis testing |
| Defines the principle of statistical hypothesis testing |
| Explains the principle of basic statistical tests |
| Explains the principle of basic statistical tests |
| Clarifies the concept of data reporting |
| Clarifies the concept of data reporting |
| Skills |
|---|
| Develops research questions and hypotheses |
| Develops research questions and hypotheses |
| Develops a questionnaire survey |
| Develops a questionnaire survey |
| Decides which statistical test is appropriate for statistical hypothesis testing |
| Decides which statistical test is appropriate for statistical hypothesis testing |
| Applies software for evaluation of statistical test |
| Applies software for evaluation of statistical test |
| Interprets the results of a statistical test |
| Interprets the results of a statistical test |
| teaching methods |
|---|
| Knowledge |
|---|
| Practice exercises |
| Lecturing |
| Practice exercises |
| Exercises on PC |
| Exercises on PC |
| Lecturing |
| assessment methods |
|---|
| Analysis of the student's performance |
| Grade (Using a grade system) |
| Analysis of the student's performance |
| Grade (Using a grade system) |
|
Recommended literature
|
-
Curwin,J., Slater,R., Eadson,D. Quantitative Methods for Business Decisions. 7th ed. Andover, UK, Cengage Learning, 2013. ISBN 978-1-480-6012-4.
-
Knight, Gerald. Analyzing business data with Excel [elektronický zdroj]. Sebastopol, CA : O´Reilly Media, 2006. ISBN 978-0-596-10073-5.
-
Liengme, B. V. A guide to Microsoft Excel 2007 for scientists and engineers. Amsterdam ; Boston : Academic Press/Elsevier, 2009. ISBN 978-0-12-374623-8.
-
MacDonald, Matthew. Excel 2007 [elektronický zdroj] : the missing manual. Sebastopol, CA : Pogue Press/O´Reilly, 2007. ISBN 978-0-596-52759-4.
-
Proctor, K. Scott. Building financial models with Microsoft Excel : a guide for business professionals. 2nd ed. Hoboken, NJ : Wiley, 2010. ISBN 978-0-470-48174-5.
-
Remenyi, D., Onofrei, G., English, J. An introduction to statistics using Microsoft Excel. UK: Academic Publishing, 2010. ISBN 978-1-906638-55-9.
-
Salkind, N. Excel statistics: a quick guide. Los Angeles: SAGE, 2016. ISBN 978-1-4833-7404-8.
-
Triola, M. F. Elementary statistics. 12h ed.. Harlow: Pearson, 2014. ISBN 978-1-292-03941-1.
-
Triola, Mario F. Elementary statistics using Excel. 4th ed. Boston : Addision-Wesley, 2010. ISBN 978-0-321-56496-2.
|