Question

In: Statistics and Probability

A sociologist was hired by a large city hospital to investigate the relationship between the number...

A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected.

Distance to Work

Days Absent

1

8

3

5

4

8

6

7

8

6

10

3

24

5

14

2

14

4

18

2

a. Which is the independent/explanatory variable?

b. Which is the dependent/response variable?

Enter the data into an Excel spreadsheet.

c. Create a scatterplot for these data. How would you interpret the scatterplot?

Run a regression analysis using Data Analysis/Regression Tool and use the output to answer the following questions:

d. What is the correlation between distance to work and days absent? What does it say about the strength of the relationship?

e. What is the coefficient of determination? How would you interpret it?

f. Write the hypotheses for the test of the slope.

g. What is the p-value for the test of the slope? How would you interpret the p-value?

h. What is the regression formula resulting from this analysis between Distance to Work and Days Absent?

i. Use your formula to predict the number of days absent for an employee who lives 9 miles from work.

j. Use your formula to predict the number of days absent for an employee who lives 17 miles from work.

Solutions

Expert Solution


Related Solutions

A sociologist was hired by a large city hospital to investigate the relationship between the number...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected. Distance to Work Number of Days Absent 2 9 4 6 4 9 7 8 9 7 11 4 13 7 15 3 15 6 19 3 Which of the following...
A sociologist was hired by a large city hospital to investigate the relationship between the number...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected. (a) Develop a scatterplot with Distance to Work (miles) as the independent variable. Format the scatterplot to your preferences with the proper labels on the axes. In a textbox describe the...
A sociologist was hired by a large city hospital to investigate the relationship between the number...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected. Distance to Work (miles) Number of Days Absent 1 8 3 5 4 8 6 7 8 6 10 3 12 5 14 2 14 4 18 2 Using Excel Data...
A sociologist was hired by a large city hospital to investigate the relationship between the number...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 6 employees was chosen, and the following data were collected. Distance to work (miles) 1 3 4 6 8 10 Number of days absent 8 5 8 7 6 3 e. Compute the correlation coefficient. f. Conduct a t-test at a...
A sociologist was hired by a large city hospital to investigate the relationship between the number...
A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected.  Use the estimated regression equation developed in part (c) to develop a 95% confidence interval for the expected number of days absent for employees living 5 miles from the company (to 1...
1. A sociologist was hired by a large city hospital to investigate the relationship between the...
1. A sociologist was hired by a large city hospital to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was chosen, and the following data were collected. Distance to Work Days Absent 1 8 3 5 4 8 6 7 8 6 10 3 24 5 14 2 14 4 18 2 a. Which variable is the...
A large city hospital conducted a study to investigate the relationship between the number of unauthorized...
A large city hospital conducted a study to investigate the relationship between the number of unauthorized days that employees are absent per year and the distance (miles) between home and work for the employees. A sample of 10 employees was selected and the following data were collected. Distance to Work (miles) Number of Days Absent 1 8 3 5 4 8 6 7 8 6 10 3 12 5 14 2 14 4 18 2 Use Excel - no hand...
A sociologist believes that there is a relationship between number of friends an elderly person has...
A sociologist believes that there is a relationship between number of friends an elderly person has and their perceived level of stress. Participant # of Friends (Y) Stress Level (X) A 10 1 B 3 7 C 12 2 D 11 3 E 6 5 F 8 4 G 14 1 H 9 2 I 10 3 J 2 10 *higher scores of the measure of stress (from 1 to 10) indicate more stress. Use this information to answer questions...
A sociologist believes that there is a relationship between number of friends an elderly person has...
A sociologist believes that there is a relationship between number of friends an elderly person has and their perceived level of stress. Participant # of Friends (Y) Stress Level (X) A 10 1 B 3 7 C 12 2 D 11 3 E 6 5 F 8 4 G 14 1 H 9 2 I 10 3 J 2 10 *higher scores of the measure of stress (from 1 to 10) indicate more stress. Use this information to answer questions...
CAN YOU PLEASE SOLVE THESE IN EXCEL. a large city hospital conducted a study to investigate...
CAN YOU PLEASE SOLVE THESE IN EXCEL. a large city hospital conducted a study to investigate the relationship between the number of authorized days that employees are absent per year and the distance between home and work for the employees. A sample of 10 employees was selected and the following data were collected Distance to work: Number of days absent: 1 8 3 5 4 8 6 7 8 6 10 3 12 5 14 2 14 4 18 2...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT