Hi There,

I need help for Q2 with Analytical formula using excel. Please find the question 2 in the screenshot and google link to data set or reference file to work on. Thanks in advance.

https://docs.google.com/spreadsheets/d/1N1-4py_msaIdohvKMD_qvQfr5mdWEe9F/edit?usp=sharing&ouid=116530119154629136960&rtpof=true&sd=true

u...u......... u... "u... ........u...n.._.._.. uuvs...n.u_...._. -u..\\...... l'\" ....... 'u' uuu.._.u.u.r \"up. .._r.r.,..u_u..uuuu. Q2. Exploring relationships between'two variables (a) I suspect there is some link between the level of annual income (\"Income\") and the amount of money people are willing to pay monthly (\"Monthly_Payment\") in order to have net zero emission electricity bills as a result of using renewable energy technologies, but I'd still like you to establish from your sample data if there is any relationship between these two variables. (b) I'm also interested to establish if there is a relationship between gender (\"Gender\") and an individual's willingness for Australia to provide financial support to developing countries (\"Support\") in order for them to facilitate renewable energy. (c) Further, it would be helpful if we knew if the age (\"Age\") of a person had any relationship to their awareness ("Awareness") of renewable energy technologies