Based on the following information, proceed to executive report where you document the following in summary form.

1. Provide a brief description of the situation.
2. What was the sample studied?
3. What analyses were carried out and what were the purposes of each of them as part of understanding and solving the crisis.
4. What resulted from the analysis? What could you conclude that will help resolve the health situation at the hospital?
5. Provide additional recommendations to management.

Horario AM-Temp ("F) Horario PM-Temp ("F) AM 101.1 PM 103.6 Tarea 8, Parte 1 - Estadisticas Descriptives AM 100.0 PM 100.8 AM 100.4 PM 99.5 AM 100.0 PM 100.9 (1) Start by determining the main descriptive statistics (mean, median, mode, variance, and standard deviation) for each set of samples using Excel formulas. AM B'86 PM 99.5 AM 99.4 PM (2) Where each value obtained from mean, median and mode to one decimal place, Round the variance and standard deviation to two decimal places. 101.9 AM 99.4 PM 101.1 AM 99.9 PM 103.0 AM 8 86 PM 101.3 AM 100.0 PM Coloque sus calculos usando Excel a continuacion: 100.0 AM 100.2 PM 100.2 Morning Temperature Calculations: AM 101.2 PM 100.2 AM 99.9 PM 101.1 Media Mediana Moda Varianza AM 98.8 PM Desviacion Estandar 102.9 99.8 99.9 98.6 AM 0.7 8 66 PM 0.8 100.0 AM 98.6 PM 101.6 Morning Temperature Calculations: AM 100.6 PM 102.1 AM 100.1 PM 103.5 Media Mediana Moda AM 101.1 Varianza PM 103.1 Desviacion Estandar 101.8 102.0 99.5 AM 99.2 PM 2.2 1,5 103.9 AM 101.2 PM 99.5 AM 100.1 PM 102.8 AM 99.2 PM 104.1 AM 100.4 PM 103.1 AM 98.6 PM 103,8 AM 101.0 PM 102.6 AM 99.6 PM 102.4 AM 98.6 PM 100.5 AM 98.6 PM 100.3 AM 100.4 PM 104.2 AM 99.9 PM 102.0 AM 99.5 PM 103.3 AM 100.1 PM 100.2 AM 99.3 PM 102.6 AM 100.5 PM 99.8 AM 101.2 PM 101.9 AM 99.6 PM 103.0 AM 99.2 PM 103,3 AM 100.0 PM 100.6 AM 98.6 PM 103.0Horario AM-Temp (F) Horario PM-Temp ("F) Tarea 8, Parte 2 - Tablas de Frecuencia AM 98.6 PM 99.5 (1) Using the already organized temperature data, prepare the Frequency Table for each schedule using: five (5) AM 98.6 PM 39.5 temperature classes (98.6-99.9, 100.0-101.3, 101.4-102.7, 102.8-104.1, 104.2-final). Determine for each class its AM 98.6 PM 39.5 frequencies, percentages of frequencies (%Freq), cumulative frequencies, and cumulative frequency percentages AM PM 99.8 (%FrecAcum) using Excel where necessary AM 98.6 PM 100.0 AM 98.8 PM 100.0 (2) Prepare a bar chart of morning and afternoon temperatures. Label the graphs appropriately. Provide feedback on the AM 98.8 PM 100.2 patterns visible on each chart. AM 98.8 PM 100.2 AM 99.2 PM 100.2 AM 99.2 PM 100.3 AM 99.2 PM 100.5 Coloque Sus Calculos Para las Temperaturas por la Manana Usando Excel a Continuacion: AM 99.3 PM 100.6 Clase Frecuencia %Frec Frec Acum %FrecAcum AM 99 4 PM 100.8 98.6-99.9 62.50% 52.5% AM 99.4 PM 100.9 100.0-101.3 47.50% 100% AM 99.5 PM 101.1 101.4-102.7 0.00% 100%% AM 39.6 101.1 102.8-104.1 0.00% 100%% AM 99.6 PM 101.3 104.2-final 0.00% 100% AM 99.8 PM 101.6 Suma 00.00% AM 99.9 101.9 AM 19.9 PM 101.9 Coloque su Grafica de Barras para las Temperaturas por la Manana: AM 99.9 PM 102.0 AM 100.0 102.1 AM 100.0 PM 102.4 Grafico AM 100.0 PM 102.6 AM 100.0 PM 102.6 AM 100.1 PM 102.8 AM 100.1 PM 102.9 AM 100.1 PM 103.0 AM 100.2 PM 103.0 AM 100.4 103.0 AM 100.4 PM 103.1 AM 100.4 PM 103.1 AM 100.5 103.3 AM 100.6 PM 103.3 109 101.4 101.4 102.7 102.8 104 1 104.2 106.5 AM 101.0 PM 103.5 temperature AM 101.1 PM 103.6 AM 101.1 PM 103.8 Comments: Based on the chart, we can see that the data is grouped on the left side of the chart. No data is AM 101.2 PM 103.9 available on the right side. Therefore, we can say that the AM temperature data has a positive bias. This AM 101.2 PM 104.1 AM PM happens when data points are grouped more toward one side of the scale than the other, creating a curve that 101.2 104.2 is not symmetric. Coloque Sus Calculos Para las Temperaturas por la Tarde Usando Excel a continuacion: Clase Frecuencia %Frec Frec Acum %FrecAcum 98.6-99.9 0.00% 10.00% 100.0-101.3 32.50% 42.50% 101.4-102.7 20.00% 62.50% 102.8-104.1 35.00% 97.50% 104.2-final 2.50% 100.00% Suma 100.00% Coloque su Grafica de Barras para las Temperaturas por la Tarde a Continuacion: Grafico 08.6-09.9 100.0-101.3 101.4-102.7" 102.8-104.1 104.2-105.5 Is temperature Comments: As we can see in the graph, we can say that it is somewhat symmetrical, because if a line were drawn that dissected the center of the graph, it would reveal two sides that almost reflect each other. However, the peak is not in the middle.Tarea 8, Parte 3 - Probabilidad de la Distribucion Normal Horario AM-Temp (F) Horario PM-Temp ("F) (1) Obtain the necessary descriptive measures to calculate the probabilities (areas) ordered in given exercise. Round the means, I AM 101.1 PM 103.6 AM 100.0 PM 100.8 decimal place, and the variances and standard deviations to two decimal places. AM 100.4 PM 99.5 (2) Remember to use the NORM function. DIST to obtain the probabilities (areas) directly without having to calculate the normal ste AM 100.0 PM 100.9 AM 98.8 PM 99.5 intermediate way. AM 99 4 PM 101.9 AM 99.4 PM 101.1 (3) Calculate each area as needed using Excel, and get the difference for the final area expressed in percentage. Round the areas AM 99.9 PM 103.0 the percentages to two decimal places. AM 98.8 PM 101.3 AM 100.0 PM 100.0 AM 100.2 PM 100.2 AM 101.2 PM 100.2 Coloque sus Calculos usando Excel a Continuacion: AM 99.9 PM 101.1 Temperaturas por la Tarde (PM-Temp) AM 98.8 PM 102.9 Temperaturas por la Manana (AM-Temp) Media Std Dev AM 99.8 PM 100.0 Media Std Dev 101.83 1.47 AM 98.6 PM 101.6 99.82 0.81 AM 100.6 PM 102.1 AM 100.1 PM 103.5 1. Determine la probabilidad de que un nin@ tenga una medida de 1. Determine la probabilidad de que un r AM 101.1 PM 103.1 temperatura entre 98.7'F y 101.7'F por la manana. temperatura entre 98.7'F y 101 AM 99.2 PM 103.9 Area AM 101.2 PM 99.5 Area Area Zsup 0.4648 AM 100. PM 102.8 Area Zsup 0.9899 AM 99.2 PM 104.1 Area Zint 0.0834 Area Zind 0.0166 Diferencea 0.4481 AM 100.4 PM 103.1 Diferencia 0.9065 Porciento 44.81% AM 98.6 PM 103.8 Porciento 90.65% AM 101.0 PM 102.6 AM 99.6 PM 102.4 2. Determine la probabilidad de que un nin@ tenga una 2. Determine la probabilidad de qu AM 98.6 PM 100.5 temperatura menor a temperatura menor a 97.3'F. AM 98.6 PM 100.3 Area AM 100.4 PM 104.2 Area 0.0009 Area Z 0.0010 AM 99.9 PM 102.0 Area Z 0.1% Porcionto 0.1% AM 99.5 PM 103.3 Porciento AM 100.1 PM 100.2 AM 99.3 PM 102.6 AM 100.5 PM 99.8 3. Determine la probabilidad de qu 3. Determine la probabilidad de que un nin@ tenga una AM 101.2 PM 101.9 temperatura mayor a temperatura mayor a 102.5.F. AM 99.6 PM 103.0 Area AM 99.2 PM 103.3 Area Area Z 0.6757 AM 100.0 PM 100.6 Area Z 0.9995 AM 98.6 0.0005 1-Area Z 0.3243 PM 103.0 1-Area Z Porciento 0.05% Porcionto 32.43%Tarea 8, Parte 4 - Pruebas de Normalidad Horario AM-Temp ("F) Horario PM-Temp ("F) AM 101.1 PM 103.6 (1) The administration has doubts about the normality of the data, and therefore threatens the credibility of its study. From the dataset AM 100.0 PM 100.8 "Descriptive Analysis" option within Excel Data Analysis to evaluate each temperature group and determine if they appear to be normal AM 100.4 PM 90.5 AM 100.0 PM 100.9 of data normality. AM 98.8 PM 99.5 (2) Place the descriptive statistics tables in the designated areas and comment on the normality of the temperature samples. AM 99.4 101.9 AM 99.4 101.1 AM 99.9 PM 103.0 AM 98.8 PM 101.3 AM 100.0 PM 100.0 AM 100.2 PM Coloque Sus Resultados de Estadisticas Descriptives Para las Temperaturas por la Manana a Con 100.2 AM 101.2 PM 100.2 AM 99.9 PM 101.1 AM-Temp (F) AM 102.9 (1) The administration has doubts about the normality of the data, and therefore 98.8 PM AM 99.8 PM 100.0 Media 99.8225 threatens the credibility of its study. From the dataset provided for temperatures, PM 101.6 Error tipico 0.127926637 AM 98.6 use the From descriptive test statistics for morning temperature option, we can 99.9 AM 100.6 PM 102.1 Mediana see that the measure of Mean (99.8225), Median (99.9), and Mode (98.6) AM PM 103.5 98.6 100.1 Moda tendency for the data are quite close to each other. The standard deviation AM 101.1 PM 103.1 Desviacion estandar 0.80907909 0.654608974 (0.8091) is not that high. We have a kurtosis value (-0.8685) between -3 and 3, AM 99.2 PM 103.9 Varianza de la muestra 0.868525384 which means that the distribution of morning temperatures is normally AM 101.2 PM 99.5 Curtosis 0.088126342 distributed. The asymmetry value (0.0881) is also between -0.50 and 0.50, which AM 100.1 PM 102.8 Coeficiente de asimetr AM 99.2 PM 104.1 Rango 2.6 means that the data is fairly symmetrically distributed, and therefore we can 98.6 AM 100.4 PM 103.1 Minimo Maximo 101.2 AM 98.6 PM 103.8 PM 102.6 Suma 3992.9 AM 101.0 AM 99.6 PM 102.4 Cuenta 40 AM 98.6 PM 100.5 AM 98.6 PM 100.3 AM 100.4 PM 104.2 Coloque Sus Resultados de Estadisticas Descriptives Para las Temperaturas por la Tarde a Cont AM 99.9 PM 102.0 AM 99.5 PM 103.3 100.1 PM 100.2 PM-Temp ("F) From the descriptive test statistics for the afternoon temperature, we can see AM AM 99.3 PM 102.6 that the measure of Mean (101.83), Median (101.95) and Mode (99.5) tendency AM 100.5 PM 99.8 Media 101.83 for the data are quite close to each other. The standard deviation (1.4697) is 0.232384518 AM 101.2 PM 101.9 Error tipico not that high. We have a kurtosis value (-1.3563) between -3 and 3, which PM 101.95 AM 99.6 103.0 Mediana means that the distribution of morning temperatures is normally distributed. 19.5 AM 99.2 PM 103.3 Moda The asymmetry value (-0.1016) is also between -0.50 and 0.50, which means AM 100.0 PM 100.6 Desviacion estandar 1.469728738 that the data is distributed quite symmetrically and therefore we can conclude 98.6 103.0 2.160102564 AM PM Varianza de la muestra Curtosis -1.356275267 that the data is normally distributed. Coeficiente de asimet 0.101602859 Rango 4.7 Minimo 99.5 Maximo 104.2 Suma 4073.2 Cuenta 40Genero Horario AM-Temp (F) Genera Horario PM-Temp (F) AM 101.1 F PM 103.6 AM 100.0 PM 100.8 AM 100.4 PM (1) You obtained data on the gender of affected min's and want to determine if there is a significant diference between the temperatures of girls and boys for each of the temperature samples for 100 0 whether or not temperatures between girls and boys are within each scheduln. PM 90.5 PM 101.9 (7] Compare girls in the morning and girls in the alteraons, and compare boys in the morning and boys in the afternoons. Do not cross morning and shemoon data. AM PM 101.1 AM PM 103.D (3) Remember the order of the data to place in Excel when generating the variances in Test F. and the means in the wringand T-Test. AM PM 101.3 AM 100.0 PM 100.0 (() Provide an explanation of the selected test and the results obtained from the tents. AM 100.2 PM 100.2 AM 101. PM 100.2 PM 101.1 Coloque la Prurba Fy T Independents para las Temperatures de las Ninas por la Manana y la Tards AM AM PM 102.9 AM PM 100.D F-Test Two-Sample for Variances I. Test: Paired Two Sample for Means AM PM 101.6 AM 100.6 PM 102.1 101 ST 101.51 AM 100. 1 PM 103.5 Mean 0 619236842 2 039368421 nnnT 2 0293-58421 Varianon AM 101.1 PM 103.1 Variance 0.619236842 70 PM 103.9 Observations 20 30 20 AM 99.87 TOTS 19 Pearson Completion 0 053912839 Media Media Hypothmined Mean Dillon Varianra Varianra 0.305137715 POF