MAP DATA ANALYSIS & STATISTICS EXAM

Name ID

USE MS Excel to solve the questions (Copy and paste the screen shots from Excel to word file and submit.

(1) The salary of 21 project managers in fortune companies in UAE is as follows (in AED); 300,000, 400,000, 600,000, 200,000, 100,000, 800,000, 200,000, 400,000, 250,000, 370,000, 420,000, 480,000, 180,000, 230,000, 210,000, 160,000, 270,000, 380,000, 320,000, 480,000, 500,000.

Calculate the Mean, Mode, Median and Standard Deviation using Excel and write your decision as a manager in one sentence against each calculation.

(2) A call center quality control manager random selected 19 shifts in last three months and records the call drops in each shift as follows; 24, 35, 17, 21, 24, 37, 26, 46, 30, 32, 13, 10, 38, 41, 43, 44, 27, 53, 27.

A. Calculate the number of classes.

B. Calculate the class length

C. Calculate the frequency in each class

D. Calculate the % frequency in each class

E. Draw histogram of frequency distribution using MS Excel

MCQ: (Choose the Right Answer)

(1) The sum of deviation about the mean is always;

(a) Zero

(b) Positive

(c) Negative

(a) Toal Standard Deviation

(2) The middle value of the ordered array of the number is

(a) Mode

(b) Median

(c) Mean

(d) Mid Point

(3) Which of the following nt measured at central tendency

(a) Percentile

(b) Quartile

(c) Standard Deviation

(d) Mode

k(4) Which of the following divides data in to four sub group

(a) Percentiles

(b) Quartiles

(c) Median

(d) Standard Deviation

(5) If the standard deviation of the population is 9, the population variance is

(a) 3

(b) 9

(c) 36

(d) 81

(6) Mean is also denoted by

(a) Mode

(b) Median

(c) Average

(d) None of the above

(7) Pie charts are useful for

(a) % of pies

(b) Mean of pies

(c) Median of pies

(d) None of the above

(8) Variance will be

(a) Always positive

(b) Always negative

(c) Always zero

(d) None of the aboe

(9) Arranging data in ordered arrays means;

(a) Always arrange the data increasing order

(b) Always arrange the data in decreasing order

(c) Arrange the data randomly

(d) None of the above

(10) What is not the data type;

(a) Primary data

(b) Secondary data

(c) Quantitative Data

(d) None of above

Part Two: Multiple choice questions

1 2 3 4 5 6 7 8 9 10