TASK ONE LINEAR Passed

pdf

School

Howard Community College *

*We aren’t endorsed by this school

Course

C207

Subject

Statistics

Date

Apr 3, 2024

Type

pdf

Pages

6

Uploaded by Himpaul619

Report
Task 1 linear - Passed Data-Driven Decision Making (Western Governors University) Scan to open on Studocu Studocu is not sponsored or endorsed by any college or university Task 1 linear - Passed Data-Driven Decision Making (Western Governors University) Scan to open on Studocu Studocu is not sponsored or endorsed by any college or university Downloaded by Ta keys (tokegb1@wgu.edu) lOMoARcPSD|38117795
TASK ONE LINEAR REGRESSION LeeAnn Woodmancy Western Governors University Downloaded by Ta keys (tokegb1@wgu.edu) lOMoARcPSD|38117795
Task 1: Linear Regression Analysis Scenario Nurses and hospital staff are known for working numerous hours with little rest. Most shifts are twelve hours long caring for patients will all different ailments. A major hospital has decided to deal with these issues and tackle the attrition level of nursing staff at their hospital. In order to determine if they want to invest in these programs the hospital has compiled data over the last 36 months. The data that we are presented with is the attrition rate vs. program participation rate. We will analyze the data and determine if the programs are working or if the data shows that there is no relationship between the two elements. A business question that could be answered by applying linear regression analysis would be, by providing an employee well-being program, will the turnover rate be reduced? There are many things we can look at when we analyze the data regarding turnover rates among nurses at a major hospital. The independent variable in the scenario would be the program participation rate. The reason that it is independent is that it can stand on its own and does not require another variable to make it work. The dependent variable would be the Nurse attrition rate. This is dependent as it requires other factors to determine this rate. The type of data is ratio/ordinal data. Percentages are ratio data as they are in a set order, or scale. The quantity of data is quantitive. It Quantifies the problem using numbers. Quantitive also deals with measurements and analytics. The data that was collected was for a total of 36 months. This data includes the number of nurses that attended the programs and the attrition for each month. 1 Downloaded by Ta keys (tokegb1@wgu.edu) lOMoARcPSD|38117795
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
The technique that I used was Scatter Plot. This analysis is ideal for studying the data between two subjects. In this case, we are looking at if nurses attend the programs for well- being, the attrition rate would decrease. I feel that this is a good study as it will give me information showing me if the program works or if there is no relation between the two. Linear regression is the appropriate analysis technique for predicting the dependent variable because it allows us to analyze between an independent and a dependent variable. The independent variable would be the participants in the study and the dependent would be the nurse attrition rate. Using linear regression allows us to identify risk factors and calculate those scores for use in determining how to continue to help lower the attrition level. SUMMARY OUTPUT Regression Statistics Multiple R 0.74428486 R Square 0.55395995 2 Downloaded by Ta keys (tokegb1@wgu.edu) lOMoARcPSD|38117795
Adjusted R Square 0.54084112 Standard Error 0.82520629 Observations 36 ANOVA df SS MS F Regression 1 28.7546759 28.75468 42.22634 Residual 34 23.1528241 0.680965 Total 35 51.9075 Coefficients Standard Error t Stat P-value Intercept 5.58955642 0.37464865 14.91946 1.74E-16 Program Participation Rate (%) -0.0849386 0.01307113 -6.49818 1.96E-07 As we look at the calculations, the p-value or ANOVA result is a statistical relationship shown as p<0.05. If it is this result, then that shows a null hypothesis is rejected and therefore there is no relationship. This data shows a P-value of 1.96E-07 which indicates that the null hypotheses will be rejected. The null hypothesis would state that there is no significant relationship between attending a program and the attrition rate. Using the data provided we could ask is there a significant relationship between Attrition Rate, x, and program participation percentage. This analysis states that there are direct relationships or trends that indicate that attending these programs influences the attrition rate. Based on the linear regression results, we can see that the trend is that attrition lowers as more nurses attend the programs. This means that the programs are working and that the attrition levels are dropping. The equation used to obtain this data's results obtain the results of this data is y= -0.0849x+5.5896 . When looking at data, we also need to consider the research limitations that could affect a recommended course of action. Because the relationship is significant, the equation can be used for future work to determine how the program is still affecting attrition. We know that based on the p-value there 3 Downloaded by Ta keys (tokegb1@wgu.edu) lOMoARcPSD|38117795
is a significant relationship. When looking at the data we cannot determine the ages of the nurses, nor if they have any medical issues or family issues that would cause the results to be askew. When we look at the goodness of fit, we see that it is 0.554. As we know 0.554 is moderate. If the R-square is closer to 0 it is not a good fit. If the R-square is a 1 then it is a perfect fit. the goodness of fit will help determine if this data could be skewed or if it’s a representation we would expect. We also need to take into consideration that this data does not tell us if these nurses are continuing with the programs or how many times they have attended. Because of this missing information, we cannot be certain that the attrition level will continue to lower because of unforeseen problems. Based on the data that was analyzed, I would recommend the hospital continue with its plan of funding the program for the next five years. Based on the information, the attrition rate is dropping consistently as the nurses are attending the programs. If additional information was available, a more definite conclusion could be formed. 4 Downloaded by Ta keys (tokegb1@wgu.edu) lOMoARcPSD|38117795
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help