Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Repeat step 1 above for the variable wage for the private sector employees. First use Excel Data Analysis Tool Pack (the descriptive statistics option) to

Repeat step 1 above for the variable wagefor the private sector employees.

First use Excel Data Analysis Tool Pack (the descriptive statistics option) to calculate summary statistics.

Second use Excel to stepwise calculate summary statistics. Here you would estimate a whole range of statistics to measure central tendency, variation, and the shape of the data - based on what you learned under Topic 1.

These calculations should be carefully laid out in Excel and should NOT use any hard-wired Excel statistical functions e.g. Average, Median, Mode, STDEV, VAR, QUARTILE, etc.

gender age wage degree married
Male 36 3.009027 Yes Yes
Male 61 6.521739 No No
Female 25 9.2 No No
Female 22 10 No No
Male 23 10.56 No No
Female 27 13.5 Yes No
Female 27 14.58333 No Yes
Male 21 16.26667 No No
Male 21 16.42857 No No
Female 31 17.5 No No
Male 27 18 No No
Female 41 18.2 Yes Yes
Female 26 18.34211 No Yes
Female 31 19.18 No No
Female 23 19.18182 No No
Female 28 19.67442 No Yes
Female 63 19.90625 No No
Male 24 19.98333 No No
Male 52 20 No No
Female 27 20.18421 Yes No
Female 27 20.83333 No Yes
Female 49 21 No Yes
Male 47 21.4 No No
Female 43 21.4186 Yes No
Female 31 21.48889 Yes No
Female 27 21.5 Yes Yes
Male 27 21.81818 No No
Female 60 21.90476 No No
Male 52 22 No No
Male 22 22.275 No No
Male 22 22.5 No No
Male 60 22.63158 No No
Female 41 22.64151 No Yes
Male 39 23.08 No No
Female 39 24.56 No Yes
Female 48 24.57143 No Yes
Male 30 24.95 No Yes
Male 22 25 No No
Male 26 25.56667 Yes No
Male 22 25.66667 No No
Male 32 26 No No
Female 46 26.24 No Yes
Female 47 26.31579 No No
Male 31 26.90476 No Yes
Male 60 27.16667 No Yes
Female 53 27.16667 No Yes
Female 25 27.34043 Yes No
Female 35 27.625 No No
Male 63 28 No Yes
Male 28 28 Yes No
Female 42 28.33333 Yes No
Male 44 28.33333 No No
Female 28 28.62 Yes No
Male 24 28.775 No No
Male 27 28.85 No No
Female 26 28.92105 Yes No
Female 59 29.08333 No Yes
Male 23 29.30909 No No
Male 40 29.69767 Yes Yes
Male 22 31 Yes No
Female 50 31.11111 No Yes
Female 65 31.125 Yes No
Male 28 31.2093 Yes No
Male 30 31.42857 Yes No
Female 37 31.66667 No Yes
Male 32 32.34375 No No
Female 25 32.42105 No No
Male 32 32.5 No Yes
Female 51 33.18605 No Yes
Male 35 33.33333 No Yes
Male 27 33.4 Yes Yes
Male 38 34.375 No No
Female 64 34.87273 No No
Male 26 34.92 Yes No
Female 34 37.09302 No Yes
Male 27 37.44737 No Yes
Male 37 37.5 No No
Female 33 37.6 Yes Yes
Male 23 38.15789 No No
Female 30 38.35 No No
Male 37 38.35 No No
Female 41 38.46154 No Yes
Female 27 38.8 No No
Male 26 38.85185 No No
Male 35 39 Yes Yes
Female 29 39.5 No No
Female 55 39.85 Yes No
Male 42 39.95 No Yes
Female 22 40 No No
Male 30 40.04546 No No
Female 61 41.66667 Yes No
Female 41 41.83636 Yes No
Male 29 42.44186 No No
Female 59 42.51351 No Yes
Male 37 43.02222 No No
Male 29 43.15 No No
Male 46 43.16 Yes No
Female 32 43.34286 Yes No
Male 50 43.85965 No Yes
Male 30 44.6 No Yes
Male 33 44.75555 No No
Female 33 44.86666 Yes No
Male 40 46.02 No No
Male 44 46.02 Yes Yes
Male 26 46.42105 Yes No
Female 58 47.95 Yes Yes
Female 31 48.075 No No
Female 36 48.2 Yes No
Female 46 48.9 Yes No
Male 32 49.02222 Yes No
Male 55 50.92857 Yes No
Male 46 52.94 Yes No
Male 37 56.25 Yes No
Female 43 56.4 No Yes
Male 64 57.525 No Yes
Male 36 61.38 Yes Yes
Male 36 61.5 No No
Male 49 61.72093 No Yes
Male 31 68.94736 Yes Yes
Female 60 70 No Yes
Male 42 70.21277 Yes No
Male 35 70.83334 Yes No
Male 31 73.1 No Yes
Male 38 73.64 Yes Yes
Male 38 78.26 Yes No
Female 43 79.68571 No Yes
Male 38 79.88889 Yes No
Male 63 80 Yes No
Male 56 87.5 No Yes
Male 64 91.17647 No Yes
Male 31 100 No No
Male 53 100 Yes Yes
Male 44 100.5814 No No

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus

Authors: Jon Rogawski, Colin Adams

3rd Edition

1319116442, 9781319116446

More Books

Students also viewed these Mathematics questions

Question

Repeat Problem 9169 using helium as the working fluid.

Answered: 1 week ago