I have attempted to do the observed relative frequency table and I'm not sure how to do the expected results or how to tell if events are independent or not.

The Australian National Electricity Market (NEM) is the wholesale spot market for electricity in the Eastern states of Australia. It comprises the states of Queensland (QLD), New South Wales (NSW), Victoria (VIC), South Australia (SA) and Tasmania (TAS). The market is operated by an independent regulatory authority, the Australian Energy Market operator (AEMO). Among its other responsibilities, AEMO runs a process of dispatching generators to meet the demand of customers for electricity. Through this process the wholesale price is determined for every 30-minute interval in each of the states, each of which represents a regional market. A 24-hour day is divided into 48, 30- minute intervals. In this assignment “price” refers to the wholesale spot price of electricity in the NEM and “interval” to a 30-minute interval. Price can, and usually does, vary by state, interval as well as by season. Prices are generally higher in seasons or months of higher demand which correspond to hot or cold periods of the year driven by air conditioning or electric heating demand. You are not expected to be experts in the electricity market, this information is provided for context. The data that you will analyse are prices for each interval in the months of February, March and April 2019 for each of NSW, VIC and SA, see the Excel file [Elec Price data _Assignment 26134 BStats]. The data has been downloaded from AEMO’s website. Prices are expressed in Australian dollars per Megawatt hour (MWh). MWh is a unit of energy.

Q2- The states of VIC, NSW and SA are dominated by brown coal, black coal and renewable generation assets respectively. These three generation types emit greenhouse gas (GHG) in varying intensities.1 Brown coal has the highest intensity followed by black coal and then renewables. A policy maker is interested in understanding if a relationship exists between electricity price and GHG intensity and has asked you to present analysis on this question. In your analysis, arrange the emissions intensity from highest to lowest (or vice versa) and use the following seven price categories:

1) <=$30/MWh

2) >$30/MWh to <=$60/MWh

3) >$60/MWh to <=$90/MWh

4) >$90/MWh to <=$120/MWh

5) >$120/MWh to <=$150/MWh

6) >$150/MWh to <=$180/MWh

7) >$180/MWh

a) Using the price data for all three months (keep the three states separate) construct a table of relative frequency. The relative frequency table will have three states and seven price categories. Form two such tables, one based on observed (actual) relative frequencies and the other based on the expected (under the assumption of independence) relative frequencies. Compare the relative frequencies in the two tables. Does the data indicate that price and GHG intensity are independent or not independent?

FREQUENCY TABLE
	NSW	VIC	SA	TOTAL
	<= $30/MWh	26	91	120	237
	> $30/MWh to <= $60/MWh	624	358	365	1347
	> $60/MWh to <= $90/MWh	1943	969	1078	3990
	> $90/MWh to <= $120/MWh	1422	1798	1633	4853
	> $120/MWh to <= $150/MWh	182	761	728	1671
	> $150/MWh to <= $180/MWh	38	136	173	347
	>$180/MWh	37	159	175	371
TOTAL	4272	4272	4272	12816

OBSERVED RELATIVE FREQUENCY TABLE
	NSW	VIC	SA	TOTAL
	<= $30/MWh	0.00203	0.0071	0.00936	0.01849
	> $30/MWh to <= $60/MWh	0.04869	0.02793	0.02848	0.1051
	> $60/MWh to <= $90/MWh	0.15161	0.07561	0.08411	0.31133
	> $90/MWh to <= $120/MWh	0.11096	0.14029	0.12742	0.37867
	> $120/MWh to <= $150/MWh	0.0142	0.05938	0.0568	0.13038
	> $150/MWh to <= $180/MWh	0.00297	0.01061	0.0135	0.02708
	>$180/MWh	0.00289	0.01241	0.01365	0.02895
TOTAL		0.33333	0.33333	0.33333

Answer rating: 100% (QA)

To analyze the relationship between electricity price and GHG intensity in the states of New South Wales NSW Victoria VIC and South Australia SA you can follow these steps 1 Arrange the emissions inte... View the full answer