Question Set 1

Use the Insert > Equation function in Canvas to write the formula for a population mean. Hint: Click on the Greek tab to find the symbols for the population mean (u) and for summation ().

Question 2- This question set uses the 'Lab 2 Cereal Data.CSV' dataset obtained from Kaggle.

Before you answer the questions below:

1. Download the 'Lab 2 Cereal Data.CSV' file.
2. Open Minitab (http://app.minitab.com)
3. In Minitab, choose File > Open > Worksheet and browse to the CSV file.

These data were collected from a sample of 75 cereals and their nutritional values. The calories variable informs about the calories per serving, protein informs about the number of grams of proteins, and sugars inform about the grams of sugars in that cereal.

Question Set 2_A:

Using Minitab, construct a histogram of calories.

• Choose Graph > Histogram > One Variable, Simple.
• Double-click on the Calories variable located in the list box on the left
• Click OK

Take a screenshot or snip of your histogram and save it as a JPG or PNG on your computer. Then, insert your graph here using Insert > Image > Upload Image.

Question Set2_B:

Using Minitab, construct a dotplot of calories.

• Choose Graph > Dotplot > One Y Variable, Simple
• Double-click on the Calories variable located in the list box on the left
• Click OK

Insert your graph here. (Similar to the last question, take a screenshot or snip of your dotplot, save it as a JPG or PNG and use Insert > Image > Upload Image.)

Question Set2_C:

Describe the shape of the distribution of the calories variable. Specifically, is the data bell-shaped, left skewed, or right skewed? Explain your answer.

Question Set2_D:

Using Minitab, compute the mean, median, mode, standard deviation, and variance of the protein variable.

• Choose Stat > Basic Statistics > Display Descriptive Statistics
• Double-click on the Proteinvariable located in the list box on the left
• Click Statistics
• Select the statistics you need
• Click OK

Insert your screenshot here. (Similar to the questions above, take a screenshot or snip of your results, save it as a JPG or PNG and use Insert > Image > Upload Image.)

Question Set2_E:

Using Minitab, construct a frequency table for the sugars variable.

• Choose Stat > Tables > Tally Individual Variables
• Double-click on the Sugarsvariable located in the list box on the left
• Click OK

Insert your screenshot using Insert > Image > Upload Image.

Question Set2_F:

Per your frequency table results, what percent of cereals in this sample have 12 or more grams of sugar? Show how you computed this.

Question Set2_G:

Using Minitab, construct a pie chart to display the number of cereals for each manufacturer.

• Choose Graph > Pie Chart > Counts of Unique Values
• For Categorical variables, double-click on the Mfr variable
• Click Options
• For Label Slices With, select Frequency
• Click OK

Insert your screenshot using Insert > Image > Upload Image.

Question Set 2_H:

Using Minitab, construct a bar chart to display number of cereals for each manufacturer.

• Choose Graph > Bar Chart > Counts of Unique Values > One Variable
• For Categorical variable, double-click on the Mfr variable
• Click OK

Insert your screenshot using Insert > Image > Upload Image.

Question Set 2_I:

Considering the pie chart and bar chart you created above, which one of the two charts is a better option for visually displaying the data? Specify your preference and explain why. (Any reasonable answer will earn full credit.)

Question Set 2_J:

Please find and upload a screenshot of a Bar Chart or Pie Chart from a news or academic site. Explain what the chart does well or poorly. Please be sure to include the URL link.

LINK TO Lab 2 Cereal Data.xlsx: https://1drv.ms/x/s!Aj_pQpiSrV7orA01HS3OR_aYa3h6?e=fZchq4