Curriculum
Introduction to Data Analysis with R
1. Introduction to Data Analysis
0/2
2. Data Import and Data Wrangling
0/4
3. Exploratory Data Analysis (EDA)
0/4
4. Data Visualization with R and Excel
0/4
5. Statistical Analysis with R and Excel
0/4
6. Advanced Data Analysis Techniques
0/2
7. Model Evaluation & Validation(Conceptual)
0/2
8. Case Study & Project Prep
0/2
9. Final Project
0/2
10. Research
0/0
Text lesson
2. Data Import in Excel
Data Import in Excel
Lesson Summary:
This week, you will focus on bringing data into Excel and preparing it for analysis. You will learn to:
-
Import CSV, Excel, and text files into Excel.
-
Check and adjust data types (dates, numbers, text) to ensure accuracy.
-
Clean datasets by handling missing values, removing duplicates, and standardizing entries.
-
Save and document your cleaned datasets for future use.
By the end of this week, you will be able to confidently import, inspect, and clean datasets in Excel, laying the foundation for analysis.