What % of the survey participants are in each department

Assignment Help Database Management System
Reference no: EM13949745

Using our data set from Unit 1, compose an email to the head of the American Intellectual Union which discusses the following:

Begin your email to 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 DataSet 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. (Feel free to use the Business Source Premier Database in the Library as a resource to research.)

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:

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

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

What % of the survey participants are in each department?

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

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?

Attachment:- Copy of DataSetandDataSetKey_0801B.zip

Reference no: EM13949745

Questions Cloud

Interpret the results of the wilks test : Find the mean vector and covariance matrix for each of the three treatments. Does there appear to be differences between the treatments and do you think that the assumption of equal variances is sensible?
The nominal exchange rate : Over a period of time, Alexis (a U.S. resident) notes that the nominal exchange rate (USD/EUR) has decreased by 3%, the price level in the Eurozone has increased by 5%, while the price level in the United States has increased by 6%. Compute the chang..
Identify a business that is bringing shalom to a city : Identify a business or other organization that is bringing Shalom to a city, region, or even nations through its activities in the marketplace.
What is the multivariate null hypothesis : Consider the data for a three-group MANOVA with two dependent variables. Run the MANOVA on SPSS. Is it significant at the .05 level? Examine the univariate F's at the .05 level. Are any of them significant? Explain this situation.
What % of the survey participants are in each department : Be sure to include other ways that probability is used in business. (Feel free to use the Business Source Premier Database in the Library as a resource to research.)
Corresponding range of steam quality values : For what range of exit temperatures, in 8C, can the calorimeter be used to determine the quality of the steam in the pipe? What is the corresponding range of steam quality values?
What is skellys variable cost ratio : What is Skelly's variable cost ratio? What is its contribution margin ratio? How much sales revenue must Skelly earn to break even? What is the expected margin of safety?
How many bottles of water a day should the average human : How many bottles of water a day should the average human drink?
Determine the mass flow rate at inlet : Ignore heat transfer with the surroundings and all kinetic and potential energy effects. If the mass flow rate  of  the  liquid  entering  at  inlet  1  is  m# 1  5 3.2 3 105  kg/h, determine the mass flow rate at inlet 2, m# 2, in kg/h.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd