Question: We would like learn about the correlation coefficient using Excel. Lets look at the following question. To find out how genetically related the cholesterol level

We would like learn about the correlation coefficient using Excel. Lets look at the following question. To find out how genetically related the cholesterol level is, they measured the cholesterol level of eight mothers and their daughters. They obtained the following data. Mother Her daughter 157 154 189 150 201 184 174 170 159 158 213 192 149 143 143 132 Evaluate the correlation coefficient and describe the correlation. We will now learn how to use Excel to quickly check our answers. Open Excel In cell A1 type Mother In cell B1 type Her daughter Below Mother type the data from the exam one by one with pressing Enter in between: 157,189,201,174,159,213,149,143 Below Her Daughter type the data from the exam one by one with pressing Enter in between: 154,150,184,170,158,192,143,132 In cell A11 type Correlation coefficient In cell A13 begin typing =Cor for correlation coefficient After you typed =Cor you will only be offered one choice =CORREL, double click on it. Then highligh all data under Mother type , Then highligh all data under Her daughter Press Enter. you should obtain the correlation coefficient. To

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

We would like learn about the correlation coefficient using Excel. Lets look at the following question. To find out how genetically related the cholesterol level is, they measured the cholesterol...

What type of business is S. G. Cowen? How is this firm different from the other financial firms? How systems and operations of financial firms are different from other types of businesses - say...

Question: What as the average weekly safety inventory level of refined sugar from the beginning January 2022 to the end of July 2022? A. 512,465.9691 metric tons per week B. 316,002.1474 metric tons...

Do you have convincing evidence of sufficient computer skills to engage in online discussion forums, access online library resources, engage in online videoconferencing, and utilize word processing,...

The following information is available for Young Company for the month of August: 1. The unadjusted balance per the bank statement on August 31 was $35,200. 2. Deposits in transit on August 31 were...

9. Perception is an important aspect of buyer behavior and must be considered in marketing strategy. Perception affects what people see, understand, and retain.

3. Move close to a student who must be disciplined and speak so that only the student can hear.

An aqueous slum? at 30?C containing 20.0 wt% solids is fed to an evaporator in which enough water is vaporized at 1 atm to produce a product slurry containing 35.0 wt% solids. Heat is supplied to the...

3 . Which of these four most common types of logical dependencies would be represented by the situation the carton must be sealed and labeled before the package can be shipped? a . Start - to - start...

import math def B(q): if q == 0 or q return 0 return q* math.log2 (q) (1-q) math.log2 (1-q) == 1: Write a short program that calls this function in order to print a out table of the values of B(g)...

Gary is awarding a gift card randomly to a list of names on a spreadsheet. To keep it fair he wants to draw a number and then award it to the person located at that number on the list. What function...

According to the ISA 300 'Planning and Audit of Financial Statement'. Outline the overall content of this audit strategy and the audit plan.

John is an elderly Italian man who lost his wife, Debra, to cancer 4 months ago. Since her death, John has become very isolated and is having regular thoughts of suicide. John's neighbour rings the...

Suppose that the integral I = (a) Determine b. f(x) da can be represented by the following Riemann sum using right endpoints and ni subintervals: 49 (A) 2 2 2 7 7 7n 7 49 + 49 n n n n n n (b)...

Derive the differential equations describing the electrical and mechanical dynamics of a shunt- connected DC motor, shown in Figure P14.36; and draw a simulation block diagram of the system. The...

You are offered a job. The company promises an initial salary of $100,000 per year and 2 options for increasing it: 1. Your salary is increased by $15,000 once a year. 2. Or by $5,000 every 6 months....

r = 0.18 Find the coefficients of determination and non-determination and explain the meaning of each.

Reflecting on recent scandals in industry, how have employees of these organizations responded to the scandal?

Suppose you are Tina, having just read this chapter. Write an e-mail (or e-mails) to Lisa, Jan, and Claire that attempt to correct some of the ethical and communication problems that are emerging.

Cheney (1983b) identified three ways that organizations attempt to foster identification. Think about an organization of which you are a part and the communication within that organization. What...