I need help with QNT 275 Week2 Case study. Make pie chart which summarizes colors of the cars in the sample. I need help with Excel functions. Please and Thank you!
Pie chart making using excel: Select the data. "Insert" tab >... View the full answer
- Thank you. I am having trouble with the Frequency. I am not sure how to set up the bins.
- May 14, 2018 at 6:16am
- Find out the minimum and the maximum value of the data and range of the data. Accordingly decide the width of the bin and then number of bins. If you have small data set you can count numbers falling in that interval manually. If you have large data set use excel function "COUNTIFS" to count the numbers falling in that bin.
- May 14, 2018 at 6:28am