Tribhuvan University
Faculty of Management
Office of the Dean
Bachelor of Business Administration in Finance (BBA-F)
Course Description
:The course “Statistical Methods and Data Modeling” is exclusively of applied natu re and computer intensive. The course is broadly divided into two components namely the theoretical (or conceptual) and practical. The first component is also divided further into two parts: the statistical methods and data modeling. The practical compone nt deals with the data analysis using Microsoft Excel for both statistical methods and data modeling. There are altogether five units in the syllabus including practical component. First unit deals with the application of descriptive statistical analysis appropriately which suits for the data set. Second unit of the course is exclusively devoted on the inferential statistics and their applications specially focusing on administrative and finance related data. This unit also include the application of test of significance of single mean, single proportion, double mean(for independent samples), more than two means(for independent samples) focusing on administrative and finance related data. Further, this also deals with the test of significance of associatio n between two independent categorical variables and test of significance of two variances in the relevant data. Unit three involves the index numbers, types and their applications with real Nepalese data in the relevant field. Unit four deals exclusively o n understanding and applications of multiple linear regression modeling, its assumptions, and regression diagnostics. It also incorporates the time series modeling. The applications of these techniques are attempted focusing on Nepalese finance, business and banking data. The last unit exclusively deals to develop the skills to analyze the data through Microsoft Excel and the interpretations of the results. The course helps students to understand different statistical methods (descriptive and inferential st atistics), multiple linear regression modeling and to apply them appropriately. Course Learning Outcomes On completion of this course the students will be able to: Understand the meaning and types of different statistical tools; Understand the importance of descriptive and inferential statistics; Perform appropriate descriptive statistical analysis; Apply appropriate statistical test(s) as checking the assumptions of the statistical tool(s); Understand the fundamental concept of regression model, use line ar regression model and able to interpret the results; Understand simple time series data and able to apply to simple trends analysis; Apply Microsoft Excel to explore and to analyze the data.
Course Objective
:This course “Statistical Methods and Data Modeling” aims to provide students with better understandings of general concepts, meaning and use of statistics and develop basic skills f or applying descriptive and some inferential statistics for analyzing the data related to business, management, finance, banking and economics. Students will also be able to apply linear regression model with real data and be able to interpret the results with reference to the specific data problems. This course also equips the student with skills to analyze the data through the use of MS Excel efficiently. Course Description The course “Statistical Methods and Data Modeling” is exclusively of applied natu re and computer intensive. The course is broadly divided into two components namely the theoretical (or conceptual) and practical. The first component is also divided further into two parts: the statistical methods and data modeling. The practical compone nt deals with the data analysis using Microsoft Excel for both statistical methods and data modeling. There are altogether five units in the syllabus including practical component. First unit deals with the application of descriptive statistical analysis appropriately which suits for the data set. Second unit of the course is exclusively devoted on the inferential statistics and their applications specially focusing on administrative and finance related data. This unit also include the application of test of significance of single mean, single proportion, double mean(for independent samples), more than two means(for independent samples) focusing on administrative and finance related data. Further, this also deals with the test of significance of associatio n between two independent categorical variables and test of significance of two variances in the relevant data. Unit three involves the index numbers, types and their applications with real Nepalese data in the relevant field. Unit four deals exclusively o n understanding and applications of multiple linear regression modeling, its assumptions, and regression diagnostics. It also incorporates the time series modeling. The applications of these techniques are attempted focusing on Nepalese finance, business and banking data. The last unit exclusively deals to develop the skills to analyze the data through Microsoft Excel and the interpretations of the results. The course helps students to understand different statistical methods (descriptive and inferential st atistics), multiple linear regression modeling and to apply them appropriately. Course Learning Outcomes On completion of this course the students will be able to: Understand the meaning and types of different statistical tools; Understand the importance of descriptive and inferential statistics; Perform appropriate descriptive statistical analysis; Apply appropriate statistical test(s) as checking the assumptions of the statistical tool(s); Understand the fundamental concept of regression model, use line ar regression model and able to interpret the results; Understand simple time series data and able to apply to simple trends analysis; Apply Microsoft Excel to explore and to analyze the data.
Course Contents:
Lecture hours show the approximate classroom time allocated to each unit.
Unit 1. Introductory Statistics
- Review of concept of descriptive statistics
- Data collection
- Primary and secondary data
- Data tabulation
- Frequency distribution and cross tabulation
- Stem and leaf plot
- Box and Whisker plot
- Diagrams and Graphs
- Scatter plots
- Measures of ce ntral tendency
- Measures of dispersion
- Measures of skewness
- Measures of kurtosis
- Correlation
- Concept of Probability and mathematical expectation
- Numerical problems and exercise related to finance, banking, economics and management.
Unit 2. Inferential Statistics
- Concept of sampling distribution
- Standard error
- Concept estimation
- Confidence interval estimation
- Hypothesis testing: null and alternative hypothesis, one -tailed and two -tailed hypothesis, errors in hypothesis testing, type I & type II errors, level of significance, rejection region, critical values, p -value, power of the test
- Linkage between testing of hypothesis and confidence interval.
- Parametric tests: Test of significance of single mean (Z test and t -test) and sin gle proportion (Z-test)
- Test of significance of two means (independent t -test)
- Assumptions for applying independent t-test
- Test of significance of two variances
- Test of significance of correlation coefficient
- Test of significance of more than two mean s (independent samples) and its assumptions
- Numerical problems and exercise related to finance, banking, economics and management.
- Non-parametric test: Chi -square test of independence if attributes, test of goodness of fit.
- Attributes
- Numerical problems and exercise related to finance, banking, economics and management.
Unit 3. Index Numbers
- Introduction
- Types of index numbers
- Methods for construction of price indexes (unweighted and weighted: Laspeyre’s, Paasche’s and Fisher’s meth od)
- Value indices, Chain indices, Consumer price index numbers
- Base shifting
- Deflation
- Numerical problems and exercise related to finance, banking, economics and management.
Unit 4. Data Modeling
- Concept of cause and effect relati onship
- Simple linear regression model and it’s fitting
- Assumptions of simple linear regression model
- Test of significance of regression coefficient, overall fitting of the model
- Interpretation of regression coefficients
- Concept of non-linear regression
- Multiple linear regression model: assumptions, fitting of multiple linear regression model
- Parameter estimation and test of significance of regression coefficients(t-test)
- Test of goodness of fit of the model(F -test)
- Coefficient of determination (R2)
- Standard Error of Estimate
- Confidence Interval estimate of regression coefficients
- Predictions through model
- Residual analysis. Time series analysis:
- definition, components, seasonal index, trend analysis, data smoothing, forecasting.
Unit 5. Data Analysis using Microsoft Excel (Practical)
- Exercises on MS-Excel covering all the analysis indicated from unit1 to unit 4.
- Basic Books Levine, D. M., Krehbiel, T. C., Berenson M. L. & Viswanathan, P. K. Business Statistics: A First
- Course. New Delhi: Pearson Education.
- Gujrati D.N. Basic Econometric. New York: McGraw Hill Education.
- Glyn, D. & Pecar, B. Business Statistics using Excel. London: Oxford University Press.
Suggested Readings:
Levin, R. I. & Rubin, D. S. Statistics for Management. New Delhi: Pearson Publications. Anderson, D.R., Sweeney, D. J. & Williams, T. A. Statistics for Business and Economics. Mason: South-Western Cengage Learning.