Review

Start

							8897853

To Complete the Assessment: Enter your Student ID below. Once you have entered your Student ID, click "Next" to begin the assessment.

Overview of Assessment Managers are required to organize, interpret, and display data that is relevant to the real-world business decisions they must make in their businesses, and these business decisions must be based on relevant and reliable data. The use of analytical tools will improve your ability to use data to make these informed decisions.  In this task, you will address the business situation scenario in this "Linear Regression Analysis Resources" attachment. You will access the scenario and data set by entering your student ID number in this “Start” tab of this attachment, then continuing to the “Scenario” tab. Using this data set, you will perform a linear regression analysis and write a report in which you recommend a solution by summarizing the key details of your analysis.

Data-Driven Decision Making

QUM2 Task 1: Linear Regression Analysis

Next >

/xl/drawings/drawing1.xml#Scenario!A1

Enter Your Student ID:

Note: To get credit for your work, you must enter your Student ID number correctly.

Scenario

Task 1: Linear Regression Analysis Scenario A major healthcare system wants to reduce job-related stress among its employees. In particular, the nursing staff endures a significant amount of pressure due to 12-hour rotating shifts, required overtime, and challenging job assignments. A few years ago, the hospital's human resources (HR) department discovered that its nurse turnover rate was much higher than any other professional position at the hospital. Those nurses leaving employment cited work conditions and emotional stress as their main concerns. To curb this trend, the hospital proactively developed an employee well-being program. For over three years, a program manager has sponsored monthly activities specifically designed to improve employee morale and reduce stress. Participation in the program has been strictly voluntary, with a $50 cash bonus awarded to all employees who consistently complete the various well-being activities every quarter. Nurse participation is specifically being tracked to see if the program has successfully improved job satisfaction and reduced job turnover. Enrollment in the program has generally increased over time. Sponsored activities are currently developed by a full-time athletic trainer, a massage therapist, and a yoga instructor. These professionals also provide individualized services to participants upon request. A full-time program coordinator is tasked with administering the program's day-to-day operations, including the responsibility of expanding employee participation through periodic marketing emails that tout program benefits and upcoming activities. Of course, there are significant internal costs associated with subsidizing this program. Nevertheless, it is widely believed that these expenses are minuscule when compared to the substantial costs associated with replacing employees—nurses in particular. Accordingly, the program costs and predicted savings are not being considered as part of this initial analysis. The purpose of this study is to determine if there is a significant relationship between the monthly rate of nurse participation and the nurse attrition rate over the span of 36 months. Since attrition can be considered a lagging indicator of job satisfaction, the attrition rate is retroactively tied back to each nurse’s enrollment month. Categorized data for program participation and nurse attrition was extracted and assembled from the program enrollment database and the HR employee database, with the data for analysis shown below. The hospital executive council is reviewing the program’s efficacy in reducing nurse attrition through program participation as part of its routine funding plan for the next five years. However, the initial meeting will primarily focus on program efficacy and predictions for future enrollment growth and nurse retention.
DATA FOR ANALYSIS	.	.
Month	Program Participation Rate (%)	Nurse Attrition Rate (%)
1	10.1	5
2	10.5	4
3	9	6.5
4	9.6	3.7
5	14.2	4.7
6	16.3	3.7
7	16.9	4.5
8	16.8	3.8
9	20.2	4.5
10	18.5	3.6
11	19.3	4.3
12	14.2	6
13	23.1	4.3
14	22.7	1.2
15	24.1	4.1
16	24	3
17	25.3	3.9
18	24.8	2.5
19	28.5	3.5
20	30.3	2.6
21	28.9	3.5
22	30.2	2.1
23	32	2.9
24	29.7	2.2
25	34.1	3.1
26	24.3	3.1
27	36.4	3.2
28	38.5	1.8
29	38.4	3.5
30	38	2.8
31	40.1	2.5
32	39.5	1.5
33	42.1	2.3
34	42.3	1.2
35	44	2.1
36	42.9	2.5

