help with assgn - 2 tasks - due in 1 week

Start

							12478063

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 reliable and relevant to the real-world decisions they must make in their businesses. 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 scenario in this "Linear Regression Analysis Resources" attachment. You will access the scenario and dataset by entering your student ID number in the "Start" tab of this attachment, then continuing to the "Scenario" tab. Using this dataset, 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

QUM3 Task 1: Linear Regression Analysis

Next >

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

Enter your student ID number:

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 endure 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 determine whether 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 administers the program's day-to-day operations, including expanding employee participation through periodic marketing emails that promote program benefits and upcoming activities. Of course, significant internal costs are associated with subsidizing this program. Nevertheless, management believes 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 whether a significant relationship exists 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 linked 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.7
2	10.5	5.5
3	9	7
4	9.6	6.5
5	14.2	5.3
6	16.3	4.7
7	16.9	4.6
8	16.8	4.8
9	20.2	3.9
10	18.5	4.6
11	19.3	4
12	14.2	3.5
13	23.1	3.1
14	22.7	3.2
15	24.1	2.9
16	24	2.6
17	25.3	2.5
18	24.8	2.7
19	28.5	4.5
20	30.3	3.6
21	28.9	4.5
22	30.2	3.1
23	32	3.9
24	29.7	3.2
25	34.1	4.1
26	24.3	4.1
27	36.4	4.2
28	38.5	2.8
29	38.4	1.9
30	38	3.8
31	40.1	1.4
32	39.5	1.5
33	42.1	1.3
34	42.3	1.3
35	44	1.2
36	42.9	1.3

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.7
2	10.5	5.5
3	9	7
4	9.6	6.5
5	14.2	5.3
6	16.3	4.7
7	16.9	4.6
8	16.8	4.8
9	20.2	3.9
10	18.5	4.6
11	19.3	4
12	14.2	3.5
13	23.1	3.1
14	22.7	3.2
15	24.1	2.9
16	24	2.6
17	25.3	2.5
18	24.8	2.7
19	28.5	4.5
20	30.3	3.6
21	28.9	4.5
22	30.2	3.1
23	32	3.9
24	29.7	3.2
25	34.1	4.1
26	24.3	4.1
27	36.4	4.2
28	38.5	2.8
29	38.4	1.9
30	38	3.8
31	40.1	1.4
32	39.5	1.5
33	42.1	1.3
34	42.3	1.3
35	44	1.2
36	42.9	1.3

assignment

LAST 3	063		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	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
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.4	4.7
2	11.8	4.3
3	9.3	4.4
4	10.9	4
5	14.5	4
6	17.6	4
7	17.2	4.1
8	18.1	4.1
9	20.5	4.1
10	19.8	3.8
11	19.6	3.5
12	15.5	5
13	23.4	3.5
14	24	1.4
15	24.4	3.3
16	25.3	3.2
17	25.6	3.1
18	26.1	2.7
19	28.8	2.7
20	31.6	2.8
21	29.2	2.7
22	31.5	2.3
23	32.3	2.1
24	31	2.4
25	34.4	2.4
26	34.6	3.4
27	36.7	2.5
28	39.8	2.1
29	38.7	2.8
30	39.3	3.1
31	40.4	1.8
32	40.8	1.8
33	42.4	1.6
34	43.6	1.5
35	44.3	1.4
36	44.2	1.8

DATA SET 2

DATA FOR ANALYSIS	.	.
Month	Program Participation Rate (%)	Nurse Attrition Rate (%)
1	11.2	4.7
2	11.6	2.7
3	10.1	4.4
4	10.7	2.4
5	15.3	3.4
6	17.4	2.4
7	18	4.1
8	17.9	2.5
9	21.3	4.1
10	19.6	2
11	20.6	3.1
12	15.5	5
13	24.4	2.7
14	24	2
15	25.4	2.9
16	25.3	1.4
17	26.6	3.7
18	26.1	1.3
19	29.8	2.9
20	31.6	1.7
21	30.2	2.3
22	31.5	1.8
23	33.3	1.7
24	30.8	1.4
25	33.2	1.5
26	34.4	1.4
27	37.5	1.3
28	39.6	1.5
29	39.5	1.9
30	39.1	1.5
31	41.2	1.2
32	40.6	1.1
33	43.2	1.1
34	43.4	1.2
35	45.1	1.8
36	44	1.2

DATA SET 3

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

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