Question

In: Statistics and Probability

I am currently doing research and I need to find the correlation between "HOURS OF SLEEP"...

I am currently doing research and I need to find the correlation between "HOURS OF SLEEP" and "LPI SCORES" I want a table to look as below how would I achieve this on Excel.

In short I want to find out what the average score someone gets when they get a certain amount of sleep.

I have all the data in a spreadsheet but cannot get the table right.

SLEEP HOURS                               LPI SCORES

4                                                      ??

5

6

7

8

9

10

11

12

Solutions

Expert Solution

>> In order to find a correlation between two or more columns in excel follow this step

>> Go to Data tab>>Analysis section click on Data analysis>>select correlation>> select your data>> tick on label if your selected data contain the first row as label>> select the output range where you want to get output>> you will see a correlation table where you wanted the output

>> For the 2nd part of your question, you need to perform a regression analysis in order to find the average LPI score based on number of sleep hours

>> Go the same data analysis section>> select LPI score as y range>> select Sleep hours column as x level>> tick appropriate section what you wanted>> click ok>> you will get a table and plenty of graph>> your intercept and coefficient of the regression equation is in the table itself

>> suppose you get like this

>> score = intercept + SleepsCoefficnt x Hours of sleep

just put hourse of sleep to get average score


Related Solutions

I am doing a research paper about ''Lack of affordable mental health services'' and I need...
I am doing a research paper about ''Lack of affordable mental health services'' and I need help getting my brainstorming done. Here are the following question I need to answer: 1. What is your topic? Why did you chose that topic? 2. Who will be the intended audience for your essay? What are some of the special considerations you need to keep in mind about this audience? 3. What tone will you use for this essay? Why this approach? 4....
I just need 3 and 5. I am not sure what I am doing wrong. I...
I just need 3 and 5. I am not sure what I am doing wrong. I get different numbers every time. Superior Markets, Inc., operates three stores in a large metropolitan area. A segmented absorption costing income statement for the company for the last quarter is given below: Superior Markets, Inc. Income Statement For the Quarter Ended September 30 Total North Store South Store East Store Sales $ 4,800,000 $ 960,000 $ 1,920,000 $ 1,920,000 Cost of goods sold 2,640,000...
I'm doing a stats project on the correlation between the amount of hours a person sleeps...
I'm doing a stats project on the correlation between the amount of hours a person sleeps and their weight; proving there is no correlation between sleep and weight gain. I have voluntary samples of people's weight and the hours they slept, and I need to list if the level of measurement is nominal or ordinal, confidence interval, and linear correlation test. how do I do this?
I am currently doing an unknown salts project where I am given 2 vials. Vial A...
I am currently doing an unknown salts project where I am given 2 vials. Vial A contains 2 salts, and vial B contains the two salts found + another salt. Here are all the possible salts that can be mine: NaI MgCl2 K2SO4 NaCl KI Na2SO4 CaCO3 Al2(SO4)3 CaCl2 KCl Na2CO3 MgSO4 Al2O3 MgCO3 CaSO4 K2CO3 All Equipment that was provided are: • Each student will be provided with two small numbered vials, one containing powder sample (A) and the...
what type of research thesis in business? I am doing thesis research of feasibility framework for...
what type of research thesis in business? I am doing thesis research of feasibility framework for parent finance company, what must I do in my research?
I am doing a project on the Glycolytic pathway btw Humans & E.coli? I am stuck on my research to find what all enzymes are involved in the glycolysis of E.coli?
I am doing a project on the Glycolytic pathway btw Humans & E.coli? I am stuck on my research to find what all enzymes are involved in the glycolysis of E.coli? For eg humans have these; Hexokinase Glucose-6-Phosphate Isomerase 6-Phosphofructokinase Fructose-bisphosphate aldolase Triose-Phosphate isomerase Glyceraldehyde-3-phosphate dehydrogenase Phosphoglycerate kinase Bisphosphoglycerate mutase Enolase Pyruvate kinase . So in the same way what does E.coli have?
I am doing a kids fishing game. right now I am doing it with 15 fish...
I am doing a kids fishing game. right now I am doing it with 15 fish and number them 1-5. prize one the lowest value and prize 5 the highest value. What do I need to do for this? You can work with a partner or by yourself. I want you to invent a game with at least 12 different possible monetary outcomes. These outcomes need to include prizes other than money. You are going to charge people money (you...
I am currently doing an experiment on continous wave NMR and was wondering if someon could...
I am currently doing an experiment on continous wave NMR and was wondering if someon could explain the theroy behind how resonace is created in a sample, for example hydrogen 1. If possible type would be best as I have trouble reading, on my laptop the hand written answers somtimes.
Hi, I am doing a preminary analytical procedures for Apollo Shoes. I have to find a...
Hi, I am doing a preminary analytical procedures for Apollo Shoes. I have to find a unusual percentage and explain two possible hypotheses for why the change occurred. I found one that increased prepaid insurace( 361%) ID:14100, but decreased in insurance expense(-96%)ID:68000. I know this is strange because when prepaid insurance goes up, insurance expense should go up, but I dont' know how to explain. Would you please help me? Thank you. Prepared by Apollo Shoes, Inc Reviewed by Trial...
I need to send my students I am doing distant classes a test How do I...
I need to send my students I am doing distant classes a test How do I do this and have them answer it without the ability for the to keep it or print it out
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT