# MAP DATA ANALYSIS & STATISTICS EXAM

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

## How to place an order?

Take a few steps to place an order on our site:

• Fill out the form and state the deadline.
• Calculate the price of your order and pay for it with your credit card.
• When the order is placed, we select a suitable writer to complete it based on your requirements.
• Stay in contact with the writer and discuss vital details of research.
• Download a preview of the research paper. Satisfied with the outcome? Press “Approve.”

### Feel secure when using our service

It's important for every customer to feel safe. Thus, at College Papers Help, we take care of your security.

Financial security You can safely pay for your order using secure payment systems.
Personal security Any personal information about our customers is private. No other person can get access to it.
Academic security To deliver no-plagiarism samples, we use a specially-designed software to check every finished paper.
Web security This website is protected from illegal breaks. We constantly update our privacy management.

Get assistance with placing your order. Clarify any questions about our services. Contact our support team. They are available 24\7.

Still thinking about where to hire experienced authors and how to boost your grades? Place your order on our website and get help with any paper you need. We’ll meet your expectations.