Answer To: MS Excel must be used to perform any calculations/graphical presentations as required in this...
Abr Writing answered on Sep 11 2020
MS Excel must be used to perform any calculations/graphical presentations as required in this assignment
Question 1 7 marks
Below you are given the examination scores of 20 students (data set also provided in accompanying MS Excel file).
52
99
92
86
84
63
72
76
95
88
92
58
65
79
80
90
75
74
56
99
a.
Construct a frequency distribution, cumulative frequency distribution, relative
frequency distribution, cumulative relative frequency distribution and percent
frequency distribution for the data set using a class width of 10.
(5 marks)
b.
Construct a histogram showing the percent frequency distribution of the examination
scores. Comment on the shape of the distribution.
(2 marks)
a.
Class interval
Frequency
Cumulative frequency
Relative frequency
Cumulative relative frequency
Percent frequency
51 – 61
3
3
0.15
0.15
15
61 – 71
2
5
0.10
0.25
10
71 – 81
6
11
0.30
0.55
30
81 – 91
4
15
0.20
0.75
20
91 – 101
5
20
0.25
1.00
25
b.
The distribution is slightly negatively skewed.
Question 2 8 marks
Shown below is a portion of a computer output for a regression analysis relating supply (Y in thousands of units) and unit price (X in thousands of dollars).
ANOVA
df
SS
Regression
1
354.689
Residual
39
7035.262
Coefficients
Standard Error
Intercept
54.076
2.358
X
0.029
0.021
a.
What has been the sample size for this problem?
(1 mark)
b.
Determine whether or not demand and unit price are related. Use α = 0.05.
(2 marks)
c. Compute the coefficient of determination and fully interpret its meaning. Be very specific.
(2 marks)
d.
Compute the coefficient of correlation and explain the relationship between supply and
unit price.
(2 marks)
e.
Predict the supply (in units) when the unit price is $50,000.
(1 mark)
HI6007 T12018 Group Assignment
Page 1
a. The sample size for the problem is 41.
b. t value = 0.029 / 0.021 = 1.381
t0.025, 39 = 2.021
As the tabulated value is...