Send data to ExcelLength of smoking cessation periodBetweenLess thantwo weeksAt least oneTotaltwo weeksand oneyearyear571218269.55260Male2.229407525SexFemale37.45140口4.139Total97196107400Part 2Answer the following to summarize the test of the hypothesis that there is no association betweethe length of the smoking cessation period. For your test, use the 0.05 level of significance.(a) Determine the type of test statistic touse.Type of test statistic: (Choose one) ▼(b) Find the value of the test statistic. (Round to two or more decimal places.)(c) Find the critical value for a test at the 0.05 level of significance. (Round totwo or more decimal places.)(d) Can we conclude that there is an association between sex and the lengthof the smoking cessation period? Use the 0.05 level of significance.O Yes O No Among the huge body of literature on smoking are data detailing the relative Sfemales in quitting smoking. A study of 400 adults (ages 20 and older) who began various smoking-cessationprograms produced the data in the contingency table below. The table shows data from the study regardingtwo variables: the smoker's sex ("male" or "female") and the length of the smoking cessation period ("lessthan two weeks", "between two weeks and one year", or "at least one year").In the table, "less than two weeks" means that the individual returned to smoking within two weeks ofbeginning the program, "between two weeks and one year" means that the individual survived the first twoweeks but returned to smoking within a year, and "at least one year" means that the individual did notsmoke for at least a year after beginning the program.The cells of the table each contain three numbers. The first number in each cell is the observed cellfrequency (fo); the second number is the expected cell frequency (fF) under the assumption that there is noassociation between sex and the length of the smoking cessation period; and the third number is thefollowing value.(fo-JE) (Observed cell frequencyExpected cell frequencySEExpected cell frequencyne numbers labeled "Total" are totals for observed frequency.

Question

Send data to ExcelLength of smoking cessation periodBetweenLess thantwo weeksAt least oneTotaltwo weeksand oneyearyear571218269.55260Male2.229407525SexFemale37.45140口4.139Total97196107400Part 2Answer the following to summarize the test of the hypothesis that there is no association betweethe length of the smoking cessation period. For your test, use the 0.05 level of significance.(a) Determine the type of test statistic touse.Type of test statistic: (Choose one) ▼(b) Find the value of the test statistic. (Round to two or more decimal places.)(c) Find the critical value for a test at the 0.05 level of significance. (Round totwo or more decimal places.)(d) Can we conclude that there is an association between sex and the lengthof the smoking cessation period? Use the 0.05 level of significance.O Yes O No Among the huge body of literature on smoking are data detailing the relative Sfemales in quitting smoking. A study of 400 adults (ages 20 and older) who began various smoking-cessationprograms produced the data in the contingency table below. The table shows data from the study regardingtwo variables: the smoker's sex (&#34;male&#34; or &#34;female&#34;) and the length of the smoking cessation period (&#34;lessthan two weeks&#34;, &#34;between two weeks and one year&#34;, or &#34;at least one year&#34;).In the table, &#34;less than two weeks&#34; means that the individual returned to smoking within two weeks ofbeginning the program, &#34;between two weeks and one year&#34; means that the individual survived the first twoweeks but returned to smoking within a year, and &#34;at least one year&#34; means that the individual did notsmoke for at least a year after beginning the program.The cells of the table each contain three numbers. The first number in each cell is the observed cellfrequency (fo); the second number is the expected cell frequency (fF) under the assumption that there is noassociation between sex and the length of the smoking cessation period; and the third number is thefollowing value.(fo-JE) (Observed cell frequencyExpected cell frequencySEExpected cell frequencyne numbers labeled &#34;Total&#34; are totals for observed frequency.

Accepted Answer

We complete the given data table from the given formula.
Expected frequency=
row total* column…