Data Analysis with R Statistics in Kigali 5th-7th Dec

R is the language of big data—a statistical programming language that helps describe, mine and test relationships between large amounts of data. Learn how to Model statistical relationships using graphs, calculations, tests, and other analysis tools. Learn how to enter and modify data; create charts, scatter plots, and histograms; examine outliers; calculate correlations; and compute regressions, bivariate associations, and statistics for three or more variables.

We will pick you from the bottom, install R in your computer, show you how to use built-in datasets, import your own data into the programme,create charts from bar…pie.hitogram to boxplots. We will also show you how to run frequencies and descriptives, transform variable as well as coding missing data. You will also learn how to analyze subgroups, create charts of association, calculate correlations, create charts and statistics for three or more variables and finish with creation of crosstabs for categorical variables.

Pre-requisetes:

Trainees are expected to have a basic understanding of statistics.

The 3 day training will be enough to get you comfortable with R Statistics.

1.       The preliminaries

a.       Installing R on your computer

b.      Using RStudio

c.       Familiarizing with the R interface

d.      R packages

e.      The built-in R datasets  

f.        Manual data entry

g.       Importing data

h.      Converting tabular data to row data

i.         Colours and R

j.        The Colorbrewer

2.       One Variable Charts

a.       Bar charts for categorical variables

b.      Pie charts for categorical variables

c.       Histograms for quantitative variables

d.      Box plots for quantitative variables

e.      Overlaying plots

f.        Saving images

3.       One Variable Statistics

a.       Calculating frequencies

b.      Calculating descriptives

c.       Single proportion: Hypothesis test and confidence interval

d.      Single mean: Hypothesis test and confidence interval

e.      Single categorical variable: One sample chi-square test

f.        Examining robust statistics for univariate analyses

4.       Data modification

a.       Examining outliers

b.      Transforming variables

c.       Computing composite variables

d.      Coding missing data

e.      Quiz

5.       Working with the Data File

a.       Case selection

b.      Subgroup analysis

c.       Merging files

6.       Charts for Associations

a.       Bar charts of group means

b.      Grouped box plots

c.       Scatter plots

7.       Association statistics

a.       Correlation

b.      Computing a bivariate regression

c.       Comparing means with the t-test

d.      Comparing paired means- Paired t-test

e.      Comparing means with a one-factor ANOVA

f.        Comparing proportions

g.       Creating cross tabs for categorical variables

h.      Computing robust statistics for bivariate associations

8.       Charts for Three or More Variables

a.       Clustered bar charts for means

b.      Scatter plots for grouped data

c.       Scatter plot matrices

d.      3D scatter plots

9.       Statistics for Three or More Variables

a.       Multiple regression

b.      Comparing means with a two-factor ANOVA

c.       Cluster analysis

d.      Conducting a principal components/factor analysis  

The 3 day course costs 350$ (305,000 FRW), Exclusive of a 18% V.A.T, The Cost includes all training fees, materials, lunch and refreshments as well as certificates and 6 month post training support.

Event Details

Event Date	05-12-2018 8:30 am
Event End Date	07-12-2018 4:00 pm
Cut off date	28-11-2018
Individual Price	350$ Per Delegate
Location	OpenCastLabs Training Facilities, Kigali Rwanda

How to register:

To register, send an email to: outreach@opencastlabs-africa.com You can also visit our website on www.opencastlabs-africa.com  and fill an online application form and submit to us.

Contact Details:

Rwanda:

P.O Box 4543 Kigali

3^rd Floor La Bonne Address House

Avenue de la Revolution

Tel:  Kigali +250 788 470 532

The Training Coordination Office (Joab/Gladys)
Capacity Building Division
Argwings Kodhek Road, opposite YAYA Center
P.o Box 30225 - 00100 , Nairobi, Kenya
Tel: +254 0204409651   Mobile: +254 723870644
Email : outreach@opencastlabs-africa.com

Language

Participants should be reasonably proficient in English.  

Fee Exceptions

All international participants will cater for their, travel expenses, visa application, insurance, accommodation and other personal expenses.

Accommodation

Accommodation is arranged upon request. For reservations contact us below.

Email: outreach@opencastlabs-africa.com

Payment:

Payment should be transferred through bank 5 days before commencement of training.

Cancellation policy

• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.
• The appropriate cancellation charge will apply

Data Analysis with SPSS in Kigali 5th-7th Dec

In this course we take you through practical sessions of data analysis in SPSS from the basics. We adopt a non-mathematical approach by taking a real life business, research, government and academic organizational perspective. We will dwell in the importation of data from excel, creation of descriptive charts, modifying and selecting cases, calculating descriptive and inferential statistics. We will also tackle modeling of associations with correlations, contingency tables and multiple regressions. We will also learn how to format our output and export tables and charts.

Course overview

Introduction

• ·         Familiarizing with the SPSS interface
• ·         Importing data from excel

Creating charts for one variable

