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