#### Go to HomeTreks Home

Note: Going home clears all of these panels.

#### Synchronize panels by clicking the panel directional buttons found at the top of the panel.

Get
M and E Nutrition Distribution, Stats and Changes

#### Output Statistical Analysis

Introduction
This tool generates a variety of basic statistics for DevTreks standard monitoring and evaluation uris. The analyses include basic progress in achieving actual versus target levels for monitoring and evaluation indicators.

Analysis View Description
This analysis supports a DevTreks tutorial. v172a

Version: 0.9.8

Compare Using:
Aggregate Using:

#### Step 3 of 3. Save

Method 1. Do you wish to save step 2's calculations? These calculations are viewed by opening this particular calculator addin.

Method 2. Do you wish to save the analysis as comma-separated, column-row, text? This format is amenable to further analysis in standard statistical packages. The text can be downloaded by packaging and downloading this uri.

#### Step 1

• Step 1. Monitoring and Evaluation Stage: Some groups may prefer to store all of their baseline, target, and actual indicators results in one analysis. The advantage is that one operation and one input can be used to store benchmark, target, and actual indicator measurements. Other groups may prefer to break the analysis into stages, such as baseline, midterm, and final. The latter requires adding stage-related indicators to specific operations with specific inputs.
• Step 1. Base Calculations To Analyze: Make sure that the data being analyzed corresponds to outputs.
• Step 1. Analysis Type: A video overview of these options is available. The Progress 1 option supports Percent Complete and Weighted Milestone analyis. The Statistics 1 option supports Total, Mean, Median, Variance, and Standard Deviation statistics. The Change by Year option supports Total Change, and Percent Change, analysis.

#### Step 2 and 3

• Step 2. What If Tag Name: Instructional videos explaining the use of what-if scenario calculations should be viewed before changing or using this parameter.
• Step 2. Base Resource Calculations To Analyze: Make sure that the calculator chosen has been used with the data being analyzed.
• Step 2. Compare Using: The Compare Only option uses a calculator's Alternative Type property to further "subdivide" the indicator data being analyzed to support the comparative analysis of alternatives.
• Step 2. Aggregate Using: Types is the least detailed analysis. Groups is the next most detailed analysis. Labels can be the most detailed, but all of the data being analyzed must have been classified using labels and Work Breakdown Structures.
• Step 3. Save Using: The Save command saves xml data the Save Text command saves csv data.

#### Progress 1 Results

• Partial Target Totals Only: The results show the cumulative totals for each indicator's partial targets. Each indicator is identified by a unique label (preferably a WBS label).
• Type: The indicator's Alternative Type: benchmark, actual, partialtarget, fulltarget.
• Actual Total: The actual quantity of the indicator completed during this partial target period.
• Actual Date: The date of the last 'actual' indicator included in the Actual Total.
• Benchmark Total: The starting quantity of the indicator prior to any project intervention.
• Benchmark Percent: (Actual Total / Benchmark Total) * 100. Zero if the Benchmark Total is zero.
• Partial Target Date: The date of this 'partial target' indicator.
• Partial Target Total: The target quantity of the indicator for this partial period.
• Partial Target Percent: (Actual Total / Partial Target Total) * 100. Zero if the Partial Target Total is zero.
• Full Total: The target quantity of the indicator for the full project period.
• Full Percent: (Actual Total / Full Total) * 100. Zero if the Full Total is zero. Note that the Actual Total is only for this partial period. Derive the percent for the full target period by adding together all of this indicator's Full Percents.

#### Change by Year or Label Results

• Name, Type, Date, Label: Taken from the first indicator with the same label and or year.
• Benchmark Total: The Benchmark Total is the initial amount of the indicator being measured that has an Target Type property of Benchmark (regardless of the year).
• Actual Total: The summation of all of the indicators for the same year except for the Benchmark.
• Benchmark Change: The is measured as Actual Total – Benchmark Total for Year x.
• Benchmark Percent Change: This is measured as Actual Total / Benchmark Total for Year x.
• Total Change: This is measured as Year x+1 Total – Year x Total.
• Total Percent Change: This is measured as Total Change / Year x Total.

#### Statistics 1 Results

