Show how to answer this in EXCEL ONLY, NO megastator minitab, etc.. Please highlight what data tools orformulas were used.
A survey investigated the public’s attitude toward the federaldeficit. Each sampled citizen was classified as to whether he orshe felt the government should reduce the deficit or increase thedeficit, or if the individual had no opinion. The sample results ofthe study by gender are reported to below.
| Gender | Reduce the Deficit | Increase the Deficit | No Opinion |
| Female | 224 | 194 | 68 |
| Male | 305 | 114 | 25 |
At the .05 significance level, is it reasonable to conclude thatgender is independent of a person’s position on the deficit?
