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) 

GOOD LUCK.