Assignment
1. Discuss the general model of problem solving presented in your textbook. What are the three main phases and the different analysis steps involved?
2. Explain the following terms and give an example of how they could help understand a real life problem.
a. Mean
b. Mode
c. Median
3. What are the differences between a bar chart, a pie chart and a line chart? Give an example of when you would use each one.
4. Give an example of how you could use what you learned about applying logic in Decision Making to a real life example.
5. Give an example of how you could use the Excel VLOOKUP or HLOOKUP formula in a real life situation.
6. Use the Excel financial Functions to calculate the amounts in the blank cells:
|
PV
|
NPER
|
RATE
|
PMT
|
FV
|
|
$1,000
|
10
|
6%
|
50
|
|
|
|
20
|
8%
|
100
|
$5,000
|
|
$905
|
7
|
|
0
|
$1,718
|
|
$1,941
|
|
7%
|
50
|
$3,700
|
|
$2,500
|
5
|
6%
|
|
$6,500
|