[SOLVED] Mission College Data Visualization Worksheet – Business Finance

by | Aug 5, 2022 | Business & Finance

I have three question about the excel that calculate the appropriate summary statistic(s) and create an appropriate data visualization to describe the variable.Employee ID
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Sex
Female
Female
Male
Male
Female
Female
Female
Female
Female
Male
Female
Male
Female
Female
Female
Female
Female
Female
Male
Female
Male
Female
Female
Male
Male
Female
Male
Male
Female
Male
Female
Male
Male
Female
Male
Female
Male
Female
Female
Female
Male
Female
Female
Female
Male
Female
Race/Ethnicity
White
White
Black
Black
White
Latino
White
Latino
White
White
White
Black
Black
White
Latino
White
White
Latino
Latino
White
Black
White
White
Black
Black
White
Black
Asian
White
Black
White
White
Black
Black
Latino
White
White
Latino
Black
White
Black
White
White
White
Black
White
Age
Engagement
Base Pay
18,10
4,00
44744
28,76
2,67
60284
30,54
2,67
46344
32,44
1,67
34433
34,59
3,33
40023
35,87
3,00
45823
38,41
3,67
32000
41,33
3,67
49756
45,52
3,67
36535
18,10
3,33
60376
26,41
2,67
38542
27,15
2,67
36561
27,29
4,33
44452
27,43
3,00
56760
27,57
4,00
48817
27,80
3,33
40083
27,81
2,67
32000
28,64
4,33
54337
28,76
3,33
41010
29,11
3,33
49855
29,29
3,00
46275
29,57
2,00
47313
29,73
4,33
50220
29,80
5,00
59122
29,95
3,67
58481
29,98
4,33
45121
30,11
4,00
57194
30,11
3,00
43995
30,31
3,33
45983
30,85
4,00
48977
30,88
3,00
51785
31,15
3,00
50593
31,47
2,67
36380
31,75
2,33
39861
31,84
3,00
39723
31,89
2,67
54433
31,92
3,00
38264
32,03
2,67
39394
32,23
3,67
39699
32,78
3,00
56384
32,90
2,67
43353
33,13
2,33
32000
33,21
2,67
44606
33,65
3,67
44133
34,25
3,33
45708
34,26
4,33
40459
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
Female
Female
Male
Male
Male
Male
Female
Female
Male
Female
Female
Female
Female
Female
Male
Female
Male
Male
Female
Male
Male
Male
Female
Female
Female
Female
Female
Male
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Female
Male
Female
Female
Male
Female
Female
Female
Black
White
White
Black
White
Black
White
White
Black
White
Black
White
White
Latino
White
White
White
White
White
Black
Black
Asian
White
Black
White
White
White
White
White
Latino
White
White
White
White
White
White
White
White
White
White
Black
White
Latino
Black
White
White
Black
34,32
34,45
34,48
34,65
34,76
35,02
35,12
35,16
35,27
35,53
35,56
35,57
35,58
36,13
36,53
36,58
36,64
36,87
37,38
37,79
37,84
37,91
38,32
38,60
38,64
38,87
39,18
39,34
39,44
39,53
39,63
40,37
40,71
41,74
42,03
42,28
42,61
42,62
43,00
43,49
43,65
44,97
44,97
47,09
47,46
43,03
45,45
3,33
1,67
4,00
2,67
2,33
2,33
3,00
3,33
2,33
3,00
2,00
2,33
3,67
3,67
2,33
3,00
3,00
3,00
3,33
3,67
3,33
3,33
3,00
3,00
4,67
2,67
3,33
2,67
3,00
3,33
3,67
3,00
3,00
2,33
3,00
4,33
3,00
2,33
2,67
3,00
3,33
3,00
3,33
2,67
3,33
3,00
3,00
32000
47885
54524
53258
32000
51076
49781
43842
40083
32000
39734
54727
38629
45026
50048
38060
49228
41572
36163
50953
49450
51605
43756
54706
48177
51164
52855
39452
40949
44799
63603
62013
57669
48737
50997
56156
47088
61258
54267
43058
40483
41089
39693
51861
32000
55232
52314
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
Female
Female
Female
Female
Male
Male
Female
Female
Female
Female
Female
Male
Male
Female
Female
Male
Male
Male
White
White
Latino
White
Black
White
White
Latino
Latino
White
White
Asian
White
White
White
Latino
Asian
White
48,57
49,23
49,57
50,29
51,16
53,96
18,10
20,46
20,48
20,56
21,21
21,66
22,06
23,67
24,25
25,34
26,43
26,55
2,67
3,67
2,67
3,67
3,33
3,00
3,67
4,00
2,33
3,00
4,67
3,00
2,67
3,00
3,00
5,00
2,33
1,00
32000
44974
32000
56877
54608
59276
51648
48375
32000
44899
61992
53940
42354
52736
57225
51022
40640
40289

Purchase answer to see full
attachment



Why Choose Us

  • 100% non-plagiarized Papers
  • 24/7 /365 Service Available
  • Affordable Prices
  • Any Paper, Urgency, and Subject
  • Will complete your papers in 6 hours
  • On-time Delivery
  • Money-back and Privacy guarantees
  • Unlimited Amendments upon request
  • Satisfaction guarantee

How it Works

  • Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
  • Fill in your paper’s requirements in the "PAPER DETAILS" section.
  • Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
  • Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
  • From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.