ASPCA wanted to find out if there was a relationship between the type of animals preferred ...

profileguru2009
 (Not rated)
 (Not rated)
Chat

  

ASPCA wanted to find out if there was a relationship between the type of animals preferred and the gender of the owner. They gathered data from 50 randomly chosen pet owners who owned either one cat or one dog:

  

gender


type


gender


type

 

female


cat


male


cat

 

male


dog


female


cat

 

male


dog


male


cat

 

male


dog


female


dog

 

female


cat


female


cat

 

female


cat


female


dog

 

female


dog


male


cat

 

female


cat


male


dog

 

male


dog


male


dog

 

female


dog


male


dog

 

female


dog


male


cat

 

male


dog


female


dog

 

male


cat


female


cat

 

male


cat


male


dog

 

female


dog


female


cat

 

female


cat


female


cat

 

female


cat


male


cat

 

female


cat


female


cat

 

female


dog


male


dog

 

male


cat


female


dog

 

male


dog


male


cat

 

male


cat


female


dog

 

male


dog


male


cat

 

male


dog


male


cat

 

female


dog


male


dog

Use Excel’s capabilities to create a pivot table that shows the number of pets owned by each gender.

Chi Square:

Use the pivot table from problem 1 to find the Chi Square value and give the interpretation based on a .01 significance level.  Is there are relationship between the sex of the owner and the type of pet they prefer?

    • 8 years ago
    (b) Ho: Gender and Type are independent versus Ha: Gender and Type are dependent ...
    NOT RATED

    Purchase the answer to view it

    blurred-text
    • attachment
      ASPCAwantedtofindoutiftherewasarelationshipbetweenthetypeofanimalspreferredandthegenderoftheowner.doc