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...

An astronaut must journey to a distant planet, which is 200 light-years from Earth. What speed will be necessary if the astronaut wishes to age only 10 years during the round trip?

During December, Western Solvent completed 40,000 units. At the end of December, there were 10,000 units in ending Work in Process that were 30 percent complete with respect to labor and overhead and...

4. Explain the general purpose of control and the levels of control in international business.

How can the normality assumption be checked after fitting a multiple regression model?

Michael, a minor, operates a one-man automobile repair shop. Anderson, having heard of Michaels good work on other cars, takes her car to Michaels shop for a thorough engine overhaul. Michael, while...

Coachlight Inc. has a periodic inventory system. The company purchased 245 units of inventory at $13.50 per unit and 390 units at $14.50 per unit. What is the weighted average unit cost for these...

Based on an evaluation of current conditions and future expectations, Beach Co. determined that the decline in the fair value (FV) of a debt investment was below the amortized cost but above the...

When sequential long-term financing is involved, the choice of debt or equity influences the future financial A timing B flexibility C stability D liquidity of the firm.

C owns all of the stock of Z Corporation, which is worth $1 million. Z wants to acquire land worth $75,000 from D. C proposes to transfer $1.00 of cash to Z at the same time D transfers the land to...

Overview You are an accountant for the Crestview Financial Services firm. You have been examining financial statements for a client called LMS Manufacturing Corporation. You recently discovered key...

Figuring out how to frame things comes from asking yourself the question, firm grasp of the obvious is something that great negotiators are able to do. O "What is really going on here?" O "Has your...

Which one of the following depends on the risk control function to provide a clear profile of the applicant's loss exposures and related hazards? Available answer options Select only one option A...

Combat Fire, Inc. manufactures steel cylinders and nozzles for two models of fire extinguishers: (1) a home fire extinguisher and (2) a commercial fire extinguisher. The home model is a high-volume...

Using (1) or (2), find L(f) if f(t) if equals: t cos 4t

4.53 The authors of the paper Delayed Time to Defibrillation after In-Hospital Cardiac Arrest (New England Journal of Medicine [2008]: 916) described a study of how survival is related to the length...

4.43 A student took two national aptitude tests. The national average and standard deviation were 475 and 100, respectively, for the rst test and 30 and 8, respectively, for the second test. The...

4.45 The report Who Borrows Most? Bachelors Degree Recipients with High Levels of Student Debt (www .collgeboard.com/trends) reported the following percentiles for amount of student debt for those...