I need to run a linear regression in excel. what should be my input for Y range,

Question

I need to run a linear regression in excel. what should be my input for Y range, and why?

Facebook Survey Find if there is a linear relationship between variables! Student Gender Hours online/week Friends Female = 0 1 0 4 150 Male = 1 2 0 10 400 3 1 7 120 4 1 15 500 5 0 9 260 6 0 5 70 7 0 7 90 8 1 5 250 9 0 12 110 10 0 2 30 11 0 6 80 12 0 2 30 13 1 3 200 14 0 6 240 15 1 6 150 16 1 4 90 17 0 8 340 18 1 10 450 19 0 4 50 20 1 4 120 21 1 6 180 22 0 4 280 23 0 5 60 24 0 9 100 25 0 12 380 26 1 8 430 27 0 2 80 28 0 7 170 29 1 6 90 30 1 4 50 31 0 2 50 32 1 5 70 33 0 7 170

Explanation / Answer

In the Y range, the dependent variable is entered and x range should be the independent variables. Based on the data provided, it seems that we are trying to measure the number of facebook friends based on the gender and also the Hours online/week. Hence, Y should be Friends column and X should be Hours online/week and Gender. The output would look like below: -

SUMMARY OUTPUT Regression Statistics Multiple R 0.710525571 R Square 0.504846587 Adjusted R Square 0.471836359 Standard Error 97.49484604 Observations 33 ANOVA df SS MS F Significance F Regression 2 290739.6196 145369.8098 15.29364154 2.63692E-05 Residual 30 285157.3501 9505.245004 Total 32 575896.9697 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept -23.61208197 40.26868897 -0.586363315 0.562017811 -105.8517163 58.62755236 Gender 43.80216573 34.75777898 1.260211872 0.21730772 -27.18268893 114.7870204 Hours online/week 29.36781821 5.505223932 5.334536537 9.0569E-06 18.124651 40.61098541

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---