Mathematics Chapter 10 Homework Problem 10-17 Data Table Calculations Set

P10-17

Data Table

Calculations set to Manual. Press F9 to recalculate.

Month Begin Bal Income Expense End Bal Run End bal P(neg bal)

1 $1,500 $950 $1,000 $1,450

Income Probability RN intvl LL 1$400 0.0000

2 $1,450 $900 $800 $1,550 $850 0.35 0 2 $400 0.0000

3 $1,550 $900 $900 $1,550 $900 0.25 0.35 3 $450 0.0000

19 $300 0.0000

20 $200 0.0000

21 $200 0.0000

22 $300 0.0000

23 $500 0.0000

24 $50 0.0000

25 $850 0.0000

26 $750 0.0000

27 $750 0.0000

28 $50 0.0000

29 $300 0.0000

30 $300 0.0000

31 -$350 0.1667

32 $0 0.0000

33 $300 0.0000

Income Distribution

Problem 10-17

Page 1

P10-17

52 $750 0.0000

53 $200 0.0000

54 $600 0.0000

55 $300 0.0000

66 $350 0.0000

67 $600 0.0000

68 $250 0.0000

69 $200 0.0000

70 $350 0.0000

81 $750 0.0000

82 $200 0.0000

83 $150 0.0000

84 $450 0.0000

85 $600 0.0000

96 $650 0.0000

97 -$400 0.2500

98 $400 0.0000

99 $800 0.0000

100 $50 0.0000

P10-17

107 $450 0.0000

108 $450 0.0000

109 $50 0.0000

110 $850 0.0000

121 $850 0.0000

122 $300 0.0000

123 $850 0.0000

124 $650 0.0000

125 $650 0.0000

136 $950 0.0000

137 $550 0.0000

138 $300 0.0000

139 $750 0.0000

140 $450 0.0000

151 $250 0.0000

152 $800 0.0000

153 $300 0.0000

154 $250 0.0000

155 -$50 0.0833

P10-17

162 $550 0.0000

163 $450 0.0000

164 $200 0.0000

165 $100 0.0000

176 -$50 0.2500

177 $650 0.0000

178 -$250 0.1667

179 $350 0.0000

180 $350 0.0000

191 $500 0.0000

192 $700 0.0000

193 $100 0.0000

194 $700 0.0000

Page 4