A sales analyst wants to determine whether there is a difference in the mean monthly sales (RM) of a cosmetic company’s four sales regions in Johor. Several salespersons from each region are chosen and their monthly sales were recorded as below: BatuPahat Muar Kota Tinggi Johor Bahru 4250 3930 3960 4350 3980 4010 4020 4450 4020 4050 4130 3880 4130 4220 4350 4574 4050 4177 3890 4130 LOOK AT THE 2 PHOTOS. a) Identify dependent and independent variable. b) Determine the suitable design for this situation. c) Compute the homogeneity of the variance.
A sales analyst wants to determine whether there is a difference in the mean monthly sales (RM) of a cosmetic company’s four sales regions in Johor. Several salespersons from each region are chosen and their monthly sales were recorded as
below:
BatuPahat Muar Kota Tinggi Johor Bahru
4250 3930 3960 4350
3980 4010 4020 4450
4020 4050 4130 3880
4130 4220 4350 4574
4050 4177 3890 4130
LOOK AT THE 2 PHOTOS.
a) Identify dependent and independent variable.
b) Determine the suitable design for this situation.
c) Compute the homogeneity of the variance.
d) Use α = 0.05 level of significance to test the hypothesis that different regions have no effect on the monthly sales.
![Multiple Comparisons
Dependent Variable: Mean Monthly Sales (RM)
Mean
Diference
J)
95% Confidence Interval
ORegion Region
Std. Error
Sig
Lower Bound
Upper Bound
Tukey HSD
2.
8.600
115.616
1.000
322.18
339.38
3
16.000
115.616
999
314.78
346.78
4.
190.800
115.616
380
521.58
139.98
-8.600
115.616
1.000
-339.38
322.18
3
7.400
115.616
1.000
-323.38
338.18
4.
-199.400
115.616
344
-530.18
131.38
-16.000
115.616
999
-346.78
314.78
2.
-7.400
115.616
1.000
338.18
323.38
206.800
115.616
314
537.58
123.98
1
190.800
115.616
380
139.98
521.58
199.400
115.616
344
131.38
530.18
206.800
115.616
314
123.98
537.58
Games-Howell
8.600
71.762
999
-221.87
239.07
16.000
93.467
998
-299.56
331.56
-190.800
131.996
525
-671.27
289.67
-8.600
71.762
999
-239.07
221.87
7.400
96.508
1.000
312.46
327.26
199.400
134.157
.503
678 58
279.78
1
16.000
93.467
998
331.56
299.56
-7.400
96.508
1.000
-327.26
312.46
4.
-206.800
146.916
534
-695 28
281.68
190.800
131.986
525
-289.67
671.27
199.400
134.157
503
-279.78
678.58
206.800
146.916
534
-281.68
695 28](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3bf981ca-c3a9-46a8-b9e7-4bbc02a53b0b%2F3b839b40-faf8-494e-b473-9eba93f0e808%2Fis73z1s_processed.jpeg&w=3840&q=75)
![Test of Homogeneity of Variances
Mean Monthly Sales (RM)
Levene
df2
Sig.
.112
Statistic
df1
2.344
3
16
ANOVA
Mean Monthly Sales (RM)
Sum of
Squares
df
Mean Square
F
Sig.
Between Groups
149144.950
49714.983
1.488
256
Within Groups
534680.000
16
33417.500
Total
683824.950
19
Descriptives
Mean Monthly Sales (RM)
95% Confidence Interval for
Mean
N
Mean
Std. Deviation
Std. Error
Lower Bound
Upper Bound
Minimum
Maximum
4086.00
106.911
47.812
3953.25
4218.75
3980
4250
4077.40
119.661
53.514
3928.82
4225.98
3930
4220
4070.00
179.583
80.312
3847.02
4292.98
3890
4350
4276.80
275.084
123.021
3935.24
4618.36
3880
4574
Total
20
4127.55
189.712
42.421
4038.76
4216.34
3880
4574
555 5](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3bf981ca-c3a9-46a8-b9e7-4bbc02a53b0b%2F3b839b40-faf8-494e-b473-9eba93f0e808%2Fxirzzs_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 4 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)