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

  Which of the following is not true about the udp header

A client uses UDP to send data to a server. The data payload is 26 bytes. Assuming no options, what is the percentage overhead considering both UDP and IP headers?

  Explain the benefits and current trends of data warehousing

Create a diagram using Visio, Microsoft Paint, or other graphical creation utility of your choosing to illustrate the conceptual data feeds into and out of the data warehouse. Note: The graphically depicted solution is not included in the required..

  Products under the traditional costing system

Determine the unit product cost of each of the company's two products under the traditional costing system

  Create a database for use by the employees

The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many different vegetables, including onions, tomatoes, carrots, potatoes, squash, eggplants and zuchini

  Explanation of interfaith sharing

The point is to foster understanding between different faiths through films. Also, a museum exhibit that originated in Israel is now touring major cities around the world for the last four years.

  Create an update query to select all records in the tbl over

Create an update query to select all records in the tblOverPriced, decrease the Price field values by 10%, run and close the query.

  Create class diagram

Draw a UML class diagram that models the aspects of job agencies that are described below.

  Define the term use case

Explain the difference between the > and > relationships in use case diagrams?

  Develop a new information system

MGMT321 Group Project :  You were hired as an analyst to develop a new information system to automate the payroll transactions in a mid-size organization. The proposed system will contain employees’ data and interface with the organization’s General ..

  What type of entertainment events are the most popular

What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing events is most popular in past 10 years?

  Create script file to list file in directory in sorted order

Create a script file to list the files in a directory in sorted order, showingonlythe file name, file size, and modification date.Each file's attributes must be on one line per file, in any order.

  Assume the data warehousing system is centralized

Assume the data warehousing system is centralized, and implemented in the environment of Microsoft SQL Server 2012. As we discussed in the introduction, each store has its own local database.

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