Basics of Statistics Using MS Excel (Microsoft Excel)

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
3. From problem statement to research questions and frameworks (models) and/or hypothesis testing using Microsoft Excel
4. Differentiate and use different statistical tests to solve problems using Microsoft Excel
5. Writing Interpretation and report. 

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

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

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

Advanced Statistics using Microsoft Excel

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


Contact

  Tel:  +1 (916) 661 - 0058

  Email: xc.california@gmail.com


Services

Consulting

     Statistical Consulting

     Data Analysis

     Modeling

Trainings

      Microsoft Excel Training

      SPSS Training

      Efficiency Analysis using DEA

      Microsoft PowerPoint Training

      Microsoft Word Training

      Simulation using Arena

Academic

      Researchers 

      Doctoral Students

      Corporate R&D

      Statistics Trainings

Tutoring and Coaching

 

 Cities we serve outside USA (Worldwide)

Tokyo, Japan
Jakarta, Indonesia
Seoul, South Korea 
Delhi, India 
Shanghai, China 
Manila, Philippines 
Karachi, Pakistan  
Sao Paulo, Brazil 
Mexico City, Mexico
Cairo, Egypt 
Beijing, China  
Osaka, Japan
Mumbai (Bombay), India 
Guangzhou, China 
Moscow, Russia
Calcutta, India 
Dhaka, Bangladesh
Buenos Aires, Argentina 
Istanbul, Turkey 
Rio de Janeiro, Brazil
Shenzhen, China
Lagos, Nigeria
Paris, France 
Nagoya, Japan 
Lima, Peru
Chicago, USA
Kinshasa, Congo (DRC) 
Tianjin, China 
Chennai, India
Bogota, Colombia
Bengaluru, India
London, United Kingdom 
Taipei, Taiwan 
Ho Chi Minh City (Saigon), Vietnam
Dongguan, China
Hyderabad, India
Chengdu, China 
Lahore, Pakistan 
Johannesburg, South Africa
Tehran, Iran
Essen, Germany
Bangkok, Thailand 
Hong Kong, Hong Kong 
Wuhan, China
Ahmedabad, India
Chongqung, China
Baghdad, Iraq
Hangzhou, China 
Toronto, Canada
Kuala Lumpur, Malaysia
Santiago, Chile
Quanzhou, China
Shenyang, China
Belo Horizonte, Brazil
Nanjing, China
Madrid, Spain
Xi'an-Xianyang, China
Milan, Italy 
Luanda, Angola
Pune, India
Singapore, Singapore
Riyadh, Saudi Arabia
Khartoum, Sudan 
Saint Petersburg, Russia
Atlanta, USA
Surat, India
Bandung, Indonesia 
Surabaya, Indonesia
Yangoon, Myanmar
Alexandria, Egypt
Guadalajara, Mexico
Harbin, China 
Zhengzhou, China
Qingdao, China
Abidjan, Cote d'Ivoire
Barcelona, Spain 
Monterrey, Mexico
Ankara, Turkey
Suzhou, China
Salvador, Brazil 
Porto Alegre, Brazil
Rome, Italy
Accra, Ghana
Sydney, Australia
Recife, Brazil 
Naples, Italy
Dalian, China 
Fuzhou, China Medellin, Colombia

 


 Cities we serve inside USA

New York, New York
Los Angeles, California
Chicago, Illinois
Houston, Texas
Philadelphia, Pennsylvania
Phoenix, Arizona
San Diego, California
San Antonio, Texas
Dallas, Texas
Detroit, Michigan
San Jose, California
Indianapolis, Indiana
Jacksonville, Florida
San Francisco, California
Columbus, Ohio
Austin, Texas
Memphis, Tennessee
Baltimore, Maryland
Charlotte, North Carolina
Fort Worth, Texas
Boston, Massachusetts
Milwaukee, Wisconsin
El Paso, Texas
Washington, District of Columbia
Nashville-Davidson, Tennessee
Seattle, Washington
Denver, Colorado
Las Vegas, Nevada
Portland, Oregon
Oklahoma City, Oklahoma
Tucson, Arizona
Albuquerque, New Mexico
Atlanta, Georgia
Long Beach, California
Kansas City, Missouri
Fresno, California
New Orleans, Louisiana
Cleveland, Ohio
Sacramento, California
Mesa, Arizona
Virginia Beach, Virginia
Omaha, Nebraska
Colorado Springs, Colorado
Oakland, California
Miami, Florida
Tulsa, Oklahoma
Minneapolis, Minnesota
Honolulu, Hawaii
Arlington, Texas
Wichita, Kansas
St. Louis, Missouri
Raleigh, North Carolina
Santa Ana, California
Cincinnati, Ohio
Anaheim, California
Tampa, Florida
Toledo, Ohio
Pittsburgh, Pennsylvania
Aurora, Colorado
Bakersfield, California
Riverside, California
Stockton, California
Corpus Christi, Texas
Lexington-Fayette, Kentucky
Buffalo, New York
Paul, Minnesota
Anchorage, Alaska
Newark, New Jersey
Plano, Texas
Fort Wayne, Indiana
St. Petersburg, Florida
Glendale, Arizona
Lincoln, Nebraska
Norfolk, Virginia
Jersey City, New Jersey
Greensboro, North Carolina
Chandler, Arizona
Birmingham, Alabama
Henderson, Nevada
Scottsdale, Arizona
North Hempstead, New York
Madison, Wisconsin
Hialeah, Florida
Baton Rouge, Louisiana
Chesapeake, Virginia
Orlando, Florida
Lubbock, Texas
Garland, Texas
Akron, Ohio
Rochester, New York
Chula Vista, California
Reno, Nevada
Laredo, Texas
Durham, North Carolina
Modesto, California
Huntington, New YorK
Montgomery, Alabama
Boise, Idaho
Arlington, Virginia
San Bernardino, California