• ·         Creating bar charts for categorical variables
• ·         Creating boxplots for quantitive variables
• ·         Creating an histogram for quantitive variables

Data modification

• ·         How to recode variables
• ·         How to recode variables with visual binning
• ·         How to recode by rank case
• ·         Computing new variables
• ·         Combining and exclusion of outliers
• ·         How to transform outliers

The data file

• ·         Case selection
• ·         The splitfile command
• ·         How to merge files
• ·         The multiple response command

Descriptive statistics for one variable

• ·         Working with frequencies
• ·         Working with descriptives
• ·         The explore command

Inferential statistics for one variable

• ·         Inferential statistics for a single propotion
• ·         Inferentials for a single mean
• ·         Inferentials for a single categorical variable

Charts for two variables

• ·         Clustered bar charts
• ·         Scatterplots
• ·         Time series charts
• ·         Bar charts for group means
• ·         Population pyramids
• ·         Boxplots for groups
• ·         Side-by-side boxplots

Descriptive and inferential statistics for two variables

• ·         Calculating correlations
• ·         Bivariate regression
• ·         Crosstabs for categorical variables
• ·         Comparing means with the means procedure
• ·         Mean comparison with t test
• ·         Mean comparison with one way ANOVA
• ·         Comparing paired means

Charts for three or more variables

• ·         Clustered bar charts for frequencies
• ·         Scatterplots by group
• ·         3-D scatterplots
• ·         Scatterplot matrices

Descriptives for three or more variables

• ·         Automatic linear models
• ·         Multiple regression
• ·         Comparing means with two-factor ANOVA

Formatting and Exporting tables and charts

• ·         Formatting descriptive statistics
• ·         Formatting correlations
• ·         Formatting regression
• ·         Exporting charts and tables

The 3 day course costs 350$ (305,000 KES), Exclusive of a 18% V.A.T, The Cost includes all training fees, materials, lunch and refreshments as well as certificates and 6 month post training support.

Event Details

Event Date	5-12-2018 8:30 am
Event End Date	7-12-2018 4:00 pm
Cut off date	28-11-2018
Individual Price	350$ Per Delegate
Location	OpenCastLabs Training Facilities, Kigali Rwanda

How to register:

To register, send an email to: outreach@opencastlabs-africa.com You can also visit our website on www.opencastlabs-africa.com  and fill an online application form and submit to us.

Contact Details:

Rwanda:

P.O Box 4543 Kigali

3^rd Floor La Bonne Address House

Avenue de la Revolution

Tel:  Kigali +250 788 470 532

The Training Coordination Office (Joab/Diana)
Capacity Building Division
Argwings Kodhek Road, opposite YAYA Center
P.o Box 30225 - 00100 , Nairobi, Kenya
Tel: +254 0204409651   Mobile: +254 723870644
Email : outreach@opencastlabs-africa.com

Language

Participants should be reasonably proficient in English.  

Fee Exceptions

All international participants will cater for their, travel expenses, visa application, insurance, accommodation and other personal expenses.

Accommodation

Accommodation is arranged upon request. For reservations contact us below.

Email: outreach@opencastlabs-africa.com

Payment:

Payment should be transferred through bank 5 days before commencement of training.

Cancellation policy

• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.
• The appropriate cancellation charge will apply

Advanced Report Development with MS Excel in Kigali 5th-7th Dec

Excel has a number of useful built in functions, but there are also some caveats about its computations. For this reason and to facilitate more flexibility, in this course we shall demonstrate some handcrafted techniques to help the delegates manage large data sets and improve their reporting efficiency.

The course sessions shall focus on how to effectively and efficiently utilize Microsoft Excel for data management, modeling and projection with a positive bias to lookups. Users will not only use Excel to build models, but also to crunch a large data dump. Learn how to minimize as much manual labor as possible, thereby saving time and performing more detailed analysis and projections quickly. Apply

commonly-used formulas in new and different ways; uncover often over-looked Excel features; streamline number crunching with pivot tables, functions, arrays, Data tools, Formatting, Macros and VBA programming.

Course Description:**

This course shows how spreadsheets can be used to enhance management reporting.

The course shows how to analyze and review data extracted from ERP systems and databases in order to prepare management reports, including using Excel’s graphing capabilities. The course studies Excel’s functions and how to use these effectively. The program also shows how to access the Visual Basic Editor and use macros and user defined functions in order to enhance Excel’s functionality. Half a day will also be spent showing attendees how to use Excel’s pivot table functionality. Pivot tables are often poorly understood and yet are the most powerful feature in Excel. A basic pivot table will allow you to summarize 50,000 rows of data in 30 seconds.

The course is highly practical: delegates will be exposed to examples (in Microsoft Excel) throughout the course.

Methodology

