project mamanjment

just-for-me-2014

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.xlsx

Home >Environmental science homework help >project mamanjment

Data

Tues	Wed	Thu	Fri	Mon	SST	Tues	Wed	Thu	Fri	Mon	Tues	Wed	Thu	Fri	Mon
199.95	195.74	102.68	162.88	101.76		20	13	23	13	13	41	33	34	27	20
186.94	120.18	228.78	88.02	119.57		33	15	27	12	19	23	32	31	30	27
172.31	137.65	197.56	70	97		33	20	29	14	17	30	27	26	24	18
181.43	125.57	180.63	75.87	150.51		31	24	31	15	26	22	21	28	23	31
177.41	153.84	205.36	118.54	138.04		39	24	35	11	25	29	48	25	31	25
236.01	149.58	206.17	93.1	151.91		36	33	37	22	36	35	33	35	16	24
217.29	148.24	168.08	77.52	130.77		54	34	43	14.5	24	20	11	21	10	8
164.54	121.41	127.93	61.94	128.59		48	35	33	24	30	8	4	4	3	5
159.23	148.08	164.86	74.13	82.96		50	45	50	26	26	6	4	13	4	16
240.87	151.52	150.99				55	42	45			14	10	11
(Data for A) Total Sales Dollars by Day of Week						(Data for B) Number of Sodas Sold by Day of Week					(Data for C) Number of Coffees Sold by Day of Week
Bonus Project 3:
The Executive Express managers wish to know if there is a difference in sales between various days of the week. In particular, they would like to know:
A) If the (population) mean Total Sales is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
B) If the (population) mean Number of Sodas Sold is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
C) If the (population) mean Number of Coffees Sold is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
Instructions: To Complete this project, paste the results of your analyses (e.g. tables from StatCrunch) and answers to these questions in a Word document.
1) State which statistical procedure studied in this course allows you to compare the means of five different groups
2) Address the manager's question regarding Total Sales (A).
	Copy the data from Excel to StatCrunch
	Run the appropriate analysis
	Answer the questions:
		Is there evidence that the mean Total Sales varies among the 5 weekdays?
		If so, which means appear to be significantly higher or lower than which others?
		Estimate the difference in Total Sales between two days that show statistically significant differences in means,
			or state why an estimated difference is not meaningful and therefore not reported
3) Address the manager's question regarding Number of Sodas Sold (B).
	Copy the data from Excel to StatCrunch
	Run the appropriate analysis
	Answer the questions:
		Is there evidence that the mean Number of Sodas sold varies among the 5 weekdays?
		If so, which means appear to be significantly higher or lower than which others?
		Estimate the difference in Number of Sodas Sold between two days that show statistically significant differences in means,
			or state why an estimated difference is not meaningful and therefore not reported
4) Address the manager's question regarding Number of Coffees Sold (C).
	Copy the data from Excel to StatCrunch
	Run the appropriate analysis
	Answer the questions:
		Is there evidence that the mean Number of Coffees sold varies among the 5 weekdays?
		If so, which means appear to be significantly higher or lower than which others?
		Estimate the difference in Number of Coffees Sold between two days that show statistically significant differences in means,
			or state why an estimated difference is not meaningful and therefore not reported
5) Write one or two sentences that make recommendations to the manager based on the results of your analyses.
Evaluation:		Up to 6 bonus points
		Work will be evaluated on correct choice of statistical procedure and correct answers to questions
		You may do all or part of the assignment. If only some of the analyses are done, partial points will be assigned as appropriate.

Ans (A)

ANOVA: Single Factor								Calculations
(Data for A) Total Sales Dollars by Day of Week								c	5
SUMMARY								n	48
Groups	Count	Sum	Average	Variance
Tues	10	1935.98	193.598	840.9138622222
Wed	10	1451.81	145.181	482.2115877778
Thu	10	1733.04	173.304	1496.7140711111
Fri	9	822	91.3333333333	989.773025
Mon	9	1101.11	122.3455555556	581.0825277778
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	52886.4414522222	4	13221.6103630556	14.983	0.0000000957	2.589
Within Groups	37945.4001122222	43	882.4511654005
Total	90831.8415644444	47
			Level of significance			0.05
