Question
REQUIREMENT: Deliver a REPORT answering below questions (analyze and make comment) IMPORTANT : **PLEASE, UPLOAD EXCEL FULLCALCULATION FILE** NSW government is considering policies to promote
REQUIREMENT: Deliver a REPORT answering below questions (analyze and make comment)
IMPORTANT: **PLEASE, UPLOAD EXCEL FULLCALCULATION FILE**
NSW government is considering policies to promote the uptake of solar panel to produce electricity for household consumption. To investigate factors that affect households' decision to adopt solar panel, a survey was carried out and the obtained data are provided in 'solar uptake survey data' data set.
a) A government officer suggests that the proportion of households adopting solar technology is the same as the proportion of households not adopting solar technology. Use a statistical test to test this claim. Make sure to state the null hypothesis and the alternative hypothesis, the type of test to be used, the test statistic, the critical value or p-value, and the conclusion from the test.
b) Use a statistical test to examine whether there is a relationship between solar technology uptake and the type of dwellings the household has. Make sure to state the null hypothesis and the alternative hypothesis, the type of test to be used, the test statistic, the critical value or p-value, and the conclusion. Using bar chart, graph the number of observations with solar and nonsolar for each type of dwellings.Hint: In Excel, you can use function COUNTIFS to count the number of observations that satisfy multiple conditions. For example, this function is useful for counting households that has adopted solar and has a given dwelling type.
c) Use a statistical test to examine whether there is a relationship between solar technology uptake and household income. Make sure to state the null hypothesis and the alternative hypothesis, the type of test to be used, the test statistic, the critical value or p-value, and the conclusion. Using bar chart, graph the number of observations with solar and nonsolar for each income group.
d) Use a statistical test to examine whether there is a relationship between solar technology uptake and head of household's education. Make sure to state the null hypothesis and the alternative hypothesis, the type of test to be used, the test statistic, the critical value or p-value, and the conclusion. Using bar chart, graph the number of observations with solar and nonsolar for each education level.
e) Based on your investigation, provide recommendations that can help policy makers increase solar technology uptake.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started