In preparation for writing your report to senior management next week, conduct the following descriptive statistics analyses with Microsoft® Excel®. Answer the questions below in your Microsoft® Excel® sheet or in a separate Microsoft® Word document:
o Insert a new column in the database that corresponds to “Annual Sales.” Annual Sales is the result of multiplying a restaurant’s “SqFt.” by “Sales/SqFt.”
o Calculate the mean, standard deviation, skew, 5-number summary, and interquartile range (IQR) for each of the variables.
o Create a box-plot for the “Annual Sales” variable. Does it look symmetric? Would you prefer the IQR instead of the standard deviation to describe this variable’s dispersion? Why?
o Create a histogram for the “Sales/SqFt” variable. Is the distribution symmetric? If not, what is the skew? Are there any outliers? If so, which one(s)? What is the “SqFt” area of the outlier(s)? Is the outlier(s) smaller or larger than the average restaurant in the database? What can you conclude from this observation?
o What measure of central tendency is more appropriate to describe “Sales/SqFt”? Why?
High school is a time of altering transition into adulthood and the real world of hard work as students separate from family, explore their independence, and build their own life. At this point, they’re looking for a place to belong to; the perfect fit. It is crucial that students have access to counselors during this transitionary period. In addition, feeling overwhelmed by exams and the future, losing a close friend or family member, and feeling not good enough are all examples of problems that every high school student goes through. These problems need to solved immediately because when they remain unsolved, such conflicts bring the student down causing them to fail academically, lose sleep, or even be depressed. This is where the student counselor comes in handy. Guidance Counselors hold a master’s degree and required state certification in school counseling. They expertise in psychology, counseling methods, and career guidance. They are mainly provided to prepare students for life after high school. Schools should provide Guidance Counselors for high school students. Although some people may argue that the time spent with a counselor will waste the student’s precious educational time, it is proven that guidance and counseling not only impact a student’s academic achievement and career success, but also the student’s social-emotional development.
To begin with, school counselors help students improve their academics. Research shows that nearly one-third of all public high school students do not end up graduating; due to the infinite stress and low incentive to be motivated learners with a bright future. As school dropout rates continue to rise, school counselors are needed more than ever for their academic support. In fact, this statistic can be avoided when schools start hiring more guidance counselors to provide mentorship opportunities and make suggestions for after-school support programs for their at-risk students. Guidance counselors help everyone from the senior trying to maximize his/her chance of getting into college to the freshman about to give up and drop out. Besides, high school is a time of increased stress that can negatively affect the students’ abilities to make suitable and reasonable decisions about their future for the welfare of themselves and others. Hence the school counselor should be the first person to get involved with students who are struggling academically.
Additionally, counselors tend to help students cope with feeling