MAT 300

M&Ms® Project

Part 2 (30 pts)

Use the Excel data file found in the Course Documents area (mnmproject.xls) to complete this assignment. If using Excel 2003, you will want to go to Tools > Add-Ins and make sure the boxes to the left of both analysis toolpaks are checked as we will be using those tools throughout the term. If using Excel 2007, you will click on the Microsoft Office Button in the upper left, then click “Excel Options”. Click on Add-Ins, then in the Manage box, select Excel Add-Ins. Click Go. In the “Add-Ins available box, select the Analysis ToolPak check box and then “Ok”. Please refer to the sample project file (samplemnmpart2.xls) in the Course Documents area for an example of what your completed file will look like if you follow all the outlined steps. Be sure to submit your file through the M&M® project link in the weekly course content.

From this point forward, we will be focusing on the data from two perspectives: color proportions and the number of candies per bag. For the color proportions, the information that will be used is the total for each color and the total number of candies sampled. For the number of candies per bag, you will use the data in the num. candies in bag column.

18 pts (3 for each color). Add up each of the columns. Calculate the sample proportions () for each of the colors. For example, the sample proportion of blue candies would be the total number of blue candies from all the bags divided by the total number of candies in all the bags.

3 pts. Calculate the sample mean () number of candies per 1.69 oz bag. (Find the mean of the number of candies in bag column).

3 pts. In another sheet in the Excel data file, create a histogram for the number of candies per bag. To do this in Excel 2003, go to Tools in the menu and click on Data Analysis, then select Histogram. In Excel 2007, select the Data tab and then click on Data Analysis in the Analysis box. Click in the input range and then select the column containing the total number of candies per bag. Be careful that you do not include the cell that has the total for the column. Select the bin column on the data page for bin range. The “bin” column tells Excel how to group the data into classes for graphing. If you include the cell with the labels (total and bin) when selecting the cells, be sure the box next to Labels is checked. Under output options, select the new worksheet ply and name it Histogram. Check next to Chart output. Finally click ok, and the histogram will be within the new worksheet page. If you will click and hold on the square in the bottom center of the histogram chart, then move the mouse down, you can widen the chart and make it easier to read.

If you do not have the Analysis toolpak in Excel, you can use StatCrunch to do this part. A link to StatCrunch can be found under the Tools for Success, the webliography and on each homework and MML quiz problem. Copy the “number of candies in bag” column into StatCrunch. To do this, you will copy the column in Excel including the column header (num. candies in bag). Then after opening StatCrunch, you will select Data > Load Data > from paste. In the window that opens, click on “paste data from clipboard”, then click “okay”. The data will be loaded into StatCrunch. Next select Graphics > Histogram. In the popup window, select the name of the column that contains your data, click next. Next, enter 1 in the box to the right of “binwidth”, then click “Create Graph!” The output can be copied and pasted into your Excel file.

3 pts. In another sheet in the file, use Excel to compute the descriptive statistics for the total number of candies per bag. This data includes sample mean, sample standard deviation, median, mode, as well as other useful information. To complete this, select Data Analysis again, then select Descriptive Statistics. In the input range, select the “number of candies in bag” column. Include the first row containing the label. Make sure the grouped by columns is selected and check the box next to “Labels in first row”. For the output, select new worksheet ply and name it Descriptive Stats. Check the box next to “Summary Statistics”.

You can also do this part in StatCrunch. With the “number of candies in bag” data copied in the previous step, select Stat > Summary Stats > Columns. In the popup window, select the name of the column that contains your data, then click “Calculate”. The output can be copied and pasted into your Excel file.

3 pts. Finally, in another worksheet titled “Part 2 Summary”, please summarize the following information from this part of the project:

- Total number and calculated proportions (sample proportions) for each color
- Sample mean number of candies per bag
- Sample standard deviation of mean number of candies per bag
- Written description of the histogram. Describe its shape: normal, skewed, etc. Also identify any potential outliers.
- Sample sizes of this project
- Total number of candies sampled (total of the number of candies in bag column). This is the sample size for all future parts dealing with color proportions.
- Total number of bags sampled (number of rows of data). This is the sample size for all future parts dealing with the mean and standard deviation number of candies per bag.

NOTE: You should be using the combined class data set, not your sample of three bags.

It is imperative that you correctly complete the Part 2 Summary as we will be using the information summarized on that page for ALL the remaining parts of the project. To help keep the sample sizes straight, remember that when you calculated the proportion of each color, you divided by the total number of candies sampled. When you calculated the mean number candies per bag, you divided by the total number of bags.

At the end of this project, you will be writing a report, explaining the method and presenting the results from each part of the project. You might find it useful to write this as you complete the work, so the report will be mostly written by the time it is assigned.

Subject | Mathematics |

Due By (Pacific Time) | 07/30/2013 12:00 am |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |