En cours

Wages Project (AGE)


Determinants of Wages from the 1985 Current Population Survey

[url removed, login to view]

Dependent Variable: Wage

Independent Variables: Education, Experience, and Age

Age (Years) -

Part II: Individual Report (90 Points)

Each team member chooses one of the variables (Use AGE ). Use EXCEL to complete a descriptive statistical analysis on the selected variable, and complete the Individual report in a WORD document.

1. Each team member chooses ONE variable. (USE AGE)

2. Generate descriptive statistics for the chosen variable. Highlight the measures of central tendency, variability, and five-number summary. Show Original Excel output.

3. Generate Histogram for the chosen variable. Show the mean, median and mode on the histogram. Comment on the shape of the histogram.

4. Calculate mean plus/minus one/two/three standard deviations, and show up the intervals on the histogram.

5. Calculate z-scores of the five-number summary.

6. Use APPROPRIATE method to detect if there is any outlier. Identify and list both Normal and Extreme outliers.

7. Generate 3 random samples of 20 each. Show Original Excel output.

8. Generate 3 random samples of 50 each. Show Original Excel output.

9. Create ONE table which compares the means and standard deviations of your samples to the mean and standard deviation of the whole “population”. Were the larger or smaller samples closer to the true mean and true standard deviation? Discuss what factors influenced how close the sample mean was to the population mean, and how this relates to the Central limit Theorem.

10. Calculate the z-scores of your sample means. (Remember you have the population mean and standard deviation, in which you SHOULD use them)

11. Write down a short paragraph including: 1) Summary of your findings, 2) What have you learned from this project, and 3) Any difficulties/comments you have.

Compétences : Analyse des Affaires, Excel, Rédaction scientifique, Statistiques

Voir plus : highlight measures central tendency, stat c, samples project, method write report, write findings report, complete short survey, c stat, standard lib, calculate factors number, write short paragraph, write descriptive paragraph, variability, survey part, mean project, histogram, age, short paragraph list, team statistics, excel random number, identify discuss, list short paragraph, report variable, outlier, word population, generate random number

Concernant l'employeur :
( 0 commentaires ) Bellevue, United States

N° du projet : #1614864

Décerné à :


Hello, I am Very much interested. Best Regards, Prema.

30 $ USD en 100 jours
(19 Commentaires)

3 freelance ont fait une offre moyenne de 40 $ pour ce travail


Hi, I would like to carry out this assignment. I am familiar with all the concepts on the list, and I have solved thousands of similar problem sets before, both in the undergraduate in Economics and later in a Master i Plus

60 $ USD en 1 jour
(3 Commentaires)

Please check the PMB

30 $ USD en 1 jour
(0 Commentaires)