HospitalBirthsPersonnel13127922107717623102723104355328516818163810107777357428113191733159410257233111692411243020313032514204967615211347161679172648505182450154319146575520095921199332522227595423149410912413136712545130026168975327158360728201792929995354302045408311686125132503386331261443420262047351412134336151717233709638052939271936944010741042411421107142762152543319419834449667045144216534601674711077934829898414911331650093510373521732635310649435475960555131759656175111655705685805075971447960991366122431456623966348663130888564024365251410016637143301671263376855611936913271161704153227121618572339205731217122474264117047579081576520712773515678116817697979387580079081030882147083049484011185016188602448777652588451472890949014529791128484792123493319401942154392895295198964961231975895459880666399701820100396825811010129810201261033655253410402511050851060432107086410806610930635561101693471116623911282797311357043911401849115010211602621173428851184945491190611120033012101471122075123286262124235328125339377126398575127127519161285699262012913645711307147031310535132016013302021347791330135037013622023123137334627451381071815139352576140254502141080814205014369972814424624087145331130121460681474207309014801358149339576150130284151911451521143231215301124154033615550941515610261779157033815844745315911614371600261161922609162562647163786116402074165212222321660948167040916801531697107411701165162517146653817211067891733763951740956175637362176014417735222917844739617912272256180963731181303814771820102183010618486893918511893921862849351618717287851882171607189364273190063019129931379192011081931964583194601514195387216196194615931975451055198039919983883420051104 Use Excel to develop a regression model for the Hospital Database (using the "Excel Databases.xls" file on Blackboard) to predict the number of Personnel by the number ofBirths. Perform a test of the slope. What is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places.13.70

Given: n=200 Hypothesis H0:β1=0 H0: The number of births is not significant in predicting the…

Answered: Use Excel to develop a regression model…

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018

18th Edition

ISBN:9780079039897

Author:Carter

Publisher:Carter

Chapter4: Equations Of Linear Functions

Section4.6: Regression And Median-fit Lines

Problem 5PPS

See similar textbooks

Related questions

Question

Hospital	Births	Personnel
1	312	792
2	1077	1762
3	1027	2310
4	355	328
5	168	181
6	3810	1077
7	735	742
8	1	131
9	1733	1594
10	257	233
11	169	241
12	430	203
13	0	325
14	2049	676
15	211	347
16	16	79
17	2648	505
18	2450	1543
19	1465	755
20	0	959
21	1993	325
22	2275	954
23	1494	1091
24	1313	671
25	451	300
26	1689	753
27	1583	607
28	2017	929
29	995	354
30	2045	408
31	1686	1251
32	503	386
33	126	144
34	2026	2047
35	1412	1343
36	1517	1723
37	0	96
38	0	529
39	2719	3694
40	1074	1042
41	1421	1071
42	762	1525
43	3194	1983
44	496	670
45	1442	1653
46	0	167
47	1107	793
48	2989	841
49	113	316
50	0	93
51	0	373
52	173	263
53	1064	943
54	759	605
55	1317	596
56	1751	1165
57	0	568
58	0	507
59	714	479
60	99	136
61	2243	1456
62	3966	3486
63	1308	885
64	0	243
65	2514	1001
66	3714	3301
67	126	337
68	556	1193
69	1327	1161
70	415	322
71	216	185
72	339	205
73	1217	1224
74	2641	1704
75	790	815
76	520	712
77	35	156
78	1168	1769
79	793	875
80	0	790
81	0	308
82	14	70
83	0	494
84	0	111
85	0	1618
86	0	244
87	776	525
88	451	472
89	0	94
90	145	297
91	1284	847
92	1	234
93	319	401
94	2154	3928
95	295	198
96	496	1231
97	589	545
98	806	663
99	701	820
100	3968	2581
101	0	1298
102	0	126
103	3655	2534
104	0	251
105	0	85
106	0	432
107	0	864
108	0	66
109	3063	556
110	169	347
111	66	239
112	827	973
113	570	439
114	0	1849
115	0	102
116	0	262
117	342	885
118	494	549
119	0	611
120	0	330
121	0	1471
122	0	75
123	286	262
124	235	328
125	339	377
126	398	575
127	1275	1916
128	5699	2620
129	1364	571
130	714	703
131	0	535
132	0	160
133	0	202
134	779	1330
135	0	370
136	2202	3123
137	3346	2745
138	1071	815
139	352	576
140	254	502
141	0	808
142	0	50
143	699	728
144	2462	4087
145	3311	3012
146	0	68
147	4207	3090
148	0	1358
149	339	576
150	130	284
151	91	145
152	1143	2312
153	0	1124
154	0	336
155	509	415
156	1026	1779
157	0	338
158	447	453
159	1161	437
160	0	261
161	922	609
162	562	647
163	78	61
164	0	2074
165	2122	2232
166	0	948
167	0	409
168	0	153
169	710	741
170	1165	1625
171	466	538
172	1106	789
173	376	395
174	0	956
175	637	362
176	0	144
177	352	229
178	447	396
179	1227	2256
180	963	731
181	3038	1477
182	0	102
183	0	106
184	868	939
185	1189	392
186	2849	3516
187	1728	785
188	2171	607
189	364	273
190	0	630
191	2993	1379
192	0	1108
193	1964	583
194	601	514
195	387	216
196	1946	1593
197	545	1055
198	0	399
199	838	834
200	51	104

Use Excel to develop a regression model for the Hospital Database (using the "Excel Databases.xls" file on Blackboard) to predict the number of Personnel by the number of
Births. Perform a test of the slope. What is the value of the test statistic? Write your answer as a number, round your answer to 2 decimal places.
13.70

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

$Pythagoras' Theorem$

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.

Similar questions