Business Statistics Using Excel
A Step by Step Method
What you will learn
Meaning of statistics in singular and plural sense; its nature and scope, types of statistics, and limitation of statistics
Learn summarizing data by descriptive as well as numerical methods
Learn probability and probability distribution- Binomial, Poisson, Normal
Know Sampling and sampling distribution, concept of standard error, sample size determination
Understand the procedure of hypothesis testing, Z test, t test, F test, Chi square test, ANOVA
Learn Correlation and regression techniques
Why take this course?
Course Description
Business Statistics course offers clear cut knowledge of descriptive statistics and inferential statistics using MS Excel.
Today, as a reseracher or a manager you must know how to convert data into information that may aid in the decision making process.
This course put interpretation and decision making with the help of data at the forefront.
The prime objective of this course is to demonstrate how to use MS Excel 2007 for statistical anlaysis using step by step method.
The following methods of analysis are included:
- Graphing Techniques
- Frequency Analysis
- Numerical Techniques
- Mean, Median, Mode Analysis
- Range, Standard Deviation, Variance Analysis
- Skewness and Kurtosis Analysis
- Complete Descriptive Analysis with example
- Probability
- Probability Distribution
- Sampling & its Distribution
- Estimation
- Hypothesis Testing
- Correlation
- Regression
This course will be useful for all business professionals, marketing managers, financial analysts, economists, and students doing foundation courses in statistics, perhaps students in their second course or social or business researchers.