Portfolio Project309

.docx

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

Report
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