Question: How can I solve this in excel? Using the Facebook Survey data complete this problem. Please answer the following tasks on the worksheet labeled Problem

How can I solve this in excel?

How can I solve this in excel? Using the FacebookHow can I solve this in excel? Using the Facebook

Using the Facebook Survey data complete this problem. Please answer the following tasks on the worksheet labeled Problem 4 Questions that is located directly after the worksheet labeled Problem 4. a. Please re-write (i.e., re-type) the table so that the variables of Gender, Hours online/week, and Friends can be used in a regression analysis. You do not need to perform the regression on the Facebook Survey data. Please place your re-written data to the right of the original data the Problem 4 worksheet starting in column F. Please answer the following questions. b. Would you include Student in your regression model? Why or why not? c. What would be the dependent variable? CUM 1000 OCUS 4 5 Student Gender Hours online/week 6 1 female 4 7 2 female 10 8 3 male 7 9 4 male 15 5 female 9 6 female 5 7 female 7 3 8 male 5 9 female 12 10 female 2 11 female 6 7 12 female 13 male 3 14 female 6 20 15 male 6 21 16 male 4 22 female 8 23 male 10 24 19 female 4 25 male 4 26 male 6 27 22 female 4 28 23 female 5 29 24 female 9 30 25 female 12 31 26 male 8 32 27 female 2 33 28 female 7 34 29 male 6 35 30 male 4 86 female 37 32 male 5 8 33 female 7 Friends 150 400 120 500 260 70 90 250 110 30 80 30 200 240 150 90 340 450 50 120 180 280 60 100 380 430 80 170 90 50 50 70 170 ON ON 000 40 89 90 Student Gender Hours online/week 1 4 2 10 3 7 4 15 5 9 6 5 7 7 8 5 9 12 10 2 11 6 12 2 13 3 14 6 15 6 16 4 17 8 18 10 19 4 20 4 21 6 22 4 23 5 24 9 12 26 8 27 2 28 7 29 6 30 31 32 33 7 Friends 150 400 120 500 260 70 90 250 110 30 80 30 200 240 150 90 340 450 50 120 180 280 60 100 380 430 80 170 90 50 50 70 170 17 25 lelse 31

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!