Activity Data Set. (Statistics Homework)

jrg1986
  • Display gender information in a chart and plot age data in a box plot.
  • Calculate the appropriate measure of central tendency and variability for the age and gender. What conclusion can you draw from the data?
  • This assignment must be completed using Microsoft Excel and you must show all your formulas, calculations, and charts.

Attention Tutors- You  MUST be fluent in the english language, produce college level work, (i.e proper grammer, spelling, punctuations, vocabulary, etc) and must be fimiliar with Excel. Do not apply for this job if you cannot complete it properly.

 

                                                                                    Data Set

 

Student

Gender

Age

Years of Work Experience

Hours Spent on the Homework

Jenny

F

42

27

2.5

Sandy

F

36

19

4

Linda

F

29

8

2

Lilly

F

54

32

5

Nichole

F

32

15

3.5

Sally

F

23

2

3

Lisa

F

22

4

1.5

Brook

F

38

3

4.5

John

M

60

31

3.5

Dave

M

43

6

4.5

Shawn

M

25

5

2

Kurt

M

47

26

3

Brandon

M

52

7

4.5

Brian

M

35

12

3.5

 

  • 11 years ago
  • 15
Answer(1)

Purchase the answer to view it

  • activity_dataset.xlsx