corrinc - >90 Target#1(Value)= 4 Target#1(Perc)= 35.72...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Net Income Consolidation with correlation Goal is 4 billion! Mean Std. Dev Actual 1 LA 0.4 0.1 #ADDIN? #ADDIN? 2 NAO 2 0.4 #ADDIN? #ADDIN? 3 Europe 1.1 0.3 #ADDIN? #ADDIN? 4 Asia 0.8 0.3 #ADDIN? #ADDIN? Total!! #ADDIN? #ADDIN? Correlations LA NAO Europe Asia LA 1 0.6 0.7 0.5 NAO 0.6 1 0.6 0.4 Europe 0.7 0.6 1 0.5 Asia 0.5 0.4 0.5 1 Name Total!! / Actual Description Output Cell E8 Minimum = 1.86 Maximum = 6.71 Mean = 4.3 Std Deviation = 0.9 Variance = 0.8 Skewness = -5.82E-02 Kurtosis = 2.89 Errors Calculated = 0 Mode = 4.47 5% Perc = 2.76 10% Perc = 3.19 15% Perc = 3.36 20% Perc = 3.55 25% Perc = 3.72 30% Perc = 3.85 35% Perc = 3.97 40% Perc = 4.08 45% Perc = 4.17 50% Perc = 4.31 55% Perc = 4.41 60% Perc = 4.53 65% Perc = 4.63 70% Perc = 4.78 75% Perc = 4.91 80% Perc = 5.04 85% Perc = 5.22 90% Perc = 5.46 95% Perc = 5.76 Filter Minimum = Filter Maximum = Type (1 or 2) = # Values Filtered = 0 0 0 0 0 Scenario #1 = >75% Scenario #2 = <25% Scenario #3 =
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: >90% Target #1 (Value)= 4 Target #1 (Perc%)= 35.72% 36% chance we fail to meet target A B C D E F G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 Name Total!! / ActLA / ActualNAO / ActuEurope / AcAsia / Actual DescriptionOutput Normal(C4,Normal(C5 Normal(C6,Normal(C7,D7) Iteration# /E8 E4 E5 E6 E7 LA NAO Europe Asia 1 4.8 0.48 2.2 1.35 0.78 LA 1 2 4.13 0.44 1.7 1.18 0.81 NAO 0.59 1 3 6.13 0.5 2.45 1.91 1.27 Europe 0.7 0.59 1 4 6.55 0.58 2.42 1.97 1.57 Asia 0.5 0.4 0.5 1 5 3.06 0.32 1.52 0.97 0.25 6 5.32 0.49 2.29 1.08 1.46 899 4.74 0.47 2.2 1.47 0.6 900 4.9 0.51 2.24 1 1.15 A B C D E F G H I J K L 1 2 3 4 5 6 7 8 9 10 11 12 13 14 907 908...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

corrinc - >90 Target#1(Value)= 4 Target#1(Perc)= 35.72...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online