Representative sample of 528 university students was surveyed to determine which of two attributes (Price and CPU) matters the most when choosing a laptop for their studies. The degree of each student was also recorded.

In Excel worksheet, use the Pivot table to create a table of expected counts and perform a Chi-squared test of independence. Information in the box below

(1 mark) What is the value of the test statistic for this Chi-squared test of independence? Answer (3dp)

(1 mark) What is the degrees of freedom associated with this Chi-squared test of independence ? Answer (Integer)

(1 mark) Is the P-value less than 0.05 for this Chi-squared test of independence? Answer

	C	A
Price	222	51
CPU	48	207