You are working on a research team studying body size ofErissinettes, a newly discovered alien race on the exoplanet Eris.The weirdly adorable Erissinettes have antennae that help theorganisms interact with their environment and agile tails used totrap unsuspecting humans for drippy cuddles. Due to their noveltyand pleasing resemblance to earth canines, interest in Erissinettebiology is high and research dollars are flowing. Your job is tocatalog the complex traits of antennae length and tail length andsee if there is a correlation. The hope is to selectively breedsmaller Erissinettes for transport and sale on Earth. This planignores the research suggesting Erissinette brain biology is muchmore similar to Earth felines; making them extremely intelligentorganisms with egomania and manipulative tendencies.
| Alien ID | Alien antennae length (cm) | Alien tail length (cm) |
| A1 | 30 | 55 |
| A2 | 23 | 45 |
| A3 | 32 | 30 |
| A4 | 13 | 33 |
| A5 | 26 | 45 |
| A6 | 36 | 57 |
| A7 | 46 | 62 |
| A8 | 42 | 44 |
| A9 | 36 | 32 |
| A10 | 53 | 49 |
| A11 | 75 | 62 |
| A12 | 16 | 29 |
| A13 | 60 | 43 |
| A14 | 22 | 45 |
| A15 | 41 | 53 |
| A16 | 15 | 37 |
| A17 | 25 | 44 |
| A18 | 26 | 31 |
| A19 | 7 | 6 |
| A20 | 5 | 23 |
What are the average, median, mode, variance, and standarddeviation of antennae length and tail length? Graph antennae lengthby tail length in a scatterplot. Does there appear to be acorrelation between the two traits? Is the correlation positive ornegative? Can you quantify the correlation?
Figure how to visually represent the mathematical value of thecorrelation on your chart. (See lung function example in lecturefor an idea of what you could produce). Write step-by-stepdirections on how to do this in excel. There may be more than onemethod and type of correlation that would be an acceptable answerto this question. Fully explain the mathematical basis of what youdid and how you did it.
