Question

MA 321 Data Analysis

PLEASE STATE EACH ANSWER A,B,C,D,E,F AS PICTURED X

A study was conducted to examine the different hourly wages offered to six students helpers in three different department services here at the FIT. The data for this study, in which each student works in each of the three departments, is shown in the following table.

Departments Students Math & Sci Athletics FBM 10.00 7.50 7.00 8.00 7.00 6.00 7.00 6.00 6.00 8.00 6.50 6.50 9.00 8.00 7.00 8.00 8.00 6.00

a)State the hypotheses for this study (8 points)

b) Using Excel, run the appropriate test (Submit your Excel output)

c) (i) Make a decision (accept or reject Ho) (4 points)

ii) Give the reason for your decision (3 pts.) (10 points)

d) Is the result significant? ______ Yes _______ No (2 pts.)

ii) Give the reason for your answer: (3 pts.)

e) Draw a conclusion (in the context of the problem)(6pts.)

f) If there is a significant difference, determine where the difference exists (8 pts.) (If finding where there is a difference is not necessary, explain why)

Answer 1

Solution MA 391 OAŁA Analysis. (a) Hypothesis for the giren Study i8 let us consider Ho: There is no significant difference between the 3 different department service three Ha: There is a significant difference between different department service. the Excel, appropriate test is: 6 using (shown below) • Tables Table 2. lexo Decision : we reject Ho : © Reason of Decisim: Rejeet Ho be cause we have significant difference between

Table 1:

ANOVA: Single Factor
SUMMARY
Groups	Count	Sum	Average	Variance
MATH	6	50	8.333333333	1.0667
ATHLETICS	6	43	7.166666667	0.6667
FBM	6	38.5	6.416666667	0.2417
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	11.1944	2	5.5972	8.5021	0.0034	3.6823
Within Groups	9.8750	15	0.6583
Total	21.0694	17
			Level of significance	0.05

Table 2:

Tukey-Kramer Multiple Comparisons
	Sample	Sample			Absolute	Std. Error	95% CI
Group	Mean	Size		Comparison	Difference	of Difference		Results
1: MATH	8.333333	6		ATHLETICS - MATH	-1.1666667	0468	(-2.165, -0.168	Means are different
2: ATHLETICS	7.166667	6		FBM - MATH	-1.9166667	0.468	(-2.915, -0.918)	Means are different
3: FBM	6.416667	6		FBM - ATHLETICS	-0.75	0.468	(-1.748, 0.248)	Means are not different
Other Data
Level of significance	0.05
Numerator d.f.	3
Denominator d.f.	15
MSW	0.658333

the three different department service (do significant Result or not. No, he result is not significant C) Reason: Not significant since lefs than 0.05 for Pralie is 0.034 which is f Statistic @) conclusion: Hence we conclude that there is a significant difference between three different department Service & Determination of difference exists or not: departments between The difference exist between the ATHELETICs and MATH, and between FBM-MAH because there 951. confidence interval of Turkey HSD difference do not contain o o