Excel Project

profilepie18k
Excelproject-studentfile1.xlsx
Home>Information Systems homework help>Excel Project

Sheet1

Customer Beginning Balance Credits Payments Purchases Service Charge New Balance Interest rate
Lanctot, Royce 378.81 48.55 126.15 211.38 9.35 424.84 3.75%
Raglow, Dora 710.99 55.62 231.37 274.71 1.95 700.66
Cervantes, Katriel 803.01 56.92 277.02 207.94 1.99 679.00
Kalinowski, Jadwiga 438.37 60.90 331.10 190.39 2.13 238.89
Danielsson, Oliver 411.45 79.33 180.09 364.02 2.78 518.83
Tuan, Lin 318.86 85.01 129.67 332.89 2.98 440.05
Cummings, Trenton 285.05 87.41 182.11 218.22 3.06 236.81
Totals 3,346.54 473.74 1,457.51 1,799.55 24.24 3,239.08
Maximums $ 803.01 $ 87.41 $ 331.10 $ 364.02 $ 9.35 $ 700.66
Minimums $ 285.05 $ 48.55 $ 126.15 $ 190.39 $ 1.95 $ 236.81
Averages $ 478.08 $ 67.68 $ 208.22 $ 257.08 $ 3.46 $ 462.73

Sheet2

AGE Birth Weight Weight Condition
19 2000
33 2551
20 2557
18 2600
21 2622
22 2637
17 2637
29 2663
26 2665
19 2722
19 2733
22 2750
30 2750
18 2769
15 2778
25 2782
20 2807
28 2821
32 2835
31 2835
36 2836
28 2863
25 2877
28 2877
29 2920
26 2920
17 2920
17 2920
24 2948
35 2948
25 2977
25 2977
29 2977
19 2977
27 2992
20 2055
25 2055
19 2082
19 2084
26 2084
17 2125
20 2126
22 2187
27 2187
20 2211
17 2225
25 2240
20 2240
18 2282
18 2296
20 2296
21 2301
26 2325
31 2353
15 2353
23 2367
20 2381
24 2381
15 2381
23 2395
30 2410
22 2410
17 2414
23 2424
17 2438
26 2442
20 2450
26 2466
14 2466
28 2466
14 2495
23 2495
17 2495
21 2495
18 4001
26 4054
21 4054
22 4111
25 4153
31 4167
35 4174
19 4238
24 4593
45 4990
24 4023
21 3222
31 3005
33 3033
21 3042
19 3062
23 3062
21 3062
18 3076
18 3076
32 3080
19 3090
24 3090
22 3090
22 3100
23 3104
22 3132
30 3147
19 3175
16 3175
21 3203
30 3203
20 3203
17 3225
17 3225
23 3232
24 3232
28 3234
26 3260
20 3274
24 3274
28 3303
20 3317
22 3317
22 3317
31 3321
23 3331
16 3374
16 3374
18 3402
25 3416
32 3430
20 3444
23 3459
22 3460
32 3473
30 3475
20 3487
23 3544
17 3572
19 3572
23 3586
36 3600
22 3614
24 3614
21 3629
19 3629
25 3637
16 3643
29 3651
19 3651
19 3651
30 3699
24 3728
19 3756
24 3770
23 3770
20 3770
25 3790
30 3799
22 3827
18 3856
16 3860
32 3860
18 3884
29 3884
33 3912
20 3940
28 3941
14 3941
28 3969
25 3983
16 3997
20 3997
28 709
17 1023
29 1552
29 1021
34 1135
25 1330
25 1474
27 1588
23 1588
24 1701
24 1729
21 1790
32 1818
19 1885
25 1893
16 1899
25 1928
20 1928
21 1928
24 1936
21 1970

Consolidation

Number of students of 4 years
Year 1
Section 1 Section 2 Section 3
IT 5666 3211 1561
Math 3700 8454 2765
Statistic 3078 8901 457
Year 2
Section 1 Section 2 Section 3
IT 75433 4334 4343
Math 4678 7890 4561
Year 3
Section 3 Section 2
IT 4357 12245
Math 6788 7899
Statistic 6789 7897
Year 4
Section 1 Section 2 Section 3
Math 3500 8000 1777
IT 1566 544 1891
Statistic 2562 568 445