hw 5 - Chirag 0 0 50000 0 0 0 61000 All Adults College...

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

View Full Document Right Arrow Icon
Chirag Patel Age 25 35 45 55 65 All Adults 32000 42000 47500 47000 38000 College Grads 39000 50000 61000 67000 61000 25 35 45 55 0 10000 20000 30000 40000 50000 60000 70000 80000 Chirag Patel All Adults College Grads Age Income
Background image of page 1

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

View Full DocumentRight Arrow Icon
65
Background image of page 2
Ticket Price Age under 10 $3.00 $7.00 Childern Age Ticket Price Mary 10 $7.00 John 18 $7.00 Mark 16 $7.00 May 9 $3.00 Paul 7 $3.00 Ziba 9 $3.00 Steve 11 $7.00 Total Cost $37.00
Background image of page 3

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

View Full DocumentRight Arrow Icon
Grading 93-100 A Weight 83-92 B Homework 25% 73-82 C Test1 20% 60-72 D Test 2 25% Below 60 F Final Exam 30% Student Name Student ID HW1 HW2 HW3 Homework Test1 Test 2 Mary 501 56 95 79 77 56 45 John 502 64 68 95 76 89 75 Mark 503 84 66 64 71 75 76 May 504 94 87 86 89 92 95 Paul 505 83 79 94 85 66 54 501 502 503 504 505 0 20 40 60 80 100 Student Progess Chart Column C Column K
Background image of page 4
0 60 F 60 73 D 73 83 C 83 93 B 93 100 A Using Built in function Final Exam Total Score Final Grade Final Grade 90 69 D D 88 82 C C 98 81 C C 98 94 A A 60 66 D D
Background image of page 5

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

View Full DocumentRight Arrow Icon
Deposit $8,000 Yearly deposit $2,500 Interest rate 3.0% Total Term 15 After 15 Years $58,961.02 Interest Principal Year 1 240.00 8240.00 Year 2 322.20 11062.20 Year 3 406.87 13969.07 Year 4 494.07 16963.14 Year 5 583.89 20047.03 Year 6 676.41 23223.44 Year 7 771.70 26495.15 Year 8 869.85 29865.00 Year 9 970.95 33335.95 Year 10 1075.08 36911.03 Year 11 1182.33 40593.36 Year 12 1292.80 44386.16 Year 13 1406.58 48292.75 Year 14 1523.78 52316.53 Year 15 1644.50 58961.02
Background image of page 6
Financial Function Interest rate 9.52% Period 30 Loan Amount $(22,000.00) Monthly Payment $185.31 I used the Funtion PMT formula (Future Value, Present Value, Rate and NPer). This function pmt formula will give you the monthly or annual payment of a loan amount based on number of periods and interest rate loan amount. Statstical Function COUNTIF 0 DATA 80 68 47 76 12 9 22 32 10 61 60 COUNTIF function gives the total count for given criterion. E.g. above it's giving me total cell cou for the values above 80.
Background image of page 7

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

View Full DocumentRight Arrow Icon
unt,
Background image of page 8
Microsoft Excel Solver-Add-In Excel's Solver is a numerical optimization add-in (an additional file that extends the capabilities of Excel). It can be fast, easy, and accurate. The Solver add-in allows you to perform "what if" calculations based on several variables. This add-in can be used to solve formulas that contain several variables. This add-in also allows you to provide one or more constraints (i.e conditions that must be met for the solution to be valid. This add-in has several uses, one of which is to
Background image of page 9

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

View Full DocumentRight Arrow Icon
Image of page 10
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/14/2010 for the course MIS 316 taught by Professor Kristine during the Spring '10 term at York University.

Page1 / 22

hw 5 - Chirag 0 0 50000 0 0 0 61000 All Adults College...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online