Appendix 1 Discussion Points

Loss of Marks: if you use the words: avoid using, mean, median, symmetric, skewed, histogram, boxplot, standard deviation, variance, Q1, Q3, IQR, outliers (or any variant thereof).

For both Government Departments and Private Enterprises, state and interpret the values for the chosen measures of central tendency and dispersion using layman's terms.A bullet point discussion is OK. (Appendix 1(a), (d)).

Report whether there have been unusually high or low office size per employee between private enterprises and government departments (Appendix 1 (b)).

By making reference to the histograms in the Infographic, discuss if there is a difference in office size per employee between private enterprises and government departments. Would Cluster Adelaide be in a position to welcome employees from both industries (Appendix 1).

the data for appendix 1.

Private Enterprises SR

Mean

12.9615385

Standard Error

0.51014397

Median

12

Mode

12

Standard Deviation

6.3716961

Sample Variance

40.5985112

Kurtosis

0.96935094

Skewness

0.64632605

Range

37.5

Minimum

0.5

Maximum

38

Sum

2022

Count

156

Q1

9

Q3

17

IQR

8

Government Departments SR

Mean

15.47619048

Standard Error

0.612573572

Median

15

Mode

17

Standard Deviation

6.277011229

Sample Variance

39.40086996

Kurtosis

-0.023700403

Skewness

0.123400937

Range

29.5

Minimum

0.5

Maximum

30

Sum

1625

Count

105

Q1

11

Q3

19

IQR

8

(b)(4 marks) Extend the analysis in (a) to include outlier calculations using the 1.5xIQR Rule.Perform these calculations by hand (not in Excel) and include here. Use this rule to determine whether there are any outliers.

Private enterprises Government departments

Lower outlier

Q1-1.5xIQR) = -3Lower Outlier = -1

Upper outlier Upper Outlier = 31

Q3+1.5xIQR) = 29

There is outlier in private enterprise and no outlier in the government department.

(c)(3 marks) Use EXCEL to create one histogram each for Private Enterprises and then Government Departments.

EXCEL INSTRUCTIONS: To create the histogram, in the EXCEL spreadsheet there is a column called Bin. Use the Bin Range provided by following the steps to create the histogram.

Refer to the Excel demonstration in the Lecture for Week 6. Otherwise, you can also find the instructions on Topic 6 (page 26-31) of the Excel Booklet.

For full marks edit each histogram to have a meaningful title that includes your network ID and replace the axis title 'Bin' with a meaningful axis title.

(d)(5 marks) By referring to your output from parts (a) and (b) and the side-by-side boxplot below, discuss the following features for the data set as a whole (do not repeat the discussion twice, provide just a single general explanation):

(i)The variable type of the data: Quantitative (Continuous or Discrete) or Qualitative (Nominal or Ordinal)

Quantitative continuous data

(ii)The shape of the distribution (symmetric, skewed left, skewed right).Support your discussion by

Using the boxplot by referring to the whisker lengths and presence/lack of outliers

Due to lack of outliers the Government department is an approximately symmetrical data, and the data is almost evenly spread. But the private enterprise has outlier present and the data distribution is skewed to right.

For the purposes of making comparisons which would be the single most appropriate measure of central tendency and dispersion? Simply state your choice and give a brief reason why.

boxplot.png

sqm per employee T 2 O Government Departments Private Enterprises