Purchase Solution

Project Quality Management

Not what you're looking for?

Ask Custom Question

To illustrate a normal distribution, shake and roll a pair of dice 30 times and graph the results. It is more likely for someone to roll a six, seven, or eight than a two or 12, so these numbers should come out more often. To create the graph use Excel. Make a grid. Label the x-axis with the numbers 2 through 12. Label the y-axis with the numbers 1 through 10. Fill in the appropriate cell for each role of the dice. Do you results resembled a normal distribution? Why or why not?

Please, I need the grid set up properly in Excell (2003 or 2007). Please upload Excel spreadsheet with information and questions answered as above and also listed on attached Word file. I must submit an Excel document, not a Word file. I will use this problem to do additional exercises, as a guide.

Purchase this Solution

Solution Summary

To illustrate a normal distribution, shake and roll a pair of dice 30 times and graph the results. It is more likely for someone to roll a six, seven, or eight than a two or 12, so these numbers should come out more often. To create the graph use Excel. Make a grid. Label the x-axis with the numbers 2 through 12. Label the y-axis with the numbers 1 through 10. Fill in the appropriate cell for each role of the dice. Do you results resembled a normal distribution? Why or why not?

Solution provided by:
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution


Free BrainMass Quizzes
Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.