IT Software in business
QUESTION 3: Complete this sales report and indicate the steps you followed:
|
Salesman |
Year |
Country |
Units sold |
Price |
Revenues |
|
Robert |
2018 |
Spain |
72 |
100 |
|
|
Adrian |
2019 |
Italy |
84 |
112 |
|
|
Rudolf |
2018 |
France |
99 |
116 |
|
|
Kenny |
2018 |
Portugal |
63 |
85 |
|
|
Adrian |
2017 |
Germany |
115 |
94 |
|
|
Robert |
2019 |
Austria |
29 |
99 |
|
QUESTION 4: Using Excel Solver, find the solution to the following equation.
950=(50/x)*(1-1/(1+x)^5) + 1000/(1+x)^5
QUESTION 5: Using RAND() function, run 1000 simulations of tossing a coin game. The coin is fair, so the chances that you have “Tail” are the same to those having “Head”. Construct histogram with the frequencies of getting head (based on data), and frequencies of getting “Tail” based on data.
below you can find instructions and explanations for the assignment:
1) You should submit an Excel file, no word files or pdfs.
2) The file should contain brief explanations
3) Question 3: 1-2 sentences are enough
4) Question 4: you can solve it with the bisection method and explain in detail all the steps you did. (Hint: you can assume that x has a meaning of interest rate and you can assume that x is in the interval from 0 to 1. Hint 2: do the iterations until you error will be less than 10)