Portfolio Project309
.docx
keyboard_arrow_up
School
Auburn University *
*We aren’t endorsed by this school
Course
302
Subject
Mathematics
Date
Apr 3, 2024
Type
docx
Pages
7
Uploaded by MajorEmuMaster524
Portfolio Project
Josue Oreste MATH309 – Statistics
Professor W. Rava
February 25, 2024
ID
Gender
Ethnicity
Age
Pay rate
Employee Satisfactio
n
1
Female
Caucasian
27
27.8
2.7
2
Male
African American
37
55.5
3.5
3
Male
Asian
35
65.5
4.4
4
Female
Hispanic
22
35.5
5.0
5
Female
indigenous American
75
75.5
4.7
6
Male
Caucasian
47
55.5
3.2
7
Male
African American
55
45.6
3.5
8
Female
Asian
33
49.5
3.3
9
Female
Hispanic
22
48.5
3.8
10
Male
Caucasian
38
49.5
4.4
11
Male
African American
57
55.5
2.2
12
Male
Asian
63
45.5
4.2
13
Male
Hispanic
45
45.5
4.1
14
Female
Caucasian
33
61.5
4.5
15
Female
Caucasian
31
45.5
4.3
16
Female
Caucasian
18
49.5
3.8
17
Female
African American
16
45.5
4.1
18
Male
African American
40
46.5
4.4
19
Male
Hispanic
48
45.5
3.8
20
Male
indigenous American
46
65.5
4.1
1.
You send the survey to all 20 employees and 15 responds. Identify the population.
2.
What level of measurement is the variable: Employee ID? 20
3.
Input the data from Table 1 into Excel. Calculate the descriptive statistics
on the Pay Rate column (Column D) of the table. (See video links on the last page of this document if needed)
Column1
Mean
50.72
Standard Error
2.39645132
Median
49
Mode
45.5
Standard Deviation
10.7172561
Sample Variance
114.859579
Kurtosis
0.96149307
Skewness
0.3207029
Range
47.7
Minimum
27.8
Maximum
75.5
Sum
1014.4
Count
20
4.
From the data from Table 1, we can look at the Ethnicity variable.
Use the data from Table 1 to complete the frequency table of ethnicity (Column C) for the participants. You can use the =countif (C2:C21, “White”) function in Excel.
Ethnicit
y
Frequen
cy
White
6
African America
n
5
Hispanic
4
Using the Ethnicity frequency table (from part A), create a pie chart for Ethnicity of employees. Make sure to include a title and each slice is clearly labeled. Paste your Pie Chart below. (See video links on the last page of this document if needed)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help