Please remember to save this file.

Next >

/xl/drawings/drawing2.xml#'Data%20Analysis%20Template'!A1

Data Analysis Template

DATA FOR ANALYSIS	.	.		Guidance: Use the data to complete your analysis and graphical display below, and then write your report.
Month	Program Participation Rate (%)	Nurse Attrition Rate (%)
1	10.1	5
2	10.5	4
3	9	6.5
4	9.6	3.7
5	14.2	4.7
6	16.3	3.7
7	16.9	4.5
8	16.8	3.8
9	20.2	4.5
10	18.5	3.6
11	19.3	4.3
12	14.2	6
13	23.1	4.3
14	22.7	1.2
15	24.1	4.1
16	24	3
17	25.3	3.9
18	24.8	2.5
19	28.5	3.5
20	30.3	2.6
21	28.9	3.5
22	30.2	2.1
23	32	2.9
24	29.7	2.2
25	34.1	3.1
26	24.3	3.1
27	36.4	3.2
28	38.5	1.8
29	38.4	3.5
30	38	2.8
31	40.1	2.5
32	39.5	1.5
33	42.1	2.3
34	42.3	1.2
35	44	2.1
36	42.9	2.5

Wellness Program Participation and Nurse Attrition

Nurse Attrition Rate (%)

y = -0.0849x + 5.5896 R² = 0.554

10.1 10.5 9 9.6 14.2 16.3 16.899999999999999 16.8 20.2 18.5 19.3 14.2 23.1 22.7 24.1 24 25.3 24.8 28.5 30.3 28.9 30.2 32 29.7 34.1 24.3 36.4 38.5 38.4 38 40.1 39.5 42.1 42.3 44 42.9 5 4 6.5 3.7 4.7 3.7 4.5 3.8 4.5 3.6 4.3 6 4.3 1.2 4.0999999999999996 3 3.9 2.5 3.5 2.6 3.5 2.1 2.9 2.2000000000000002 3.1 3.1 3.2 1.8 3.5 2.8 2.5 1.5 2.2999999999999998 1.2 2.1 2.5

Program Participation Rate

Nurse Attrition Rate

assignment

