1.0/ 1.0 PointsNow that we calculated the Expected Counts we need to find the Test Statistic.Test Stat = You will need to all 12 Count values but I am only showing you 3 because there isn't room to write out the entireequation.Question 13 of 20Click to see additional instructionsAn electronics store has 4 branches in a large city. They are curious if sales in any particular department aredifferent depending on location. They take a random sample of 4 purchases throughout the 4 branches – theresults are recorded below. Run an independence test for the data below at the 0.05 level of significance.AppliancesTVComputersCell PhonesBranch 156286324Branch 244225527Branch 353174933Branch 451316629Enter the P-Value - round to 4 decimal places. Make sure you put a 0 in front of the decimal.!0.6099Answer Key: Answer Key: 0.6099Feedback:Feedback:We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given theObserved Counts in the table. Next you need to sum the rows and columns. Once you have those you need tocalculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.AppliancesTVComputersCell PhonesSumBranch 156286324171Branch 244225527148Branch 353174933152Branch 451316629177Sum20498233113648AppliancesTVComputersCell PhonesBranch 1=204*(171/648)=98*(171/648)=233*(171/648)=113*(171/648)
0.0/ 1.0 PointsBranch 2=204*(148/648)=98*(148/648)=233*(148/648)=113*(148/648)Branch 3=204*(152/648)=98*(152/648)=233*(152/648)=113*(152/648)Branch 4=204*(177/648)=98*(177/648)=233*(177/648)=113*(177/648)Now that we calculated the Expected Count we can use Excel to find the p-value. Use =CHISQ.TEST(highlight actual counts, highlight expected counts) = 0.6099Question 14 of 20Click to see additional instructionsA local gym is looking in to purchasing more exercise equipment and runs a survey to find out thepreference in exercise equipment amongst their members. They categorize the members based on howfrequently they use the gym each month – the results are below. Run an independence test at the 0.01 levelof significance.Free WeightsWeightMachinesEnduranceMachinesAerobicsEquipment0-10 Uses1217251311-30 Uses20189931+ Uses2612119Enter the test statistic - round to 4 decimal places.%15.8713Answer Key: Answer Key: 15.8803Feedback:Feedback:We are running a Chi-Square Test for Independence. Copy and Paste the table into Excel. You are given theObserved Counts in the table. Next you need to sum the rows and columns. Once you have those you need tocalculate the Expected Counts. You need to find the probability of the row and then multiple it by the column total.Free WeightsWeight MachinesEnduranceMachinesAerobics EquipmentSum0-10 Uses121725136711-30 Uses2018995631+ Uses261211958Sum58474531181
1.0/ 1.0 PointsFree WeightsWeight MachinesEnduranceMachinesAerobics Equipment0-10 Uses=58*(67/181)=47*(67/181)=45*(67/181)=31*(67/181)11-30 Uses=58*(56/181)=47*(56/181)=45*(56/181)=31*(56/181)31+ Uses=58*(58/181)=47*(58/181)=45*(58/181)=31*(58/181)Now that we calculated the Expected Counts we need to find the Test Statistic.