There are four (4) questions in this problem. The following are the bar chart an
ID: 3172772 • Letter: T
Question
There are four (4) questions in this problem. The following are the bar chart and pie chart illustrating what types of food people like to grill during BBQ season. Identify a scenario that the bar chart might be preferable. Identify a scenario that the pie chart might be preferable. 3. You have the following exam scores for a finance midterm from a class of 20 students: 100, 54, 99, 95, 88, 67, 74, 89, 90, 92, 85, 83, 72, 77, 80, 50, 100, 87, 82, 85 If you wanted to create a histogram using MS Excel for this data, what bins (classes) would be reasonable to provide to Excel? (Identify the bin/class boundaries.) 4. After you created histogram function using Excel, what correction(s) would you need to make to your chart?Explanation / Answer
Answers to the question:
1. When one needs to see absolute sales numbers of every month
2.Whn one wants to see %age distribution of people accross different age buckets
3.So, the min and max is 50 and 100. And we have 20 people. Ideally we can have bins of (100-50)/20 = 2.5 but since there ar eonly 20 people, we can have:
Bins size = 5
Class boundries= 50 to 55, 55 to 60...95 to 100
4.No corrections need to be made. Just the buckets needs to be created for every observation and frequency plot drawn for this.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.