Ask Question
Computers and TechnologyComputers and Technology
25 April, 00:34

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

+2
Answers (1)
  1. 25 April, 02:55
    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?
Find 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 and Technology if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers
You Might be Interested in
Fair Use means a teacher can take the contents of a web activity page and repost it in your school's web site because it is for a school. True or False. Support the answer.
Answers (1)
11. If the following pseudocode were an actual program, what would it display: Declare Integer a = 5 Declare Integer b = 2 Declare Integer c = 3 Declare Integer result Set result = a + b + c Display result
Answers (2)
What system is used in computer appliances and special-purpose applications, such as an automobile, ATM, or media player and are used for a single purpose?
Answers (1)
List and describe the four basic components of a computer system
Answers (1)
Financial institutions are monitored through which of the following? A. Federal Reserve System B. National Banking Union Administration C. Federal Deposit Insurance Corporation D National Financial Institution Agency
Answers (1)
New Questions in Computers and Technology
What is it called when you give credit in your writing to someone else's quote?
Answers (1)
In the CRC checker at the receiver, the remainder that indicates error in the received data is: a. a string of binary zeros b. a string of binary ones c. a string of alternating binary ones and zeros d. not a string of binary zeros
Answers (2)
What is the output of this program? class output { public static void main (String args[]) { String a = "hello i love java"; System. out. println (a. indexOf ('i') + " "+a. indexOf ('o') + " "+a. lastIndexOf ('i') + " "+a. lastIndexOf ('o')); }
Answers (1)
Which utility would you use to test communication on your own computer using your ip address as a parameter?
Answers (1)
Define a Python function named sortIt with 1 parameter. This parameter will be a list. Your function should use list's built-in function to organize its entries from smallest to largest.
Answers (1)
Home » Computers and 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?