3 EXERCISES STATISTICS PROBABLITY
Joss_Smitx01
CHAP2.xlsxSheet1
| Month | Qty | Costs(000) | Sales(000) | Cost Per Unit | Profit | Profit/unit | |
| Jan | 15000 | $1,250.00 | $2,340.00 | $0.08 | $1,090.00 | $0.07 | RED |
| Feb | 16400 | $1,620.00 | $1,952.00 | $0.10 | $332.00 | $0.02 | RED |
| Mar | 13625 | $1,467.00 | $1,675.00 | $0.11 | $208.00 | $0.02 | GREEN |
| Apr | 13020 | $1,585.00 | $2,102.00 | $0.12 | $517.00 | $0.04 | GREEN |
| May | 17025 | $1,652.00 | $2,054.00 | $0.10 | $402.00 | $0.02 | RED |
| Jun | 11250 | $1,340.00 | $1,875.00 | $0.12 | $535.00 | $0.05 | GREEN |
| Jul | 12345 | $1,236.00 | $1,457.00 | $0.10 | $221.00 | $0.02 | RED |
| Aug | 18024 | $1,784.00 | $1,640.00 | $0.10 | -$144.00 | -$0.01 | RED |
| Sep | 14695 | $1,565.00 | $1,987.00 | $0.11 | $422.00 | $0.03 | GREEN |
| Oct | 16874 | $1,675.00 | $2,014.00 | $0.10 | $339.00 | $0.02 | RED |
| Nov | 19785 | $1,895.00 | $2,650.00 | $0.10 | $755.00 | $0.04 | RED |
| Dec | 20102 | $1,874.00 | $2,540.00 | $0.09 | $666.00 | $0.03 | RED |
| 12 | 188145 | 18943 | 24286 | 1.2215330041 | 5343 | ||
| 0.0833333333 | 1090 | ||||||
| 15678.75 | 1578.5833333333 | 2023.8333333333 | $0.10 | 445.25 | 0.0290886564 | ||
| 15700 | 1602.5 | 2000.5 | 0.0991221403 | 412 | 0.0261647928 | ||
| 2846.5427555354 | 221.7527117118 | 354.7818365068 | 0.0106748549 | 309.5301791719 | 0.0198443794 | ||
| 0.1815541899 | 0.1404757716 | 0.1753019039 | 0.1048668008 | 0.6951828842 | 0.6822033676 | ||
Column chart for Costs(000)
Costs(000) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1250 1620 1467 1585 1652 1340 1236 1784 1565 1675 1895 1874Bar chart for Sales(000)
Sales(000) Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2340 1952 1675 2102 2054 1875 1457 1640 1987 2014 2650 2540Line Chart for cost per unit, profit
Cost Per Unit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 8.3333333333333329E-2 9.8780487804878053E-2 0.1076697247706422 0.121 73579109062981 9.7033773861967695E-2 0.11911111111111111 0.10012150668286755 9.8979138925876606E-2 0.10649880911874787 9.9265141638022997E-2 9.5779631033611326E-2 9.3224554770669585E-2 Profit Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 1090 332 208 517 402 535 221 -144 422 339 755 666Scatter diagram for Profit
Profit 1090 332 208 517 402 535 221 -144 422 339 755 666
