Problem Set Week One
All statistical calculations will use  Employee Salary Data Set

1. Using the Excel Analysis ToolPak function descriptive statistics, generate and show the descriptive
statistics for each appropriate variable in the sample data set.
1. For which variables in the data set does this function not work correctly for? Why?
2. 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:
1. sal, compa, age, sr and raise. Use either the descriptive stats function or the Fx functions (average and stdev).
3. What is the probability for a:
1. Randomly selected person being a male in grade E?
2. Randomly selected male being in grade E?
3. Why are the results different?
4. Find:
1. The z score for each male salary, based on only the male salaries.
2. The z score for each female salary, based on only the female salaries.
3. The z score for each female compa, based on only the female compa values.
4. The z score for each male compa, based on only the male compa values.
5. What do the distributions and spread suggest about male and female salaries?
6. Why might we want to use compa to measure salaries between males and females?
5. Based on this sample, what conclusions can you make about the issue of male and female pay equality?
6. Are all of the results consistent with your conclusion? If not, why not?

## History...

Imagine yourself in Lowell, Massachusetts in 1840 where either you or a close family member works as a factory girl in the textile mill. Discuss wh...

## Writing : Robert Cormier The Chocolate War & SE H...

compare and contrast assignment on author Robert Cormier who wrote The Chocolate War and S.E. Hinton who wrote The Outsiders. please state...

## Describe three employment laws and the consequence...

Employment Law Report Develop a 1,050-word report that includes the following: Describe three employment laws and the consequences of...

## Ken Co. uses standard costing for accounting. Foll...

Problem 2: Direct Cost Variance Analysis (30 points total)Ken Co. uses standard costing for accounting. Following is th...

## Complete the worksheet after reading this short bi...

Complete the worksheet after reading this short biography: THIS IS THE ANCESTOR TO BE CHOOSEN: Early in the fif...

...

## write a five pages essay with mla format about thi...

Write an essay of 5-7 pages, double-spaced, in a 12-point font.Essay should discuss at least one piece of scholarship that I upload on the topic di...

## History : Assignment Two Slave Girls...

Surname 1Students nameProfessors nameCourse titleDateAssignment: Two Slave Girls: Phillis Wheatley and Sojourner Truth1.Phyllis was a perfect example...

## What are the different types of reliablity?...

Please answer the following questions pertaining to psychology each question must be at lease 150 words. Provide References PLEASE VIEW ATTACHED N...

## Humanities : Submit a one page description of you...

Submit a one page description of your chosen research topic, how you plan to examine this topic, and why this topic is significant. Who wi...

...

## Assignment 6...

Question 1 10 points1 Calculating Cost of Equity: The Dybvig Corporation’s common stock has a beta of 1.21. If the risk- free rate is 3....

### 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.

Approx. price
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65