Excel toolbox

# 4.1 Conducting analyses with the data analysis tool pack

The data analysis tool pack provides access to a number of statistical analysis tools. It is part of Excel add-ins that are not enabled by default.

Before first use, it must therefore be activated:

Under the File tab, select the Options item, then in the window that opens, choose Add-ins and click the Go button at the bottom of the window. In the new Add-ins available window, check Analysis ToolPak and click OK. Once installed, the tool pack can be accessed from the Data tab in the Analysis section.

The analysis tool consists of 19 statistical tools that can generate descriptive statistics such as mean, median, mode and standard deviation. It is also possible to make histograms.

The following exercices are only available on the French page at this stage- translation coming soon!

In order to practice using the Excel analysis tool pack, here is a practical exercise using clean data from the case study - developed by CartONG as part of the Data Analysis Toolbox publication. A more complete presentation of this case study can be found in the “Data Analysis Toolbox” – Part “7 The case study ”.

In this example, we propose to generate descriptive statistics for:

• The age of household members
• The Food Consumption Score (FCS) of households

Use the [“Excel Toolbox - Analysis 4.1 - Practice exercise - V1 - Statement”] file to practice using the Excel data analysis tool pack.

In case of difficulties, or to compare your results with those of the case study, refer to the file [“Excel Toolbox - Analysis 4.1 - Practical exercise - V1 – Solutions”].

The data analysis tool pack also allows a correlation analysis to be conducted (for more details, see section “4.5 Correlation analysis”). In order to practice using the potential correlation between 2 variables, by using the data analysis tool pack (Bonus 2), here is a practical exercise using clean data from the case study - developed by CartONG as part of the Data Analysis Toolbox publication. A more complete presentation of this case study can be found in the “Data Analysis Toolbox” – Part “7 The case study ”.

In this example, we propose to generate analyses of the correlation between the average duration of food security assistance (for a household) and the size of the household.

Use the [“Excel Toolbox - Analysis 4.5 - Practice exercise - V1 - Statement”] file to practice correlation analysis.

In case of difficulties, or to compare your results with those of the case study, refer to the file [“Excel Toolbox - Analysis 4.5 - Practical exercise - V1 – Solutions”].