Q1
The table below indicate the norm for students grades in MGSC 301.
Grade		Excellent	Very Good	Good	Accepted	Fail
Proportion of Students	0.4	0.3	0.15	0.1	0.05
Q1
The new cohort of 75 students in MGSC 301 indicated the following results:
Grade		Excellent	Very Good	Good	Accepted	Fail
Number of Students	31	23	12	7	2
Using p = .05, does the actual rating of the new cohort deviate significantly
from the norm in MGSC 301?

Q2											6 Marks			Production Methods
A production manager is comparing between three production methods.								A	B	C
The productivity (number of units produced per day) of the three production methods for the last 25 days					45	39	43
is presented in the table titled "Production Methods."										42	37	41
At the = .05 level of significance, test whether the means for the three production methods are equal.					78	62	66
														56	47	51
														45	39	43
														71	57	61
														52	44	48
														59	49	53
														52	44	48
														48	41	45
														81	64	68
														76	61	65
														65	53	57
														63	52	56
														52	44	48
														41	36	40
														47	40	44
														58	48	52
														69	56	60
														95	74	78
														62	51	55
														51	43	47
														42	37	41
														53	45	48
														74	59	63

Q3										12 Marks				Age	Weight
A researcher is interested in determining if age predicts weight or not.								54	65
The table to the right indicate the age and weights of the people (14) in the sample.							62	92
														80	82
														25	74
a) Run simple regression analysis using Excel.					2 Mark					28	76
Note: use 95% confidence level.												29	71
														62	79
b) Is age a significant determinant of weight? Explain.					3 Marks					64	85
														47	82
c) What is amount of variation in weight that is explained by age? Explain.			4 Marks					49	62
														52	64
d) What is the expected weight of a person who is 56 years old?				3 Marks					35	54
														36	73
														91	83

Q4													12 Marks	ParkSpend
The "Multinational Parks" is interested in determining the variables that influence the amount of money families spend at their parks.					Spend ($)	Number of Family members	Distance from the Parks (KM)
The "ParkSpend" table to the right indicate the amount spent per family, the number of family members, and the distance from the park families live.			38.39	4	20
														31.04	5	34
a) Run regression analysis using Excel to determine the variable(s) that significantly influence the amount of money families spend at the parks.				51.45	6	11
Note: use a 95% confidence level.										2 Marks		107.19	3	61
														144.24	3	119
b) Which variable(s) significantly affect(s) spending at parks? Explain.							2 Marks		72.54	3	28
														36.13	2	41
c) What is the amount of variation that the number of family members and distance from the parks? Explain.				2 Marks		100.09	6	85
														151.96	6	148
d) Is the regression model significant? Explain.									2 Marks		82.3	6	13
														201.18	7	134
e) Based on the Excel output, what is the regression equation?								2 Marks		91.74	5	70
														56.66	4	4
f) Based on the regression equiation, estimate the amount of spending a family of 6 that lives 28 kilometres from the parks is expected to spend.				56.69	1	50
Show your work.											2 Marks		19.9	3	59
														99.32	5	34
														62.82	7	28
														25.74	3	5
														94.84	5	43
														132.31	4	132
														86.52	4	96
														25.33	4	20
														17.2	7	9
														158.95	8	108
														64.97	4	38
														152.15	7	73
														130.47	2	143
														161.04	7	107
														27.41	6	9
														165.2	7	130
														13.15	4	24
														75	2	3
														50.7	1	82
														64.63	1	40
														44.94	4	6
														93.02	6	59
														45.62	4	42
														84.72	7	26
														53.52	8	14
														169.76	7	134
														62.07	7	45
														146.18	3	144
														130.92	1	119
														64.05	5	44
														81.57	1	85
														66.42	4	85
														80.26	1	136
														51.85	3	39
														138.65	2	141
														150.89	1	118
														55	7	8
														26.38	5	11
														113.5	5	81
														85.86	3	119
														192.3	8	99
														85.54	1	38
														26.93	1	27
														97.77	5	68
														107.21	4	62
														44.77	5	7
														175.82	5	147
														114.88	3	65
														80.97	1	87
														155.53	4	145
														134.27	6	90
														179.69	6	136
														30.9	3	1
														18.62	3	27
														118.37	3	72
														106.52	6	55
														88.75	8	70
														23.19	4	40
														126.24	4	65
														91.22	2	42
														101.2	2	38
														29.86	1	88
														120.87	8	64
														63.94	5	23
														100.04	5	89
														41.42	1	100
														167.42	8	89
														21.04	1	28
														4.59	2	7
														115.66	1	136
														71.57	7	53
														69.12	6	18
														143.79	5	136
														183.82	2	141
														150.98	8	145
														105.84	6	21
														139.27	6	104
														23.91	2	8
														154.14	4	111
														139.32	7	72
														77.43	3	122
														87.18	2	76
														141.37	1	138
														170.74	7	103
														102.15	3	99
														7.05	1	17
														118.59	4	63
														134.19	8	48
														127	4	103
														70.75	1	133
														53.68	4	49
														156.7	2	148
														61.45	1	47
														67.71	5	21
														75.53	5	49
														58.12	4	21
														83.06	8	23
														99.45	6	85
														54	1	18
														175.77	4	116
														89.18	5	40
														84.84	1	106
														42.82	6	55
														82.1	8	40
														101.23	4	65
														161.93	5	142
														131.82	6	62
														110.29	3	141
														42.37	4	16
														135.65	3	118
														39.56	4	11