LAST 3	853		SHEET	4
0	1	0
1	2
2	3							0
3	4
4	5
5	1
6	2
7	3
8	4
9	5
10	1
11	2
12	3
13	4
14	5
15	1
16	2
17	3
18	4
19	5
20	1
21	2
22	3
23	4
24	5
25	1
26	2
27	3
28	4
29	5
30	1
31	2
32	3
33	4
34	5
35	1
36	2
37	3
38	4
39	5
40	1
41	2
42	3
43	4
44	5
45	1
46	2
47	3
48	4
49	5
50	1
51	2
52	3
53	4
54	5
55	1
56	2
57	3
58	4
59	5
60	1
61	2
62	3
63	4
64	5
65	1
66	2
67	3
68	4
69	5
70	1
71	2
72	3
73	4
74	5
75	1
76	2
77	3
78	4
79	5
80	1
81	2
82	3
83	4
84	5
85	1
86	2
87	3
88	4
89	5
90	1
91	2
92	3
93	4
94	5
95	1
96	2
97	3
98	4
99	5
100	1
101	2
102	3
103	4
104	5
105	1
106	2
107	3
108	4
109	5
110	1
111	2
112	3
113	4
114	5
115	1
116	2
117	3
118	4
119	5
120	1
121	2
122	3
123	4
124	5
125	1
126	2
127	3
128	4
129	5
130	1
131	2
132	3
133	4
134	5
135	1
136	2
137	3
138	4
139	5
140	1
141	2
142	3
143	4
144	5
145	1
146	2
147	3
148	4
149	5
150	1
151	2
152	3
153	4
154	5
155	1
156	2
157	3
158	4
159	5
160	1
161	2
162	3
163	4
164	5
165	1
166	2
167	3
168	4
169	5
170	1
171	2
172	3
173	4
174	5
175	1
176	2
177	3
178	4
179	5
180	1
181	2
182	3
183	4
184	5
185	1
186	2
187	3
188	4
189	5
190	1
191	2
192	3
193	4
194	5
195	1
196	2
197	3
198	4
199	5
200	1
201	2
202	3
203	4
204	5
205	1
206	2
207	3
208	4
209	5
210	1
211	2
212	3
213	4
214	5
215	1
216	2
217	3
218	4
219	5
220	1
221	2
222	3
223	4
224	5
225	1
226	2
227	3
228	4
229	5
230	1
231	2
232	3
233	4
234	5
235	1
236	2
237	3
238	4
239	5
240	1
241	2
242	3
243	4
244	5
245	1
246	2
247	3
248	4
249	5
250	1
251	2
252	3
253	4
254	5
255	1
256	2
257	3
258	4
259	5
260	1
261	2
262	3
263	4
264	5
265	1
266	2
267	3
268	4
269	5
270	1
271	2
272	3
273	4
274	5
275	1
276	2
277	3
278	4
279	5
280	1
281	2
282	3
283	4
284	5
285	1
286	2
287	3
288	4
289	5
290	1
291	2
292	3
293	4
294	5
295	1
296	2
297	3
298	4
299	5
300	1
301	2
302	3
303	4
304	5
305	1
306	2
307	3
308	4
309	5
310	1
311	2
312	3
313	4
314	5
315	1
316	2
317	3
318	4
319	5
320	1
321	2
322	3
323	4
324	5
325	1
326	2
327	3
328	4
329	5
330	1
331	2
332	3
333	4
334	5
335	1
336	2
337	3
338	4
339	5
340	1
341	2
342	3
343	4
344	5
345	1
346	2
347	3
348	4
349	5
350	1
351	2
352	3
353	4
354	5
355	1
356	2
357	3
358	4
359	5
360	1
361	2
362	3
363	4
364	5
365	1
366	2
367	3
368	4
369	5
370	1
371	2
372	3
373	4
374	5
375	1
376	2
377	3
378	4
379	5
380	1
381	2
382	3
383	4
384	5
385	1
386	2
387	3
388	4
389	5
390	1
391	2
392	3
393	4
394	5
395	1
396	2
397	3
398	4
399	5
400	1
401	2
402	3
403	4
404	5
405	1
406	2
407	3
408	4
409	5
410	1
411	2
412	3
413	4
414	5
415	1
416	2
417	3
418	4
419	5
420	1
421	2
422	3
423	4
424	5
425	1
426	2
427	3
428	4
429	5
430	1
431	2
432	3
433	4
434	5
435	1
436	2
437	3
438	4
439	5
440	1
441	2
442	3
443	4
444	5
445	1
446	2
447	3
448	4
449	5
450	1
451	2
452	3
453	4
454	5
455	1
456	2
457	3
458	4
459	5
460	1
461	2
462	3
463	4
464	5
465	1
466	2
467	3
468	4
469	5
470	1
471	2
472	3
473	4
474	5
475	1
476	2
477	3
478	4
479	5
480	1
481	2
482	3
483	4
484	5
485	1
486	2
487	3
488	4
489	5
490	1
491	2
492	3
493	4
494	5
495	1
496	2
497	3
498	4
499	5
500	1
501	2
502	3
503	4
504	5
505	1
506	2
507	3
508	4
509	5
510	1
511	2
512	3
513	4
514	5
515	1
516	2
517	3
518	4
519	5
520	1
521	2
522	3
523	4
524	5
525	1
526	2
527	3
528	4
529	5
530	1
531	2
532	3
533	4
534	5
535	1
536	2
537	3
538	4
539	5
540	1
541	2
542	3
543	4
544	5
545	1
546	2
547	3
548	4
549	5
550	1
551	2
552	3
553	4
554	5
555	1
556	2
557	3
558	4
559	5
560	1
561	2
562	3
563	4
564	5
565	1
566	2
567	3
568	4
569	5
570	1
571	2
572	3
573	4
574	5
575	1
576	2
577	3
578	4
579	5
580	1
581	2
582	3
583	4
584	5
585	1
586	2
587	3
588	4
589	5
590	1
591	2
592	3
593	4
594	5
595	1
596	2
597	3
598	4
599	5
600	1
601	2
602	3
603	4
604	5
605	1
606	2
607	3
608	4
609	5
610	1
611	2
612	3
613	4
614	5
615	1
616	2
617	3
618	4
619	5
620	1
621	2
622	3
623	4
624	5
625	1
626	2
627	3
628	4
629	5
630	1
631	2
632	3
633	4
634	5
635	1
636	2
637	3
638	4
639	5
640	1
641	2
642	3
643	4
644	5
645	1
646	2
647	3
648	4
649	5
650	1
651	2
652	3
653	4
654	5
655	1
656	2
657	3
658	4
659	5
660	1
661	2
662	3
663	4
664	5
665	1
666	2
667	3
668	4
669	5
670	1
671	2
672	3
673	4
674	5
675	1
676	2
677	3
678	4
679	5
680	1
681	2
682	3
683	4
684	5
685	1
686	2
687	3
688	4
689	5
690	1
691	2
692	3
693	4
694	5
695	1
696	2
697	3
698	4
699	5
700	1
701	2
702	3
703	4
704	5
705	1
706	2
707	3
708	4
709	5
710	1
711	2
712	3
713	4
714	5
715	1
716	2
717	3
718	4
719	5
720	1
721	2
722	3
723	4
724	5
725	1
726	2
727	3
728	4
729	5
730	1
731	2
732	3
733	4
734	5
735	1
736	2
737	3
738	4
739	5
740	1
741	2
742	3
743	4
744	5
745	1
746	2
747	3
748	4
749	5
750	1
751	2
752	3
753	4
754	5
755	1
756	2
757	3
758	4
759	5
760	1
761	2
762	3
763	4
764	5
765	1
766	2
767	3
768	4
769	5
770	1
771	2
772	3
773	4
774	5
775	1
776	2
777	3
778	4
779	5
780	1
781	2
782	3
783	4
784	5
785	1
786	2
787	3
788	4
789	5
790	1
791	2
792	3
793	4
794	5
795	1
796	2
797	3
798	4
799	5
800	1
801	2
802	3
803	4
804	5
805	1
806	2
807	3
808	4
809	5
810	1
811	2
812	3
813	4
814	5
815	1
816	2
817	3
818	4
819	5
820	1
821	2
822	3
823	4
824	5
825	1
826	2
827	3
828	4
829	5
830	1
831	2
832	3
833	4
834	5
835	1
836	2
837	3
838	4
839	5
840	1
841	2
842	3
843	4
844	5
845	1
846	2
847	3
848	4
849	5
850	1
851	2
852	3
853	4	4
854	5
855	1
856	2
857	3
858	4
859	5
860	1
861	2
862	3
863	4
864	5
865	1
866	2
867	3
868	4
869	5
870	1
871	2
872	3
873	4
874	5
875	1
876	2
877	3
878	4
879	5
880	1
881	2
882	3
883	4
884	5
885	1
886	2
887	3
888	4
889	5
890	1
891	2
892	3
893	4
894	5
895	1
896	2
897	3
898	4
899	5
900	1
901	2
902	3
903	4
904	5
905	1
906	2
907	3
908	4
909	5
910	1
911	2
912	3
913	4
914	5
915	1
916	2
917	3
918	4
919	5
920	1
921	2
922	3
923	4
924	5
925	1
926	2
927	3
928	4
929	5
930	1
931	2
932	3
933	4
934	5
935	1
936	2
937	3
938	4
939	5
940	1
941	2
942	3
943	4
944	5
945	1
946	2
947	3
948	4
949	5
950	1
951	2
952	3
953	4
954	5
955	1
956	2
957	3
958	4
959	5
960	1
961	2
962	3
963	4
964	5
965	1
966	2
967	3
968	4
969	5
970	1
971	2
972	3
973	4
974	5
975	1
976	2
977	3
978	4
979	5
980	1
981	2
982	3
983	4
984	5
985	1
986	2
987	3
988	4
989	5
990	1
991	2
992	3
993	4
994	5
995	1
996	2
997	3
998	4
999	5

