FisherMatt - ExcelAssignment1

FisherMatt - ExcelAssignment1 - This exercise will train...

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

View Full Document Right Arrow Icon
This exercise will train you in writing complex IF statements, computing SUM, AVERAGE, MIN, MAX, STD DEVIATION, COUNTIF, FREQUENCY etc. Grade Sheet Weight 35% 65% Maximum score 100 100 Student ID Exam 1 Exam 2 Weighted Total Final Grade 1000 86 85 85.4 B No No 1001 82 75 77.5 C No No 1002 89 90 89.7 B No No 1003 83 84 83.7 B No No 1004 77 76 76.4 C No Yes 1005 51 50 50.4 D No Yes Bin Frequency 1006 98 89 92.2 A No No A 5 1007 81 89 86.2 B No No B 11 1008 87 92 90.3 A No No C 9 1009 84 80 81.4 B No No D 4 1010 74 78 76.6 C No Yes 1011 87 80 82.5 B No No Total 29 1012 83 91 88.2 B No No 1013 77 86 82.9 B No No 1014 68 76 73.2 C No Yes 1015 81 90 86.9 B No No 1016 83 85 84.3 B No No 1017 85 86 85.7 B No No 1018 65 69 67.6 D No Yes 1019 75 73 73.7 C No Yes 1020 78 69 72.2 C No Yes 1021 67 76 72.9 C No Yes 1022 91 99 96.2 A Yes No 1023 74 73 73.4 C No Yes 1024 71 65 67.1 D No Yes 1025 81 81 81.0 B No No 1026 78 76 76.7 C No Yes 1027 75 69 71.1 C No Yes 1028 59 66 63.6 D No Yes 1029 95 100 98.3 A Yes No 1030 90 93 92.0 A Yes No Average 79.19 80.35 79.95 Total 3 13 Standard Deviation 10.15 10.90 10.30 Maximum 98 100 98.25 Minimum 51 50 50.35 Count if Consistent A Count if Consistent C or D
Background image of page 1

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

View Full DocumentRight Arrow Icon
Retirement Savings Assumptions Last Name Fisher First Name Matthew Current Earnings $175,000
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 06/24/2011 for the course MIS 301 taught by Professor Mccleod during the Fall '08 term at University of Texas at Austin.

Page1 / 2

FisherMatt - ExcelAssignment1 - This exercise will train...

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