Get Instant Help From 5000+ Experts For

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Analysis of Animal Shelter Data

## Primary Research Question

1.Have you ever been curious about how long it takes for an animal to be adopted?  To investigate questions like this, we contacted the Austin Animal Shelter and they provided us with information about 473 cats and dogs.  Included in the dataset are information about how the animals arrived at the shelter, their sex, breed, age, weight, and the number of days spent in the shelter.  The data is contained in AnimalData.xls.

Primary Research Question: how many days do animals spend in the shelter before they are adopted?

a.Construct pie chart on any one of the qualitative variable {column C to F; column H to O; column W}

b.Construct bar chart on any one of the qualitative variable {column C to F; column H to O; column W}

c.Calculate Descriptive Statistics on any of the qualitative variable (Column P, T or X}.

d.Construct Histogram on column X.

2.Analyze what you learned from the excel output.

Deliverables

2.Bring one page write up to class.

Instructions for Excel Project

Descriptive Statistics

1.Click Tools, Data Analysis…, and Descriptive Statistics

2.Enter cell addresses of data (or highlight your data) in Input Range Box (for example: \$I\$1:\$K\$388)

3.Click on Labels in First Row Option

4.Click on Summary Statistics

5.Click OK

Pie Chart

Use If or Countif function to convert labels to numeric value before you can plot pie chart.

Histogram

1.Cut Heading Days.Shelter from Column X and Paste in Column Y

2.Enter bin values in Column Y starting from row 2.  It will be 4 to 36 increment of 4 (i.e., 4, 8, 12…..36)

3.Click Tools, Data Analysis…, and Histogram

4.Enter cell addresses of data (or highlight your data) in Input Range Box (for example: \$X\$2:\$X\$245)

5.Enter cell addresses of bin values (or highlight your values from column B) in Bin Range Box (for example: \$Y\$1:\$Y\$9)

6.Click on Labels Option

7.Click on Chart Output Option

8.Click OK

9.To remove the gaps, place the cursor over one of the rectangles and click the right button of the mouse.

10.Click (with the left button) Format Data Series…

11.Click Options, move the pointer to Gap Width; and change the number from 150 to 0.  Click OK.

12.Click on a graph and make it bigger

If Data Analysis does not show up in Tools menu follow following steps:

3.Check mark first two boxes

4.Click OK

Now Data Analysis will show up in Tools menu.

Write Up

1.Describe data.  How many animals are there; how many dogs or cats? Percentage?

2.Describe pie & bar chart.  What condition animal had when they came to shelter?  Were they neutered or not? how many male & female? what percentage of dogs were aggressive?

3.Describe descriptive statistics.  On average how long dogs and cats stayed in the shelter?  Minimum? Maximum?  Which animal?  Or what was the average age of the animal when it came to shelter?

4.Describe histogram on adopted animal.  How long animal stayed in shelter before got adopted?  What number of animal were adopted before 10 days in shelter?