Question

In: Statistics and Probability

Calculate the Coefficient of Correlation and the Least Squares Equation for the following data, hours of...

Calculate the Coefficient of Correlation and the Least Squares Equation for the following data, hours of study (x) and hours of sleep(y). Using your equation, if the hours of study is 5, what is the expected hours of sleep? For any credit, make sure you show your work and submit a PDF or picture of it via the test assignment in Week 5. Hours of Study Hours of Sleep 2 10 6 6 6 5 3 9 2 12

Solutions

Expert Solution

Hours of Study Hours of Sleep X * Y X2 Y2
X Y
2 10 20 (2*10) 4 100
6 6 36 (6*6) 36 36
6 5 30 (6*5) 36 25
3 9 27 (3*9) 9 81
2 12 24 (2*12) 4 144
Total 19 42 137 89 386
Average 3.8 8.4

Least Square equation is as follows

Y = mX + b

Where, X represents hours of study

Y represents hours of sleep

Where, m is slope of the line

b is Y intercept

To calculate m

m =

m =  

m = - 1.345

To calculate b

b =

b =

b = 13.512

Putting this values in the equation

Y = mX + b

Y = -1.345 X + 13.512

If the hours of study is 5, what is the expected hours of sleep?

We have, hours of study X = 5, find Y

Y = -1.345 X + 13.512

Y = -1.345 *5 + 13.512

Y = 6.786 7

if the hours of study is 5, will require 7 hours of sleep.

Coefficient of Correlation

Hours of Study Hours of Sleep
X Y
2 10 -1.8 1.6 -2.88 3.24 2.56
6 6 2.2 -2.4 -5.28 4.84 5.76
6 5 2.2 -3.4 -7.48 4.84 11.56
3 9 -0.8 0.6 -0.48 0.64 0.36
2 12 -1.8 3.6 -6.48 3.24 12.96
19 42 0 0 -22.6 16.8 33.2
3.8 8.4


r = - 0.957


Related Solutions

Find the equation of the least-squares regression line ŷ and the linear correlation coefficient r for...
Find the equation of the least-squares regression line ŷ and the linear correlation coefficient r for the given data. Round the constants, a, b, and r, to the nearest hundredth. {(0, 10.8), (3, 11.3), (5, 11.2), (−4, 10.7), (1, 9.3)}
Whywould researchers believe that an ordinary least squares regression is superior to a partial correlation coefficient?
Whywould researchers believe that an ordinary least squares regression is superior to a partial correlation coefficient?
SPSS: Correlation Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data...
SPSS: Correlation Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data for “Hours of Exercise” and “Life Satisfaction.” (0 = Not at all satisfied). Provide an APA-style results section write – up. (b) Graph the relationship. HINT: Below you will find instructions for the APA-style write-up. Complete the write-up on a word document and upload the file for submission. Hours of Exercise.    2 0 5 6 1 2 4 4 3 4 life satisfaction...
Find an equation for the least-squares regression line for the following data. Round answers to 3...
Find an equation for the least-squares regression line for the following data. Round answers to 3 decimal places (i.e. y = 1.234x -0.123) Advertising Expenses in 1000's of $ (x): 2.4, 1.6, 2, 2.6, 1.4, 1.6, 2, 2.2 Company Sales in 1000's of $ (y ):225, 184, 220, 240, 180, 184, 186, 215 y=    ?   x+   ? What would the company sales be if $2500 is spent on advertising?
Use the following data to calculate and record the correlation coefficient, r. Height (in.) Foot Length...
Use the following data to calculate and record the correlation coefficient, r. Height (in.) Foot Length (in.) 63 10 66 12 62.5 9.4 74 10.5 70 11.3 72 11.3 71 12.5 64 9.1 72 10.9 71 10 74 12.1 67 10 69 11.1 65 9.6 62.8 9 72 11.3 68.8 10.5 69 10 65.3 9 53 7 71 10.3 74 11.7 70 10 72 10.6 72.5 12.8 67 9.5 69 10.9 74 11.6 68 9 70.1 10.1 62 8 77...
2. Given the following data determine a. the correlation coefficient b. The straight-line equation using the...
2. Given the following data determine a. the correlation coefficient b. The straight-line equation using the least square method c. Find the standard error. X= 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Y=2.5, 4.8, 6.5, 7.9, 9.7, 11.1, 12.7, 14.7, 16, 17.4.
For the following data, calculate the correlation coefficient. (Show the code) Y X 72 45 73...
For the following data, calculate the correlation coefficient. (Show the code) Y X 72 45 73 38 75 41 76 35 77 31 B.Plot the scatterplot of the data above AND add the scatterplot here. (Show code) What type of relationship do you see? Using the information from problem 1 calculate the intercept and   coefficient. Then write the regression equation to explain the relationship. (Show the code) Interpret the R-squared.
An investigator estimates the following equation using Ordinary Least Squares from time series data: Y1 =...
An investigator estimates the following equation using Ordinary Least Squares from time series data: Y1 = a0 + a1X1t + a2X2t + Ut The following scenarios represent violations of the CLRM assumptions. For each scenario, state the underlying assumption being referred to and state the null hypothesis of that assumption. i- There is another important variable, which has been omitted. ii- X1 and X2 are correlated iii- Ui is correlated with its own past values. iv- The mean value of...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear equation and any other non- linear equation. Provide R-squared for both cases. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Year Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50 2008 $869.75...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear...
Considering the following time series data: (Tableau) Determine the least squares trend equation. Use a linear equation and any other non- linear equation. Provide R-squared for both cases. Estimate the price of gold (ounce) for 2020. Does this seem like a reasonable estimate based on historical data? What is the quality of the forecast? Also, Provide Mean Absolute Error (MAE), and the Mean Absolute Percentage Error (MAPE). Year Price of Gold (ounce) 2005 $513.00 2006 $635.70 2007 $836.50 2008 $869.75...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT