Sydney University Data Analysis Worksheet

SWINBURNE UNIVERSITY OF THECHNOLOGYSTA10007 QUANTITATIVE ANALYSIS
TP3 2022
ASSESSMENT No. 2: Assignment (20%)
NAME: ………………………………………….
STUDENT ID: ………………………………….
STA10007 Assignement
TP3 2022
Page 1 of 9
Part A: Data Analysis and Presentation
QUESTION 1
The following data represent the number of Uni students booked for Covid testing in a
Sydney Covid testing clinic over a 50-week period.
29 25 29 30 32 29 28 30 28 29 26 30 28 32 27 31 29 28 30 27 30 29 28 31
27 26 30 29 28 27 31 32 26 31 27 29 32 30 27 30 31 32 28 29 31 28 26 30 31
29
Use MS Excel data analysis to produce a descriptive summary statistics table and
complete the table below.
Uni students booked for Covid testing in a clinic
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Kurtosis
Skewness
Range
Minimum
Maximum
Sum
Count
Q1
Q3
IQR
a. Comment on the skewness of the data set
b. Comment on stability or otherwise
c. Presentation: Video presentation (less than 10 minutes)
(2.5, 2.5, 3 = 8)
STA10007 Assignement
TP3 2022
Page 2 of 9
Part B: Data Analysis: Results Interpretation
QUESTION 2
Mean
Standard Error
Median
Mode
Standard Deviation
Sample Variance
Skewness
Range
Minimum
Maximum
Sum
Count
Coefficient of Variation
Q1 = 2.20; Q3 = 7.15; IQR = 4.95;
3.68
0.21
3.54
2.82
1.25
0.63
0.70
9.74
4000 (of a population of 26,000)
Tasks:
a
Complete the table
b
Comment on the skewness of the data set
c
Comment on stability or otherwise
d
Comment on the size of the sample
(2, 2, 3, 1 = 8)
STA10007 Assignement
TP3 2022
Page 3 of 9
QUESTION 3
Investments
Government Bonds
Shares – COM Bank
Shares – NAB
Mean Return
16.0%
10.0%
8.0%
Standard Deviation
0.50%
1.5%
1.0%
Tasks: (for each investment)
a
Complete the calculation for coefficient of variation
b
Comment on stability or otherwise for each investment based on part a above.
c
Find Mean +/- 1 standard deviation for each investment. Which investment
would you choose?
(3×1, 3×1, 2 = 8)
STA10007 Assignement
TP3 2022
Page 4 of 9
QUESTION 4
Regression Statistics
Multiple R
R Square
Adjusted R Square
Standard Error
Observations
0.95
0.92
0.87
1.25
6,000 (of a population of 14,000)
Intercept
X
Coefficients
21.50
3.00
Std. Error
5.06
1.37
t Stat
-3.50
1.80
Tasks:
a
Write the Regression equation
b
Explain the meaning of the key parts of the equation
c
Find the prediction/forecast for X = 6
d
Comment on the relevance of the statistical results for : R Square; n; t stats
e
Comment on how an increase of the sample size would affect the standard
error
(1, 2, 2, 2, 1 = 8 marks)
STA10007 Assignement
TP3 2022
Page 5 of 9
QUESTION 5
Regression Statistics
Standard Error
R Square
Adjusted R Square
F
N
8.50
0.08
0.09
4.20
300 (of a population of 30,000)
Intercept
X1
X2
X3
Coefficients Std. Error
21.50
19.670
1.00
4.956
2.30
0.610
-2.00
10.69
t Stat
-2.365
0.643
0.954
-0.165
Y = b0 + b1X1 + b2X2 + b3X3
Tasks:
a
Write the Regression equation
b
Find the prediction/forecast for: X1 = 7; X2=8; X3=5
c
Comment on the relevance of the statistical results: R Square, F, t Stats
d.
Comment on the size of the sample
e
Comment on the overall quality of the sample
(1, 2, 3, 1, 1 = 8)
STA10007 Assignement
TP3 2022
Page 6 of 9
QUESTION 6 (10 marks)
Class
0-