View the step-by-step solution to:

Make pie chart which summarizes colors of the cars in the sample. Please and Thank you!

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!

Top Answer

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.
    • MMK921
    • 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.
    • akhilanand
    • May 14, 2018 at 6:28am

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask a homework question - tutors are online