Please show necessary Excel formualas and breakdown required

Please show necessary Excel formualas and breakdown required

11.26 USA Today reported on when the decision of                  
what to have for dinner is made. Suppose the results were                  
based on a survey of 1,000 respondents and considered                  
whether the household included any children under 18                  
years old. The results are cross-classified in the following                  
table:                  
                  
       Type of Household          
                  
When Decision Made One Adult two or more two or more
       No children   adlts/kids adlts/no kids     
                          
Just before eating   162   54   154      
in the afternoon   73   38   69      
in the morning   59   58   53      
a few days before   21   64   45      
the night before   15   50   45      
always eat the
same thing on
this night       2   16   2      
not sure       7   6   7      
                  
At the 0.05 level of significance, is there evidence of a                  
significant relationship between when the decision is made                  
of what to have for dinner and the type of household?   

Solution