Hi, can you please help me with this question?

A representative sample of 53? university students was surveyed to determine which of two attributes would have the most significant influence on choosing a laptop computer for their studies: price and portability. The sex of each student was also recorded. The data are recorded in the |apt_op choicexlsx. In Excel worksheet, use the Pivot table to create a table of expected counts and perform a Chi-squared test of independence. 1. {1 mark} What is the value of the test statistic for this Chisquared test of independence? (3dp} 2. {1 mark} What is the degrees of freedom associated with this Chi-squared test of independence '? {Integer} 3. {1 mark} Is the P-value less than 0.05 for this Chi-squared test of independence? 0 AutoSave O OFF 1 laptop_choice a Home Insert Draw Page Layout Formulas Data Review View ? Tell me Share Comments Calibri (Body) AA ab Wrap Text General Insert v 11 2 x AY - O. Delete v Cell Sort & Find & Analyse Sensitivity Paste BIUV Merge & Centre v $ ~ % " Conditional Format Formatting as Table Styles Format Filter Select Data A1 4 X V fx B D E F G H J K L M N 0 P Q R S T U V w X Z 1 Males Females 2 Price 265 54 3 Portability 55 213 owa UT as.data.frame(res) + 100% Ready