_________________________
________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis
Assignment Two (Ver DU-A) Page 1
MIS770 Foundation Skills in Business Analysis
DEPARTMENT OF INFORMATION SYSTEMS AND BUSINESS ANALYTICS
DEAKIN BUSINESS SCHOOL
FACULTY OF BUSINESS AND LAW, DEAKIN UNIVERSITY
Assignment Two
Analysis of Climate Change Survey Data
Particulars
• Due: Week 9, 11:59 pm, Sunday 17th May 2020.
• Marks: 30%.
• Words: 2,000 words or approximate equivalent.
• Submission: Two files (Excel, Word) electronically in CloudDeakin.
Email submissions will not be accepted.
Note: Do not convert your Word document to pdf format.
• Notes: This assignment is to be completed individually.
Please ensure you are familiar with the Extension Request and the Late Penalties rules
governing assignments in the Faculty of Business and Law (see details below).
Assurance of Learning
This assignment assesses the following Graduate Learning Outcomes and related Unit Learning Outcomes:
Graduate Learning Outcome (GLO) Unit Learning Outcome (ULO)
GLO4: Critical thinking: evaluating information using
critical and analytical thinking and judgment
ULO2: Manipulate and summarise data that
accurately represents real world problems
ULO3: Interpret and appraise statistical output to
assist in real-world decision making
Faculty of Business and Law Assignment Extension Procedures
Information for students seeking an extension BEFORE the due date
If you wish to seek an extension for this assignment prior to the due date, you need to apply directly to the Unit
Chair by completing the Assignment and Online Test Extension Application Form (available from
https://www.deakin.edu.au/students/faculties/buslaw/student-support/assignment-extensions) and sending the
completed form as well as your supporting documentation (if a non COVID-19 related issue) and a draft of your
assignment, to our generic email address T12020MIS770@deakin.edu.au. (Note: completing the Extension
Application Form is mandatory if you wish to apply for an extension.)
This process needs to occur as soon as you become aware that you will have difficulty in meeting the due date,
but no later than 5-00 pm Friday 15th May 2020. In other words, requests for extensions will not be entertained
after the normal close of business on Friday 15th May 2020.
Please note: Unit Chairs can only grant extensions up to two weeks beyond the original due date. If you require
more than two weeks, or have already been provided an extension by the Unit Chair and require additional
time, you must apply for Special Consideration via StudentConnect within 3 business days of the due date.
Misreading the due date/time, assignment anxiety or returning home will not be accepted as grounds for
consideration.
https://www.deakin.edu.au/students/faculties/buslaw/student-support/assignment-extensions
mailto:T12020MIS770@deakin.edu.au
_________________________________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis Assignment Two (Ver DU-A) Page 2
Conditions under which an extension will normally be considered include:
• Medical – to cover medical conditions of a serious nature, e.g. hospitalisation, serious injury or chronic
illness.
Note: temporary minor ailments such as headaches, colds and minor gastric upsets are not serious medical
conditions and are unlikely to be accepted. However serious cases of these may be considered.
• Compassionate – e.g. death of a close family member, significant family and relationship problems.
• Hardship/Trauma – e.g. sudden loss or gain of employment, severe disruption to domestic arrangements,
victim of crime.
Information for students seeking an extension AFTER the due date
If the due date has passed; you require more than two weeks extension, or you have already been provided with
an extension and require additional time, you must apply for Special Consideration via StudentConnect. Please
be aware that applications are governed by University procedures and must be submitted within three business
days of the due date or previously granted extension due date.
In most instances the maximum amount of time that can be granted for an assignment extension is three weeks
after the due date, as Unit Chairs are required to have all assignment submitted before results/feedback can be
released back to students.
Penalties for late submission
The following marking penalties will apply if you submit an assessment task after the due date without an
approved extension:
• 5% will be deducted from the available marks for each day, or part thereof, up to five days.
• Work that is submitted more than five days after the due date will not be marked; you will receive 0% for
the task.
Note: ‘Day’ means calendar day.
The Unit Chair may refuse to accept a late submission where it is unreasonable or impracticable to assess the
task after the due date.
Additional information
For advice regarding academic misconduct, special consideration, extensions, and assessment feedback, please
refer to the document “Rights and responsibilities as a student” in the “Unit Guide and Information” folder
under the “Resources” section in the MIS770 CloudDeakin site.
________________________________________________________________________________________________
Overview
The purpose of this assignment is to investigate a dataset that has been produced as a result of the survey you
conducted on Climate Change. You now need to interrogate the dataset in order to answer questions posed by
your client, the Australian Government. Ultimately, you will need to analyse the data, interpret the results, and
then draw appropriate conclusions.
The aims of the assignment are to:
• provide you with some examples of the application of data analysis
• test your understanding of the material presented in the relevant topics
• test your ability to analyse data and interpret your results
• test your ability to effectively communicate your results to others
Before attempting the assignment, make sure you have prepared yourself well. At a minimum, please read the
relevant sections of the prescribed textbook and review the materials provided in Modules 1 and 2 (i.e. Topics 1
to 7).
_________________________________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis Assignment Two (Ver DU-A) Page 3
Scenario
The Australian Government has previously commissioned you, Ellyse Perry (Chief Analyst at Survey House), to
develop a survey to help them gauge the views of the Australian public regarding “Climate Change”. Now, in
order to implement possible Climate Change policy initiatives, the Government, through their representative
Daisy Pearce (Manager, Public Relations in the Prime Minister’s Office), wants you to interpret the data gathered
from your survey and then answer several questions.
Daisy does not have an analytics background, so it’s important that you utilise “plain, easy to understand
language” in your answers. If you believe you need to include any technical terms, then you must explain these
in a clear and succinct manner.
The questions you need to answer are contained in the following memorandum.
Memorandum
Date: 24th April, 2020
To: Ellyse Perry, Chief Analyst, Survey House
From: Daisy Pearce, Manager, Public Relations, PM’s Office
Subject: Analysis of Climate Change Survey Data
Dear Ellyse,
Can you please carry out an analysis of the recent Climate Change Survey data (contained in the file
ClimateChangeSurvey.xlsx) and prepare a Memorandum reply to me containing answers to the following
questions.
My specific questions are:
Q1. An Overall View of “Monthly_Payment” spend per month
Can you provide me with an overall summary of the amount people are willing to pay monthly in order to have
a net zero electricity bill sourced entirely through renewable energy (e.g. solar panels with backup battery)? A
summing up of the variable “Monthly_Payment” just by itself, would be useful.
Q2. “Monthly_Payment” vs “Concerned”
I am interested in how the “Monthly_Payment” amount people are willing to pay for renewable energy relates
to how “Concerned” people are with the current situation regarding Climate Change. In particular, does there
appear to be any difference in how much people are prepared to pay monthly on renewable energy compared
to the “Concerned” responses of: Not concerned; Slightly concerned; Somewhat concerned; Very concerned,
and Extremely concerned.
Q3. Climate Change Affordability Measures
(a) Can you estimate the average “Monthly_Payment” amount people are willing to pay for renewable
energy in Australia?
(b) Climate Change is a global concern and there are countries that do not have the financial resources to
address their local Climate Change circumstances. Therefore, I’m interested to know if you can estimate
the proportion of all Australians who believe that Australia should financially “Support” developing
countries in their efforts to address Climate Change.
Q4. Climate Change Views
(a) A previous report published by one of the national daily newspapers indicated that the proportion of
Australians who have Already Installed or Plan to Install “Solar_Panels” on their homes is no more than
25%. An industry energy group has responded to this report by claiming that the rate has been
understated and the true figure is higher. Can you check this industry group’s claim?
(b) Another point of contention made in the report was the amount of money Australians would be
prepared to make an up-front payment (“Up_Front_Payment”) in order to have net zero electricity bills
_________________________________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis Assignment Two (Ver DU-A) Page 4
through renewable energy. The report states that it is, on average, less than $21,500. The same
industry energy group has responded by claiming that the amount of money Australians are prepared to
pay up-front is at least $21,500. Could you please also check this claim by the industry group?
Q5. Relationships
I would like to see whether factors listed below provide any explanation of the amount people are willing to pay
monthly (“Monthly_Payment”) in order to have net zero electricity bills through renewable energy. If so, can you
also indicate which factor is the most important?
(a) “Income”
(b) “Age”
Q6. Appropriate Sample Size
Finally, I am concerned that the sample of 400 Australians is too small to provide accurate results as this seems
hardly enough data. For a survey we intend to undertake next year, we would like to be able to:
(a) estimate the proportion of Australians that are Aware or Very Aware of Climate Change to within 3%,
and
(b) accurately estimate the average monthly payment (“Monthly_Payment”) amount people are willing to
pay in order to have net zero electricity bills through renewable energy to within $20.
How many Australians would we need to include in next year’s survey to satisfy both of these requirements?
Regards, Daisy
Memorandum Requirements
• Your memorandum reply should be no longer than 3 pages and there is no need to include a Table of
Contents, any visualisations (i.e. Charts and Tables), or Appendices in the Memorandum. The
Charts/Graphics and Tables you create are only to be placed in the Data Analysis file (i.e. the Excel
spreadsheet) and not reproduced in the memorandum.
• Suggested Word formatting for the memorandum: Single‐line spacing; no smaller that 10‐ point font; page
margins approx. 25mm, and good use of white space.
• Your memorandum must, however, have a cover sheet containing your particulars and Unit details.
• Set out the memorandum in the same order as in the originating Memorandum from Daisy, with each
section (question) clearly marked.
• Use plain language and keep your explanations succinct. Avoid the use of technical or statistical jargon. As
a guide to the meaning of “Plain Language”, imagine you are explaining your findings to a person without
any statistical training (e.g. someone who has not studied this unit). What type of language would you use
in that case?
• Marks will be lost if you use unexplained technical terms, irrelevant material, or have poor
presentation/organisation.
• All Microsoft Excel output associated with each question in the Memorandum is to be placed in the
corresponding tab in the file ClimateChange_yourstudentid.xlsx
Data Analysis Instructions/Guidelines
In order to prepare a reply to Daisy’s memorandum, you will need to examine and analyse the dataset
ClimateChangeSurvey.xlsx thoroughly.
Daisy has asked a number of questions and your Data Analysis output (i.e. your charts/tables/graphs) should be
structured such that you answer each question on the separate tab/worksheet provided in your Excel document.
There are also three extra tabs in ClimateChangeSurvey.xlsx called CI, HT and SS and you may use the various
templates contained in these tabs in your “Confidence Interval”, “Hypothesis” and “Sample Size” answers
should you wish to do so.
_________________________________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis Assignment Two (Ver DU-A) Page 5
_________________________________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis Assignment Two (Ver DU-A) Page 6
In order to effectively answer the questions, your Data Analysis output needs to be appropriate. Accordingly,
you’ll need to establish which of the following techniques are applicable for any given question:
• Summary Measures (e.g. Descriptive Statistics, Inc. Outlier detection).
• Comparative Summary Measures (i.e. Descriptive Statistics for multiple values of a variable).
• Suitable tables (such as a Frequency Distribution) and charts or graphics (such as Histograms, Box Plots, Pie
Charts, Bar/Column Charts) that will illustrate more clearly, other important features of a variable.
• Scatter Diagrams (used to visually establish if there is a relationship between two numeric variables).
• Cross Tabulations (sometimes called Contingency Tables), used to establish the relationships (dependencies)
between two variables (see Additional Materials under Topic 2 – Creating Cross Tabulations in Excel using
Pivot Tables).
• Confidence Intervals. You can assume that a 95% confidence level is appropriate. We use Confidence
Intervals when we have no idea about the population parameter we are investigating. Additionally, we
would use Confidence Intervals if we are asked for an estimate. You can use the relevant Excel templates
provided in the dataset and copy them to the applicable question tab.
• Hypothesis Tests. You can assume that a 5% level of significance is appropriate. We Use Hypothesis Tests
when we are testing a Claim, a Theory or a Standard. You can use the relevant Excel templates provided in
the dataset and copy them to the applicable question tab.
• Sample size calculation: You can assume that a 95% confidence level is appropriate. You may include
comparisons for 90% and 99% and a recommendation for the appropriate sample size.
• To answer some questions, you may need to make certain assumptions about the data set we are using.
Mention these in your data analysis, where relevant. There is no need to mention this in the memo.
Note: There is an Appendix at the end of each Chapter of the Prescribed Textbook which describes the basic
Excel steps associated with that Topic. Chapters 1 to 9 are applicable for this assessment.
Submission
Your completed assignment should be submitted in two separate files:
• Memorandum (Part A): A Word document of no more than 3 pages that is not to contain any
charts/tables/graphs. (Note: Do not submit a pdf document in lieu.). Please name your Word document
ClimateChange_yourstudentid x
• Data Analysis (Part B): An Excel document containing separate tabs/worksheets with charts/tables/graphs
for each question. Please note that all interpretations should be presented in your “Memorandum” and the
Excel document should only contain your intermediate analysis and final output. Please name your Excel
document ClimateChange_yourstudentid.xlsx
The assignment is to be submitted to the MIS770 assignment box in Deakin’s Cloud Campus before 11-59 pm,
Sunday 17th May 2020. Please ensure you include your name and student details in your Word document as well
following the above file naming convention. Failure to follow this convention may lead to a delay in receiving
feedback and marks.
_________________________________________________________________________________________________________________________
MIS770 Foundation Skills in Business Analysis Assignment Two (Ver DU-A) Page 7
Marking Rubric
Poor
Needs
Improvement Satisfactory Good Very Good Excellent
Data Analysis
(Marks: 16)
0 points 4.8 points 8 points 9.6 points 11.2 points 16 points
This part
relates to the
various
visualisations
in the form
of charts,
tables &
graphs etc.
created by
Ellyse which
formed the
basis of her
response to
Daisy.
Uses irrelevant
or inappropriate
techniques to
analyse the data,
or the Data
Analysis and
visualisation
tools were used
to analyse the
data but in an
incomplete or
inaccurate
manner.
Uses some
appropriate data
analysis and
visualisation tools
to analyse the
data but there
are many errors
in the analysis.
Uses
appropriate data
analysis and
visualisation tools
to analyse the
data but there
are several errors
in the analysis.
Uses
appropriate data
analysis and
visualisation tools
to analyse the
data but there
are some errors
in the analysis.
Comprehensive
analysis of the
data using
appropriate
techniques, but
there are some
minor errors in
the analysis.
Uses data
visualisations to
understand the
patterns in data.
Skilful and
comprehensive
analysis of data
using many
different
techniques.
Uses data
visualisations to
produce novel
insights.
A very poor
presentation of
the analysis, or
the analysis
does not follow
principles of
good graphical
display.
The
presentation of
the analysis
needs
improvement.
The
presentation of
the analysis is
satisfactory.
The
presentation of
the analysis is of
a respectable
standard.
The analysis is
well organised
and follows
principles of
good graphical
display.
An excellent
presentation of
the analysis.
0 – 4.7 Marks 4.8 – 7.9 Marks 8 – 9.5 Marks 9.6 – 11.1 Marks 11.2 – 12.7 Marks 12.8 – 16 Marks
Memorandum
(Marks: 12)
0 points 3.6 points 6 points 7.2 points 8.4 points 12 points
This part is the
written
response by
Ellyse to the
questions
posed by
Daisy.
Does not
communicate any
of the main
findings of the
analysis in an
accurate and/or
useful way, or
the interpretation
and
communication
of findings is at a
basic level.
Explains some of
the main
findings of the
analysis
accurately which
only enables the
reader to draw a
few reasonable
conclusions.
Explains most of
the main
findings of the
analysis
accurately and
enables the
reader to draw
several
reasonable
conclusions.
Explains nearly
all of the main
findings of the
analysis
accurately and
enables the
reader to draw
mostly
reasonable
conclusions.
Provides
detailed and
accurate
descriptions of
the most
important
features of the
analysis along
with
appropriately
qualified
conclusions.
Provides
outstanding
descriptions and
conclusions that
are carefully
considered and
insightful.
The written
communication is
unprofessional or
difficult to follow
and contains
numerous errors.
The written
communication
is not very easy
to follow and/or
it contains too
many errors.
The written
communication
is clear and easy
to follow but it
contains minor
errors.
The written
communication
is clear and easy
to follow and
generally free of
errors.
The written
communication
is professional,
easy to follow
and has a good
structure.
The written
communication
is very
professional,
logical and easy
to follow.
0 – 3.5 Marks 3.6 – 5.9 Marks 6 – 7.1 Marks 7.2 – 8.3 Marks 8.4 – 9.5 Marks 9.6 – 12 Marks
Overall
Assignment
Presentation
(Marks: 2)
0 points
No attempt has
been made to
follow the
assignment
Requirements/
Instructions/
Guidelines.
0.6 points
Little attempt
has been made
to follow the
assignment
Requirements/
Instructions/
Guidelines.
1 point
Most of the
assignment
Requirements/
Instructions/
Guidelines have
been followed.
1.2 point
Majority of the
assignment
Requirements/
Instructions/
Guidelines have
been followed.
1.4 points
All of the
assignment
Requirements/
Instructions/
Guidelines have
been followed.
2 points
All of the
assignment
Requirements/
Instructions/
Guidelines have
been dealt with
meticulously.
Poorly
presented
Unsatisfactorily
presented
Satisfactorily
presented
Good
presentation
Very good
presentation
Faultless
assignment
presentation
0 – 0.5 Marks 0.6 – 0.9 Marks 1 – 1.1 Marks 1.2 – 1.3 Marks 1.4 – 1.5 Marks 1.6 – 2 Marks
>Variables
panels with battery)
, }
, Vic, Qld, , , Tas, , }
, }
, High School, Certificate, Degree, , }
ition
, , Green, Minor Parties}
, }
, Dissatisfied, /Unfamiliar, , }
}
, , There is no Climate Change, Unsure/Undecided}
ness
, Moderately Aware, Have a little knowledge, Have no Interest/Awareness}
Not Serious, – Extremely Serious)
, , , , , , , 10}
, , Would Install if I could, No plan to install/Do not want}
, , Coal, , , , Renewable}
, , , , , , Other}
Set
Monthly_Payment Up_Front_Payment Age Gender Income State Locality Education Politics Support Cause Awareness Affected Seriousness Concerned Solar_Panals Energy_Source News_Source 8.00
, 0
35 Female ,000
Rural Postgrad Degree Yes Very Satisfied Mostly Human 1 Gas Magazines .00
, 0
Male , 0
Urban TAFE Labour Yes Very Satisfied Australian Govt Mostly Natural Very Aware Severly Affected 10 Already Installed Hydro Social Media Female , NSW Rural Bachelor Labour Yes Dissatisfied Australian Govt Unsure Very Aware 4 Already Installed Solar Other 8.00
,9 Female ,000
Rural High School Other Yes Australian Govt Little Knowledge 2 No Plan/Do Not Want Hydro Newspapers .00
,7 33 Male NSW Urban High School Labour Yes Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Plan to Install Oil Internet 8.00
, 5
60 Female NSW Urban High School Coalition Yes Australian Govt No Climate Change Very Aware Somewhat Affected 9 No Plan/Do Not Want Coal Newspapers 2.00
Male NSW Rural Bachelor No Very Dissatisfied Australian Govt Mostly Human Very Aware Not Affected 5 Somewhat Concerned Plan to Install Coal Magazines .00
, 25 Male ,000
VIC Rural High School Greens Yes Satisfied Mostly Human Little Knowledge Somewhat Affected 2 Not Concerned Already Installed Wind Internet .00
Female ,000
NSW Urban Bachelor Coalition Yes Very Satisfied State Govts Mostly Natural Aware Not Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Social Media .00
35 Female , 0
VIC Urban High School Greens Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Slightly Concerned Solar Internet ,0 35 Male ,000
QLD Urban PhD Coalition Yes Very Satisfied Australian Govt Mostly Natural Aware Severly Affected 4 Very Concerned No Plan/Do Not Want Wind Newspapers , 0
49 Female ,800
NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Human Aware Somewhat Affected 7 Somewhat Concerned No Plan/Do Not Want Hydro TV .00
5
Male NSW Urban High School Labour No Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Plan to Install Hydro Magazines 50 Male QLD Rural High School Coalition Yes Dissatisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 7 Very Concerned Plan to Install Coal Social Media 0.00
,600
49 Female ,000
VIC Rural High School Coalition Yes Satisfied Individuals/Families Mostly Human Little Knowledge Somewhat Affected 7 Very Concerned Already Installed Wind Internet .00
5
39 Female , 0
QLD Urban High School Coalition No Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Coal Internet .00
Male NSW Urban TAFE Coalition No Dissatisfied Australian Govt Mostly Human Very Aware Severly Affected 10 Very Concerned No Plan/Do Not Want Solar Other .00
5
59 Female NSW Urban High School Coalition Yes Very Satisfied No Climate Change Very Aware Somewhat Affected 9 Very Concerned Install if I Could Coal Other 25 Female WA Urban Bachelor Coalition No Very Satisfied Australian Govt Mostly Human Very Aware Not Affected 2 Extremely Concerned Install if I Could Coal Internet 0.00
18 Female NSW Urban High School Greens Yes Unsure/Unfamilar State Govts Unsure Very Aware Somewhat Affected 1 Extremely Concerned No Plan/Do Not Want Other Social Media $21,700 37 Male VIC Urban Coalition Yes Very Satisfied Australian Govt Mostly Natural Aware Severly Affected 5 Somewhat Concerned Already Installed Solar Newspapers 7.00
,700
24 Male ,000
TAS Urban Bachelor Coalition No Satisfied State Govts No Climate Change Aware Not Affected 2 Extremely Concerned No Plan/Do Not Want Gas Internet .00
33 Female NSW Urban High School Coalition No Satisfied State Govts Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Solar TV 30 Female NSW Urban Bachelor Coalition No Satisfied Australian Govt Mostly Human Not Affected 3 Somewhat Concerned No Plan/Do Not Want Solar TV Female NSW Rural High School Coalition Yes Satisfied State Govts Mostly Human Very Aware Somewhat Affected 2 Slightly Concerned No Plan/Do Not Want Gas Newspapers .00
56 Male NT Urban Postgrad Degree Coalition No Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Severly Affected 2 Slightly Concerned No Plan/Do Not Want Gas Internet Female NT Urban TAFE Coalition Yes Very Dissatisfied State Govts No Climate Change Little Knowledge Severly Affected 4 Somewhat Concerned No Plan/Do Not Want Solar Social Media 5
35 Female VIC Rural High School Labour Yes Satisfied State Govts Mostly Natural Very Aware Somewhat Affected 4 Somewhat Concerned Install if I Could Wind Magazines .00
Male QLD Urban High School Greens No Very Satisfied Australian Govt Mostly Human Aware Somewhat Affected 6 Not Concerned Install if I Could Gas Social Media .00
34 Male VIC Urban Bachelor Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Not Affected 4 Somewhat Concerned Already Installed Wind Other 50 Male VIC Urban Pre High School Coalition Yes Satisfied Australian Govt Unsure Very Aware Severly Affected 7 Very Concerned Plan to Install Solar Newspapers .00
34 Male VIC Rural High School Coalition Yes Very Dissatisfied Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Install if I Could Hydro Other .00
Female $ 18,700 VIC Urban TAFE Coalition No Satisfied Australian Govt Mostly Natural Very Aware Severly Affected 6 Very Concerned No Plan/Do Not Want Solar Other .00
Male QLD Rural High School Coalition Yes Dissatisfied Australian Govt Unsure Very Aware Somewhat Affected 6 Very Concerned No Plan/Do Not Want Coal Social Media 27 Male $ 30,100 SA Urban High School Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 3 Somewhat Concerned Already Installed Solar Social Media 40 Female ,000
NSW Urban PhD Coalition Yes Dissatisfied Australian Govt No Climate Change No Interest/Awareness Severly Affected 5 Extremely Concerned No Plan/Do Not Want Coal TV 33 Male ,200
NSW Rural High School Other Yes Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 4 Extremely Concerned Already Installed Coal Social Media 38 Female VIC Urban High School Coalition No Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Solar Newspapers 41 Female VIC Urban Bachelor Coalition No Unsure/Unfamilar Australian Govt Unsure Very Aware Not Affected 6 Very Concerned Plan to Install Solar Other 32 Female QLD Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Hydro Magazines 58 Female QLD Rural Bachelor Labour Yes Dissatisfied Australian Govt No Climate Change Little Knowledge Not Affected 9 Extremely Concerned No Plan/Do Not Want Hydro Other 28 Male QLD Urban High School Coalition Yes Very Satisfied Industry/Companys Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned No Plan/Do Not Want Wind Internet .00
19 Female NSW Urban High School Labour No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 1 Slightly Concerned No Plan/Do Not Want Other Other .00
33 Male SA Urban Bachelor Labour No Satisfied Australian Govt Mostly Human Very Aware Not Affected 4 Somewhat Concerned No Plan/Do Not Want Hydro Newspapers $0.00 59 Male NSW Urban High School Labour Yes Very Dissatisfied Australian Govt Mostly Human Aware Somewhat Affected 4 Somewhat Concerned Already Installed Solar Internet Male $ 18,500 WA Urban High School Coalition No Dissatisfied Australian Govt Unsure Very Aware Somewhat Affected 7 Very Concerned No Plan/Do Not Want Solar Newspapers .00
21 Male $ 85,000 VIC Urban High School Greens Yes Satisfied State Govts Mostly Human Little Knowledge Somewhat Affected 2 Slightly Concerned Already Installed Hydro Other 26 Male ,000
NSW Urban PhD Other Yes Unsure/Unfamilar Australian Govt Mostly Human No Interest/Awareness Severly Affected 2 Extremely Concerned Already Installed Oil Social Media .00
39 Female SA Urban High School Coalition No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Wind Newspapers .00
29 Male $ 30,100 NSW Urban Postgrad Degree Greens No Very Dissatisfied Australian Govt Mostly Natural Very Aware Severly Affected 3 Somewhat Concerned Already Installed Hydro Social Media 31 Female NSW Rural TAFE Other Yes Dissatisfied Australian Govt Unsure Very Aware Severly Affected 4 Not Concerned Already Installed Solar Internet 33 Male ,000
NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Coal TV .00
36 Female ,000
NSW Urban High School Greens No Very Satisfied Australian Govt Mostly Human Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Solar TV 28 Female $ 68,000 NSW Rural Postgrad Degree Greens Yes Satisfied Australian Govt Mostly Human Little Knowledge Severly Affected 2 Slightly Concerned No Plan/Do Not Want Solar Social Media 40 Male NSW Urban High School Coalition Yes Satisfied Australian Govt No Climate Change Very Aware Somewhat Affected 5 Very Concerned Install if I Could Solar Other 25 Female SA Urban High School Greens No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 2 Not Concerned Install if I Could Coal Magazines QLD Urban High School Greens Yes Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Wind Internet .00
27 Female NSW Rural High School Coalition No Dissatisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 2 Somewhat Concerned Plan to Install Coal Other 40 Female $ 16,800 TAS Urban High School Labour No Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Very Concerned Already Installed Solar Social Media .00
27 Male NSW Urban High School Greens No Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Install if I Could Solar Magazines 53 Female VIC Urban Pre High School Labour Yes Satisfied Australian Govt No Climate Change Aware Severly Affected 8 Very Concerned Install if I Could Solar Newspapers .00
39 Male WA Urban High School Greens No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Solar Social Media 47 Female QLD Urban Bachelor Coalition Yes Very Satisfied Australian Govt Mostly Human No Interest/Awareness Not Affected 7 Extremely Concerned Plan to Install Solar Social Media .00
27 Male ,500
NSW Urban High School Coalition No Satisfied Australian Govt Mostly Natural Little Knowledge Somewhat Affected 3 Not Concerned No Plan/Do Not Want Coal TV 40 Male NSW Urban High School Labour No Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Very Concerned No Plan/Do Not Want Wind Social Media 27 Female VIC Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Little Knowledge Somewhat Affected 3 Not Concerned Install if I Could Solar Other .00
60 Male $ 72,000 WA Rural High School Greens Yes Satisfied State Govts No Climate Change Little Knowledge Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Wind Internet 25 Female SA Urban High School Greens No Unsure/Unfamilar Australian Govt Unsure No Interest/Awareness Somewhat Affected 2 Slightly Concerned Install if I Could Solar Internet 53 Female VIC Urban TAFE Greens Yes Satisfied Australian Govt Mostly Natural Aware Severly Affected 8 Very Concerned Already Installed Hydro Other 35 Female VIC Urban High School Labour No Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 4 Somewhat Concerned Install if I Could Hydro Newspapers .00
43 Female QLD Urban TAFE Coalition Yes Satisfied Australian Govt Mostly Human Very Aware Severly Affected 6 Very Concerned No Plan/Do Not Want Solar Social Media 33 Male ,000
VIC Rural PhD Coalition Yes Satisfied Australian Govt Mostly Human Aware Severly Affected 4 Very Concerned No Plan/Do Not Want Solar Newspapers $343.00 48 Female SA Urban Pre High School Labour No Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 7 Very Concerned No Plan/Do Not Want Solar Internet $21.00 $10,925 29 Female NSW Urban High School Labour No Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Install if I Could Coal TV .00
26 Male SA Urban Postgrad Degree Coalition No Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 3 Somewhat Concerned No Plan/Do Not Want Coal Other 23 Male NSW Urban High School Coalition No Dissatisfied Australian Govt Unsure Very Aware Somewhat Affected 2 Not Concerned Already Installed Oil TV 30 Male SA Rural High School Coalition Yes Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Already Installed Hydro Social Media .00
$24,025 53 Male $ 55,000 QLD Urban High School Coalition Yes Dissatisfied Australian Govt Unsure Aware Somewhat Affected 8 Very Concerned No Plan/Do Not Want Solar Newspapers .00
53 Male ,000
NSW Urban TAFE Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Aware Severly Affected 8 Not Concerned Plan to Install Solar Other .00
43 Female QLD Urban TAFE Coalition Yes Satisfied Australian Govt Unsure Very Aware Severly Affected 6 Not Concerned Already Installed Hydro Newspapers 30 Female WA Rural Bachelor Coalition Yes Dissatisfied State Govts No Climate Change Very Aware Not Affected 3 Somewhat Concerned Already Installed Wind Other 27 Female QLD Urban High School Coalition Yes Very Satisfied Australian Govt Unsure Aware Somewhat Affected 3 Somewhat Concerned Install if I Could Solar TV 59 Female QLD Rural Bachelor Coalition No Dissatisfied Individuals/Families Mostly Human Little Knowledge Not Affected 9 Very Concerned Install if I Could Coal Other 36 Male NSW Urban High School Greens Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Wind Internet 52 Female VIC Urban Postgrad Degree Labour No Very Dissatisfied Australian Govt Unsure Very Aware Severly Affected 8 Very Concerned Already Installed Solar Newspapers 40 Female NSW Urban Bachelor Greens Yes Satisfied Australian Govt Mostly Human Very Aware Not Affected 5 Very Concerned Plan to Install Solar Social Media 29 Female QLD Urban High School Coalition Yes Satisfied Industry/Companys Mostly Human Very Aware Somewhat Affected 3 Extremely Concerned No Plan/Do Not Want Solar Internet 40 Female VIC Urban High School Labour No Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 5 Very Concerned Already Installed Wind Newspapers .00
$12,050 36 Male VIC Rural Postgrad Degree Other Yes Dissatisfied Australian Govt No Climate Change Very Aware Severly Affected 5 Somewhat Concerned No Plan/Do Not Want Coal Other 38 Female VIC Urban High School Coalition No Satisfied Australian Govt Mostly Human Aware Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Hydro Magazines 64 Male QLD Urban Bachelor Coalition Yes Unsure/Unfamilar Australian Govt No Climate Change Very Aware Not Affected 10 Very Concerned Already Installed Solar Other .00
43 Male NSW Rural Bachelor Coalition Yes Very Satisfied Local Govts Mostly Human Very Aware Not Affected 6 Very Concerned Install if I Could Coal Internet 28 Male QLD Rural High School Greens No Unsure/Unfamilar Individuals/Families Mostly Natural Very Aware Somewhat Affected 3 Somewhat Concerned No Plan/Do Not Want Coal Social Media .00
52 Male QLD Urban Bachelor Coalition No Very Satisfied Australian Govt Unsure Very Aware Not Affected 8 Very Concerned Already Installed Solar Social Media 48 Male NSW Urban High School Greens Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 7 Very Concerned Plan to Install Hydro Internet 52 Female NSW Urban High School Coalition Yes Satisfied Australian Govt No Climate Change Aware Somewhat Affected 1 Slightly Concerned Already Installed Gas Other 43 Male NSW Urban TAFE Coalition No Satisfied Individuals/Families Mostly Natural Little Knowledge Severly Affected 6 Very Concerned No Plan/Do Not Want Coal Other 39 Male QLD Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Aware Somewhat Affected 5 Not Concerned No Plan/Do Not Want Wind Magazines 29 Female NT Urban Pre High School Coalition Yes Satisfied Australian Govt Unsure Very Aware Severly Affected 3 Somewhat Concerned No Plan/Do Not Want Solar TV 34 Female SA Rural Bachelor Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Not Affected 4 Somewhat Concerned Already Installed Solar Other .00
25 Female SA Urban High School Greens Yes Unsure/Unfamilar Australian Govt Unsure Aware Somewhat Affected 2 Slightly Concerned Plan to Install Coal TV 32 Female VIC Urban Bachelor Greens No Very Satisfied Australian Govt Mostly Human No Interest/Awareness Not Affected 4 Somewhat Concerned Install if I Could Solar Magazines .00
49 Male $ 18,700 ACT Urban High School Greens Yes Unsure/Unfamilar Australian Govt Unsure Very Aware Somewhat Affected 7 Very Concerned Plan to Install Nuclear TV 40 Male NT Urban Pre High School Coalition No Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Severly Affected 5 Very Concerned No Plan/Do Not Want Solar Newspapers .00
39 Female $ 16,800 NSW Urban High School Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Solar Other 32 Female WA Rural High School Other Yes Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Plan to Install Coal Social Media 25 Female $ 18,700 QLD Urban Postgrad Degree Labour No Satisfied Australian Govt Mostly Human Very Aware Severly Affected 2 Not Concerned No Plan/Do Not Want Hydro Newspapers .00
42 Male $ 60,000 QLD Urban High School Coalition Yes Very Dissatisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 6 Not Concerned Install if I Could Gas Social Media 37 Female $ 70,000 VIC Urban High School Coalition Yes Very Satisfied Australian Govt No Climate Change Aware Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Other .00
$11,300 28 Male VIC Urban Bachelor Labour No Satisfied Australian Govt Unsure Very Aware Not Affected 3 Not Concerned Already Installed Solar Internet 23 Male ,000
NSW Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 2 Extremely Concerned No Plan/Do Not Want Hydro TV $34.00 37 Male $ 65,000 VIC Urban High School Other Yes Dissatisfied Australian Govt Mostly Natural Aware Somewhat Affected 5 Somewhat Concerned Already Installed Nuclear Other .00
35 Male $ 13,600 NSW Urban High School Coalition No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Hydro TV 63 Male $ 20,000 NSW Urban High School Coalition No Satisfied Australian Govt Unsure Very Aware Somewhat Affected 10 Very Concerned Already Installed Coal Research Journals 29 Female $ 22,000 QLD Rural Postgrad Degree Other No Dissatisfied Individuals/Families Mostly Human Little Knowledge Severly Affected 3 Somewhat Concerned Install if I Could Solar Social Media $0.00 62 Female VIC Urban Bachelor Labour Yes Satisfied Australian Govt Mostly Human Very Aware Not Affected 4 Somewhat Concerned Install if I Could Hydro Internet 26 Female ,900
VIC Urban High School Greens Yes Very Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 3 Extremely Concerned Install if I Could Wind Social Media $39.00 50 Male $ 22,500 NSW Rural High School Labour Yes Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 7 Very Concerned Install if I Could Solar Social Media $434.00 49 Male VIC Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 7 Very Concerned Install if I Could Wind Magazines 44 Female NSW Urban High School Coalition Yes Very Dissatisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 6 Very Concerned Plan to Install Solar Social Media 25 Female VIC Rural Bachelor Coalition Yes Unsure/Unfamilar State Govts Mostly Human Little Knowledge Not Affected 2 Not Concerned No Plan/Do Not Want Wind Social Media .00
$10,950 44 Male $ 16,800 VIC Urban TAFE Labour No Unsure/Unfamilar Australian Govt Unsure Very Aware Severly Affected 6 Very Concerned Already Installed Solar Newspapers 42 Male VIC Urban TAFE Labour Yes Satisfied Australian Govt Unsure Aware Severly Affected 6 Very Concerned No Plan/Do Not Want Solar Social Media 36 Male NSW Rural High School Labour Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Plan to Install Coal Magazines 41 Female $ 31,000 NSW Rural TAFE Coalition No Dissatisfied Individuals/Families Mostly Natural Little Knowledge Severly Affected 6 Very Concerned Already Installed Solar Newspapers 26 Female NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Slightly Concerned Already Installed Hydro TV $0.00 42 Male $ 13,600 QLD Urban Bachelor Coalition No Satisfied Australian Govt Mostly Natural Very Aware Not Affected 6 Very Concerned No Plan/Do Not Want Solar Newspapers 27 Female ,800
VIC Urban High School Labour No Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 3 Extremely Concerned Plan to Install Solar Magazines $29.00 48 Male QLD Urban High School Labour Yes Unsure/Unfamilar Australian Govt Mostly Human Aware Somewhat Affected 1 Not Concerned Already Installed Hydro Internet 65 Female VIC Urban High School Greens No Very Dissatisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 3 Very Concerned Plan to Install Solar Social Media .00
65 Male $ 22,500 WA Rural High School Labour Yes Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Coal Newspapers $0.00 44 Female $ 21,100 WA Rural High School Labour Yes Unsure/Unfamilar Australian Govt Unsure Very Aware Somewhat Affected 6 Somewhat Concerned No Plan/Do Not Want Coal Newspapers 48 Male QLD Urban High School Greens Yes Satisfied Australian Govt Mostly Human Aware Somewhat Affected 7 Very Concerned No Plan/Do Not Want Solar TV .00
37 Female QLD Urban High School Labour No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Solar Internet 52 Female VIC Urban High School Coalition Yes Dissatisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 8 Very Concerned No Plan/Do Not Want Hydro Other .00
38 Female QLD Urban High School Labour No Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Wind Newspapers $19.00 35 Male VIC Urban High School Coalition Yes Satisfied State Govts Mostly Natural Very Aware Somewhat Affected 4 Somewhat Concerned Install if I Could Solar Internet $10,625 34 Female NSW Urban High School Labour No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 2 Somewhat Concerned No Plan/Do Not Want Wind Research Journals 34 Female SA Urban Bachelor Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Not Affected 4 Somewhat Concerned No Plan/Do Not Want Wind Social Media $10.00 27 Male ACT Rural High School Coalition No Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Slightly Concerned No Plan/Do Not Want Solar Magazines 23 Female NSW Urban High School Greens Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 2 Slightly Concerned No Plan/Do Not Want Hydro TV $0.00 62 Female $ 14,300 NSW Urban Postgrad Degree Greens Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Severly Affected 10 Very Concerned Install if I Could Solar Research Journals 41 Female NSW Rural High School Labour Yes Unsure/Unfamilar Australian Govt Mostly Human Little Knowledge Somewhat Affected 1 Not Concerned Plan to Install Hydro Social Media $13,850 26 Female SA Rural High School Labour Yes Dissatisfied State Govts Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Install if I Could Coal TV $31.00 36 Male $ 24,400 QLD Rural High School Labour Yes Very Satisfied Australian Govt Unsure Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Solar Social Media 37 Female $ 65,000 VIC Rural Bachelor Greens No Unsure/Unfamilar Australian Govt Mostly Natural Little Knowledge Not Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Social Media 39 Male VIC Rural High School Other No Unsure/Unfamilar Australian Govt Unsure Little Knowledge Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Internet 62 Male QLD Urban High School Coalition No Satisfied Australian Govt Mostly Natural No Interest/Awareness Somewhat Affected 4 Somewhat Concerned Already Installed Solar Social Media .00
61 Male $ 28,200 WA Urban Pre High School Coalition No Unsure/Unfamilar Australian Govt No Climate Change Very Aware Severly Affected 10 Very Concerned Install if I Could Hydro Newspapers $23,475 20 Female VIC Urban High School Coalition No Very Satisfied State Govts Mostly Natural Very Aware Somewhat Affected 1 Slightly Concerned Already Installed Gas Social Media 31 Female WA Rural Bachelor Other No Very Satisfied Australian Govt Mostly Human Very Aware Not Affected 4 Somewhat Concerned No Plan/Do Not Want Wind Social Media $434.00 28 Female NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural No Interest/Awareness Somewhat Affected 3 Not Concerned No Plan/Do Not Want Coal TV $59.00 22 Female $ 32,000 WA Urban High School Labour No Very Satisfied Australian Govt Unsure Very Aware Somewhat Affected 2 Not Concerned Already Installed Hydro Other $14,700 36 Female NSW Urban High School Coalition No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Install if I Could Coal TV $39,038 48 Male ,200
NSW Urban High School Labour Yes Satisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 7 Extremely Concerned No Plan/Do Not Want Wind Newspapers $23,325 47 Male $ 58,000 NSW Urban TAFE Labour No Satisfied Australian Govt Mostly Human Aware Severly Affected 7 Very Concerned Install if I Could Solar TV 51 Female VIC Urban High School Coalition Yes Very Satisfied Local Govts Mostly Human Very Aware Somewhat Affected 8 Very Concerned Already Installed Hydro Newspapers 48 Female $ 95,000 NSW Rural Postgrad Degree Coalition No Very Satisfied Australian Govt Mostly Human Little Knowledge Severly Affected 7 Very Concerned Already Installed Solar Newspapers 30 Male VIC Rural High School Labour No Very Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Already Installed Wind TV $11,325 40 Male $ 18,700 WA Urban High School Labour No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 5 Very Concerned No Plan/Do Not Want Solar Magazines $12.00 29 Male VIC Urban High School Coalition No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 3 Not Concerned No Plan/Do Not Want Solar Social Media 35 Female $ 26,300 QLD Rural High School Coalition Yes Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Solar Magazines $11,300 61 Male $ 16,800 VIC Urban High School Labour No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 10 Very Concerned No Plan/Do Not Want Coal Social Media $11,225 38 Female $ 19,600 NT Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Plan to Install Solar Internet 40 Male NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 5 Slightly Concerned Install if I Could Solar TV .00
32 Male $ 13,600 ACT Urban Bachelor Labour No Satisfied Australian Govt Mostly Human Very Aware Not Affected 4 Somewhat Concerned Plan to Install Solar Social Media .00
32 Female NSW Urban High School Other No Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 4 Somewhat Concerned Already Installed Nuclear Magazines 68 Female QLD Urban High School Coalition No Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 4 Not Concerned No Plan/Do Not Want Gas Internet $30.00 39 Female $ 31,000 VIC Rural High School Coalition Yes Satisfied Individuals/Families Mostly Human Little Knowledge Somewhat Affected 1 Slightly Concerned Install if I Could Hydro Social Media $38.00 58 Male $ 22,800 QLD Urban High School Labour Yes Very Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 2 Somewhat Concerned Install if I Could Wind Research Journals $366.00 47 Female $ 27,600 ACT Rural TAFE Coalition No Very Dissatisfied Australian Govt Unsure Very Aware Severly Affected 7 Somewhat Concerned No Plan/Do Not Want Wind Internet 50 Female SA Rural Postgrad Degree Labour No Very Satisfied Australian Govt Mostly Natural Very Aware Severly Affected 1 Somewhat Concerned Already Installed Hydro Magazines $53.00 $25,075 24 Female $ 70,000 QLD Urban High School Labour No Dissatisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 2 Not Concerned Plan to Install Solar Newspapers 30 Female VIC Urban Bachelor Coalition Yes Satisfied State Govts Mostly Human Very Aware Not Affected 3 Not Concerned No Plan/Do Not Want Gas Magazines .00
31 Female VIC Rural Pre High School Coalition Yes Very Satisfied State Govts Mostly Human Very Aware Severly Affected 4 Somewhat Concerned Already Installed Solar Magazines $13.00 37 Female NSW Urban High School Coalition No Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Coal Internet 44 Male $ 40,000 VIC Rural TAFE Labour Yes Very Satisfied State Govts Unsure Little Knowledge Severly Affected 6 Very Concerned No Plan/Do Not Want Solar Social Media $55.00 41 Female $ 33,400 VIC Urban High School Coalition Yes Satisfied State Govts Mostly Human Very Aware Somewhat Affected 2 Somewhat Concerned Plan to Install Oil Newspapers $10.00 46 Female NSW Urban TAFE Greens No Satisfied Australian Govt Unsure Very Aware Severly Affected 7 Very Concerned Plan to Install Hydro Internet 57 Female $ 19,600 VIC Rural High School Coalition Yes Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 9 Very Concerned Install if I Could Wind Social Media $691.00 61 Female $ 83,000 SA Urban TAFE Labour Yes Satisfied Australian Govt No Climate Change Aware Severly Affected 10 Very Concerned No Plan/Do Not Want Solar Research Journals 58 Male $ 90,000 SA Urban Bachelor Greens No Very Satisfied Australian Govt No Climate Change No Interest/Awareness Not Affected 9 Very Concerned Install if I Could Hydro Social Media $43.00 $13,100 49 Female $ 26,000 VIC Rural High School Greens No Unsure/Unfamilar Australian Govt Unsure Very Aware Somewhat Affected 7 Very Concerned Install if I Could Solar Newspapers 30 Male NSW Urban High School Greens Yes Unsure/Unfamilar State Govts Mostly Human Very Aware Somewhat Affected 3 Very Concerned Already Installed Solar Social Media .00
$12,825 55 Male $ 22,500 NSW Urban High School Labour No Very Satisfied Australian Govt No Climate Change Very Aware Somewhat Affected 8 Very Concerned No Plan/Do Not Want Solar Other $13,225 32 Female $ 26,300 SA Urban TAFE Other Yes Very Satisfied Australian Govt Unsure Very Aware Severly Affected 4 Somewhat Concerned No Plan/Do Not Want Solar Newspapers .00
$15,025 29 Male $ 33,900 WA Urban Bachelor Coalition No Very Satisfied Australian Govt No Climate Change Very Aware Not Affected 3 Somewhat Concerned No Plan/Do Not Want Solar Social Media 47 Male $ 49,000 QLD Urban High School Coalition Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 7 Very Concerned Install if I Could Coal Internet 32 Female NSW Rural Postgrad Degree Labour No Unsure/Unfamilar Individuals/Families Mostly Human Little Knowledge Severly Affected 1 Slightly Concerned Plan to Install Gas Social Media 44 Female SA Rural High School Coalition Yes Very Satisfied Individuals/Families Unsure Little Knowledge Somewhat Affected 6 Very Concerned Already Installed Solar Internet $31.00 34 Female $ 63,700 TAS Urban Pre High School Labour Yes Unsure/Unfamilar Australian Govt No Climate Change Aware Severly Affected 4 Not Concerned No Plan/Do Not Want Coal Other 38 Female $ 21,100 WA Rural High School Coalition Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Solar TV $294.00 $13,175 42 Male $ 26,300 NSW Urban TAFE Coalition Yes Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 6 Very Concerned Install if I Could Solar Social Media 30 Female VIC Urban Postgrad Degree Greens Yes Very Satisfied Australian Govt Unsure Little Knowledge Severly Affected 1 Slightly Concerned Install if I Could Gas Internet .00
29 Female QLD Rural High School Coalition No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned No Plan/Do Not Want Coal Other .00
38 Male ACT Urban High School Greens Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Magazines $16,600 32 Male $ 40,600 WA Urban Pre High School Coalition Yes Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 4 Somewhat Concerned Install if I Could Wind Newspapers 55 Male QLD Urban Bachelor Labour No Satisfied Individuals/Families Mostly Human Very Aware Not Affected 8 Very Concerned Plan to Install Coal Research Journals $99.00 $11,325 47 Female $ 18,700 VIC Urban High School Labour Yes Unsure/Unfamilar Individuals/Families Mostly Human Very Aware Somewhat Affected 7 Very Concerned Already Installed Solar TV $13,100 40 Female $ 26,000 SA Rural High School Greens Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Very Concerned No Plan/Do Not Want Solar Internet $22,225 37 Female $ 59,000 NSW Urban Bachelor Coalition Yes Satisfied State Govts Mostly Human Aware Not Affected 3 Somewhat Concerned Already Installed Hydro TV $11,325 43 Male $ 18,700 NSW Rural High School Coalition No Satisfied Australian Govt Unsure Very Aware Somewhat Affected 6 Very Concerned No Plan/Do Not Want Coal Social Media 32 Male NSW Urban High School Coalition Yes Very Satisfied State Govts Mostly Human No Interest/Awareness Somewhat Affected 4 Slightly Concerned No Plan/Do Not Want Hydro TV $96.00 31 Male VIC Urban High School Coalition Yes Very Dissatisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 4 Somewhat Concerned Install if I Could Wind Social Media .00
44 Female $ 7,900 WA Urban Postgrad Degree Coalition No Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Severly Affected 6 Very Concerned Already Installed Solar Social Media $21,000 39 Female $ 59,200 VIC Rural High School Greens Yes Unsure/Unfamilar Australian Govt Mostly Natural Little Knowledge Somewhat Affected 5 Somewhat Concerned Already Installed Solar Other 41 Female $ 6,500 NSW Urban High School Coalition No Dissatisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 6 Very Concerned No Plan/Do Not Want Coal Social Media QLD Urban Bachelor Coalition No Unsure/Unfamilar State Govts Mostly Human Very Aware Not Affected 3 Somewhat Concerned Plan to Install Solar Social Media .00
58 Male NSW Urban High School Labour Yes Satisfied Australian Govt Mostly Human Aware Somewhat Affected 9 Very Concerned No Plan/Do Not Want Solar Social Media 55 Female ,000
NSW Urban High School Labour Yes Very Satisfied Australian Govt No Climate Change Aware Somewhat Affected 8 Somewhat Concerned Install if I Could Coal Social Media $16,325 60 Female VIC Urban TAFE Coalition Yes Satisfied Local Govts No Climate Change Very Aware Severly Affected 9 Very Concerned Install if I Could Solar Social Media $38.00 29 Male $ 55,000 ACT Urban Bachelor Coalition No Satisfied State Govts Mostly Human Aware Not Affected 3 Somewhat Concerned Install if I Could Wind TV 42 Male $ 67,000 NSW Urban Bachelor Coalition No Satisfied Australian Govt Unsure Aware Not Affected 6 Very Concerned Already Installed Solar Magazines 41 Female $ 76,300 VIC Urban Bachelor Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Aware Not Affected 6 Very Concerned No Plan/Do Not Want Solar Newspapers $128.00 35 Female VIC Urban High School Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 4 Somewhat Concerned Already Installed Wind Newspapers .00
24 Male ,000
NSW Urban High School Labour Yes Unsure/Unfamilar Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 2 Extremely Concerned Already Installed Solar Internet $40.00 39 Female NSW Urban TAFE Labour Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Severly Affected 2 Somewhat Concerned No Plan/Do Not Want Solar Magazines $384.00 38 Male $ 31,000 NSW Urban High School Coalition Yes Unsure/Unfamilar State Govts Mostly Natural Little Knowledge Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Newspapers .00
37 Male QLD Urban Bachelor Coalition No Satisfied Australian Govt Unsure No Interest/Awareness Not Affected 5 Slightly Concerned No Plan/Do Not Want Hydro Internet .00
47 Male WA Urban High School Coalition Yes Very Satisfied Individuals/Families Unsure Little Knowledge Somewhat Affected 7 Very Concerned No Plan/Do Not Want Solar Internet $272.00 $24,025 38 Male $ 72,000 QLD Rural High School Coalition Yes Satisfied State Govts Unsure Little Knowledge Somewhat Affected 5 Somewhat Concerned Already Installed Coal Other $10,200 41 Female $ 13,600 TAS Urban Pre High School Greens No Satisfied Australian Govt No Climate Change Very Aware Severly Affected 6 Very Concerned Already Installed Solar TV .00
41 Male NSW Urban Bachelor Greens No Satisfied Australian Govt Mostly Human Aware Not Affected 6 Extremely Concerned No Plan/Do Not Want Solar Social Media $59.00 $24,975 38 Female NSW Rural High School Other Yes Unsure/Unfamilar State Govts Unsure Little Knowledge Somewhat Affected 5 Somewhat Concerned Install if I Could Hydro TV 29 Female WA Urban Bachelor Coalition No Very Satisfied State Govts Mostly Human Very Aware Not Affected 3 Somewhat Concerned Install if I Could Wind Social Media 38 Female $ 22,800 TAS Urban Pre High School Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Severly Affected 5 Somewhat Concerned No Plan/Do Not Want Hydro Other $105.00 61 Female NSW Urban TAFE Coalition No Unsure/Unfamilar Australian Govt Mostly Natural No Interest/Awareness Severly Affected 4 Somewhat Concerned Already Installed Solar Other $21.00 26 Male $ 16,800 QLD Urban Bachelor Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Not Affected 3 Somewhat Concerned Already Installed Hydro TV $72.00 $24,325 25 Female ACT Rural High School Greens Yes Satisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 1 Slightly Concerned Plan to Install Gas Newspapers $76.00 $11,300 62 Female $ 16,800 SA Urban High School Greens Yes Unsure/Unfamilar Individuals/Families Mostly Human Very Aware Somewhat Affected 10 Very Concerned Already Installed Solar Newspapers $0.00 $17,325 42 Female $ 40,000 NSW Urban Bachelor Labour Yes Very Satisfied Individuals/Families Mostly Human Little Knowledge Not Affected 6 Very Concerned Plan to Install Solar Newspapers 31 Male $ 76,000 ACT Rural High School Coalition Yes Very Satisfied Australian Govt Unsure Aware Somewhat Affected 3 Somewhat Concerned No Plan/Do Not Want Solar TV $8,525 33 Female VIC Rural Postgrad Degree Labour No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Severly Affected 4 Slightly Concerned Plan to Install Gas Internet .00
21 Male $ 28,000 NT Urban Postgrad Degree Coalition Yes Dissatisfied State Govts Mostly Natural Very Aware Severly Affected 2 Slightly Concerned Install if I Could Gas Social Media $17.00 50 Male VIC Urban High School Coalition No Satisfied Individuals/Families Unsure Little Knowledge Somewhat Affected 7 Very Concerned No Plan/Do Not Want Solar Magazines $53.00 36 Male $ 33,900 WA Urban TAFE Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Severly Affected 5 Somewhat Concerned No Plan/Do Not Want Wind Social Media $22.00 41 Male QLD Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 6 Very Concerned Already Installed Solar Newspapers $365.00 27 Female NSW Urban Postgrad Degree Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Severly Affected 3 Somewhat Concerned Install if I Could Solar Social Media $20.00 42 Female $ 7,200 NSW Urban Bachelor Labour No Satisfied Australian Govt Mostly Natural Very Aware Not Affected 6 Very Concerned No Plan/Do Not Want Nuclear TV 28 Female $ 24,300 WA Urban Pre High School Labour No Very Satisfied Australian Govt No Climate Change Very Aware Severly Affected 3 Slightly Concerned Install if I Could Nuclear Social Media 46 Male $ 95,000 VIC Urban TAFE Labour No Very Satisfied Australian Govt Mostly Human No Interest/Awareness Severly Affected 7 Extremely Concerned Already Installed Solar Social Media 32 Male WA Urban High School Labour Yes Satisfied Australian Govt Mostly Human Aware Somewhat Affected 4 Somewhat Concerned Install if I Could Solar Internet $56.00 $11,900 40 Female $ 19,000 VIC Rural TAFE Greens Yes Very Satisfied Australian Govt Mostly Natural Little Knowledge Severly Affected 5 Very Concerned Install if I Could Wind TV $63.00 39 Male $ 42,700 NT Urban TAFE Greens No Satisfied Australian Govt Unsure Very Aware Severly Affected 5 Somewhat Concerned No Plan/Do Not Want Oil Social Media .00
30 Male QLD Urban Bachelor Labour Yes Unsure/Unfamilar Australian Govt Mostly Human No Interest/Awareness Not Affected 3 Not Concerned Plan to Install Solar Magazines $17.00 $13,850 33 Male $ 28,900 SA Urban High School Coalition No Unsure/Unfamilar State Govts Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Solar Other 27 Male $ 49,000 NSW Rural High School Greens Yes Very Dissatisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 3 Extremely Concerned Plan to Install Coal Other 37 Male $ 74,200 NSW Urban High School Labour No Unsure/Unfamilar Australian Govt Mostly Natural Little Knowledge Somewhat Affected 5 Somewhat Concerned Install if I Could Coal TV $26.00 56 Female WA Rural High School Greens Yes Satisfied Australian Govt No Climate Change Aware Somewhat Affected 9 Not Concerned Install if I Could Gas Other WA Rural Bachelor Labour No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Not Affected 3 Somewhat Concerned Plan to Install Solar Internet 36 Male SA Urban Pre High School Coalition No Dissatisfied Australian Govt Mostly Natural Very Aware Severly Affected 5 Somewhat Concerned No Plan/Do Not Want Hydro TV 32 Male $ 81,990 ACT Urban High School Greens Yes Satisfied Australian Govt Mostly Human Aware Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Coal Magazines 44 Female $ 63,300 NSW Urban TAFE Coalition No Satisfied Australian Govt Mostly Human Aware Severly Affected 2 Not Concerned No Plan/Do Not Want Wind Social Media 48 Male ,300
TAS Urban High School Greens Yes Unsure/Unfamilar Australian Govt Unsure No Interest/Awareness Somewhat Affected 7 Extremely Concerned Plan to Install Solar Magazines $69.00 39 Female QLD Urban TAFE Greens Yes Satisfied State Govts Mostly Natural Very Aware Severly Affected 5 Somewhat Concerned Already Installed Solar Internet $26,750 31 Male SA Rural Pre High School Coalition No Unsure/Unfamilar Australian Govt Mostly Human Little Knowledge Severly Affected 4 Somewhat Concerned Plan to Install Solar TV $14,825 39 Female VIC Urban High School Greens No Very Satisfied Australian Govt No Climate Change Little Knowledge Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Hydro Social Media $13,250 62 Female $ 22,000 NSW Rural TAFE Greens No Satisfied Individuals/Families No Climate Change Little Knowledge Severly Affected 10 Very Concerned Plan to Install Solar Other $0.00 21 Female WA Urban High School Coalition No Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 2 Slightly Concerned Already Installed Wind Newspapers 62 Male VIC Urban High School Coalition Yes Very Satisfied Australian Govt No Climate Change No Interest/Awareness Somewhat Affected 10 Extremely Concerned No Plan/Do Not Want Solar Research Journals $21.00 34 Female NSW Urban High School Coalition No Very Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 4 Somewhat Concerned Install if I Could Wind Newspapers 35 Female SA Urban Pre High School Labour Yes Satisfied Australian Govt Mostly Human Very Aware Severly Affected 2 Somewhat Concerned Already Installed Solar Magazines 41 Female VIC Urban Bachelor Coalition Yes Satisfied Australian Govt Mostly Human Aware Not Affected 6 Very Concerned Already Installed Coal Internet $19.00 45 Male $ 59,000 QLD Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Aware Somewhat Affected 6 Very Concerned No Plan/Do Not Want Coal Newspapers 54 Female NSW Urban High School Coalition No Satisfied Australian Govt Mostly Natural Aware Somewhat Affected 8 Very Concerned No Plan/Do Not Want Solar Internet 51 Female $ 60,000 NSW Urban High School Labour No Very Satisfied Australian Govt Mostly Natural Aware Somewhat Affected 8 Very Concerned Already Installed Solar TV 52 Male $ 90,000 NSW Rural Bachelor Labour Yes Unsure/Unfamilar Australian Govt Mostly Natural Little Knowledge Not Affected 8 Slightly Concerned Already Installed Oil Magazines .00
29 Female NSW Urban Bachelor Greens No Very Satisfied Australian Govt Mostly Natural Very Aware Not Affected 3 Somewhat Concerned Already Installed Hydro TV 44 Male SA Urban Bachelor Coalition Yes Unsure/Unfamilar Australian Govt Unsure Aware Not Affected 6 Not Concerned No Plan/Do Not Want Solar Newspapers 40 Female NSW Urban Bachelor Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Aware Not Affected 5 Very Concerned Already Installed Solar TV 41 Male QLD Urban High School Coalition No Very Satisfied Australian Govt Mostly Human Aware Somewhat Affected 6 Extremely Concerned Install if I Could Solar Other 31 Male $ 125,000 QLD Urban High School Labour No Very Satisfied Australian Govt No Climate Change No Interest/Awareness Somewhat Affected 4 Extremely Concerned Plan to Install Hydro Social Media $40.00 38 Male NSW Urban Bachelor Coalition No Very Dissatisfied Australian Govt Mostly Natural Very Aware Not Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Social Media $39.00 $24,300 43 Male $ 67,000 VIC Rural High School Coalition Yes Satisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 6 Very Concerned No Plan/Do Not Want Solar Social Media 40 Female $ 65,000 NSW Rural Bachelor Coalition No Satisfied Australian Govt No Climate Change Little Knowledge Not Affected 5 Very Concerned Install if I Could Solar TV $40.00 $12,200 41 Male NSW Urban High School Coalition Yes Unsure/Unfamilar State Govts Unsure Very Aware Somewhat Affected 6 Very Concerned Already Installed Wind Other .00
$12,825 64 Female $ 22,500 SA Urban TAFE Greens No Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 10 Very Concerned Already Installed Solar Newspapers $33.00 $15,850 40 Male SA Urban TAFE Greens Yes Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 5 Very Concerned Already Installed Solar Social Media 52 Female $ 110,000 WA Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Unsure Aware Somewhat Affected 8 Very Concerned Already Installed Solar Social Media 41 Male $ 55,000 VIC Urban High School Other Yes Very Satisfied State Govts Mostly Human Aware Somewhat Affected 6 Somewhat Concerned Already Installed Wind Internet 38 Female $ 12,100 NSW Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned No Plan/Do Not Want Hydro Magazines $51.00 69 Male VIC Urban TAFE Greens Yes Satisfied State Govts Unsure Very Aware Severly Affected 11 Somewhat Concerned Install if I Could Wind Newspapers $100.00 $11,650 26 Male $ 19,600 NSW Urban High School Labour Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Plan to Install Solar Social Media 26 Female VIC Rural High School Other No Satisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 3 Somewhat Concerned Install if I Could Solar Internet 45 Female $ 92,000 QLD Rural Bachelor Greens Yes Unsure/Unfamilar Australian Govt Unsure Little Knowledge Not Affected 6 Very Concerned Already Installed Solar Social Media $19.00 26 Male $ 28,200 NT Urban High School Greens Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned Already Installed Solar TV $10.00 33 Female $ 57,000 NT Urban High School Coalition No Very Satisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Coal Internet 38 Male $ 71,000 QLD Urban High School Greens Yes Very Dissatisfied Australian Govt No Climate Change Aware Somewhat Affected 3 Somewhat Concerned Already Installed Coal Other $0.00 $23,450 36 Female $ 63,700 SA Urban High School Labour No Very Dissatisfied Australian Govt Mostly Natural Aware Somewhat Affected 5 Somewhat Concerned Plan to Install Solar Other $72.00 36 Female $ 13,600 VIC Urban Postgrad Degree Coalition Yes Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 5 Somewhat Concerned No Plan/Do Not Want Solar Magazines $31.00 $11,850 45 Male $ 20,600 WA Rural Pre High School Greens Yes Satisfied Australian Govt Unsure Very Aware Severly Affected 6 Somewhat Concerned Already Installed Wind Social Media 45 Female SA Urban High School Coalition No Unsure/Unfamilar Australian Govt Unsure No Interest/Awareness Somewhat Affected 6 Very Concerned Install if I Could Hydro Social Media $17.00 $10,225 34 Male $ 13,600 QLD Rural Postgrad Degree Labour Yes Satisfied Australian Govt Mostly Human Very Aware Severly Affected 3 Somewhat Concerned No Plan/Do Not Want Coal Magazines $14,275 51 Male $ 28,200 QLD Urban High School Labour No Satisfied Australian Govt Unsure Very Aware Somewhat Affected 8 Very Concerned Already Installed Solar Social Media $9,925 38 Male $ 13,600 NSW Urban Bachelor Other No Dissatisfied Australian Govt Mostly Human Very Aware Not Affected 2 Somewhat Concerned Plan to Install Solar Social Media 58 Male $ 26,300 ACT Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 9 Very Concerned Already Installed Solar TV $0.00 $11,300 54 Female $ 13,600 VIC Urban High School Greens Yes Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 2 Somewhat Concerned Already Installed Oil Internet $13,175 57 Female TAS Rural High School Coalition Yes Unsure/Unfamilar Individuals/Families No Climate Change Very Aware Somewhat Affected 9 Very Concerned Install if I Could Coal Research Journals $676.00 43 Male $ 90,000 VIC Urban High School Coalition Yes Very Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 6 Extremely Concerned Already Installed Wind Social Media 40 Male NSW Urban Bachelor Greens Yes Dissatisfied Australian Govt Mostly Natural Very Aware Not Affected 5 Very Concerned Plan to Install Solar Magazines 45 Male VIC Rural High School Coalition Yes Very Dissatisfied Individuals/Families Mostly Natural Little Knowledge Somewhat Affected 6 Very Concerned No Plan/Do Not Want Solar Magazines 54 Female $ 58,000 ACT Rural High School Other No Satisfied Individuals/Families No Climate Change Little Knowledge Somewhat Affected 8 Not Concerned No Plan/Do Not Want Gas Other 43 Female NSW Rural Postgrad Degree Coalition Yes Dissatisfied Industry/Companys Unsure Very Aware Severly Affected 6 Very Concerned Already Installed Hydro Social Media 48 Male $ 68,000 WA Rural Pre High School Coalition No Unsure/Unfamilar Australian Govt Unsure Aware Severly Affected 7 Very Concerned No Plan/Do Not Want Solar Social Media $156.00 $13,850 44 Female $ 29,200 SA Urban TAFE Coalition Yes Satisfied Australian Govt Unsure Very Aware Severly Affected 6 Very Concerned Already Installed Solar Newspapers 57 Male QLD Urban TAFE Coalition No Very Satisfied Australian Govt No Climate Change Very Aware Severly Affected 9 Very Concerned Already Installed Solar Other 20 Male $ 125,000 NSW Urban High School Labour Yes Satisfied State Govts Unsure No Interest/Awareness Somewhat Affected 2 Slightly Concerned Plan to Install Hydro Internet $29.00 $11,325 49 Male $ 18,700 NSW Urban High School Labour No Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 7 Very Concerned Plan to Install Solar TV $0.00 39 Female $ 63,200 TAS Urban High School Greens Yes Satisfied Australian Govt Mostly Natural Aware Somewhat Affected 5 Somewhat Concerned Plan to Install Solar Other $924.00 41 Male SA Urban Bachelor Coalition Yes Satisfied Australian Govt Mostly Natural Aware Not Affected 6 Extremely Concerned No Plan/Do Not Want Hydro TV $12.00 $10,175 37 Female $ 8,600 NT Urban Postgrad Degree Labour No Dissatisfied Australian Govt Mostly Human Very Aware Severly Affected 2 Somewhat Concerned Already Installed Nuclear Magazines 65 Male NSW Urban TAFE Coalition Yes Satisfied Industry/Companys Mostly Natural Very Aware Severly Affected 10 Very Concerned Already Installed Solar Research Journals 50 Male $ 90,000 NSW Urban High School Coalition No Satisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 7 Very Concerned Install if I Could Hydro Social Media 57 Male SA Urban High School Coalition Yes Satisfied Individuals/Families Mostly Human Little Knowledge Somewhat Affected 9 Very Concerned No Plan/Do Not Want Coal Internet 48 Female NSW Urban TAFE Greens Yes Satisfied Australian Govt Unsure Very Aware Severly Affected 7 Very Concerned Install if I Could Solar TV 53 Female $ 21,300 NSW Urban High School Greens Yes Satisfied Australian Govt Unsure Very Aware Somewhat Affected 8 Very Concerned Install if I Could Solar Newspapers $76.00 52 Male $ 71,000 NSW Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Unsure Aware Somewhat Affected 8 Very Concerned No Plan/Do Not Want Solar TV 38 Female WA Rural Postgrad Degree Other Yes Very Satisfied Australian Govt Mostly Human Little Knowledge Severly Affected 1 Extremely Concerned Plan to Install Hydro Internet $50.00 $10,125 33 Male $ 13,200 NSW Rural High School Coalition No Unsure/Unfamilar Individuals/Families Mostly Human Very Aware Somewhat Affected 3 Somewhat Concerned No Plan/Do Not Want Coal Social Media 63 Female $ 18,300 ACT Urban Bachelor Greens Yes Very Satisfied Australian Govt No Climate Change Very Aware Not Affected 10 Very Concerned No Plan/Do Not Want Coal Social Media $32,700 51 Male $ 83,000 NSW Urban High School Labour Yes Satisfied Australian Govt Mostly Human Aware Somewhat Affected 8 Very Concerned Plan to Install Solar Internet 43 Male $ 75,900 NSW Rural High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Aware Somewhat Affected 6 Very Concerned Install if I Could Solar Social Media 44 Male VIC Urban High School Greens No Satisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 6 Very Concerned Already Installed Solar Other $92.00 $10,975 30 Female $ 16,800 SA Urban Pre High School Coalition No Very Dissatisfied Australian Govt Mostly Human Very Aware Severly Affected 3 Somewhat Concerned No Plan/Do Not Want Hydro Social Media 42 Male SA Urban Bachelor Labour Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Not Affected 6 Very Concerned No Plan/Do Not Want Hydro Magazines $74.00 $11,900 62 Female $ 16,800 QLD Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 10 Not Concerned Already Installed Gas Newspapers 38 Female TAS Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Solar Magazines .00
$13,750 54 Male $ 24,400 NSW Urban High School Coalition No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 8 Very Concerned Already Installed Oil TV 52 Female $ 70,000 SA Urban High School Labour Yes Very Dissatisfied Australian Govt Mostly Natural No Interest/Awareness Somewhat Affected 8 Very Concerned Already Installed Solar Magazines $54.00 $10,575 38 Female $ 16,600 VIC Urban Bachelor Labour Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Not Affected 5 Somewhat Concerned Install if I Could Solar Newspapers $18,350 55 Female $ 40,000 NT Urban Bachelor Labour Yes Unsure/Unfamilar Individuals/Families Mostly Natural Little Knowledge Not Affected 8 Very Concerned No Plan/Do Not Want Wind Social Media $12,700 43 Female $ 24,300 VIC Urban Bachelor Coalition Yes Very Satisfied Australian Govt Unsure Very Aware Not Affected 6 Very Concerned Install if I Could Solar Newspapers $10,200 25 Female $ 13,600 VIC Urban High School Labour No Unsure/Unfamilar Individuals/Families Mostly Human Very Aware Somewhat Affected 2 Not Concerned Plan to Install Coal Internet $10,625 36 Male $ 16,800 TAS Urban Pre High School Other Yes Satisfied Australian Govt Mostly Human Very Aware Severly Affected 5 Somewhat Concerned Plan to Install Solar Social Media $10,700 53 Female $ 13,000 VIC Rural Postgrad Degree Coalition No Very Satisfied Individuals/Families Mostly Human Little Knowledge Severly Affected 8 Very Concerned Already Installed Solar Social Media $0.00 $12,700 28 Male $ 18,700 SA Urban Bachelor Labour Yes Satisfied Australian Govt Mostly Human Very Aware Not Affected 3 Somewhat Concerned No Plan/Do Not Want Hydro Other 32 Female NSW Urban High School Labour No Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Slightly Concerned Plan to Install Solar Internet 40 Female $ 15,100 VIC Urban TAFE Labour Yes Unsure/Unfamilar Australian Govt Unsure Very Aware Severly Affected 5 Very Concerned Plan to Install Wind Social Media $128.00 $13,300 57 Male $ 24,400 SA Rural High School Labour Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 9 Very Concerned Install if I Could Solar TV 27 Male $ 26,300 VIC Urban High School Coalition No Dissatisfied Australian Govt Unsure Very Aware Somewhat Affected 3 Not Concerned No Plan/Do Not Want Gas Internet 38 Male $ 58,000 VIC Urban High School Labour Yes Satisfied Australian Govt No Climate Change Little Knowledge Somewhat Affected 5 Somewhat Concerned Already Installed Hydro Other 28 Female VIC Urban High School Coalition No Satisfied Australian Govt Mostly Human Little Knowledge Somewhat Affected 1 Slightly Concerned No Plan/Do Not Want Gas TV 52 Female QLD Urban TAFE Labour Yes Satisfied Local Govts Unsure Very Aware Severly Affected 8 Very Concerned Install if I Could Solar Other 39 Female NSW Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Plan to Install Coal Magazines 36 Male $ 92,000 NSW Urban Bachelor Coalition No Very Satisfied Australian Govt Mostly Human Aware Not Affected 5 Slightly Concerned No Plan/Do Not Want Wind TV 38 Female $ 62,000 NSW Urban High School Greens Yes Unsure/Unfamilar Australian Govt Mostly Natural Aware Somewhat Affected 5 Not Concerned Plan to Install Coal TV 41 Male SA Rural High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural No Interest/Awareness Somewhat Affected 6 Very Concerned Install if I Could Hydro Social Media 27 Female $ 95,000 NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 3 Very Concerned Already Installed Oil Social Media $9,200 32 Female $ 9,300 SA Urban Pre High School Labour No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Severly Affected 4 Somewhat Concerned No Plan/Do Not Want Solar Other $16,325 39 Male NSW Urban High School Coalition Yes Satisfied State Govts Mostly Human Very Aware Somewhat Affected 5 Somewhat Concerned Already Installed Coal Other 51 Male $ 95,000 VIC Urban High School Labour No Very Satisfied Australian Govt Unsure No Interest/Awareness Somewhat Affected 8 Very Concerned Plan to Install Solar Social Media $11,325 42 Female $ 18,700 SA Urban TAFE Greens No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Severly Affected 6 Very Concerned Already Installed Coal Magazines $0.00 30 Female NSW Rural Postgrad Degree Labour Yes Satisfied Australian Govt Mostly Human Very Aware Severly Affected 3 Somewhat Concerned Already Installed Coal Social Media 24 Male $ 49,000 WA Rural Postgrad Degree Other Yes Satisfied State Govts Mostly Human Little Knowledge Severly Affected 1 Slightly Concerned No Plan/Do Not Want Hydro Social Media $11,325 33 Male $ 18,700 QLD Rural High School Coalition Yes Very Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Already Installed Solar Magazines $50.00 $10,525 61 Male $ 13,600 WA Urban TAFE Labour Yes Satisfied Individuals/Families Unsure Very Aware Severly Affected 10 Very Concerned Install if I Could Solar Social Media 39 Female $ 10,600 TAS Urban Bachelor Labour Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Not Affected 5 Somewhat Concerned Plan to Install Hydro Newspapers 23 Male $ 24,400 ACT Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 2 Slightly Concerned No Plan/Do Not Want Oil Internet 55 Male QLD Urban High School Coalition Yes Unsure/Unfamilar Individuals/Families No Climate Change Little Knowledge Somewhat Affected 8 Very Concerned Install if I Could Solar Research Journals $10,200 43 Female $ 13,600 QLD Rural High School Coalition Yes Dissatisfied Australian Govt Mostly Human Very Aware Somewhat Affected 6 Very Concerned Install if I Could Coal Social Media $39.00 $10,950 43 Female $ 16,800 WA Rural Bachelor Coalition Yes Very Satisfied Australian Govt Mostly Natural Very Aware Not Affected 6 Very Concerned No Plan/Do Not Want Solar Newspapers $35,375 50 Male $ 110,000 QLD Urban TAFE Coalition No Very Satisfied Australian Govt Mostly Human No Interest/Awareness Severly Affected 7 Somewhat Concerned Already Installed Coal TV $141.00 43 Female NSW Rural High School Coalition No Very Satisfied State Govts Mostly Human Little Knowledge Somewhat Affected 6 Very Concerned No Plan/Do Not Want Solar Internet 49 Female NSW Urban High School Labour No Dissatisfied Australian Govt Mostly Human No Interest/Awareness Somewhat Affected 7 Very Concerned Already Installed Solar Newspapers 63 Female SA Urban Pre High School Coalition No Unsure/Unfamilar Australian Govt Unsure Very Aware Severly Affected 2 Not Concerned Already Installed Gas Research Journals 33 Female TAS Urban Bachelor Greens Yes Very Satisfied State Govts Mostly Human Very Aware Not Affected 4 Somewhat Concerned Already Installed Solar Magazines 35 Male $ 76,000 WA Urban High School Coalition No Unsure/Unfamilar Australian Govt Mostly Natural Little Knowledge Somewhat Affected 4 Somewhat Concerned Plan to Install Solar Social Media 21 Female $ 63,300 NSW Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Aware Somewhat Affected 2 Slightly Concerned Plan to Install Wind Social Media 63 Female $ 20,600 NSW Urban TAFE Greens Yes Unsure/Unfamilar Australian Govt No Climate Change Very Aware Severly Affected 10 Very Concerned Install if I Could Solar TV 36 Female $ 70,000 QLD Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Little Knowledge Somewhat Affected 5 Somewhat Concerned Install if I Could Solar Internet 28 Female SA Rural Bachelor Coalition No Satisfied Industry/Companys Mostly Human Very Aware Not Affected 3 Somewhat Concerned Already Installed Hydro Internet $12,700 43 Female $ 24,300 VIC Urban High School Coalition Yes Very Satisfied Australian Govt Unsure Very Aware Somewhat Affected 6 Very Concerned Install if I Could Solar Social Media 44 Female $ 22,800 WA Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 6 Very Concerned No Plan/Do Not Want Solar Newspapers 25 Female WA Urban Bachelor Coalition Yes Very Satisfied Australian Govt Mostly Natural No Interest/Awareness Not Affected 2 Not Concerned Already Installed Hydro Magazines $383.00 27 Male $ 153,000 SA Urban Pre High School Coalition No Very Satisfied Australian Govt Mostly Human No Interest/Awareness Severly Affected 3 Somewhat Concerned No Plan/Do Not Want Coal Internet 22 Female $ 60,000 NSW Urban High School Greens Yes Very Satisfied Australian Govt Mostly Human Aware Somewhat Affected 2 Not Concerned Already Installed Nuclear Newspapers $128.00 $13,675 33 Male $ 28,200 NSW Urban High School Labour No Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Already Installed Solar TV $169.00 25 Male $ 26,300 VIC Urban Postgrad Degree Labour Yes Very Satisfied Australian Govt Mostly Human Very Aware Severly Affected 2 Slightly Concerned Already Installed Nuclear Social Media $78.00 $11,325 47 Female $ 18,700 NT Urban Postgrad Degree Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Severly Affected 7 Very Concerned Install if I Could Solar TV $30.00 $10,950 44 Male $ 16,800 SA Urban Pre High School Coalition Yes Satisfied Australian Govt Mostly Human Very Aware Severly Affected 2 Very Concerned Already Installed Solar Newspapers 26 Male $ 71,000 SA Urban High School Coalition Yes Satisfied State Govts Mostly Human Aware Somewhat Affected 3 Slightly Concerned Install if I Could Hydro Magazines 47 Female $ 12,300 SA Urban Bachelor Coalition Yes Very Satisfied Australian Govt Unsure Very Aware Not Affected 7 Very Concerned Already Installed Solar Internet $307.00 35 Female $ 63,200 VIC Urban Bachelor Greens Yes Unsure/Unfamilar Australian Govt Mostly Natural Aware Not Affected 4 Somewhat Concerned Already Installed Coal Internet $43.00 41 Male ACT Urban High School Labour No Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 6 Very Concerned Already Installed Wind Magazines $51.00 32 Male VIC Urban High School Coalition Yes Very Satisfied Australian Govt Mostly Human Aware Somewhat Affected 4 Somewhat Concerned No Plan/Do Not Want Coal Internet 34 Female VIC Urban Pre High School Labour No Satisfied Australian Govt Mostly Human Aware Severly Affected 4 Somewhat Concerned No Plan/Do Not Want Hydro Newspapers $0.00 31 Male QLD Urban Postgrad Degree Labour Yes Satisfied Australian Govt No Climate Change Very Aware Severly Affected 4 Somewhat Concerned No Plan/Do Not Want Solar Internet 31 Male $ 58,000 NSW Urban Bachelor Labour No Very Satisfied State Govts Mostly Human Little Knowledge Not Affected 4 Somewhat Concerned Install if I Could Solar TV 57 Male NSW Urban High School Greens Yes Very Satisfied Australian Govt No Climate Change Very Aware Somewhat Affected 9 Very Concerned Plan to Install Hydro Newspapers $10.00 32 Female VIC Urban High School Labour Yes Unsure/Unfamilar Australian Govt Mostly Human Very Aware Somewhat Affected 4 Somewhat Concerned Already Installed Solar Internet 44 Male $ 248,000 NSW Urban Bachelor Coalition No Satisfied Australian Govt Mostly Natural No Interest/Awareness Not Affected 6 Very Concerned Already Installed Solar Social Media 29 Male $ 60,000 NSW Urban High School Greens Yes Very Satisfied Individuals/Families Mostly Human Little Knowledge Somewhat Affected 3 Not Concerned No Plan/Do Not Want Coal TV $20.00 $12,325 56 Male $ 20,600 NSW Rural High School Coalition No Very Satisfied Australian Govt Mostly Human Very Aware Somewhat Affected 9 Very Concerned Already Installed Solar Internet $357.00 $14,575 28 Male $ 32,000 WA Urban High School Labour Yes Satisfied Australian Govt No Climate Change Very Aware Somewhat Affected 3 Somewhat Concerned Already Installed Hydro Other 42 Female VIC Rural Bachelor Greens No Dissatisfied Australian Govt Mostly Natural Very Aware Not Affected 6 Very Concerned Already Installed Coal Internet 22 Female NSW Urban Bachelor Greens Yes Satisfied Industry/Companys Mostly Human Very Aware Not Affected 2 Slightly Concerned Already Installed Nuclear TV $78.00 35 Female SA Urban Postgrad Degree Coalition Yes Satisfied Australian Govt Mostly Natural Very Aware Severly Affected 4 Somewhat Concerned Plan to Install Coal Other 52 Female SA Urban Bachelor Coalition No Satisfied Australian Govt Mostly Natural No Interest/Awareness Not Affected 4 Extremely Concerned No Plan/Do Not Want Hydro Social Media for mean (σ known)
)
(σ)
(s)
(X)
Sample Mean (X) of the Mean
C10/SQRT(C12)
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! Margin of Error ERROR:#NUM! Margin of Error ERROR:#DIV/0! ERROR:#DIV/0! Interval Lower Limit ERROR:#NUM! Interval Lower Limit ERROR:#DIV/0! Limit
ERROR:#DIV/0! Interval Upper Limit ERROR:#NUM! Interval Upper Limit ERROR:#DIV/0! ‘. Note that ‘<>‘ represents not equal.
(Mean)
Hypotheses µ = “,IF(D12=”<","≥","="))
Null Hypothesis π ≤ µ <> Alternative Hypothesis π > Test Type Upper Level of significance α (Use decimal) Critical Region ERROR:#NUM! ERROR:#NUM! ERROR:#NUM! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#VALUE! ERROR:#DIV/0! Data Data Sampling Error (Use %) Confidence Level (Use %) Confidence Level (Use %) Intermediate Calculations Intermediate Calculations 0.0000 Z value 0.0000 ERROR:#DIV/0! Calculated Sample Size ERROR:#DIV/0! Result ERROR:#DIV/0! Sample Size Needed ERROR:#DIV/0!
2
Variable Name
Explanation
Options
Monthly_Payment
Amount willing to pay monthly ($) in order to have net zero electricity bills through renewable energy (e.g.
Solar
Up_Front_Payment
Amount willing to pay up front ($) in order to have net zero electricity bills through renewable energy (e.g. Solar panels with battery)
Age
Your Age in Years
Gender
Gender you most identify with
{
Male
Female
Income
Your income in Dollars
State
State in which you normally reside
{
NSW
WA
SA
ACT
NT
Locality
If you live in a city or the country
{
Urban
Rural
Education
The highest level of Education achieved
{Pre
High School
TAFE
Bachelor
Postgrad Degree
PhD
Politics
Which political party you most associate yourself with
{
Coal
Labour
Support
Belief that Australia should financially support developing countries in their efforts to address Climate Change
{
Yes
No
Govt_Policy
How happy you are with the Australian Government’s current policies on Climate Change
{Very
Dissatisfied
Unsure
Satisfied
Very Satisfied
Lead Role
Who should take the most responsibility in addressing Climate Change
{Australian government, State governments, Local government, Industry/Companies,
Individuals/Families
Cause
Who/what you think is most responsible for Climate Change
{
Mostly Human
Mostly Natural
Aware
Awareness you have regarding Climate Change
{
Very Aware
Affected
The extent you believe you have been affected by Climate Change
{Severely affected, Somewhat affected, Not affected}
Seriousness
Seriousness of Climate Change on Australian society (
1
–
10
{1, 2,
3
4
5
6
7
8
9
Concerned
Your concern with current situation regarding Climate Change
{Not concerned, Slightly concerned, Somewhat concerned, Very concerned, Extremely concerned}
Solar_Panals
Willingness to Install Solar Panels
{
Already Installed
Plan to Install
Energy_Source
Which Energy Source you believe should be Australia’s largest contributor to national Electricity generation
{Solar,
Hydro
Wind
Gas
Oil
Nuclear
Other
News_Source
Your preferred News Source to learn about Climate Change
{
Internet
Newspapers
Magazines
Research Journals
TV
Social Media
Data
Count
Gov_Policy
Lead_Role
1
$
46
$
49
35
$
75
QLD
Coalition
Australian Govt
Little Knowledge
Severly Affected
Slightly Concerned
No Plan/Do Not Want
2
$4
30
$
12
70
64
$
20
60
TAS
Not Concerned
3
$10.00
$12,000
33
$
21
100
Not Affected
Somewhat Concerned
4
$
27
$
36
50
23
$
85
VIC
Very Dissatisfied
No Climate Change
Somewhat Affected
Extremely Concerned
5
$3
11
$
18
25
$ 46,
200
6
$
40
$
14
77
$ 30,100
Unsure/Unfamilar
Very Concerned
7
$
29
$11,025
37
$ 18,700
Greens
8
$
303
$
31
250
$
94
State Govts
9
$
104
$21,700
39
$
57
10
$
69
$10,250
$
16
80
Install if I Could
11
$709.00
$
59
81
$ 2
53
12
$21.00
$
24
95
$
63
13
$
51
$10,
97
34
$ 16,800
14
$53.00
$12,700
$ 24,
300
15
$
32
$
26
$
76
16
$3
92
$13,
22
$
28
90
17
$3
55
$13,
350
61
$ 24,600
18
$
66
$17,
47
$ 40,600
Industry/Companys
19
$533.00
$13,750
$ 18,100
20
$
68
$22,850
$ 19,700
21
$22.00
$ 57,000
Pre High School
22
$
91
$
38
$
83
23
$
56
$14,
275
$ 30,700
24
$25.00
$22,950
$ 56,200
No Interest/Awareness
25
$17.00
$15,925
43
$ 28,000
26
$
89
$10,925
$ 13,
400
27
$31.00
$24,700
58
$ 68,000
28
$30.00
$12,
72
$ 24,200
29
$
158
$29,275
42
$ 70,000
30
$
67
$11,
325
$ 18,500
31
$100.00
$13,100
$ 26,000
32
$3
87
$16,600
$ 33,400
Local Govts
33
$
147
$11,325
41
34
$
294
$14,800
44
$ 33,200
35
$0.00
$14,
125
36
$943.00
$46,400
$
210
37
$908.00
$49,950
$
208
38 $0.00
$10,075
$ 14,300
39
$2.00
$12,600
$ 23,800
40 $10.00
$24,025
$ 60,000
41
$756.00
$23,725
$ 55,000
42
$49.00
$15,975
$ 37,900
43
$
130
$16,900
$ 12,300
44
$
285
$14,575
$ 32,000
45
$27,425
$ 72,000
46 $0.00
$11,300
48
47
$2
88
$44,275
48 $917.00
$39,975
$
134
49
$
263
$14,325
$ 34,000
50
$
54
$16,
150
51 $10.00
$11,350
$ 23,200
52
$925.00
$50,569
$
213
53
$
344
$34,100
$
105
54 $17.00
$19,875
55
$44.00
$16,925
$ 42,300
56
$26.00
$11,850
$ 20,600
57 $26.00 $13,100 39 Male
$ 28,300
58
$
99
$13,425
$ 24,700
59
$92.00
$10,950
60
$1
65
$12,050
$ 21,300
61
$563.00
$26,725
$ 63,700
62
$
343
$11,125
$ 19,100
63
$590.00
$26,425
$ 92,000
64
$
366
$25,800
$
79
65
$39.00
$10,975
$ 16,900
66
$28.00
$26,400
$ 81,990
67
$
146
$25,725
68
$27.00
$18,900
$ 52,800
69
$434.00
$26,750
$ 63,800
70 $31.00
$10,
225
$ 13,600
71
$
84
$9,850
$ 12,100
72
$765.00
$42,488
$
175
73
$11,700
$ 20,000
74
$ 16,600
75
$1
98
$12,300
$ 22,400
76 $31.00
$13,650
$ 23,500
77 $44.00
$20,075
$ 45,500
78
$
342
79
$
292
$35,
375
$
110
80
$
159
$12,625
$ 22,300
81
$58.00
$13,525
$ 27,500
82
$43.00
$24,325
$ 61,000
83
$134.00
$15,800
$ 31,000
84 $0.00
$15,200
$ 38,100
85
$72.00
$8,825
$ 7,000
86
$691.00
$13,175
$ 26,300
87
$482.00
$14,700
$ 39,700
88
$36.00
$9,350
$ 10,000
89
$
354
$ 23,400
90 $28.00
$22,225
$ 59,000
91
$84.00
$12,450
$ 21,100
92
$
384
$15,050
$ 34,300
93
$12.00
$10,850
$ 16,200
94
$
295
$12,825
$ 22,500
95
$442.00
$13,850
$ 29,200
96
$601.00
$52,031
$ 90,000
97
$413.00
$12,675
$ 22,000
98 $72.00
$19,500
$ 59,200
99
$34.00
$12,400
$ 22,800
100
$29.00
$11,650
$ 19,600
101
$
253
$23,475
$ 65,000
102
$629.00
$21,000
$ 49,300
103
$
148
$12,025
104 $0.00
$11,225
$ 18,000
105
$
141
$10,625
106
$16.00
$12,750
$ 24,300
107
$94.00
$16,325
108
$
357
$26,100
109
$19.00
$25,075
110
$
383
$ 20,200
111
$891.00
$59,063
$
120
112
$26,175
113
$
138
$11,150
114
$74.00
$12,175
115
$38.00
$12,725
116
$13,250
$ 26,400
117
$928.00
$73,275
$
335
118
$12,275
119
$13,475
$ 27,600
120
$479.00
$31,325
$ 86,400
121
$275.00
$24,300
$ 67,000
122
$
131
123
$850.00
$23,325
$ 58,000
124
$54.00
$17,250
$ 47,600
125
$78.00
$15,000
126
$56.00
$10,500
$ 20,300
127
$10,200
128
$948.00
$62,
156
$
367
129
$39,038
$ 83,000
130
$59.00
$20,200
$ 42,600
131
$
377
$14,825
132
$11,950
133
$837.00
$33,725
$ 95,000
134
$
172
$8,850
$ 8,600
135
$640.00
$30,625
$ 76,300
136
$
363
$13,075
$ 28,200
137
$12,200
$ 21,900
138
$40.00
$ 7,200
139
$55.00
$9,175
$ 9,100
140
$9,725
$ 15,800
141 $10.00
$14,375
$ 24,400
142
$10,700
143
$85.00
$31,375
$ 49,000
144
$470.00
$ 28,900
145
$12,250
146 $0.00
$22,375
147
$150.00
$16,475
$ 40,000
148
$250.00
$38,225
$ 110,000
149
$
373
$14,275
150
$13.00
$ 29,400
151
$68.00
$15,025
$ 33,900
152
$33,625
$ 103,200
153
$20,025
154
$76.00
$ 35,800
155
$893.00
$
240
156
$418.00
157
$105.00
$16,100
$ 35,200
158
$939.00
$31,500
159 $105.00
$18,425
$ 48,300
160
$99.00
161
$10,175
$ 14,700
162
$403.00
$13,225
163
$156.00
164
$119.00
165
$464.00
$40,775
$ 160,000
166
$
188
$10,225
167
$
365
$21,925
$ 46,000
168
$67.00
$8,900
$ 6,500
169
$22,425
170
$13,550
171
$14,225
172 $54.00
$9,325
$ 5,100
173
174
$149.00
$15,700
$ 29,800
175
$
233
$10,675
$ 15,500
176
$8,700
$ 7,900
177
$200.00
$17,325
178
$16,625
179
$9,200
$ 9,300
180
$95.00
$12,075
181
$32,700
182
$675.00
$34,850
183
184
$827.00
$17,100
$ 42,700
185
$
194
186
$440.00
187
$
272
188 $84.00
$18,500
189
$117.00
$9,550
$ 4,000
190
$96.00
$11,900
$ 19,000
191
$23,450
192
$148.00
$11,375
193
194
$135.00
$17,800
$ 17,000
195
$
262
$10,125
$ 13,200
196
$
202
$16,050
$ 42,000
197
$124.00
198
$70.00
$9,875
$ 11,100
199
200
$128.00
201
$61.00
202
$48.00
203
$493.00
$35,900
$ 140,000
204
$24,975
$ 63,300
205
$
257
$8,875
206
$69.00
207
$169.00
$8,525
208 $34.00 $14,700 30 Female
$ 32,500
209
$
327
$45,700
$ 125,000
210
$1,191.00
$58,013
$
248
211
$51.00
$ 36,100
212
$25,950
213
$63.00
$25,850
214
$729.00
$28,475
215
$14,000
$ 29,600
216
$1,
226
$56,569
$
304
217
$10,525
$ 16,300
218
$14,350
219
$
338
$35,525
$ 152,000
220
$
312
$21,450
$ 56,000
221
222
$33.00
223
$1,
349
$66,056
$ 402,000
224
$ 76,000
225
$542.00
$20,675
$ 57,800
226
$20.00
$13,300
227
$24,600
$ 62,000
228
$12,125
229
$ 25,000
230
231
232
$545.00
$28,575
233
$73.00
$ 5,800
234
$
288
$19,475
235
$10,375
$ 13,000
236
$15,850
237
$16,375
$ 39,900
238
$9,450
$ 10,300
239
$8,950
240
$676.00
$11,775
241
$205.00
$27,050
242
$681.00
$28,050
$ 74,200
243
244
$16,850
245
$
361
$43,875
$ 143,000
246
247
$567.00
$17,425
248
$452.00
$24,550
249
$31,150
$ 69,000
250 $0.00 $10,625 30 Female
$ 15,300
251
$183.00
$15,875
$ 41,300
252
$241.00
$30,275
253
$168.00
$38,550
254
$914.00
$50,588
$
322
255
$9,950
$ 13,700
256
$690.00
$ 75,900
257
$141.00
$ 33,000
258
$401.00
259
$37,225
$ 63,200
260
$966.00
$48,431
$ 248,000
261
$23,925
$ 59,600
262 $30.00
$10,575
$ 15,100
263
$924.00
$44,288
$ 185,000
264
$23,600
265
$560.00
$40,763
$ 153,000
266
$110.00
$25,575
267
$417.00
$25,250
268
$
337
$12,575
$ 18,300
269
$126.00
$25,650
$ 79,500
270
$214.00
$26,975
$ 71,000
271
$954.00
$53,681
$ 344,300
272
$485.00
$36,025
273
$15,650
$ 40,200
274
275 $96.00
$23,775
276
$ 22,100
277
$
341
278
$ 37,700
279
$130.00
$41,050
280
$230.00
$24,225
281
$98.00
$9,625
282
$15,475
$ 29,500
283
284
$407.00
$27,825
$ 80,000
285
$575.00
$30,725
286
$13,675
287
$21,825
288 $96.00
$25,325
289
290
$9,925
291
292
$873.00
$26,600
$ 69,600
293
294
$24.00
295
$143.00
296
$203.00
$13,800
297
298
$122.00
$ 23,900
299
$26,000
300 $0.00
$17,175
$ 43,400
301
$627.00
$18,350
$ 44,000
302
$242.00
$25,625
303
$298.00
$16,950
$ 42,400
304
$247.00
$26,150
305
306
$108.00
$18,575
$ 44,800
307
$429.00
$52,725
308
309
$23,300
310
$53,400
$ 213,000
311
312 $30.00
$17,025
$ 38,800
313
$496.00
$32,325
314
$50.00
$20,625
$ 48,000
315
$47.00
$9,500
$ 10,600
316
$161.00
$12,500
317
$28,975
318
$424.00
$27,400
$ 41,000
319
320
$42.00
$11,725
321
$453.00
322 $21.00
$28,375
323
$920.00
$61,181
$ 265,100
324
325 $338.00
$18,000
$ 46,900
326
327 $0.00
$9,975
$ 13,800
328
$
372
329
$60.00
$28,675
330
331
$145.00
332
$165.00
333
$18.00
334
$65.00
335
$193.00
336
337 $143.00
$8,650
$ 8,500
338 $39.00
$10,550
339
340
$86.00
$14,675
341 $0.00
$20,725
342 $0.00
$23,900
$ 26,600
343 $73.00
$16,550
$ 37,000
344
$307.00
$15,425
$ 39,100
345
$425.00
$27,975
346
$167.00
$21,550
347
$728.00
$42,450
$ 176,300
348
$851.00
$35,875
349
$283.00
350
$163.00
$ 43,300
351
$692.00
$36,400
352
$87.00
353
$8,975
$ 8,300
354 $149.00
$36,250
355
$154.00
356
357 $21.00 $14,700 37 Male $ 35,800 WA Urban High School Coalition Yes Unsure/Unfamilar Australian Govt Mostly Natural Very Aware Somewhat Affected 5 Somewhat Concerned Install if I Could Solar Newspapers
358
$345.00
$9,300
359
$52.00
$13,150
360
$209.00
$21,750
$ 52,000
361
$136.00
362
363
$357.00
364
$23,525
$ 64,000
365 $40.00
$22,700
$ 55,800
366 $38.00
$12,775
$ 19,800
367 $31.00
$14,475
$ 31,600
368
$116.00
$26,775
369
$505.00
$37,275
370
$488.00
$12,325
371
$41.00
$23,550
372 $40.00
$14,875
$ 33,300
373
$198.00
374
$37.00
$12,350
375 $33.00
$24,725
$ 63,000
376
$50,400
377 $0.00
$35,950
378
379
$16,525
380
381
382
$416.00
$23,500
383
$202.00
$9,900
384 $37.00 $11,325 41 Female $ 18,700 ACT Urban High School Coalition Yes Satisfied Australian Govt Mostly Natural Very Aware Somewhat Affected 6 Somewhat Concerned No Plan/Do Not Want Hydro Social Media
385
$24,950
386
$16,200
$ 39,200
387
$28,850
$ 77,000
388
$700.00
$41,625
$ 122,000
389
$15,525
$ 36,000
390
$562.00
$22,100
391
$411.00
$18,375
$ 44,100
392
$9,575
$ 10,800
393
$1,036.00
$57,581
394
$7.00
$21,200
395
396
397
$80.00
$8,175
$ 5,000
398
$82.00
$20,350
$ 41,500
399
$8,500
$ 6,300
400
$835.00
$52,594
$ 272,000
Q1
Q2
Q3
Q4
Q5
Q6
CI – Template
–
Instructions (Note: These are Template – copy to your Q1 – Q6 tabs as necessary)
1. Cells shaded in blue are for inputs (it is important that you do not change any other cells)
2. Cells shaded in green represent final results or important calculations
3. Non-shaded cells show intermediate results
Confidence Interval
Confidence Interval for mean (σ unknown)
Confidence Interval for proportion (
π
Data
Data Data
Population Standard Deviation
Sample Standard Deviation
Sample Size
Sample Mean
Count of Successes
Sample Size Sample Size
Confidence Level
(Use %)
Confidence Level (Use %) Confidence Level (Use %)
Intermediate Calculations
Intermediate Calculations Intermediate Calculations
Standard Error
ERROR:#DIV/0!
=
Standard Error of the Mean
=H10/SQRT(H12)
Sample Proportion
=M11/M10
Degrees of Freedom
-1
=H12-1
Z Value
0.0000
=NORMSINV(1-(1-M12)/2)
Z Value 0.0000
=NORMSINV(1-(1-C13)/2)
t Value
ERROR:#NUM!
=TINV(1-H13,H17)
Standard Error of the Proportion
=SQRT(M16*(1-M16)/M10)
Margin of Error
=ABS(C18*C16)
=ABS(H18*H16)
=ABS(M17*M18)
Confidence Interval Confidence Interval Confidence Interval
Interval Lower Limit
=C11-C19
=H11-H19
=M16-M19
Interval
Upper
=C11+C19
=H11+H19
=M16+M19
HT – Template
– Instructions (Note: These are Template – copy to your Q1 – Q6 tabs as necessary)
1. Cells shaded in blue are for inputs (it is important that you do not change any other cells)
2. Cells shaded in green represent final results or important calculations
3. Non-shaded cells show intermediate results
4. In cells D7 and J7 the ONLY valid values are ‘<', '>‘ or ‘
<>
Hypothesis Test for
µ
Hypothesis Test for π (Proportion)
Hypotheses
Null Hypothesis
=IF(D12=”>”,”
≤
=IF(E12=””,””,E12)
=IF(K12=”>”,”≤”,IF(K12=”<","≥","="))
=IF(L12=””,””,L12)
Alternative Hypothesis
Test Type
Two
=IF(D12=”<","Lower",IF(D12=">“,”Upper”,”Two”))
=IF(K12=”<","Lower",IF(K12=">“,”Upper”,”Two”))
Level of significance
α
(Use decimal)
Critical Region
Degrees of Freedom -1
=E23-1
Critical Value
=IF(L13=”Two”,NORMSINV(L15/2),IF(L13=”Lower”,NORMSINV(L15),NORMSINV(1-L15)))
Lower Critical Value
=IF(E13=”Two”,-(TINV(E15,E17)),IF(E13=”Lower”,-(TINV(E15*2,E17)),TINV(E15*2,E17)))
=IF(K11=”=”,-L17,””)
Upper Critical Value
=IF(D11=”=”,-E18,””)
Sample Data
Sample Data Sample Size
Sample Standard Deviation
Count of ‘Successes’
Sample Mean
Sample Size
Sample proportion, p
=L21/L20
Standard Error
ERROR:#VALUE!
=SQRT(L11*(1-L11)/L20)
Standard Error of the Mean ERROR:#DIV/0!
=E21/SQRT(E23)
Z Sample Statistic
=(L23-L11)/L24
t Sample Statistic
=(E22-E11)/E25
p-value
=IF(L13=”Two”,2*(1-NORMSDIST(ABS(L25))),IF(L25*L17>0,1-NORMSDIST(ABS(L25)),NORMSDIST(ABS(L25))))
p-value ERROR:#VALUE!
=IF(D11=”=”,TDIST(ABS(E26),E17,2),IF(E26*E18>0,TDIST(ABS(E26),E17,1),1-TDIST(ABS(E26),E17,1)))
Decision
Decision ERROR:#DIV/0!
=IF(L26 ERROR:#VALUE!
=IF(E27 SS – Template
– Instructions (Note: These are Template – copy to your Q1 – Q6 tabs as necessary)
1. Cells shaded in blue are for inputs (it is important that you do not change any other cells)
2. Cells shaded in green represent final results or important calculations
3. Non-shaded cells show intermediate results
Sample size for a Mean
Sample size for a Proportion
Population Standard Deviation
Estimate of True Proportion
Sampling Error
Z value
=NORM.S.INV((1+C12)/2)
=NORM.S.INV((1+H12)/2)
Calculated Sample Size
=((C15*C10)/C11)^2
=(H15^2*H10*(1-H10))/H11^2
Result
Sample Size Needed
=ROUNDUP(C16,0)
=ROUNDUP(H16,0)