Question: I need help to solve this following question with steps and how it will be done through excel: A job-training program offers training in advance

I need help to solve this following question with steps and how it will be done through excel:

A job-training program offers training in advance computer programming. It is suspected that the probability that an individual will be able to find a programming job within six months (after the completion of the program) depends on previous related working experience. A random sample of 80 individuals trained in the program yields the following frequency table:

Number of Years of Experience Number of Individuals

Zero 52

One year 16

More than one year 12

Of the 52, 16 and 12 individuals in the three experience categories listed in the table, respectively, 20, 8 and 10 were able to find a programming job within six months.

a.At a 5% level of significance, is there any evidence to support the hypothesis that the probability of finding a job (within six months) depends on prior related working experience?

a.At a 10% level of significance, is there any evidence against the hypothesis that the percentage of individuals in the program with "zero", "one year" and "more than one year" of experience are respectively 70%, 15%, and 15%?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!