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.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Topic Video
Question

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
Transcribed Image Text: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
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
Transcribed Image Text: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
Expert Solution
steps

Step by step

Solved in 4 steps with 1 images

Blurred answer
Knowledge Booster
Hypothesis Tests and Confidence Intervals for Means
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman