stats question

Read the Budget Woes and Worse Ahead...Boston's Pine Street Inn Examines Patterns of Homeless Shelter Use case and then conduct the following analysis.

Using the dataset “Pine Street Inn Length of Stay Data.xls, Download Pine Street Inn Length of Stay Data.xls,” please…

Calculate the descriptive statistics for the data. Do not calculate descriptive statistics for Guest Number (this is just a unique identifier). What was the mean length of stay for guests at Pine Street Inn? What was the median length of stay for guests at Pine Street Inn? What were the maximum and minimum lengths of stay for guests at Pine Street Inn? What do the differences in the mean, median, and mode tell you about Pine Street Inn's guests? What does the skewness tell you about the distribution of the data? Create a histogram for Length of Stay using a bin width of 30 (don't forget to label each axis). Does the histogram support your interpretation of the skewness? How does this information affect your understanding of Pine Street’s budget problem and mission? What additional data would be useful for your analysis? Considering Pine Street’s budget problem, what would be your recommendation to their Board of Directors? Justify your answer using your analysis. Integrate your answers to the above questions in a report following the Individual Case Analysis Instructions.pdf