Business Statistics

profileHuzaifaaa
AssignmentBusStats.xlsx
Home>Business & Finance homework help>Accounting homework help>Business Statistics

Notes

Data overview:
The data set is a random sample of 219 employees from the public and private sectors in Australia in 2017.
The tab "public" includes the employees from the public sector.
The tab "private" includes the employees from the private sector.
Sources: the 2017 HILDA (Household, Income and Labour Dynamics in Australia) survey
Variable Definition:
gender female or male
degree Yes = with a university degree; No = without a university degree
married Yes = married; No = unmarried
wage measured in 2017 AU$
age

Public

gender age wage degree married
Female 45 20.59375 No No
Female 23 21.28125 No No
Male 44 22.5 No Yes
Female 27 22.91667 Yes No
Male 28 23.10526 No No
Female 24 23.29545 No No
Female 31 23.34 Yes No
Male 28 24.23684 Yes No
Female 39 25 Yes Yes
Female 22 26.31579 Yes No
Female 27 27.77778 Yes No
Female 64 28.57143 No No
Female 44 29.22222 Yes No
Female 25 29.25 Yes No
Female 22 30.66667 No No
Male 28 30.66667 No No
Female 27 30.85 No No
Male 54 30.90909 No Yes
Male 45 31.25 Yes Yes
Male 28 31.875 No No
Female 46 32.43243 No No
Female 43 33.575 Yes Yes
Female 61 33.625 No Yes
Male 38 33.75 No No
Female 26 34 Yes Yes
Male 30 35.54054 Yes No
Male 28 35.71429 No No
Female 28 35.76923 Yes No
Female 34 35.97368 No Yes
Female 25 36.43333 No No
Female 32 36.64444 Yes Yes
Male 48 37.21053 No No
Female 24 37.25333 Yes No
Female 29 37.33333 No No
Male 41 37.48889 Yes Yes
Female 37 37.5 Yes Yes
Female 57 37.5 No Yes
Male 32 39.47368 No No
Male 31 39.8 Yes No
Male 31 40 No No
Female 51 40.54054 No Yes
Female 32 41.09524 No No
Male 33 41.225 Yes Yes
Female 45 41.36666 No Yes
Male 53 41.6 No No
Female 32 42.13158 Yes Yes
Male 63 42.42424 Yes No
Female 46 43.05 No Yes
Male 58 45.13044 Yes Yes
Male 30 45.94 Yes Yes
Female 29 46.24 No No
Male 46 47.5 No No
Male 40 47.67442 Yes No
Female 52 47.71111 Yes No
Male 39 48.125 Yes No
Male 65 49.47368 No Yes
Male 59 50 No No
Male 40 50 Yes Yes
Male 57 50 No No
Male 26 50.35 Yes Yes
Male 37 50.875 Yes No
Female 31 51.35135 No Yes
Male 44 51.45 No No
Male 44 52.5 No No
Female 31 52.63158 Yes No
Female 31 52.75 Yes Yes
Female 55 54.6 Yes Yes
Female 41 55.55556 No No
Female 60 55.59459 Yes Yes
Female 31 55.66667 Yes Yes
Female 51 56.52632 Yes Yes
Male 39 57.14286 Yes No
Male 40 57.76 No No
Female 30 57.86842 No No
Male 33 58.05263 No Yes
Male 38 58.45238 Yes Yes
Female 36 61.36666 Yes No
Male 53 62.3 No No
Male 56 64.47369 No Yes
Male 48 64.48 No Yes
Male 54 64.7 Yes No
Female 49 64.725 Yes No
Male 55 67.65455 Yes Yes
Male 60 78.91428 Yes No
Female 43 82.89474 Yes Yes
Male 56 98.975 Yes Yes

Private

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