# Using Excel and Probabilities to Analyze a Dataset

Using the attached data set, compose an email to the head of the American Intellectual Union (AIU) which discusses the following:

- Begin your email to the AIU by first providing an overview of the database, i.e. a story.

- Be sure to include information about how you would use the concept of probabilities to apply to profiles for hiring more satisfied individuals. (Job Satisfaction is an attitude about one's job. It may be measured globally or via facets (e.g. intrinsic/extrinsic). However, job satisfaction is a post hoc phenomenon. Using "profiles" developed via the data set to predict job satisfaction is not feasible. Further, the only variables you could use would be gender, age, department, position. To say, for example, that salaried females between 22-49 years of age and working in IT are more likely to be satisfied says nothing about potential hires. It probably says more about the way the department is managed and the resources available to accomplish tasks. Finally, unless job satisfaction is a performance criterion, it would most likely be illegal to use this concept.)

- Be sure to include other ways that probability is used in business. Keeping in mind that in this email you are going to try to apply probabilities to profile hiring more satisfied individuals, discuss the following in your email:

1. What is the gender distribution (% females and % males)?

2. What is the "tenure with company" distribution by gender?

3. What % of the survey participants are in each department?

4. For each gender, what is the sample mean for overall satisfaction?

5. If we choose a person at random from this database:

- What is the probability that this person will be between 22 and 49 years old?

- What is the probability that their overall job satisfaction is 4.7 or lower?

- What is the probability that this person will be a male in the information technology department?

- What is the probability that this person will be an hourly employee whose intrinsic satisfaction is 6 or more?

https://brainmass.com/statistics/probability/using-excel-and-probabilities-to-analyze-a-dataset-262402

#### Solution Preview

Student,

See attached results in the Word document and spreadsheet.

You added additional information that you are looking for a multi-page email to be composed. I think the skeleton of it could go like this:

{overview of the database} We have collected statistical profiles on our employees that profile the company as diverse while tending toward more female employees. We are ...