Share
Explore BrainMass

Project Quality Management

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.

Attachments

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?

$2.19