BUSINESS PERFORMANCE MONITORING USING EXCEL
Année du cours : 1 année(s)
Etablissement : IÉSEG School of Management
Langue : English
Formation(s) dans laquelle/lesquelles le cours apparait :
Période : S2
It is essential that students have a background on Research Methodology.
At the end of the course, the student should be able to :
– prepare essential materials for Business Performance analysis using Excel.(AOL-3A) (AOL-1C).
– improve some skills and tools for analyzing data appear in various fields of management.(AOL-5B)
– realise the concept of decision making in an uncertain environment.(AOL-6B)
– understand the importance of describing data and summarizing descriptive relationships.
– define the descriptive Measures of central tendency and variability in data.(AOL-3A)
– use the general principles for analyzing data such as sampling, unbiasedness, estimation with confidence intervals and Tests of Hypothesis using MS Excel.(AOL-3A)
1. Concept of decision making in an uncertain business environment. Importance of data-driven business performance analysis.
2. Business Analytics and Data Visualization using Excel.
3 .General principles for analyzing data: Pivot tables and hypothesis testing using Excel.
4. General principles for analyzing data: Estimation with confidence intervals and Tests of Hypothesis using Excel..
5. Simple Linear Regression and Multiple Regression and model building using Excel.
6. Categorical Data analysis using Excel and interpretting results.