• Name, Type, Date, Label: Taken from he first indicator. The analysis ignores the type.
• Observations: The number of observations
• Total, Mean, Median, Variance, Standard Deviation: Standard sample statistics for the indicators that have been aggregated (using their labels).

#### References

• International Federation of Red Cross and Red Crescent Societies Project/programme monitoring and evaluation (MandE) guide. 2011. (www.ifcr.org)
• US Government Accountability Office Applied Research and Methods. GAO Cost Estimating and Assessment Guide. Best Practices for Developing and Managing Capital Program Costs. March, 2009.
• United Nations Development Programme Handbook on Planning, Monitoring and Evaluating for Development Results. 2009

#### Reminder: Analyzers require running the underlying NPV calculator after inserting, deleting, or updating, this linked view (that keeps the NPV calculator's linked views synchronized with these linkedviews).

Current view of document
DevTreks -social budgeting that improves lives and livelihoods
Output Group
M and E Nutrition Distribution, Stats and Changes
Monitoring and Evaluation Type: realtime
Output
2013 Number of children examined for malnutrition
Monitoring and Evaluation Type: final
Output Series
2012 Number of children examined for malnutrition, Project 01
Unit Total Observ Mean Median Variance Stand Dev
Q1 Unit Q1 Total Q1 Observ Q1 Mean Q1 Median Q1 Variance Q1 Stand Dev
Q2 Unit Q2 Total Q2 Observ Q2 Mean Q2 Median Q2 Variance Q2 Stand Dev
Q1 malnourished children examined
0123A proportion children 03/15/2012
proportion children 3.553 24.000 0.148 0.097 0.024 0.156
children 358800.000 24.000 14950.000 10100.000 241812173.913 15550.311
children population 2440000.000 24.000 101666.667 100500.000 5949275.362 2439.114
This indicator measures the Q1 proportion of malnourished children examined during the malnutrition improvement program.
Output Series
2012 Number of children examined for malnutrition, Project 02
Output Series
2012 Number of children examined for malnutrition, Project 03
Output Series
2013 Number of children examined for malnutrition, Project 01
Output Series
2013 Number of children examined for malnutrition, Project 02
Output Series
2013 Number of children examined for malnutrition, Project 03
Output
2013 Number of food nutrient packages distributed
Unit Total Observ Mean Median Variance Stand Dev
Q1 Unit Q1 Total Q1 Observ Q1 Mean Q1 Median Q1 Variance Q1 Stand Dev
Q2 Unit Q2 Total Q2 Observ Q2 Mean Q2 Median Q2 Variance Q2 Stand Dev
Q1 food nutrient packages delivered
0122A proportion families 03/15/2013
proportion families 2.800 4.000 0.700 0.700 0.067 0.258
families 285000.000 4.000 71250.000 70000.000 772916666.667 27801.379
population families 405000.000 4.000 101250.000 100000.000 6250000.000 2500.000
This indicator measures the Q1 proportion of families with malnourished children that received the minimal number of food nutrient packages each week.
Monitoring and Evaluation Type: final
Q1 food nutrient packages delivered
0122A proportion families 03/15/2013
proportion families 2.800 4.000 0.700 0.700 0.067 0.258
families 285000.000 4.000 71250.000 70000.000 772916666.667 27801.379
population families 405000.000 4.000 101250.000 100000.000 6250000.000 2500.000
This indicator measures the Q1 proportion of families with malnourished children that received the minimal number of food nutrient packages each week.
Output Series
2012 Number of food nutrient packages distributed
Unit Total Observ Mean Median Variance Stand Dev
Q1 Unit Q1 Total Q1 Observ Q1 Mean Q1 Median Q1 Variance Q1 Stand Dev
Q2 Unit Q2 Total Q2 Observ Q2 Mean Q2 Median Q2 Variance Q2 Stand Dev
Q1 food nutrient packages delivered
0122A proportion families 03/15/2012
proportion families 6.282 9.000 0.698 0.800 0.045 0.213
families 635000.000 9.000 70555.556 80000.000 503027777.778 22428.281
population families 907000.000 9.000 100777.778 100000.000 2944444.444 1715.938
This indicator measures the Q1 proportion of families with malnourished children that received the minimal number of food nutrient packages each week.
Output Series
2013 Number of food nutrient packages distributed
These outputs are used to test Statistics and Annual Change indicator calculations.