Texts: QUESTION 2
(1)
(a) Explain how you would add the Excel Analysis Tool pack to Microsoft Excel.
(b) Assume that you are given the following sample values to enter them in column A of the MS Excel spreadsheet:
4, 6, 7, 3, 8, 6, 0, 2, 1, 1, 3, 4, 7, 8, 6, 3, 4, 3, 6, 5, 6, 8, and 9.
(i)
(ii)
(iii)
Explain how you would view the average, count, and sum in the MS Excel customize status bar
(2)
Type in the formulas for calculating the average, median and range of the data in your answer sheet.
(3)
Type in the formulas and obtained values of the standard deviation and coefficient of variation of the given sample data in your answer sheet.
(5)
3
STA1506/012/0
(iv) Type in the sample values in the first row, type in the formulas and obtained values of the standard deviation and coefficient of variation of the given sample data in your answer sheet.
(4)
[51