A) If the (population) mean Total Sales is the same for all five days of the week, or if at least one day has a significantly different mean, and if so, which are higher or lower than others and by how much
Tukey-Kramer Multiple Comparisons
	Sample	Sample		Sales	Absolute	Std. Error	Critical
Group	Mean	Size		Comparison	Difference	of Difference	Range	Results	Days
1: Tues	193.598	10		Group 1 to Group 2	48.42	9.39	37.95	Means are different	Tue-Wed
2: Wed	145.181	10		Group 1 to Group 3	20.29	9.39	37.95	Means are not different	Tue-Thu
3: Thu	173.304	10		Group 1 to Group 4	102.26	9.65	38.99	Means are different	Tue-Fri
4: Fri	91.33	9		Group 1 to Group 5	71.25	9.65	38.99	Means are different	Tue-Mon
5: Mon	122.35	9		Group 2 to Group 3	28.12	9.39	37.95	Means are not different	Wed-Thu
				Group 2 to Group 4	53.85	9.65	38.99	Means are different	Wed-Fri
Other Data				Group 2 to Group 5	22.84	9.65	38.99	Means are not different	Wed-Mon
Level of significance	0.05			Group 3 to Group 4	81.97	9.65	38.99	Means are different	Thu-Fri
Numerator d.f.	5			Group 3 to Group 5	50.96	9.65	38.99	Means are different	Thu-Mon
Denominator d.f.	43			Group 4 to Group 5	31.01	9.90	40.00	Means are not different	Fri-Mon
MSW	882.4511654005
Q Statistic	4.04

Ans (B)

Ans (B)								Calculations
(Data for B) Number of Sodas Sold by Day of Week								c	5
SUMMARY								n	48
Groups	Count	Sum	Average	Variance
Tues	10	399	39.9	131.2111111111
Wed	10	285	28.5	120.2777777778
Thu	10	353	35.3	72.9
Fri	9	151.5	16.8333333333	31.375
Mon	9	216	24	48
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	2003.6111111111	4	500.9027777778	6.060	0.001	2.589
Within Groups	3554.5	43	82.6627906977
Total	5558.1111111111	47
			Level of significance			0.05
Ans (B)
Soda	Sample	Sample		Sodas	Absolute	Std. Error	Critical
Group	Mean	Size		Comparison	Difference	of Difference	Range	Results	Days
1: Tues	39.9	10		Group 1 to Group 2	11.40	2.88	11.62	Means are not different	Tue-Wed
2: Wed	28.5	10		Group 1 to Group 3	4.60	2.88	11.62	Means are not different	Tue-Thu
3: Thu	35.3	10		Group 1 to Group 4	23.07	2.95	11.93	Means are different	Tue-Fri
4: Fri	16.83	9		Group 1 to Group 5	15.90	2.95	11.93	Means are different	Tue-Mon
5: Mon	24	9		Group 2 to Group 3	6.80	2.88	11.62	Means are not different	Wed-Thu
				Group 2 to Group 4	11.67	2.95	11.93	Means are not different	Wed-Fri
Other Data				Group 2 to Group 5	4.50	2.95	11.93	Means are not different	Wed-Mon
Level of significance	0.05			Group 3 to Group 4	18.47	2.95	11.93	Means are different	Thu-Fri
Numerator d.f.	5			Group 3 to Group 5	11.30	2.95	11.93	Means are not different	Thu-Mon
Denominator d.f.	43			Group 4 to Group 5	7.17	3.03	12.24	Means are not different	Fri-Mon
MSW	82.6627906977
Q Statistic	4.04

Ans (C)

Ans (C)								Calculations
(Data for C) Number of Coffees Sold by Day of Week								c	5
SUMMARY								n	48
Groups	Count	Sum	Average	Variance
Tues	10	228	22.8	128.6222222222
Wed	10	223	22.3	217.3444444444
Thu	10	228	22.8	108.4
Fri	9	168	18.6666666667	117.5
Mon	9	174	19.3333333333	74.5
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	-151.6555555556	4	-37.9138888889	(0.290)	ERROR:#NUM!	2.589
Within Groups	5625.3	43	130.8209302326
Total	5473.6444444444	47
			Level of significance			0.05
