I have the following questions/issues relating to the NetZero attitude dataset.

1. Is there a willingness among urban residents to pay higher monthly payments for achieving net-zero electricity bills compared to their rural counterparts?

2. Is the proportion of residents who are not concerned about climate change lower in rural areas compared to urban areas?

3. Does the proportion of residents who believe that Australia should financially support developing countries in their support efforts to address climate change differ across their political beliefs?

4. Does the average upfront amount for achieving net-zero electricity bills significantly differ across who they think should take responsibility in addressing climate change?

5. Design an experiment to see the impact of locality and political affiliation on the amount willing to pay upfront for achieving net-zero electricity bills.

6. A study was conducted to evaluate the attitudes of 12 randomly selected residents towards the government's approach to climate change. An Attitude Index was used to measure the level of support for the government's approach, where higher values indicated greater support. The residents participated in the study in both 2021 and 2022. Is there a change in the attitude?

THE data analysis using the Excel templates provided in practicals. In choosing the technique to apply for a given question, keep the following in mind: ? Are we dealing with a numerical variable or a categorical variable? ? Are we dealing with one population, two populations or more than two populations? ? Are we dealing with an independent population or a dependent population? ? Each question must be answered using the most appropriate technique(s) and justify the decision where applicable. ? Please formulate the hypotheses, and state them clearly in both notation and words in the Excel file. ? Even though a question(s) lead you to inferential techniques, consider conducting a descriptive analysis of the data first. For all questions , assume that: ? 95 % confidence level is appropriate for confidence intervals and; ? 5.0 % level of significance (i.e. ? = 0.05) is appropriate for any hypothesis tests

Transcribed Image Text:

AutoSave OFF T12023A1 (1) Home Insert Draw Page Layout Formulas Data Review Calibri (Body) 12 A A Paste B I U A View Tell me % Conditional Formatting Format as Table Number Cell Styles v Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. Comments Share Cells Editing Restart Now B Explanation Amount willing to pay monthly ($) in order to have net zero electricity bills through renewable energy (e.g. Solar panels with battery) C32 fx A 1 Variable Name Monthly_Payment 2 Up_Front_Payment 4 Age Gender Income State Education 8 Locality 10 Politics 11 Support 12 Govt Policy 13 Lead Role 14 Cause 3456789222222222222222222 15 Awareness 16 Affected 17 Seriousness 18 Concerned 19 Solar Panals 20 Energy Source 21 News Source Amount willing to pay up front ($) in order to have net zero electricity bills through renewable energy (e.g. Solar panels with battery) Your Age in Years Gender you most identify with Your income in Dollars State in which you normally reside If you live in a city or the country The highest level of Education achieved Which political party you most associate yourself with Belief that Australia should financially support developing countries in their efforts to address Climate Change How happy you are with the Australian Government's current policies on Climate Change Who should take the most responsibility in addressing Climate Change Who/what you think is most responsible for Climate Change Awareness you have regarding Climate Change The extent you believe you have been affected by Climate Change Seriousness of Climate Change on Australian society (1 - Not Serious, 10 - Extremely Serious) Your concern with current situation regarding Climate Change Willingness to Install Solar Panels Which Energy Source you believe should be Australia's largest contributor to national Electricity generation Your preferred News Source to learn about Climate Change {Male, Female} {NSW, Vic, Qld, WA, SA, Tas, ACT, NT} {Urban, Rural} C Options {Pre High School, High School, TAFE Certificate, Bachelor Degree, Postgrad Degree, PhD} {Coalition, Labour, Green, Minor Parties} {Yes, No} {Very Dissatisfied, Dissatisfied, Unsure/Unfamiliar, Satisfied, Very Satisfied} {Australian government, State governments, Individuals/Families} {Mostly Human, Mostly Natural, There is no Climate Change, Unsure/Undecided} {Very Aware, Moderately Aware, Have a little knowledge, Have no Interest/Awareness} {Severely affected, Somewhat affected, Not affected} {1, 2, 3, 4, 5, 6, 7, 8, 9, 10} {Not concerned, Slightly concerned, Somewhat concerned, Very concerned, Extremely concerne {Already Installed, Plan to Install, Would Install if I could, No plan to install/Do not want} {Solar, Hydro, Wind, Coal, Gas, Oil, Nuclear, Other Renewable} {Internet, Newspapers, Magazines, Research Journals, TV, Social Media, Other} 29 30 31 32 33 34 35 36 37 AutoSave OFF T12023A1 (1) Home Insert Draw Page Layout Formulas Data Review Calibri (Body) 12 A A Paste B I U A View Tell me % Conditional Formatting Format as Table Number Cell Styles v Update Available We've made some fixes and improvements. To complete the process, the app needs to restart. Comments Share Cells Editing Restart Now B Explanation Amount willing to pay monthly ($) in order to have net zero electricity bills through renewable energy (e.g. Solar panels with battery) C32 fx A 1 Variable Name Monthly_Payment 2 Up_Front_Payment 4 Age Gender Income State Education 8 Locality 10 Politics 11 Support 12 Govt Policy 13 Lead Role 14 Cause 3456789222222222222222222 15 Awareness 16 Affected 17 Seriousness 18 Concerned 19 Solar Panals 20 Energy Source 21 News Source Amount willing to pay up front ($) in order to have net zero electricity bills through renewable energy (e.g. Solar panels with battery) Your Age in Years Gender you most identify with Your income in Dollars State in which you normally reside If you live in a city or the country The highest level of Education achieved Which political party you most associate yourself with Belief that Australia should financially support developing countries in their efforts to address Climate Change How happy you are with the Australian Government's current policies on Climate Change Who should take the most responsibility in addressing Climate Change Who/what you think is most responsible for Climate Change Awareness you have regarding Climate Change The extent you believe you have been affected by Climate Change Seriousness of Climate Change on Australian society (1 - Not Serious, 10 - Extremely Serious) Your concern with current situation regarding Climate Change Willingness to Install Solar Panels Which Energy Source you believe should be Australia's largest contributor to national Electricity generation Your preferred News Source to learn about Climate Change {Male, Female} {NSW, Vic, Qld, WA, SA, Tas, ACT, NT} {Urban, Rural} C Options {Pre High School, High School, TAFE Certificate, Bachelor Degree, Postgrad Degree, PhD} {Coalition, Labour, Green, Minor Parties} {Yes, No} {Very Dissatisfied, Dissatisfied, Unsure/Unfamiliar, Satisfied, Very Satisfied} {Australian government, State governments, Individuals/Families} {Mostly Human, Mostly Natural, There is no Climate Change, Unsure/Undecided} {Very Aware, Moderately Aware, Have a little knowledge, Have no Interest/Awareness} {Severely affected, Somewhat affected, Not affected} {1, 2, 3, 4, 5, 6, 7, 8, 9, 10} {Not concerned, Slightly concerned, Somewhat concerned, Very concerned, Extremely concerne {Already Installed, Plan to Install, Would Install if I could, No plan to install/Do not want} {Solar, Hydro, Wind, Coal, Gas, Oil, Nuclear, Other Renewable} {Internet, Newspapers, Magazines, Research Journals, TV, Social Media, Other} 29 30 31 32 33 34 35 36 37