Notes for Introduction to Excel
Graphing Problem 1!
Text concatenation (&) =A1&A2 formula concatenates the contents of cell A1 with cell A2.
If you want a space between words then you need to concatenate that as well, =A1& &A2
Paste Special
In some cases
SimpleandCompoundInterest
Problem2.1:
Suppose we deposit $1,000 in a bank savings account that pays interest at a rate of 8%. How
much would we have in the account after 5 years?
We need more information to answer this question
Is this simple interest (c
Consider the joint probability density function
f ( x, y ) = (0.6) x (0.4)1 x (0.3) y (0.52)1 y 2 xy
where the possible values for X and Y are x = 0,1 and y = 0,1.
Find:
1.
2.
3.
4.
5.
6.
7.
f(0,0), f(0,1), f(1,0), f(1,1).
The marginal density functions f