Ans (C)
Coffee	Sample	Sample		Coffee	Absolute	Std. Error	Critical
Group	Mean	Size		Comparison	Difference	of Difference	Range	Results	Days
1: Tues	22.8	10		Group 1 to Group 2	0.50	3.62	14.61	Means are not different	Tue-Wed
2: Wed	22.3	10		Group 1 to Group 3	- 0	3.62	14.61	Means are not different	Tue-Thu
3: Thu	22.8	10		Group 1 to Group 4	4.13	3.72	15.01	Means are not different	Tue-Fri
4: Fri	18.67	9		Group 1 to Group 5	3.47	3.72	15.01	Means are not different	Tue-Mon
5: Mon	19.33	9		Group 2 to Group 3	0.50	3.62	14.61	Means are not different	Wed-Thu
				Group 2 to Group 4	3.63	3.72	15.01	Means are not different	Wed-Fri
Other Data				Group 2 to Group 5	2.97	3.72	15.01	Means are not different	Wed-Mon
Level of significance	0.05			Group 3 to Group 4	4.13	3.72	15.01	Means are not different	Thu-Fri
Numerator d.f.	5			Group 3 to Group 5	3.47	3.72	15.01	Means are not different	Thu-Mon
Denominator d.f.	43			Group 4 to Group 5	0.67	3.81	15.40	Means are not different	Fri-Mon
MSW	130.8209302326
Q Statistic	4.04

ASFData3

Tues	Wed	Thu	Fri	Mon
41	33	34	27	20
23	32	31	30	27
30	27	26	24	18
22	21	28	23	31
29	48	25	31	25
35	33	35	16	24
20	11	21	10	8
8	4	4	3	5
6	4	13	4	16
14	10	11

TukeyKramer3

Ans (C)
	Sample	Sample		Absolute	Std. Error	Critical
Group	Mean	Size	Comparison	Difference	of Difference	Range	Results
1: Tues	22.8	10	Group 1 to Group 2	0.5	3.6169176136	14.6123471588	Means are not different
2: Wed	22.3	10	Group 1 to Group 3	0	3.6169176136	14.6123471588	Means are not different
3: Thu	22.8	10	Group 1 to Group 4	4.1333333333	3.7160295974	15.0127595736	Means are not different
4: Fri	18.6666666667	9	Group 1 to Group 5	3.4666666667	3.7160295974	15.0127595736	Means are not different
5: Mon	19.3333333333	9	Group 2 to Group 3	0.5	3.6169176136	14.6123471588	Means are not different
			Group 2 to Group 4	3.6333333333	3.7160295974	15.0127595736	Means are not different
Other Data			Group 2 to Group 5	2.9666666667	3.7160295974	15.0127595736	Means are not different
Level of significance	0.05		Group 3 to Group 4	4.1333333333	3.7160295974	15.0127595736	Means are not different
Numerator d.f.	5		Group 3 to Group 5	3.4666666667	3.7160295974	15.0127595736	Means are not different
Denominator d.f.	43		Group 4 to Group 5	0.6666666667	3.8125659227	15.4027663276	Means are not different
MSW	130.8209302326
Q Statistic	4.04

ANOVA3

Ans (C)							Calculations
							c	5
SUMMARY							n	48
Groups	Count	Sum	Average	Variance
Tues	10	228	22.8	128.6222
Wed	10	223	22.3	217.3444
Thu	10	228	22.8	108.4000
Fri	9	168	18.6666666667	117.5000
Mon	9	174	19.3333333333	74.5000
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	-151.6556	4	-37.9139	-0.2898	ERROR:#NUM!	2.5888
Within Groups	5625.3000	43	130.8209
Total	5473.6444	47
			Level of significance			0.05

ASFData2

Tues	Wed	Thu	Fri	Mon
20	13	23	13	13
33	15	27	12	19
33	20	29	14	17
31	24	31	15	26
39	24	35	11	25
36	33	37	22	36
54	34	43	14.5	24
48	35	33	24	30
50	45	50	26	26
55	42	45

TukeyKramer2

Ans (B)
	Sample	Sample		Absolute	Std. Error	Critical
