A marketing organization wishes to study the effects of four sales methods on we
ID: 3156012 • Letter: A
Question
A marketing organization wishes to study the effects of four sales methods on weekly sales of aproduct. The organization employs a randomized block design in which three salesman use eachsales method. The results of Excel SaleMeth output of a randomized block ANOVA of thesedata. Using the computer output:
1. Test the null hypothesis H0 that no differences exist between the effects of the salesmethods (treatments) on mean weekly sales. Set = .05. Can we conclude that the
different sales methods have different effects on mean weekly sales?
2. Test the null hypothesis H0 that no differences exist between the effects of the salesmen(blocks) on mean weekly sales. Set = .05. Can we conclude that the different salesmenhave different effects on mean weekly sales?
3. Use Tukey simultaneous 95 percent confidence intervals to make pairwise comparisonsof the sales method effects on mean weekly sales. Which sales method(s) maximize meanweekly sales?
Explanation / Answer
1. Test the null hypothesis H0 that no differences exist between the effects of the sales methods (treatments) on mean weekly sales. Set = .05. Can we conclude that the different sales methods have different effects on mean weekly sales?
This we can done using MINITAB.
steps :
ENter data method wise and salesman wise --> STAT --> ANOVA --> General linear model --> Response : select observation column --> Model : select method and salesman --> Comparisons : Method : Tukey --> COnfidence interval , with confidence level : 95.0 --> click on test --> ok --> Results : select third option --> ok --> ok
General Linear Model: obs versus method, salesman
Factor Type Levels Values
method fixed 4 M1, M2, M3, M4
salesman fixed 3 A, B, C
Analysis of Variance for obs, using Adjusted SS for Tests
Source DF Seq SS Adj SS Adj MS F P
method 3 93.583 93.583 31.194 36.23 0.000
salesman 2 22.167 22.167 11.083 12.87 0.007
Error 6 5.167 5.167 0.861
Total 11 120.917
S = 0.927961 R-Sq = 95.73% R-Sq(adj) = 92.17%
We reject H0 at 5% level of significance for salesman and method .
Conclusion :There is differences exist between the effects of the salesmethods (treatments) on mean weekly sales.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.