Problem Set Week One
All statistical calculations will use
Employee Salary Data Set
- Using the Excel Analysis ToolPak function descriptive
statistics, generate and show the descriptive
statistics for each appropriate variable in the sample data set.- For which variables in the data set does this function not work correctly for? Why?
- Sort the data by Gen or Gen 1 (into males and females) and find
the mean and standard deviation
for each gender for the following variables:- sal, compa, age, sr and raise. Use either the descriptive stats function or the Fx functions (average and stdev).
- What is the probability for a:
- Randomly selected person being a male in grade E?
- Randomly selected male being in grade E?
- Why are the results different?
- Find:
- The z score for each male salary, based on only the male salaries.
- The z score for each female salary, based on only the female salaries.
- The z score for each female compa, based on only the female compa values.
- The z score for each male compa, based on only the male compa values.
- What do the distributions and spread suggest about male and female salaries?
- Why might we want to use compa to measure salaries between males and females?
- Based on this sample, what conclusions can you make about the issue of male and female pay equality?
- Are all of the results consistent with your conclusion? If not, why not?
Guidelines for Assignment:
Only use MS-Word format to submit the assignment
Donâ€t submit the assignment without applying follo...
Im trying to learn for my class and Im stuck. Can you help? In 250 words , describe how can underdevel...
...
This is a discussion question that needs to be answer with at least 125 words. Please use own wordsIn what ways do you think the ma...
A new process for producing synthetic diamonds can be operated at a profitable level only if the average weight of the diamonds produced by the pro...
Needed is a basic android app in eclipse. A timer is required that allows a user to input any number in seconds. When they press the button - sta...
/*! elementor - v3.6.5 - 27-04-2022 */
.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
Give an example of how using deception in research can and should be used. Describe why the use of deception can be considered acceptable while som...
Assignment 1: The Wild Frontier, Part 1Due Week 3 and worth 70 pointsImagine you are the leader of the IT team at the...
*“Are we ready for martial law? I think we are, because everybody’s sitting back and watching our freedoms being taken away. Guess what? The te...
our list of questions must be submitted with your assignment as an attachment. After interviewing the family, compile the data and analyze the resp...
NO COVER PAGE REQUIRED. PLEASE USE APA FORMAT AND REFERENCES Karen is a 33 year-old G2P2, with a medical history of...
Other samples, services and questions:
Calculate Price
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.
