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. What can you conclude from the study? O The number of personnel is not adding significant predictability to the number of births in a hospital. O The number of births is not adding significant predictability to the number of personnel in a hospital. O The number of personnel is adding significant predictability to the number of births in a hospital. The number of births is adding significant predictability to the number of personnel in a hospital.

ID gender dist. from Hunter(miles) commute time (min) Borough 1 M 3.2 20 Manhattan 2 M 7.5 42 Other 3 M 8.8 84 Other 4 M 2.5 12 Manhattan 5 M 5.4 32 Other 6 M 16 63 Other 7 F 4.4 21 Manhattan 8 F 17.2 95 Other 9 F 8.4 72 Other 10 F 4.5 25 Manhattan 11 F 2.7 24 Manhattan 12 F 20.7 80 Other 13 F 14 91 Other 14 F 5.4 24 Manhattan 15 F 5.5 37 Manhattan 16 F 3.4 25 Manhattan   Find the z-scores for each student's commute time.

Judge Disposed Appealed Reversed Court Fred Cartolano 3037 137 12 Common Thomas Crush 3372 119 10 Common Patrick Dinkelacker 1258 44 8 Common Timothy Hogan 1954 60 7 Common Robert Kraft 3138 127 7 Common William Mathews 2264 91 18 Common William Morrissey 3032 121 22 Common Norbert Nadel 2959 131 20 Common Arthur Ney Jr. 3219 125 14 Common Richard Niehaus 3353 137 16 Common Thomas Nurre 3000 121 6 Common John O'Connor 2969 129 12 Common Robert Ruehlman 3205 145 18 Common J. Howard Sundermann Jr. 955 60 10 Common Ann Marie Tracey 3141 127 13 Common Ralph Winkler 3089 88 6 Common Total 43945 1762 199 -- Penelope Cunningham 2729 7 1 Domestic Patrick Dinkelacker 6001 19 4 Domestic Deborah Gaines 8799 48 9 Domestic Ronald Panioto 12970 32 3 Domestic Total 30499 106 17 -- Mike Allen 6149 43 4 Municipal Nadine Allen 7812 34 6 Municipal Timothy Black 7954 41 6 Municipal David Davis 7736 43 5 Municipal Leslie Isaiah Gaines 5282 35 13…

2. We wish to analyze the monthly water usage of a production plant, Y (in gallons), with respect to its monthly production X₁ (in tons), mean monthly temperature X₂ (in °F) and the monthly number of days X3 of plant operation using the data given in the file 'WATER.xlsx'. The following models are considered: I: II: Y = Y = Bo + B₁X₁ + B₂X2 + ß3X3 + E, Bo + B₁X₁ + B2X2 + B3X3 + B₁X1X2 + B5X₁X3 + B6X2X3 + ε Perform your tests at a = 10% in this question. (a) Generate a matrix scatter plot and state the relationship among these variables. (b) Use R/Minitab to estimate the parameters of Model I, set up three hypotheses to test whether each variable is useful given that the other variables are in the model. (c) In Model II, the interaction terms among these three variables are considered. Using the sum of squared residuals from the estimates of models I and II, do an F-test to test the whether all these interaction terms are useful jointly in predicting the monthly water usage of the…

3) How many Coffee Drinkers are there? 58 Total People 29 Tea Drinkers 8 10 ? 6 ? ? Beer Drinkers ? 12 Coffee Drinkers

None, Low, Medium, High ( alcohol consumption) Never Smokes  None 450 Low 205  Medium 190 High  75   Smoker None  425 Low  255  Medium 170  High  30   What is the Frequency of :  None smoking , no alcohol Snokers who dont consume alcohol Never smoke high alcohol Smokers and high alcohol

Price SqFt 600000 2767 545000 2731 314900 2051 419000 2084 365000 2270 479000 1950 323000 1235 339900 2116 399000 1644 552000 2415 223017 1375 315777 1529 499000 2223 575000 2327 342000 1879 375000 1558 349000 2012 485000 1200 549888 1410 295000 1943 399000 1827 306999 1840 265200 1636 479000 2357 249700 1152 539500 2650 365000 2154 295900 1279 499000 2156 526000 2493 514900 2390 346000 1347 460000 2120 389000 1917 499000 1200 405000 2643 389900 1789 545000 2327 339000 1742 425000 1746 479000 1421 392000 2569 Interpret b0 in the context of this problem. Interpret b1 in the context of this problem. What percent of total variation in prices is explained by the regression model? Provide evidence to support your answer. Please include the excel function.

Sale Price 12400 10400 12100 10000 11000 8895 7675 9975 6350 10470 9895 11250 8795 12500 9340 10150 9200 9395 11000 10640 10000 7500 8000 10440 10200 10300 9740 9280 10930 8000 9000 7680 9400 10730 7350 12240 11970 8240 9910 10080 9440 8970 9500 10050 10130 11400 8500 7500 9090 10500 According to the National Automobile Dealers Association, the mean price for used cars is $10,192. A manager of a Kansas City used car dealership reviewed a sample of 50 recent used car sales at the dealership in an attempt to determine whether the population mean price for used cars at this particular dealership differed from the national mean. The prices for the sample of 50 cars are shown in the file named UsedCars. Formulate the hypotheses that can be used to determine whether a difference exists in the mean price for used cars at the dealership. What is the p-value? At , what is your conclusion?

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…

i really need help with question number 2