The course is highly interactive, and formal lecture content is kept to a minimum. Spreadsheet techniques are explained and demonstrated by using extensive case studies, adhering closely to real life examples. Throughout the program emphasis is laid on the importance of reality-checking and the dangers of spreadsheet blindness, on a fundamental understanding of key issues and on the skills of communicating conclusions from spreadsheet techniques to colleagues and partners.

Delegates will be expected to be highly participative and motivated to learn, and to express their needs and priorities clearly.

Knowledge Pre-Requisites

Attendees will be expected to be using Excel in the context of a reporting related role and be comfortable with using Excel for data entry. A basic knowledge of Excel 2007 and later will therefore be assumed, but if delegates need a refresher on specific items then, time permitting, the course director will try and meet their needs. The course is also suitable for all senior professionals who may not have had specific spreadsheet training in reporting, analysis, modeling and forecasting, who have developed their skills over time and who would like to develop a broader knowledge of what Excel can offer, as well as reassurance about their existing spreadsheet techniques.

Candidates ideally should bring their own computers with Excel 2007 or later loaded in order to benefit from the course

Course Details:

1.      Analyzing Data

·         Using Automatic Outlining

·         Consolidating Information by Position or Category

·         Inserting Subtotals

·         Creating an Advanced Filter

·         Using Database Functions

2.      Data Management

·         Importing Data from a Text File

·         Exporting Data

·         Converting Text to Columns

·         Connecting to Data in an Access Database

·         Creating a Web Query

·         Importing Web Data using a Saved Query

·         Working with Hypertext Links

3.      Fundamentals of Excel Pivoting

·         Understanding PivotTables

·         Creating a PivotTable using Worksheet Data

·         Creating a PivotTable using an External Data Connections

·         Laying out a PivotTable on a Worksheet

·         Modifying PivotTable Fields

·         Using a Report Filter

·         Refreshing a PivotTable

·         Formatting a PivotTable

4.      Enhancing PivotTables

·         Working with Summary Functions

·         Sorting Items in a PivotTable

·         Creating a Slicer

·         Grouping Data

·         Applying Label and Value Filters

·         Creating a Calculated Field

·         Creating a Calculated Item

·         Creating Charts from PivotTables

5.      Excel Business Analysis

·         Creating Scenarios

·         Working with Scenarios

·         Using Goal Seek

·         Using One-Input Data Tables

·         Using Two-Input Data Tables

·         Understanding Solver

·         Defining a Problem

·         Solving a Problem

·         Generating a Report of Results and Alternate Solutions

6.      Forecasting, Charting and Dashboards

·         Inserting chart Trendline

·         Choosing the right Trendline for the right data

·         Linear forecasting

·         Relationship equations for projection

·         Using Excel for Budgeting

·         Budgeting best practices Building & Linking Budgets

7.      Advanced Formulas and Functions

·         Working with Functions

·         Using the IF Function

·         Nesting Functions

·         Using Multiple Conditions with the IF Function

·         Using Table Lookup Functions (HLookup and VLookup)

·         Using Text Functions

8.      Business Intelligence Fundamentals

·         Introduction to excel PowerBI tools• Importing Data

·         Transforming, cleansing and Filtering Data

·         Merging and Shaping Data

·         Grouping and Aggregating Data

·         Inserting Calculated Columns

9.      Excel automation

·         Recording a Macro

·         Saving a Macro-Enabled Workbook

·         Executing a Macro

·         Creating a Macro Button

·         Working with Macro Buttons

The 3 day course costs 240,000 FRW, Exclusive of a 18% V.A.T, The Cost includes all training fees, materials, lunch and refreshments as well as certificates and 6 month post training support.

Event Details

Event Date	05-12-2018 8:30 am
Event End Date	07-12-2018 4:00 pm
Cut off date	28-11-2018
Individual Price	$300.00  (240,000 FRW)
Location	OpenCastLabs Training Facilities, Kigali Rwanda

How to register:

To register, send an email to: outreach@opencastlabs-africa.com You can also visit our website on www.opencastlabs-africa.com  and fill an online application form and submit to us.

Contact Details:

Rwanda:

P.O Box 4543 Kigali

3^rd Floor La Bonne Address House

Avenue de la Revolution

Tel: Kigali +250 788 470 532

The Training Coordination Office (Joab/Diana)
Capacity Building Division
Argwings Kodhek Road, opposite YAYA Center
P.o Box 30225 - 00100 , Nairobi, Kenya
Tel: +254 0204409651   Mobile: +254 723870644
Email : outreach@opencastlabs-africa.com

Language

Participants should be reasonably proficient in English.  

Fee Exceptions

All international participants will cater for their, travel expenses, visa application, insurance, accommodation and other personal expenses.

Accommodation

Accommodation is arranged upon request. For reservations contact us below.

Email: outreach@opencastlabs-africa.com

Payment:

Payment should be transferred through bank 5 days before commencement of training.

Cancellation policy

• All requests for cancellations must be received in writing.
• Changes will become effective on the date of written confirmation being received.
• The appropriate cancellation charge will apply