Module 2 Excel-Lorena Amable.xlsx - The data provided in this file has been obtained from a random sample of d INCLUDE SUPPORTING CALCULATIONS FORMULAS

Module 2 Excel-Lorena Amable.xlsx - The data provided in...

This preview shows page 1 - 13 out of 33 pages.

PANTHER ID ENTER YOUR Panther ID: 5634290 Today's Date and Time 7/2/20 Application Username Erick To access textbook data set : Employee # Annual Salary Gender Age Experience (Years) TrainingLevel QMB Assignment Florida International University May-19 Video demo explanations Florida International University May-19 The data provided in this file has been obtained fro INCLUDE SUPPORTING CALCULATIONS, FORMULA not acceptable.
Image of page 1

Subscribe to view the full document.

Name Lorena Amable 019 12:18 These numbers were assigned for the sole purpose of giving each employee a un The total annual salary of the employee in plain USD The employee gender F for Female and M for Male The employee age in years The numer of years of experience of the employee Created by Dr. Gladys Simpson y Created by Dr. Nicole Wishart y om a random sample of data AS OR PIVOTS TABLES YOU USE TO RESPOND TO ALL QUESTI irect-com.ezproxy.fiu.edu/science/article/pii/B978012804250209991 The training is offered from time to time and is voluntary (it is not a job requireme either training course are coded as “A.” They become “B” after the first training cou second and final course. [email protected] Canvas Messages
Image of page 2
nique number. IONS. Entering only the answers is 10?via%3Dihub ent). Employees who have not taken urse, and they change to “C” after the
Image of page 3

Subscribe to view the full document.

1
Image of page 4
Image of page 5

Subscribe to view the full document.

10/11/2019 6/1/2019
Image of page 6
5/25/2019 10/11/2019
Image of page 7

Subscribe to view the full document.

Frequency Count - Employee Gender Training Level F M Total Result A 7 18 25 B 11 8 19 C 2 4 6 Total Result 20 30 50 Joint and Marginal probabilities Count - Employee Gender Training Level F M Total Result A 14.00%### 50.00% B 22.00%### 38.00% C 4.00%### 12.00% Total Result 40.00%### 100.00% Conditional Probability--col Count - Employee Gender Training Level F M Total Result A 35.00%### 50.00% B 55.00%### 38.00% C 10.00%### 12.00% Total Result 100.00%### 100.00% Conditional Probability--row Count - Employee Gender Training Level F M Total Result A 28.00%### 100.00% B 57.89%### 100.00% C 33.33%### 100.00% Total Result 40.00%### 100.00%
Image of page 8
Employee Annual Salary Gender Age Experience 1 $ 52,722 M 38 8 2 $ 53,174 M 50 10 3 $ 56,294 M 49 10 4 $ 46,574 M 56 8 5 $ 44,138 F 38 2 6 $ 52,111 M 56 5 7 $ 47,180 F 45 5 8 $ 24,352 F 35 1 9 $ 24,395 F 52 6 10 $ 24,967 F 55 6 11 $ 37,292 M 47 1 12 $ 52,722 M 47 10 13 $ 24,395 M 31 5 14 $ 41,188 F 34 3 15 $ 53,174 M 54 10 16 $ 35,423 M 44 1 17 $ 57,242 F 45 7 18 $ 26,491 F 46 7 19 $ 41,188 F 35 2 20 $ 49,033 M 43 9 21 $ 49,033 F 55 10 22 $ 32,368 F 42 3 23 $ 24,352 F 35 1 24 $ 42,961 M 36 3 25 $ 44,183 F 38 5 26 $ 58,515 M 36 8 27 $ 53,429 F 45 7 28 $ 54,981 M 47 7 29 $ 49,033 M 42 10 30 $ 53,174 M 54 10 31 $ 40,741 M 47 2 32 $ 27,525 F 35 3 33 $ 49,033 M 53 8 34 $ 29,606 F 34 4 35 $ 53,627 M 47 10 36 $ 44,183 M 41 2 37 $ 24,395 M 30 5 38 $ 53,174 M 46 4 39 $ 35,200 F 38 1 40 $ 47,180 F 45 5 41 $ 53,627 M 47 10
Image of page 9

Subscribe to view the full document.

42 $ 53,174 M 50 5 43 $ 51,237 M 58 2 44 $ 51,237 M 56 1 45 $ 62,530 M 50 10 46 $ 50,602 M 44 5 47 $ 49,033 M 42 10 48 $ 58,968 F 59 10 49 $ 46,574 M 57 8 50 $ 27,525 F 38 3
Image of page 10
Training Level C B B A B A B A A A A A A B A A C A B A B B A B B C B A A B A A A B A A A C B C B
Image of page 11

Subscribe to view the full document.

A B C B B A B A A
Image of page 12
Image of page 13
  • Summer '16

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Ask Expert Tutors You can ask 0 bonus questions You can ask 0 questions (0 expire soon) You can ask 0 questions (will expire )
Answers in as fast as 15 minutes