Ask Question
Computers & TechnologyComputers & Technology
4 December, 05:58

If I have a list of peoples hair colour and grades, can I check for the correlation with excel? How?

+1
Answers (1)
  1. 4 December, 06:53
    0
    You can check for correlation using

    a. the Analysis Toolpak add-in in Excel to quickly generate correlation coefficients between hair colors and grade; using the following steps.

    1. On the Data tab, in the Analysis group, click Data Analysis.

    Click Data Analysis

    2. Select Correlation and click OK.

    Select Correlation

    3. select the range of cells that occupies the hair color and grade as the Input Range.

    Select the Input Range

    4. Check Labels in first row.

    5. Select cell A8 as the Output Range.

    6. Click OK.

    Input and Output Options

    Result.

    Correlation Coefficients
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “If I have a list of peoples hair colour and grades, can I check for the correlation with excel? How? ...” in 📙 Computers & Technology if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers
You Might be Interested in
A group of PHP statements that performs a specific task. Select one: a. Predefined Functions b. Functions c. Undefined Functions d. User Defined Functions
Answers (1)
Which of these is another word for prototype? Behavior Information Model Simulation
Answers (1)
What is RAD? List an advantage and a disadvantage of using RAD.
Answers (1)
What is a specific set of instructions or steps used to solve a particular problem
Answers (1)
Mikayla works in the planning department of a restaurant chain. The company wants to expand into two more countries in the state where its headquarters is located. Mikayla needs to find out which countries have the highest average income.
Answers (2)
New Questions in Computers & Technology
Two blue armies are each poised on opposite hills preparing to attack a single red army in the valley. The red army can defeat either of the blue armies separately but will fail to defeat both blue armies if they attack simultaneously.
Answers (1)
Suppose we replace the wait () and signal () operations of monitors with a single construct await (B), where B is a general Boolean expression that causes the process executing it to wait until B become true.
Answers (1)
Write a method drivingCost () with input parameters drivenMiles, milesPerGallon, and dollarsPerGallon, that returns the dollar cost to drive those miles. All items are of type double. If the method is called with 50 20.0 3.1599, the method returns 7.
Answers (1)
What are the 6 external parts of a computer
Answers (1)
What type of hard drive is in original xbox?
Answers (1)
Home » Computers & Technology » If I have a list of peoples hair colour and grades, can I check for the correlation with excel? How?
Sign Up Forgot Password?