DATA SET 1

DATA FOR ANALYSIS	.	.
Month	Program Participation Rate (%)	Nurse Attrition Rate (%)
1	10.1	4
2	11.5	4
3	9	5.5
4	10.6	3.7
5	14.2	3.7
6	17.3	3.7
7	16.9	3.5
8	17.8	3.8
9	20.2	3.5
10	19.5	3.6
11	19.3	3.3
12	15.2	6
13	23.1	3.3
14	23.7	1.2
15	24.1	3.1
16	25	3
17	25.3	2.9
18	25.8	2.5
19	28.5	2.5
20	31.3	2.6
21	28.9	2.5
22	31.2	2.1
23	32	1.9
24	30.7	2.2
25	34.1	2.1
26	34.3	3.1
27	36.4	2.2
28	39.5	1.8
29	38.4	2.5
30	39	2.8
31	40.1	1.5
32	40.5	1.5
33	42.1	1.3
34	43.3	1.2
35	44	1.1
36	43.9	1.5

DATA SET 2

DATA FOR ANALYSIS	.	.
Month	Program Participation Rate (%)	Nurse Attrition Rate (%)
1	11.1	5
2	11.5	4
3	10	6.5
4	10.6	3.7
5	15.2	4.7
6	17.3	3.7
7	17.9	4.5
8	17.8	3.8
9	21.2	4.5
10	19.5	3.6
11	20.3	4.3
12	15.2	6
13	24.1	4.3
14	23.7	1.2
15	25.1	4.1
16	25	3
17	26.3	4.9
18	25.8	2.5
19	29.5	4.5
20	31.3	2.6
21	29.9	3.5
22	31.2	2.1
23	33	2.9
24	30.7	2.2
25	33.1	3.1
26	34.3	3.1
27	37.4	3.2
28	39.5	1.8
29	39.4	3.5
30	39	2.8
31	41.1	2.5
32	40.5	1.5
33	43.1	2.3
34	43.3	1.2
35	45	2.1
36	43.9	1.5

