Business Analytics and Real Estate Consulting

Quantitative Methods and Quantitative Analysis Training in Sacramento

Topics covered in Basic and Advanced Training:

Basics of Statistics Using MS Excel or SPSS

Basic Statistics and Quantitative methods using Microsoft Excel is vital to develop analytical skills. Better decisions are outcome of such skills and it‘s for both researchers and business managers.
 
What you will learn:
1. Quantitative data collection,
2. Data entry, data cleaning, analysis and decision making using Microsoft Excel / SPSS
3. From problem statement to research questions and frameworks (models) and/or hypothesis testing using Microsoft Excel / SPSS
4. Differentiate and use different statistical tests to solve problems using Microsoft Excel / SPSS
5. Writing Interpretation and report. 

The focus of this class is on using Microsoft Excel / SPSS to solve statistics problems.

Subjects that we cover:
- Basic Statistics (Microsoft Excel / SPSS)
- Inferential Statistics (Microsoft Excel / SPSS)
- Type of variables and measurement levels (Microsoft Excel / SPSS)
- Sample and Population (Microsoft Excel / SPSS)
- Data with Microsoft Excel / SPSS
- Entering and Cleaning Data (Microsoft Excel / SPSS)
Descriptive Statistics  (Microsoft Excel / SPSS)
- Frequency tables, Pie chart, Bar chart, Histogram (Microsoft Excel / SPSS)
- Mean, Mode, Median (Microsoft Excel / SPSS)
- Skewness, Standard Deviation, Variance (Microsoft Excel / SPSS)
Hypothesis Testing for differences (Microsoft Excel / SPSS)
- t-tests ( 1-sample test , 2-smaple test and paired t-test) (Microsoft Excel / SPSS)
- Analysis of Variance (ANOVA) (Microsoft Excel / SPSS)
Hypothesis Testing for Relations (Microsoft Excel / SPSS)
- Graphing scatter diagram (Microsoft Excel / SPSS)
- Correlations and Regression Analysis (Simple linear regression) (Microsoft Excel / SPSS)

- graphing results
Decision Analysis using the results from Microsoft Excel / SPSS
Interpretation, sensitivity analysis, writing report, conclusion and more. (Microsoft Excel / SPSS)

Advanced Statistics using Microsoft Excel

- Review of Descriptive Statistics
    Scale of Measurement
- Tests & Assumptions
- Multivariate Statistics (Microsoft Excel / SPSS)
     Why Study Multivariate Statistics
     Univariate and Bivariate Statistics (Microsoft Excel / SPSS)
- Reliability (Microsoft Excel / SPSS)
- Data Appropriate for Multivariate Statistics
     Correlation and Partial Correlation (Microsoft Excel / SPSS)
     Hypothesis Testing (Microsoft Excel / SPSS)
- Multiple Regression  (1) (Microsoft Excel / SPSS)
     General Purpose and Description
     Theoretical Issues: Assumptions
     Data Analysis and Interpretation
- Multiple Regression (2) (Microsoft Excel / SPSS)
     Factor Analysis (Exp. & Com.)   SPSS
     Basics of Logistic Regression (LR) / SPSS
     Interpretation of LR / SPSS
- Statistical technics to compare groups (1)
      Non Parametric statistics (Microsoft Excel / SPSS)
      T test MS Excel SPSS
      One way ANOVA (Microsoft Excel / SPSS)
- Statistical technics to compare groups (2)
      Two ways ANOVA (Microsoft Excel / SPSS)
      MANOVA using  SPSS
      Analysis of Covariance (ANCOVA using SPSS)
      Introduction to SEM (Structural Equation Modelling)