Find the probability of selecting a male and find the

Question

Q1 : Understandthe basic statistical concepts that are used to analyze business data.

Q2: Use and interpretdifferent descriptive statistical measures

Q3: Apply the laws of probability tosolve basic problems in business.

1.   Use Microsoft office EXCEL to solve the questions of this part.

2.   Print and attach your solutions and graphs.

The business statistics exam results for a random sample of 40 students in a local university are listed here.

30	17	18	11	9	48	19	9
9	25	38	1	22	14	19	59
10	29	9	17	24	52	9	35
32	43	53	34	12	30	9	31
34	38	8	39	8	18	34	29

A.Construct frequency, relative frequency, and percent frequency distributions. Use classes 0 - 9, 10 - 19,.....and so on.

B.Answer the following questions.

B₁.Find the percentage of students who scored less than or equal to 49.

B₂.Find the percentage of students who scored more than or equal 20.

B₃.Find thepercentage of students who scored between 20 and 49.

B₄.Find the number of students who scored between 20 and 49.

C.Draw the following bar graphson the same sheet of paper (3graphs) -

C₁:Classes size with frequency.

C₂:Classes size with relative frequency.

C₃:Classes size with percent frequency.

D.Compute the following: Show All Your Workin a separate sheet

1. The sample mean.

2. The median.

3. The mode.

4. The range.

5. The 35^th percentile.

6. The 80^th percentile.

7. The sample variance and the sample standard deviation.

8. The Coefficient of variation.

Question two:

The ministry of labor collected data on the occupations of workers. The following table shows the number of Maleand Femaleworkers in the occupation categories Labor and Managerial:

Occupation	Male	Female
Labor	10576	3482
Managerial	19079	19021

a) Develop a joint probability table:

b) Find the probability of selecting a male.

c) Find the probability of selecting a female manager.

d) Compute the probability of selecting a male worker given that he is labor.

e) Compute the probability of selecting a male worker or manager.

f) Are the events mentioned in question mutually exclusive? Give a reason for your answer.

g) Are the events mentioned in question d)independent events? Give a reason for your answer.