# 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-

## We've got everything to become your favourite writing service

### Money back guarantee

Your money is safe. Even if we fail to satisfy your expectations, you can always request a refund and get your money back.

### Confidentiality

We don’t share your private information with anyone. What happens on our website stays on our website.

### Our service is legit

We provide you with a sample paper on the topic you need, and this kind of academic assistance is perfectly legitimate.

### Get a plagiarism-free paper

We check every paper with our plagiarism-detection software, so you get a unique paper written for your particular purposes.

### We can help with urgent tasks

Need a paper tomorrow? We can write it even while you’re sleeping. Place an order now and get your paper in 8 hours.

### Pay a fair price

Our prices depend on urgency. If you want a cheap essay, place your order in advance. Our prices start from $11 per page.