You are working on a research team studying body size of Erissinettes, a newly discovered alien...

You are working on a research team studying body size of Erissinettes, a newly discovered alien race on the exoplanet Eris. The weirdly adorable Erissinettes have antennae that help the organisms interact with their environment and agile tails used to trap unsuspecting humans for drippy cuddles. Due to their novelty and pleasing resemblance to earth canines, interest in Erissinette biology is high and research dollars are flowing. Your job is to catalog the complex traits of antennae length and tail length and see if there is a correlation. The hope is to selectively breed smaller Erissinettes for transport and sale on Earth. This plan ignores the research suggesting Erissinette brain biology is much more similar to Earth felines; making them extremely intelligent organisms 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 standard deviation of antennae length and tail length? Graph antennae length by tail length in a scatterplot. Does there appear to be a correlation between the two traits? Is the correlation positive or negative? Can you quantify the correlation?

Figure how to visually represent the mathematical value of the correlation on your chart. (See lung function example in lecture for an idea of what you could produce). Write step-by-step directions on how to do this in excel. There may be more than one method and type of correlation that would be an acceptable answer to this question. Fully explain the mathematical basis of what you did and how you did it.

Expert Solution

Descriptive statistics

In Excel we put the data first in two columns and then using different formula we get the required measures.

We use AVERAGE, MEDIAN, MODE, VAR, STDEV functions respectively to get the following output:

Next we go to Insert option and select the Scatter plot option to get the following output:

From the plot we can see that with increase in antennae length, there is increase in tail length too. So there exists a positive correlation.

To quantify it we use CORREL function in Excel.

We get the Correlation coefficient as 0.694.

Including a trend line in the plot we can visualise the correlation.

Clearly the slope of the trend line indicates that there is a positive correlation between the two variables.

orchestra answered 1 year ago

Suppose you meet an extraterrestrial alien. The alien is doing a research project on the health...

Suppose you meet an extraterrestrial alien. The alien is doing a research project on the health care system in the United States since the 1960’s. The alien understands that disease exists and that resources are scarce. Explain to the alien the foundational parts of our health care system AND how our health care system has evolved since the 1960’s and why.

You’re working on a newly discovered gene and are tasked to quantitatively quantify the precise transcript...

You’re working on a newly discovered gene and are tasked to quantitatively quantify the precise transcript levels of this gene being expressed in a culture of cells. Explain the method you will use and details of how you will perform this.

A university research team was studying the relationship between idea generation by groups with and without...

A university research team was studying the relationship between idea generation by groups with and without a moderator. For a random sample of 4 groups with a moderator, the mean number of ideas generated per group was 78, and the standard deviation was 24.4. For a random sample of 4 groups without a moderator, the mean number of ideas generated was 63.5, and the standard deviation was 22. Test the assumption that the 2 population variances were equal against the...

Suppose a planet was discovered with life and you were a member of a team of...

Suppose a planet was discovered with life and you were a member of a team of scientists who were selected to study these new life forms. During your analyses of fossils from this new planet you discovered that speciation rates appear to be 10 times faster than on Earth. Formulate a series of hypotheses (at least 5) for why speciation might be faster on the newly discovered planet. Each hypothesis should include an explanation of how the mechanism would foster...

As a newly appointed C.F.O of a company, you have discovered that your company is facing...

As a newly appointed C.F.O of a company, you have discovered that your company is facing a poor cash flow position, what measures would you implement in order to establish a strong cash flow position. Recommend with the view of a financial institution.

Imagine you are working on a team and one of your team members is writing a...

Imagine you are working on a team and one of your team members is writing a library of C functions to work with strings. They decide to name their library mystringfunctions, and have two files: a source file mystringfunctions.c and a header file mystringfunctions.h. In this problem, you will write automated tests known as unit tests. This program has been partially written for you in testmystringfunctions.c. Write the body of functions that are marked with a comment that begins with...

biology (5) Your research team has discovered that plants seem to grow hardier when exposed to...

biology (5) Your research team has discovered that plants seem to grow hardier when exposed to white light (full spectrum) but fail to grow under green light. Design a complete experimental set-up (see Criteria section above) that would support this premise. .. what would the hypothesis and the independent variable/dependent variable and control variable will be? ..

how could you utilize a reporter gene to determine if a newly discovered regulatory gene is...

how could you utilize a reporter gene to determine if a newly discovered regulatory gene is transcribed in the presence of tictactodose?

You were given the assignment to classify a newly discovered plan using systematics how would you...

You were given the assignment to classify a newly discovered plan using systematics how would you use character states such as synapomorphies, apomorphies to compare the new plant previously described plants

1. You are the head of a research team, and you are training your team members...

1. You are the head of a research team, and you are training your team members on the index number technique. Your task is to explain to your team members that when measuring an overall price increase (e.g., inflation), the Laspeyres index likely overestimates while the Paasche index likely underestimates it.

Question