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)

Decision Analysis using the results from Microsoft Excel
Interpretation, sensitivity analysis, writing report, conclusion and more. (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)
The text passage is a course outline for a class on using Microsoft Excel for basic and advanced statistical analysis. It lists the topics and skills that will be covered, including data collection, entry, cleaning, analysis, and various statistical tests.
no_question

the passage does not contain any mathematical questions or answers. it is purely a descriptive outline of the course content and what students will learn.
Given a text passage, determine:
    1. If it contains a mathematical question (including word problems or calculations)
    2. If an answer to that mathematical question is provided in the text

First, describe the content structure you found in 1-2 sentences.

Then provide your analysis in the following format:
TYPE: <one of the following values>
- NO_QUESTION
- SINGLE_QUESTION
- SINGLE_QUESTION_WITH_ANSWER
- MULTIPLE_QUESTIONS
- MULTIPLE_QUESTIONS_WITH_ANSWERS
system
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)

Decision Analysis using the results from Microsoft Excel
Interpretation, sensitivity analysis, writing report, conclusion and more. (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)
user
The text passage is a course outline for a class on using Microsoft Excel for basic and advanced statistical analysis. It lists the topics and skills that will be covered, including data collection, entry, cleaning, analysis, and various statistical tests.

TYPE: NO_QUESTION

The passage does not contain any mathematical questions or answers. It is purely a descriptive outline of the course content and what students will learn.