Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Since the data file (AssignmentBusStats.xls) suggests a higher mean hourly wage rate in the public sector, a researcher hence states that the population means hourly

Since the data file (AssignmentBusStats.xls) suggests a higher mean hourly wage rate in the public sector, a researcher hence states that the population means hourly wage rates for public and private sectors are different. Do you agree? Propose a statistical method to examine whether the researcher's statement is true or not. Clearly indicate any assumptions made.

Public (screenshots)

image text in transcribedimage text in transcribed
1 gender age wage degree married 2 Female 45 20.5938 No No 3 Female 23 21.2813 No No 4 Male 44 22.5 No Yes 5 Female 27 22.9167 Yes No 6 Male 28 23.1053 No No 7 Female 24 23.2955 No No 8 Female 31 23.34 Yes No 9 Male 28 24.2368 Yes No 10 Female 39 25 Yes Yes 11 Female 22 26.3158 Yes No 12 Female 27 27.7778 Yes No Female 64 28.5714 No No 14 Female 44 29.2222 Yes No 15 Female 25 29.25 Yes No 16 Female 22 30.6667 No No 17 Male 28 30.6667 No No 18 Female 27 30.85 No No 19 Male 54 30.9091 No Yes 20 Male 45 31.25 Yes Yes 21 Male 28 31.875 No No 22 Female 46 32.4324 No No 23 Female 43 33.575 Yes Yes 24 Female 61 33.625 No Yes 25 Male 38 33.75 No No 26 Female 26 34 Yes Yes 27 Male 30 35.5405 Yes No 28 Male 28 35.7143 No No 29 Female 28 35.7692 Yes No 30 Female 34 35.9737 No Yes 31 Female 25 36.4333 No No 32 Female 32 36.6444 Yes Yes 33 Male 48 37.2105 No No 34 Female 24 37.2533 Yes No 35 Female 29 37.3333 No No 36 Male 41 37.4889 Yes Yes 37 Female 37 37.5 Yes Yes 38 Female 57 37.5 No Yes 39 Male 32 39.4737 No No 40 Male 31 39.8 Yes No 41 Male 31 40 No No 42 Female 51 40.5405 No Yes41 Male 31 40 No No 42 Female 51 40.5405 No Yes 43 Female 32 41.0952 No No 44 Male 33 41.225 Yes Yes 45 Female 45 41.3667 No Yes 46 Male 53 41.6 No No 47 Female 32 42.1316 Yes Yes 48 Male 63 42.4242 Yes No 49 Female 46 43.05 No Yes 50 Male 58 45.1304 Yes Yes 51 |Male 30 45.94 Yes Yes 52 Female 29 46.24 No No 53 | Male 46 47.5 No No 54 Male 40 47.6744 Yes No 55 Female 52 47.7111 Yes No 56 Male 39 48.125 Yes No 57 | Male 65 49.4737 No Yes 58 Male 59 50 No No 59 Male 40 50 Yes Yes 60 Male 57 50 No No 61 Male 26 50.35 Yes Yes 62 Male 37 50.875 Yes No 63 Female 31 51.3514 No Yes 64 Male 44 51.45 No No 65 Male 44 52.5 No No 66 Female 31 52.6316 Yes No 67 Female 31 52.75 Yes Yes 68 Female 55 54.6 Yes Yes 69 Female 41 55.5556 No No 70 Female 60 55.5946 Yes Yes 71 Female 31 55.6667 Yes Yes 72 Female 51 56.5263 Yes Yes 73 Male 39 57.1429 Yes No 74 Male 40 57.76 No No 75 Female 30 57.8684 No No 76 Male 33 58.0526 No Yes 77 Male 38 58.4524 Yes Yes 78 Female 36 61.3667 Yes No 79 Male 53 62.3 No No 80 Male 56 64.4737 No Yes 81 Male 48 64.48 No Yes 82 Male 54 64.7 Yes No 83 Female 49 64.725 Yes No 84 Male 55 67.6546 Yes Yes 85 Male 60 78.9143 Yes No 86 Female 43 82.8947 Yes Yes 87 Male 56 98.975 Yes Yes

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 Single And Multivariable

Authors: Deborah Hughes Hallett, Andrew M Gleason, William G McCallum, Daniel E Flath, Patti Frazer Lock, Sheldon P Gordon, David O Lomen, David Lovelock, Brad

6th Edition

1118475712, 9781118475713

More Books

Students also viewed these Mathematics questions

Question

The quality of the argumentation

Answered: 1 week ago