The functions of a firm producing car batteries, x1 and windscreen x2 are given below. i. 3x1 + 4x2 = 650 ii. 2x1+3x2 = 500

Using Excel functions, determine the number of batteries and windscreen produced by the firm

b) Below is a list of the Nairobi Securities Exchange's daily volumes for two weeks of trading, in millions of shares. 1669 1754 1752 1771 1835 1659 1755 1742 1671 1845 Using Excel Functions and Tool Pak Data analysis, obtain

i. The mean, Mode, Median and Range for the share values

ii. The Sample variance and Sample standard deviation for these values. Interpret your results\

iii. The Population variance and population standard deviation for these values

iv. Carry out the analysis using Excel's built-in descriptive statistics tool