even further. The Z tables can now be used, but it must first be calculated. The equation to use for calculating the Z is:Xi - X / STD = Z By calculating the Z, and assuming a normal distribution, the Z tables are used to find the percentage of time the funds fell below 15 %. The following calculations are for the remaining funds:M1:15–15.43 / 8.8 = Z = -.05Table percentage is 48.01% A1:15-17.80 / 12.3 = Z = -.31Table percentage is 37.83 %A2:15-16.94. / 12.4 = Z = -.24Table percentage is 40.52 %The given calculations show that the return on the selected funds, returned less than 15 % at least 37.83 % of the time. Data Calculations ResultsTable 1. Returns for Conservative fund one and two 19881989199019911992199319941995199619971998C110.412.818.415.03.08.211.38.013.27.310.7C210.914.024.215.92.58.713.710.217.98.011.6AVGSTDRANGEC110.754.1615.40C212.505.7021.70Graph 1. Returns for Conservative fund one and twoTable 2. Returns for Secure fund one and two19881989199019911992199319941995199619971998S118.210.223.718.97.812.023.04.421.28.08.2S216.39.327.819.10.512.815.31.427.92.713.1AVGSTDRANGES114.156.9719.30S213.309.5027.40Graph 2. Returns for Secure fund one and twoTable 3. Returns for Moderate fund one and two19881989199019911992199319941995199619971998M114.510.029.723.211.616.019.70.829.57.67.5M221.914.427.217.66.415.728.24.527.66.64.5AVGSTDRANGEM115.438.8728.90M212.5021.7023.70Graph 3. Returns for Moderate fund one and twoTable 4. Returns for Balanced fund one and two19881989199019911992199319941995199619971998B129.29.224.717.32.321.822.81.420.87.77.5B221.58.923.213.27.812.724.82.325.69.211.9AVGSTDRANGEB114.979.2027.80B214.647.5023.30Graph 4. Returns for Balanced fund one and twoTable 5. Returns for Ambitious fund one and two19881989199019911992199319941995199619971998A136.26.332.411.82.914.722.93.538.610.815.8A227.32.633.514.73.415.132.8-6.124.113.825.2AVGSTDRANGEA117.8012.3035.70A216.9412.4039.60Graph 5. Returns for Ambitious...
