need help only in 4 (d)

d) Describe the shape of the distribution?

4. Let us look more closely at the issue of working while at school. a. Let us begin with a histogram. Clear your pivot table or create a new one. - Drag HrsWork to Rows, - ID to Values, - Summarize with COUNT, - Show values as \% of Column Total, - Take a picture of the table and chart and paste it below. There are many rows to the table, so just show the first few. b. We must still Group the data to make our histogram. - Select any Row label and select Group. - Excel will suggest Starting at 0 , but this represents Not Working. There is no simple way to Filter out 0 . Excel will not let you Group without selecting all labels, and it won't let you have a variable in the Rows box and the Filter box at the same time. As a work around, let us start at 0.001. - Excel suggests ending at 80, but this is an outlier. A more reasonable end point might be 60 . - Finally, Excel suggests an increment of 10. This would only yield too few groups, so let us try using an increment of 5 hours. - Take a picture of the table and chart and paste it below. c. This histogram has half of students in the 0 or blank group. These are students who are not working or did not tell us about their work. Hide this group as well as the over 60 group. Take a picture of the table and chart and paste it below. d. Describe the shape of the distribution