Statistical Data Analysis using Microsoft Excel
Details
Date Event
19th to 23rd April 2021 Statistical Data Analysis using Microsoft Excel10th to 14th May 2021 Statistical Data Analysis using Microsoft Excel21st to 25th June 2021 Statistical Data Analysis using Microsoft ExcelVenue: FineResults Research Services, Nairobi, Kenya Training Centre.
Click to Register: Physical class USD 800
Contact us: email: [email protected] or Cell phone (+254 759 285 295)
INTRODUCTION
Microsoft Excel is a very powerful tool for statistical data analysis. In fact there are numerous instances when a data analyst does not require to use other specialized data analysis software such as SPSS, Stata, R, etc, as long as they have access to Microsoft Office Excel. This course will help improve participants' familiarity with Excel statistical functions and hence achieve great effectiveness and efficiency in research. The course describes how to use the Analysis ToolPack in Microsoft Excel, numerous statistical functions and data management techniques as applicable in most research endevours. An explanation of Excel limitation and how to overcome them will also be provided. Keen attention would be made in guiding participants on how to present results from Microsoft Excel data analysis as well as writing research reports.
DURATION
5 Days
COURSE OBJECTIVES
By the end of this training, participants will become knowledgeable in the following:
- Data management techniques using Microsoft Excel
- Descriptive statistics and methods of results interpretation and presentation.
- Multivariate methods of data analysis and subsequent methods of results interpretation and presentation.
- Selection of appropriate statistical model.
- How to present/communicate data analysis results.
Course Outline
Module 1:
Data management in Microsoft Excel
- Computing new variable information
- Protecting data in Microsoft Excel
- Generating variables through calculations
- How to remove unwanted characters in data
- How to compare data
- Finding and searching data in Excel
- Substituting and replacing data in Excel
- Outlining Data
- Sorting data
- Formatting text data into columns
- Cleaning of data using flash fill
- Detecting and removing duplicate data
- Selecting data that meets a certain criteria
Preparing data for analysis
- How to Create a Structured Reference Table
- Conditional formatting
- What-If Analysis
- Data Validation
- How to consolidate worksheet data
- Importing/Exporting data in/from Excel
- Pivot tables
- Using Excel data form to add, edit and delete records (rows) and display only those records that meet certain criteria.
- Using macros to automate Excel data management tasks
- Using Sparklines in Excel to graph data in cells.
Descriptive Statistics
Measures of Variability and Central Tendency
- Describing quantitative data
- Describing qualitative data
Excel Graphics
- Graphing quantitative data
- Graphing qualitative data
Module 2: Correlation, Chi-square and mean comparison analysis
Correlation
- Correlation
- Subgroup Correlations
- Scatterplots of Data by Subgroups
- Overlay Scatterplots
Chi-Square
- Goodness of Fit Chi Square All Categories Equal
- Goodness of Fit Chi Square Categories Unequal
- Chi Square for Contingency Tables
Comparing Means
- Confidence Interval for the Mean
- Test of Hypothesis Concerning the Population Mean
- Difference Between Mean of Two Populations
- One Sample t-tests
- Paired Sample t-tests
- Independent Samples t-tests
- Comparing Means Using One-Way ANOVA
Module 3: Important Excel functions
- Text Functions
- Logical Functions
- Information Functions
- Date and Time Functions
- Lookup and Reference Functions
- Math and Trig Functions
- Statistical Functions
- Other Functions
Module 4: Data Analysis (continued)
- Normal Distribution
- Regression Analysis
- Analysis of Covariance
Module 5: Analysing Data in Time and Forecasting
Analysing Data in Time
- Trends/Regression line
- Linear, Logarithmic, Polynomial, Power, Exponential, Moving Average Smoothing
- Seasonal fluctuations analysis
Forecasting
- Extrapolation
TRAINING CUSTOMIZATION
This training can also be customized for your institution upon request. You can also have it delivered your preferred location.
For further inquiries, please contact us through Mobile: (+254 759 285 295) or Email: [email protected]
REQUIREMENTS
Participants should be reasonably proficient in English. During the trainings, participants should come with their own laptops.
TRAINING FEE
The course fee covers the course tuition, training materials, two break refreshments, lunch, and study visits.
CANCELLATION POLICY
- All requests for cancellations must be received in writing.
- Changes will become effective on the date of written confirmation being received.
Visit our website for more details
VIEW RELATED COURSES
- Analysis of Complex Sample Survey Data using Stata
- Analysis of Qualitative Data using NVivo
- Analysis of Qualitative Data using QDA Miner
- Better and Timely Data Collection, Analysis and Visualization using ODK, SPSS/Stata/R and QGIS
- Data Collection and Processing using CSPro
- Discrete Choice modeling through theory and practice
- Effective Communication of Research Findings with Users of Knowledge for Impact
- Effective Data Collection, Management and Visualization
- Epidemiology and Bio-statistics using Stata
THE MOST POPULAR COURSES
- GIS using ArcGIS Desktop
- Effective Project Proposal and Report Writing
- Agriculture, Innovation and Technology for Sustainable Development
- Scientific Writing: Preparing a Manuscript for Publication in International Journals
- Effective B2B & Trade Marketing Strategies
- Accounting & Finance for Non-Financial Professionals using QuickBooks
- Post-Disaster Economic Recovery and Sustainable Livelihood Restoration
- Collection and management of Research data using ODK and Kobo Toolbox
- Developing and Leading High Performing Teams
Send proof of payment to [email protected]
View our Research Institute coursesFor any registration of 3 or more participants; we offer a discount of up to 10%.
Click here now to Register.For further inquiries email [email protected] or contact us on Tel: +254 759 285 295
FineResults Research Services offers training solutions to individuals, communities, governments and civil society organizations, both local and international.
We also provide application-oriented and field-based consultancy services in all aspects of research and evaluations from inception to completion. This includes research designs, designing monitoring and evaluations systems, technical reviews, programme evaluations, questionnaire validation, data collection, data capture, data analysis and report writing. FineResults Research Services is a limited company incorporated under the laws of Kenya. Its head office is in Nairobi Kenya.
The organization has a wide range of experience working with both local and international organizations in both consultancies and capacity building in Africa and beyond.
MissionA world class training and research organization for the realization of individuals, organizations and community welfare.
VisionTo provide world class training and research services that increase individuals and organizations productivity in their development role.
Our Value Statement- We cherish partnerships.
- We believe that our Training and Research Solutions can re-energise organisations by creating vision, certainty and strategic intent. ...