DATA SET 3

DATA FOR ANALYSIS	.	.
Month	Program Participation Rate (%)	Nurse Attrition Rate (%)
1	10.1	5
2	10.5	4
3	9	6.5
4	9.6	3.7
5	14.2	4.7
6	16.3	3.7
7	16.9	4.5
8	16.8	3.8
9	20.2	4.5
10	18.5	3.6
11	19.3	4.3
12	14.2	6
13	23.1	4.3
14	22.7	1.2
15	24.1	4.1
16	24	3
17	25.3	3.9
18	24.8	2.5
19	28.5	3.5
20	30.3	2.6
21	28.9	3.5
22	30.2	2.1
23	32	2.9
24	29.7	2.2
25	34.1	3.1
26	24.3	3.1
27	36.4	3.2
28	38.5	1.8
29	38.4	3.5
30	38	2.8
31	40.1	2.5
32	39.5	1.5
33	42.1	2.3
34	42.3	1.2
35	44	2.1
36	42.9	2.5

image1.png

image2.svg

.MsftOfcResponsive_Fill_003057 { fill:#003057; } .MsftOfcResponsive_Stroke_003057 { stroke:#003057; }

image3.jpg

image4.png

image5.svg

.MsftOfcResponsive_Fill_f6be00 { fill:#F6BE00; }

image6.jpeg

image7.png