Answer:
No options are given, but the most commonly used survey response methods are:
- Multiple choice questions = generally easy to code
- Rating scale questions = also easy to code, since response scales have a finite number of choices, e.g. 2 true/false, 3 agree/disagree/undecided, 5 very bad/bad/fair/good/excellent
- Matrix questions. = are a little bit more complex since they involve several rating scale questions, but it is not something difficult either
- Dropdown questions. = similar to multiple choice questions
- Open-ended questions. = this are hard to code since each subject can respond different things, e.g. the thing that I like the most about this project is bla, bla, bla. There are no pre-set answers given to the subjects. THIS TYPE IS THE MOST DIFFICULT TO CODE.
- Demographic questions = similar to multiple choice
- Ranking questions = similar to scaled questions
Answer:
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
Explanation:
In MS Excel, on the left hand side below the tool bar there is a small box which tells the cell name where the cursor is clicked, the name of the cell can be changed from here easily, click on the desired cell and then by clicking on the box you can enter the name of the cell. After a cell is renamed the formula can be written by simply putting the name of the cell instead of the original e.g. E13
The formula for average is =AVERAGE(E15,E16).
The formula for highest is =MAX(F15,F16).
The formula for lowest is =MIN(G15,G16).
The cells provided in the formula above is just an example and more than two cells can be selected.
Answer:
The amount of dividend received by common stockholders in 2017 = $7500
Explanation:
The preference shares are cumulative which means the 2015 dividend on cumulative preference shares will be paid in the next year when dividend is declatred.
The total dividend on preference shjares is = 2500 * 100 * 0.05 = $12500
In 2016 dividend of 22500 is declared and paid.
Out of this 22500, 12500 relates to prefernece dividend for 2015.
The remaining 10000 relates to 2016 preference dividend. Thus, 2500 of 2016 preference dividned is outstanding and will be paid in 2017.
In 2017 out of 22500, 15000 (12500 + 2500) dividendd is paid to preference share holders.
The amount of dividend received by common stockholders in 2017 = 22500 - 15000 = $7500
In most cases for this type of questions you would have to use a calculator, since this is not a value that can be approximated. Do you have an inverse normal function on your graphical calculator?
