Statistical Analysis & Basics of Research Using Excel
7 Days Online Workshop Schedule
(12-18 June, 2021)
Day - 1
- Building Excel Foundation
- Fundamentals of Spreadsheets:
- Viewing, Entering, editing; Coding, Filling, and formatting Cells and Data;
- Introduction to formulas, Functions, Referencing Data in the Formulas
- Cleaning the Data:
- Importing File data; Removing Duplicate and inaccurate; empty rows; Dealing with inconsistencies; Filtering and sorting of data;
- Creating and editing Charts
- If functions, AND OR NOT Functions
- Creating Pivot table: Understanding; creating; Defining; filtering; clearing; switching; formatting; creating slicers and timeline filters.
- Understanding Excel Macros
Day - 2
- Building Excel Foundation- II
- If functions, AND OR NOT Functions
- Creating Pivot table: Understanding; creating; Defining; filtering; clearing; switching; formatting; creating slicers and timeline filters.
- Understanding Excel Macros
Day - 3
- Tool Development
- Art of Developing a Questionnaire (theory)
- Creating your own spreadsheet and entering data
Day - 4
- Descriptive Analysis and Hypothesis
- Descriptive analysis (Excel)
- Chi square test
- Hypothesis Development (theory)
Day - 5
- Hypothesis Testing -I
- Theory and Practical
- T-test (independent t- test and Paired t-test)
- Anova (one factor, two factor three way)
Day - 6
- Hypothesis Testing _II
- Theory and Practical
- Correlation and regression
- Multiple regression
Day - 7
- Concluding Day )
- Practice & Doubt Session
NOTE: E-CERTIFICATES WILL BE ISSUED TO THE PARTICIPANTS.
Registration Process
- Workshops Dates: 12-18 June, 2021
- Evening Timings: 6:30 PM to 8:00 PM
- Registration Charges: Rs 800/- INR Member
- Last Date of Registration: 10th June, 2021
For Online Registrations : Click Here
More Details: Click Here
For Latest Updates Join LISWORLD GROUP
Telegram Group : Click Here Whatsapp Group: Click Here
No comments:
Post a Comment
If you have any doubts,
please let me know