Group	Mean	Size	Comparison	Difference	of Difference	Range	Results
1: Tues	39.9	10	Group 1 to Group 2	11.4	2.875113749	11.615459546	Means are not different
2: Wed	28.5	10	Group 1 to Group 3	4.6	2.875113749	11.615459546	Means are not different
3: Thu	35.3	10	Group 1 to Group 4	23.0666666667	2.9538985758	11.9337502461	Means are different
4: Fri	16.8333333333	9	Group 1 to Group 5	15.9	2.9538985758	11.9337502461	Means are different
5: Mon	24	9	Group 2 to Group 3	6.8	2.875113749	11.615459546	Means are not different
			Group 2 to Group 4	11.6666666667	2.9538985758	11.9337502461	Means are not different
Other Data			Group 2 to Group 5	4.5	2.9538985758	11.9337502461	Means are not different
Level of significance	0.05		Group 3 to Group 4	18.4666666667	2.9538985758	11.9337502461	Means are different
Numerator d.f.	5		Group 3 to Group 5	11.3	2.9538985758	11.9337502461	Means are not different
Denominator d.f.	43		Group 4 to Group 5	7.1666666667	3.030635993	12.2437694117	Means are not different
MSW	82.6627906977
Q Statistic	4.04

ANOVA2

Ans (B)							Calculations
							c	5
SUMMARY							n	48
Groups	Count	Sum	Average	Variance
Tues	10	399	39.9	131.2111
Wed	10	285	28.5	120.2778
Thu	10	353	35.3	72.9000
Fri	9	151.5	16.8333333333	31.3750
Mon	9	216	24	48.0000
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	2003.6111	4	500.9028	6.0596	0.0006	2.5888
Within Groups	3554.5000	43	82.6628
Total	5558.1111	47
			Level of significance			0.05

ASFData

Tues	Wed	Thu	Fri	Mon
199.95	195.74	102.68	162.88	101.76
186.94	120.18	228.78	88.02	119.57
172.31	137.65	197.56	70	97
181.43	125.57	180.63	75.87	150.51
177.41	153.84	205.36	118.54	138.04
236.01	149.58	206.17	93.1	151.91
217.29	148.24	168.08	77.52	130.77
164.54	121.41	127.93	61.94	128.59
159.23	148.08	164.86	74.13	82.96
240.87	151.52	150.99

TukeyKramer

Tukey-Kramer Multiple Comparisons
	Sample	Sample		Absolute	Std. Error	Critical
Group	Mean	Size	Comparison	Difference	of Difference	Range	Results
1: Tues	193.598	10	Group 1 to Group 2	48.417	9.3938871901	37.9513042479	Means are different
2: Wed	145.181	10	Group 1 to Group 3	20.294	9.3938871901	37.9513042479	Means are not different
3: Thu	173.304	10	Group 1 to Group 4	102.2646666667	9.6513016228	38.9912585562	Means are different
4: Fri	91.3333333333	9	Group 1 to Group 5	71.2524444444	9.6513016228	38.9912585562	Means are different
5: Mon	122.3455555556	9	Group 2 to Group 3	28.123	9.3938871901	37.9513042479	Means are not different
			Group 2 to Group 4	53.8476666667	9.6513016228	38.9912585562	Means are different
Other Data			Group 2 to Group 5	22.8354444444	9.6513016228	38.9912585562	Means are not different
Level of significance	0.05		Group 3 to Group 4	81.9706666667	9.6513016228	38.9912585562	Means are different
Numerator d.f.	5		Group 3 to Group 5	50.9584444444	9.6513016228	38.9912585562	Means are different
Denominator d.f.	43		Group 4 to Group 5	31.0122222222	9.9020265344	40.0041871992	Means are not different
MSW	882.4511654005
Q Statistic	4.04

ANOVA

ANOVA: Single Factor							Calculations
							c	5
SUMMARY							n	48
Groups	Count	Sum	Average	Variance
Tues	10	1935.98	193.598	840.9139
Wed	10	1451.81	145.181	482.2116
Thu	10	1733.04	173.304	1496.7141
Fri	9	822	91.3333333333	989.7730
Mon	9	1101.11	122.3455555556	581.0825
ANOVA
Source of Variation	SS	df	MS	F	P-value	F crit
Between Groups	52886.4415	4	13221.6104	14.9828	0.0000	2.5888
Within Groups	37945.4001	43	882.4512
Total	90831.8416	47
			Level of significance			0.05