A company applies an aptitude test to all those who apply for work as programmers. The...

A company applies an aptitude test to all those who apply for work as programmers. The results of these tests are analyzed according to their precedence (general advertising, advertisements for specialized magazines, employment agencies, personal recommendations or people who come spontaneously). With a significance level of 0.025, determine if there is a difference between the results of these tests according to their precedence.

Your work should have detailed procedure, in this exercise you can use the tool offered by Excel for the required test, but you have to have the appropriate analysis.

General Pub	36	47	38	51	62	78	60	47	49	53	26	38	61	39	43
Rev Esp.	58	64	62	47	71	90	65	82	61	59
Ag Emp.	47	59	48	81	66	50	42	53
Rec Per.	67	61	82	97	65	72	54	59	58
Spontaneous	38	47	80	41	38	66	50

Solutions

Expert Solution

The appropriate test is one way ANOVA as five groups are involved in the study.

The statistical hypothesis is,

Ho: There is no difference between the test results according to the distinct five precedence. Ha: There is a difference between the test results according to the distinct five precedence.

Perform the test in Excel:

Enter the data in the Excel spreadsheet.

Go to data analysis add-in in the DATA tab. Select ANOVA:single factor and click OK.

Enter range of the entire data set. Select the labels and enter the output range. Click Ok.

The obtained output is shown below:

Anova: Single Factor

SUMMARY
Groups	Count	Sum	Average	Variance
General Pub	15	728	48.53333	169.6952
Rev Esp.	10	659	65.9	152.9889
Ag Emp.	8	446	55.75	159.9286
Rec per.	9	615	68.33333	186
Spontaneous	7	360	51.42857	253.2857


ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	3248.561	4	812.1401	4.53488	0.003736	2.583667
Within Groups	7879.848	44	179.0874

Total	11128.41	48

Decision: Since the p-value (0.003736) is less than the significance level 0.025, so the researcher rejects the null hypothesis.

Conclusion: There is a sufficient evidence to support that there is a significant difference between the test results according to the distinct five precedence.

orchestra answered 1 year ago

Next > < Previous

Related Solutions

A company applies an aptitude test to all those who apply for jobs as programmers. The...

A company applies an aptitude test to all those who apply for jobs as programmers. The results of these tests are analyzed according to their precedence (general advertising, ads in specialized magazines, employment agencies, personal recommendations or people who come spontaneously). With a significance level of 0.025, determine if there is a difference between the results of these tests according to their precedence. Your work should have detailed procedure, in this exercise you can use the tool offered by Excel...

Your company gives everyone who applies to your company a proficiency test. Your boss likes to...

Your company gives everyone who applies to your company a proficiency test. Your boss likes to hire people who fall in the "average" range. They feel that people who score exceptionally high on the test are more likely to leave for a better job, and people who score very low are not productive enough. The average score on the proficiency test is 750 with a variance of 400. Your boss tell you to exclude the top 14% and the bottom...

The term “manage upward” applies to those managers and leaders who are lacking in skills to...

The term “manage upward” applies to those managers and leaders who are lacking in skills to the degree that subordinate employees are compelled to be assertive and take action. Which management and/or leadership techniques could work best in this situation? Explain why you chose the techniques you listed.

1) The number of students taking the Scholastic Aptitude Test (SAT) has risen to an all-time...

1) The number of students taking the Scholastic Aptitude Test (SAT) has risen to an all-time high of more than 1.5 million. Students are allowed to repeat the test in hopes of improving the score that is sent to college and university admission offices. The number of times the SAT was taken and the number of students are as follows. (HINT: This is a Discrete Probability Distribution Problem) Number of Times SAT is taken Number of Students 1 721,769 2...

Can traditional contract law that applies to third-party beneficiary contracts, assignments, and delegations, apply to those...

Can traditional contract law that applies to third-party beneficiary contracts, assignments, and delegations, apply to those same types of contracts entered into on the Internet? Why or why not? What is the current state of technology for protecting online transactions? How can a party be assured that the negotiation and transmission of a contract online is secure? How can the performance of a contract be monitored online?

this is for those who did Arduino projects this code is supposed to work this way,...

this is for those who did Arduino projects this code is supposed to work this way, there is a temperature sensor in the Arduino Uno along with a motor. the motor should turn on only when the temperature in the sensor exceeds 23 degrees Celcius. Here is the code float AnalogToVolts(int reading); void setup() { Serial.begin(9600); pinMode(13, OUTPUT); } void loop() { int reading; float volts; float temperature_in_celsius; reading = analogRead(A1); volts = AnalogToVolts(reading); //Function call if ( temperature_in_celsius >...

A stress test in finical marketing means: (check all that apply) Tries to incorporate all the...

A stress test in finical marketing means: (check all that apply) Tries to incorporate all the interconnections between financial institutions. Does not look at historical returns, and looks at all the details of the portfolios and their vulnerabilities during all sorts of potential financial crises. Aims to test the behavior of historical returns and their fluctuations during all sorts of potential financial crises. Tries to incorporate all potential economic and financial crises, such as recessions, appreciation and depreciation of currency,...

a soap manufacturing company has three employees who work in a warehouse All of the warehouse...

a soap manufacturing company has three employees who work in a warehouse All of the warehouse workers are authorized to order inventory when it falls below order level.The workers complete a purchase order and mail it to supplier of their choice .The inventory is delivered directly to the warehouse .The workers send a memo to accounts payable reporting receipt of inventory accounts payable compares warehouse memo to suppliers invoice .Accounts payable prepares a memo which treasurer signs .discuss internal control...

Do College students who have volunteered for community service work differ from those who have not?...

Do College students who have volunteered for community service work differ from those who have not? A study obtained data from 57 students who had done service work and 17 who had not. One of the response variables was a measure of attachment to friends, measured by the Inventory of Parent and Peer Attachment. Here are the results. Group Condition n x s__ 1 Service 57 105.32 14.68 2 No Service 17 96.82 14.26 a. Do these data give evidence...

5. Professor Frank Nabarro insists that all senior physics majors take his notorious physics aptitude test....

5. Professor Frank Nabarro insists that all senior physics majors take his notorious physics aptitude test. The test is so tough that anyone not going on to a career in physics has no hope of passing, whereas 55% of the seniors who do go on to a career in physics still fail the test. Further, 70% of all senior physics majors in fact go on to a career in physics. Assuming that you fail the test, what is the probability...

Subjects