Description
You are to select an appropriate quantitative data analysis technique for each of the six (6) individual tasks below. DO NOT attempt to use the same data analysis technique for each task as that is not possible. Results MUST be presented in tables/figures appropriate for the data analysis technique used. An explanation of the results and relationship to SDG 12 are required. https://sdgs.un.org/goals The 12th SDG is Responsible Production and Consumption.Detail in files
Unformatted Attachment Preview
Mill area
Mossman
Tableland (Atherton)
Mulgrave
South Johnstone
Tully
Herbert River total
Burdekin total
Prosperpine
Mackay
Plane Creek
Bundaberg
Isis
Maryborough
Queensland total
Mill Region
Northern
Northern
Northern
Northern
Northern
Herbert
Burdekin
Central
Central
Central
Southern
Southern
Southern
Mill owner
https://fnmilling.com.au
www.msfsugar.com.au
www.msfsugar.com.au
www.msfsugar.com.au
www.tullysugar.com
www.wilmarsugar-anz.com
www.wilmarsugar-anz.com
www.wilmarsugar-anz.com
www.mkysugar.com.au
www.wilmarsugar-anz.com
www.bundysugar.com.au
www.isissugar.com.au
www.msfsugar.com.au
Tonnes of
Tonnes cane
cane
harvested from condemn
mill area
ed
867,320
0
429,274
0
888,878
0
1,517,377
104
2,179,083
0
4,055,702
0
7,909,756
38
1,546,803
0
4,927,815
0
1,272,644
160
1,095,130
0
971,582
0
592,216
0
28,253,580
302
Data from Sugar Research Australia
CCS = Commercail Cane Sugar (content of cane purchased by sugar mills)
IPS = International Polarisation Scale
2019 Queensland Cane and Sugar Production
Total hectares
Tonnes of cane
harvested from mill
crushed
area
867,320
429,274
888,878
1,517,673
2,175,083
4,055,702
7,909,718
1,546,803
4,927,815
1,272,484
1,095,130
971,582
592,216
28,249,678
10,908.0
4,737.6
11,737.0
21,527.6
29,248.3
56,365.7
67,823.0
21,036.1
67,586.8
17,841.5
15,460.8
13,183.9
9,603.3
347,059.6
Tonnes of
cane per
hectare
79.5
90.6
75.7
70.5
74.5
72.0
116.6
73.5
72.5
71.3
70.8
73.7
61.7
81.4
CCS Average
Tonnes of Sugar
IPS (est.)
Cane rail route
kilometres
12.95
14.14
12.94
12.95
13.56
13.89
14.97
14.14
14.02
14.63
14.62
14.76
14.32
13.99
110,443
60,388
158,187
161,873
290,555
564,772
1,222,301
221,922
697,300
184,507
159,852
150,576
86,284
4,068,960
87
0
256
470
200
563
624
230
850
167
330
153
0
Mill area
Mossman
Tableland (Atherton)
Mulgrave
South Johnstone
Tully
Herbert River
Burdekin
Prosperpine
Mackay
Plane Creek
Bundaberg
Isis
Maryborough
Queensland
Mill Region
Northern
Northern
Northern
Northern
Northern
Herbert
Burdekin
Central
Central
Central
Southern
Southern
Southern
Mill owner
https://fnmilling.com.au
www.msfsugar.com.au
www.msfsugar.com.au
www.msfsugar.com.au
www.tullysugar.com
www.wilmarsugar-anz.com
www.wilmarsugar-anz.com
www.wilmarsugar-anz.com
www.mkysugar.com.au
www.wilmarsugar-anz.com
www.bundysugar.com.au
www.isissugar.com.au
www.msfsugar.com.au
Tonnes cane
harvested from mill
area
757,788
486,217
1,002,143
1,771,356
2,463,558
4,250,399
7,905,092
1,535,660
5,152,241
1,234,483
1,047,595
808,815
633,914
29,049,261
2020 Queensland Cane and Sugar Production
Tonnes of
cane
condemn
ed
0
0
133
575
117
862
1184
0
541
0
0
0
0
3,412
Tonnes of cane
crushed
757,788
486,217
1,002,010
1,770,781
2,463,441
4,249,537
7,903,908
1,535,600
5,151,700
1,234,483
1,047,595
808,815
633,914
29,045,789
Total hectares
harvested from mill
area
Tonnes of
cane per
hectare
CCS Average
Tonnes of Sugar IPS
(est.)
9,610.0
5,345.5
11,402.5
21,707.5
28,210.0
55,224.5
66,201.4
20,239.7
65,326.3
18,374.0
13,743.9
10,127.4
10,065.7
335,578.4
78.9
91.0
87.9
81.6
87.3
77.0
119.4
75.9
78.9
67.2
76.2
79.9
63.0
86.6
12.98
14.35
12.41
12.23
12.95
13.19
14.62
14.36
14.12
14.25
14.67
14.81
14.49
13.80
81,448
85,765
169,173
182,465
326,604
581,287
1,198,377
224,466
737,078
182,312
153,032
123,851
90,595
4,136,453
Cane rail route
kilometres
87
0
256
470
200
563
624
230
850
167
330
153
0
2021 Queenslan
Mill area
Mill Region
Mossman
Northern
Tableland (Atherton) Northern
Mulgrave
Northern
South Johnstone
Northern
Tully
Northern
Herbert River
Herbert
Burdekin
Burdekin
Prosperpine
Central
Mackay
Central
Plane Creek
Central
Bundaberg
Southern
Isis
Southern
Maryborough
Southern
Queensland
Mill owner
https://fnmilling.com.au
www.msfsugar.com.au
www.msfsugar.com.au
www.msfsugar.com.au
www.tullysugar.com
www.wilmarsugar-anz.com
www.wilmarsugar-anz.com
www.wilmarsugar-anz.com
www.mkysugar.com.au
www.wilmarsugar-anz.com
www.bundysugar.com.au
www.isissugar.com.au
www.msfsugar.com.au
Tonnes of
Tonnes cane
cane
harvested from mill condemn
area
ed
733,289
9109
536,946
126
943,355
789
1,477,841
1008
2,513,827
6713
3,797,258
530
7,887,668
0
1,556,299
0
5,335,705
2100
1,367,692
508
936,828
31
711,959
0
467,621
0
28,266,288
20,914
2021 Queensland Cane and Sugar Production
Tonnes of cane
crushed
Total hectares
harvested from mill
area
724,180
536,920
942,566
1,476,833
2,507,114
3,796,668
7,887,668
1,556,299
5,333,605
1,367,184
935,797
711,959
467,621
28,244,414
9,118.0
5,570.7
11,208.1
20,871.6
28,863.4
54,985.5
65,505.2
19,901.0
63,666.0
17,487.2
11,892.5
9,000.0
7,391.4
325,460.6
Tonnes of
cane per
hectare
80.4
96.4
84.2
70.8
87.1
69.1
120.4
78.2
83.8
78.2
78.8
79.1
63.3
86.9
CCS Average
12.53
14.02
11.61
11.41
12.36
12.73
14.40
14.43
13.73
14.37
14.18
13.71
13.76
13.53
Tonnes of Sugar
IPS (est.)
76,957
76,251
111,344
168,927
317,336
484,884
1,173,826
227,227
745,097
194,226
129,725
100,215
66,459
3,872,474
Cane rail
route
kilometres
87
0
256
470
200
563
624
230
850
167
330
153
0
Length: 1500 words (excluding references, tables, charts, figures, and appendix)
Queensland sugar cane mill company:
Wilmar Sugar https://www.wilmarsugar-anz.com/
The 12th SDG is Responsible Production and Consumption. https://sdgs.un.org/goals
Requires a critical analysis of both quantitative and qualitative data.
The quantitative data in Excel (Queensland cane and sugar production)
The qualitative data is available on the home page of the Queensland Sugar Cane Mills Corporation
website. Wilmar Sugar https://www.wilmarsugar-anz.com/
Quantitative analysis
You are to select an appropriate quantitative data analysis technique for each of the six (6) individual
tasks below. DO NOT attempt to use the same data analysis technique for each task as that is not
possible. Results MUST be presented in tables/figures appropriate for the data analysis technique
used. An explanation of the results and relationship to SDG 12 are required. https://sdgs.un.org/goals
The 12th SDG is Responsible Production and Consumption.
The critical quantitative analysis tasks are:
1. Compare the average tonnes of cane harvested for each mill region for 2019, 2020, and 2021.
2. Compare the total number of hectares harvested for each mill region for 2019, 2020, and 2021.
3. Determine if there a significant difference between the tonnes of cane crushed and the tonnes
of sugar IPS, produced for each region and each year?
4. Determine if there is a trend in the total hectares harvested for each mill region (compare 2019,
2020, and 2021).
5. Compare the average tonnes of cane harvested by your selected Queensland sugar cane mill
company’s mills, against the tonnes of cane harvested by the other Queensland sugar cane mill
companies’ mills (compare 2019, 2020, and 2021).
6. Determine if there a significant difference between the tonnes of cane crushed and the tonnes
of sugar IPS, produced for your Queensland sugar cane mill company’s mills (compare 2019,
2020, and 2021).
TYPES OF DATA ANALYTICS technique (Need to choose one of these techniques to analyses the
task, each task requires a different selection of techniques, and no task is analysed with the same
techniques.)
1. Descriptive – who is doing what where, when and how?
2. Diagnostic – why are they doing that?
3. Exploratory – finding patterns of relationships between things that might be important
4. Predictive – use what people did/what happened in the past to predict the future
5.
6.
7.
Mechanistic – predict how changes in the processes in a system might influence outcomes
Causal analytics – identify how changes in key elements in the system might influence
outcomes
Inferential analytics – traditional business research using samples of big data
Qualitative analysis
You are going to conduct a critical qualitative analysis (inductive) of Queensland sugar cane mill
company’s website (Wilmar Sugar https://www.wilmarsugar-anz.com/ ). Look at this Queensland
sugar cane mill company website. Does the website homepage project responsible production and
consumption (UN SDG 12)? To answer this question, need to analyse the homepage as follows:
Begin with the homepage photos, for each photo consider:
1. Who and/or what is in the photo?
2. What is happening in the photo?
3. What visual image is the photo trying to project?
4. What is in the foreground of the photo (the focus)?
5. How is light used (dark/bright; sunny/cloudy etc)?
6. Does the accompanying text inform you more about the photo?
Discussion of image analysis:
Provide a comprehensive, synthesized discussion of your results DO NOT just write each question
and then an answer. Discuss how/if the images project the company’s alignment with responsible
production and consumption (UN SDG 12).
Next, read through the text on the homepage, you are using thematic analysis to understand the text
on the homepage.
1. Read the text and get familiar with what is being said. At this step look for general themes to
begin with and keep notes. Think about what you need to code and the codes you can use to
accurately describe the content. Remember SDG 12, you could code according to different methods
of responsible production, and consumption (e.g., power fed into the grid). Keep notes, write down
how and why you have coded your data, and what this means. This assists you as you work through
the text and back through the text (this is an iterative process), you need to know what you have
done before and why you did that.
2. Go through your initial codes carefully, look for patterns and themes. For example, the text you
are looking at relates to animals, you have initial codes of dogs, giraffes, leopards, flies, crickets,
and mosquitos. From these codes you can see two themes (aka categories). The codes of dogs,
giraffes, leopards, would fit the theme of mammals, while the codes of flies, crickets, and mosquitos,
would fit the theme of insects. As you work through the text you may notice sub-themes, for example,
the theme may be mammals, and sub-themes domesticated or wild. Your notes should show how
your codes were interpreted and combined into themes.
3. Review your themes and check everything categorized as a theme fits the text. Check the
themes actually exist in the text, are any missing? Are you certain your themes are accurate and
comprehensive? If there is too much information under one theme it may be too broad and may
require dividing into two or three themes. Remember, keep track of what you have done and any
changes to themes in your notes.
4. You spent time at step 3 refining your themes, now it is time to finalize them and give them a
label. At this step you can create a table of two columns. In the first column put the names of your
themes, in column 2, beside each theme provide a detailed description of the theme. Make certain
the theme names reflect the properties of the theme and are not ambiguous. You can use more than
one word to label your theme.
Discussion of text analysis:
Discuss the results of your text analysis, focusing on the UN SDG 12 topic. You are not to just
paraphrase, you need to tell a clear coherent story with selected quotes to support your points.
Concept maps, and/ or models and/or graphic images, and/or word clouds must be used to support
your results.
FORMAT (Length: 1500 words (excluding references, tables, charts, figures, and appendix)
Introduction:
Introduce the work, what it is about, what you are going to do, a brief background on Queensland
sugar cane mill company: Wilmar Sugar, and an outline of the UN’s SDG 12 as it relates to this
work.
Wilmar Sugar https://www.wilmarsugar-anz.com/
The 12th SDG is Responsible Production and Consumption. https://sdgs.un.org/goals
Quantitative analysis
You are to introduce the topic and the aim(s) of this quantitative section of your data analysis.
Introduce each task in turn and explain what quantitative data analysis technique you are going to
use for each task and why that technique is the best option for that task.
Results
Results should be presented in tables and figures appropriate for each analysis conducted. Tables
and figures must be correctly numbered and named. Write an explanation of the results shown in
the table/figure, and how these results are important to the UN SDG 12.
Qualitative analysis
You are to introduce the topic and the aim(s) of this qualitative section of your data analysis.
Results
Image analysis
Provide a comprehensive, synthesised discussion of your results DO NOT just write each question
and then an answer. Discuss how/if the images project the company’s alignment with responsible
production and consumption (UN SDG 12). If the images do not align with SDG 12, what do they
depict.
Text analysis
Discuss the results of your text analysis, focusing on the UN SDG 12 topic. You are not to just
paraphrase, you need to tell a clear coherent story with selected quotes to support your points.
Concept maps, and/ or models and/or graphic images, and/or word clouds must be used to support
your results.
Conclusion
Conclude with a section that brings together (synthesises) the results of your quantitative and
qualitative critical analyses and how they support or do not support the UN’s SDG 12.
Recommendations
Provide recommendations to the sugar cane mill owners on how to move the image they project on
their website to align more closely to the UN’s SDG 12.
Reference
APA7
Purchase answer to see full
attachment