Detailed Study Notes on Excel and Basic Statistics
Chapter 1: Introduction
Objective:
Students to achieve proficiency in basic Excel functions and some statistical concepts.
Course Structure:
Excel files to be worked on collaboratively during sessions.
Excel file uploaded on platform "d 12" for practice.
Attendance will be checked through submissions after class exercises.
All submitted work during class will be considered attendance.
Assumptions:
Students have no prior knowledge of Excel or statistics.
Course aims to teach from the ground up, ensuring everyone learns and practices.
Plan for Upcoming Sessions:
Data analytics process will be discussed briefly.
Basic statistics will be introduced and applied using Excel.
Course to explore probabilities, hypothesis testing, and data analytics step-by-step.
Data Analytics Process:
First Step: Question Formulation
Importance of asking the right questions:
What happened?
Why did it happen?
What will happen in the future?
What if we do this?
How can we improve?
Example Question:
How to identify early pregnancy through data?
Second Step: Collect Data
Data types and availability.
Encourage students to use provided data; other data may need to be sourced in future.
Third Step: Summarize Data
Understanding the data better through summary statistics.
Summary statistics include: Mean, Median, Max, and Min.
Significance of graphing summary statistics to visualize information.
Fourth Step: Analyze Data
Use of summary statistics to draw insights.
Comparing different groups (e.g., Male vs Female sales data).
Analyzing correlations between variables.
Communication of Findings:
Importance of effectively communicating insights.
Communication formats include emails, reports, and visualizations.
Avoid overselling or underselling insights.
Chapter 2: Different Data Sets
Summarizing Data:
Importance of summarizing data for clarity and understanding of the overall picture.
Summary statistics include mean, median, max, min, number of observations.
Techniques for executing conditional averages.
Analyzing Data and Answering Research Questions:
First, summary statistics provide a good insight.
Advanced methods may include hypothesis testing and correlation analysis.
Advanced methods will be briefly discussed for the next week's homework.
Chapter 3: Variation of Data
Measures of Central Tendency:
Main measures: Mean, Median, Mode.
Mean Definition:
Arithmetic Mean:
Commonly used to represent average value but vulnerable to outliers.
Median Definition:
Middle value when data is arranged in order.
Not affected by outliers.
Mode Definition:
Value that appears most frequently.
Applicable for numerical and categorical data.
Chapter 4: Sort of Data
Importance of Sorting Data:
Necessary for accurate calculations of median.
Sorting enables quick calculation of summaries.
Example Calculation for Mean, Median, Mode:
Median is especially valuable in situations with outliers.
Chapter 5: Variation of Data
Analyzing Data Variation:
Range Definition:
Difference between maximum and minimum values.
Standard Deviation Definition:
A vital measure of spread: indicates how far data deviates from the mean.
Formula:
Chapter 6: Range of Data
Limitations of Using Range:
Fails to communicate data distribution comprehensively.
Introduce standard deviation as a preferred measure of variation.
Chapter 7: Selecting Data
Using Excel for Data Analysis:
Examples on how to compute mean, median, mode, max, min, standard deviation through Excel functions systematically.
The formulae to be used (e.g. AVERAGE, MEDIAN, MODE) explored.
Chapter 8: Conclusion
Histogram Concept:
Distribution of data visualization through histogram to perceive main trends.
Next Steps:
Introduction to creating histograms and exploring more about normal distributions.