MRO MGT555 Individual assignment 1 Nur Damia Hananni binti Amiruddin PDF

Preview

Summary

1INTRODUCTION TO BUSINESS ANALYTICS(MGT555)INDIVIDUAL ASSIGNMENT 1PREPARED BY:NUR DAMIA HANANNI BINTI AMIRUDDIN(2018682744)PREPARED FOR:DR. FAIZAH MASHAHADISUBMISSION DATE:22/05/ Illustrate using infographic the classification of research data NUMBER AND TYPES OF CEREAL 1. 11111111111111111111111111...

Description

INTRODUCTION TO BUSINESS ANALYTICS (MGT555) INDIVIDUAL ASSIGNMENT 1 PREPARED BY: NUR DAMIA HANANNI BINTI AMIRUDDIN (2018682744) PREPARED FOR: DR. FAIZAH MASHAHADI SUBMISSION DATE: 22/05/2020 1

1. Illustrate using infographic the classification of research data

2. Introduce the data This report presents the analysis of data collected from the cereal data. The data is classified as non-numerical data which collected through methods of observations, oneto-one interviews, conducting focus groups, and similar methods. Qualitative data in statistics is also known as categorical data and can be arranged categorically based on the attributes and properties of a thing or a phenomenon. Qualitative data that fits the cereal data is nominal data. The values of the data cannot be arrange in any particular order. For example the Post’s manufacture produced six types of cereals which are Cap’n’Crunch, Honey Graham Ohs, Life, Puffed Rice, Puffed Wheat and Quaker Oat Squares. Based on the cereal data and the infographic attached, there are 67 types of cereals produced by six manufacturers. The manufacturers involved in this cereal data are General Mills, Kellogg, Nabisco, Post, Quaker and Ralston Purina. Also, there are five kinds of nutritions contained in the cereals which are calories, sodium, fibre, carbs and sugars. This report solely focuses on presenting and analyzing the gathered data using a PivotTable, PivotChart, basic excel functions and descriptive statistics.

3. a) Number and manufacturers involved in the study.

TOTAL NUMBER AND MANUFACTURERS 25 20

21

20 General Mills Kellogg Nabisco Post Quaker

15 10 8 66

6

5 Ralston Purina 0 General Mills

Kellogg

Nabisco

Post

QuakerRalston Purina

Total Number and Manufacturers

6

Based on the chart above, there are six total number of manufacturers involved in this data which are General Mills, Kellogg, Nabisco, Post, Quaker and Ralston Purina. The chart shows that Kellogg is the most highest in manufacturing cereals. Kellogg produced around 21 types of cereals. Meanwhile, Nabisco, Quaker and Ralston Purina produced the less number of cereals which are six. On the other hand, General Mills is the second highest with 20 types of cereals manufactured and Post has manufactured around eight different types of cereals.

b) Number and types of cereal

NUMBER AND TYPES OF CEREAL 1.2 1111111111111111111111111111111111111111111111111111111111111111111

100% Bran AlI-Bran

1 0.8

All-Bran w/Extra Fiber 0.6

Almond Delight

0.4

Apple Cinn Cheerios Apple Jacks Basic 4 Bran Chex Bran Flakes Cap'n'Crunch

Crunch Almond Delight 100% Bran

0.2 0

Number and Types of Cereal

Cheerios Cinnamon Toast Crunch

67

The chart shows that there are 67 of cereals name and the number for each cereal is one. Each cereals are manufactured by the five manufactures stated earlier. The name for each cereals can be referred in excel’s data.

c) Types of cereal manufactured by each manufacturer i. General Mills

Row Labels

Count of Manufacturer

General Mills Apple Cinn Cheerios Basic 4 Cheerios Cinnamon Toast Crunch Clusters Cocoa Puffs Count Chocula Crispy Wheat & Raisins Golden Grahams Honey Nut Cheerios Kix Lucky Charms Multi-Grain Cheerios Oatmeal Raisin Crisp Total Corn Flakes Total Raisin Bran Total Whole Grain Trix Wheaties Wheaties Honey Gold Grand Total

20 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 20

The total number of cereal manufactured by General Mills are 20. It is consider as the second highest in manufacturing cereals amongs the six manufacturers.

ii. Kellogg

Row Labels Kellogg AlI-Bran All-Bran w/Extra Fiber Apple Jacks Corn Flakes Corn Pops Cracklin' Oat Bran Crispix Froot Loops Frosted Flakes Frosted Mini-Whests Fruitful Bran Just Right Crunchy Nugget Just Right Fruit &Nut Mueslix Crispy Blend Nut & Honey Crunch Product 19 Raisin Bran Raisin Squares Rice Krispies Smacks Special K Grand Total

Count of Manufacturer 21 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 21

Kellogg manufactured 21 kinds of cereals and the highest cereal manufacturer among the others.

iii. Nabisco

Row Labels

Count of Manufacturer

Nabisco 100% Bran Cream of Wheat Shrdded Wht Spn Size Shredded Wheat Shredded Wheat n Bran Strawberry Fruit Wheels Grand Total

6 1 1 1 1 1 1 6

Total number of cereals manufactured by Nabisco are six. Nabisco is considered amongst the lowest manufacturer that produced different kind of cereals.

iv. Post

Row Labels Post Bran Flakes Fruit & Fibre Fruity Pebbles Grape Nuts Flakes Grape-Nuts Great Grains Pecan Honey Comb Post Nat. Raisin Bran Grand Total

Count of Manufacturer 8 1 1 1 1 1 1 1 1 8

Post manufactured a total of eight cereals and the it is the second lowest of cereal manufacture.

v. Quaker

Row Labels Quaker Cap'n'Crunch Honey Graham Ohs Life Puffed Rice Puffed Wheat Quaker Oat Squares Grand Total

Count of Manufacturer 6 1 1 1 1 1 1 6

Quaker amongst the lowest cereal manufacturer along with Nabisco and Ralston Purina with a value of six kinds of cereals.

vi. Ralston Purina

Row Labels

Count of Manufacturer

Ralston Purina Almond Delight Bran Chex Corn Chex Double Chex Rice Chex Wheat Chex Grand Total

6 1 1 1 1 1 1 6

Ralston Purina manufactured six types of cereals and it is also the lowest manufacturer of cereals compared to the the other three manufacturer.

d) Cereal with the highest and lowest calories Highest Calories Lowest Calories

160 50

CEREAL WITH HIGHEST CALORIES 180 160 140 120 100 80 60 40 20 0

160

Total

Mueslix Crispy Blend

CEREAL WITH LOWEST CALORIES 60 50

50 50

50

4 All-Bran w/Extra Fiber Puffed Rice Puffed Wheat

3 2 10 0 All-Bran w/Extra Fiber

Puffed Rice

Puffed Wheat

The chart above shows the name of cereal that contained a highest and lowest calories. The highest calories in the cereal data is Mueslix Crispy Blend which is manufactured by Kellogg with 160 kcal. There are three name of cereals which listed under the cereal with lowest calories (All-Bran w/Extra Fiber, Puffed Rice, Puffed Wheat) which contained only 50 kcal. Puffed Rice and Puffed Wheat are manufactured by Quaker, meanwhile All-Brand is by Kellogs. The three lowest calories are definitely good for health and can be consumed for people who wanted to go for a diet. The highest and lowest calories can be count using the basic excel functions (min:max).

e) Cereal with the highest and lowest sugar Highest sugar Lowest sugar

15 0

CEREAL WITH HIGHEST SUGARS 1615 14 12 10 8 6 Smacks 4 2 0 Smacks

CEREAL WITH LOWEST SUGARS 1 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 0

Total

0

0

0

All-Bran Cream of Puffed w/ExtraWheat Fiber Rice

0

0

0

0

Puffed Shrdded Shredded Shredded Wheat Wht Spn Wheat Wheat n Size Bran

Based on the charts above, out of the total 67 cereals, Smacks has the highest level of sugars with 15g of it. Smacks is manufactured by Kellogg. However, there are seven cereals which has no sugars in it. These cereals are All-Bran w/Extra Fiber, Cream of Wheat, Puffed Rice, Puffed Wheat, Shrdded Wht Spn Size, Shredded Wheat and Shredded Wheat n Bran. These none sugary cereals can be a healthy breakfast for all ages and particularly important if you want to avoid a blood sugar crash later. The highest and lowest sugars can be count using the basic excel functions (min:max).

f) Average cereal calories produced by the manufactures Average Calories

105.5224

The total everage calories produced by manufactures is 105.5224 kcal. This implies that amongst the 67 cereals, most of the cereals contained at least 150 kcal in it. The average of calories can be obtained using the basic excel function (=average(data range)). i. General Mills Row Labels General Mills Apple Cinn Cheerios Basic 4 Cheerios Cinnamon Toast Crunch Clusters Cocoa Puffs Count Chocula Crispy Wheat & Raisins Golden Grahams Honey Nut Cheerios Kix Lucky Charms Multi-Grain Cheerios Oatmeal Raisin Crisp Total Corn Flakes Total Raisin Bran Total Whole Grain Trix Wheaties Wheaties Honey Gold Grand Total

Average of Calories 112 110 130 110 120 110 110 110 100 110 110 110 110 100 130 110 140 100 110 100 110 112

As for General Mills, the average calories that this manufacture produced in total of 20 cereals is 112 kcal. It has the highest average calories compared to the other manufacturers. Based on the chart and table, Total Raisin Bran contained the highest calories with 140 kcal. The cereals with lowest calories produced by General Mills are Multi-Grain Cheerios, Total Whole Grain and Wheaties.

ii. Kellogg

Kellogg

Average of Calories 108.0952381

AlI-Bran All-Bran w/Extra Fiber Apple Jacks Corn Flakes Corn Pops Cracklin' Oat Bran Crispix Froot Loops Frosted Flakes Frosted Mini-Whests Fruitful Bran Just Right Crunchy Nugget Just Right Fruit &Nut Mueslix Crispy Blend Nut & Honey Crunch Product 19 Raisin Bran Raisin Squares Rice Krispies Smacks Special K Grand Total

70 50 110 100 110 110 110 110 110 100 120 110 140 160 120 100 120 90 110 110 110 108.0952381

Row Labels

Kellogg has an average of 108.10 kcal in total of 21 cereals. The cereal with highest calories manufactured by Kellogg is Mueslix Crispy Blend with 160 kcal. The lowest would be AllBran w/Extra Fiber with 50 kcal only.

iii. Nabisco Row Labels Nabisco

Average of Calories 86.66666667 70 100 90 80 90 90

100% Bran Cream of Wheat Shrdded Wht Spn Size Shredded Wheat Shredded Wheat n Bran Strawberry Fruit Wheels Grand Total

86.66666667

Nabisco has the lowest average calories (86.67 kcal) compared to the other six manufacturers. The highest calories of cereal manufactured by Nabisco is Cream of Wheat with 100 kcal. Meanwhile, the lowest calories of cereal is 100% Bran (70 kcal).

iv. Post Row Labels Post

Average of Calories 110

Bran Flakes Fruit & Fibre Fruity Pebbles Grape Nuts Flakes

90 120 110 100

Grape-Nuts Great Grains Pecan Honey Comb Post Nat. Raisin Bran

110 120 110 120

Grand Total

110

Post ranked as the second highest for having a high average of calories (110kcal). Post manufactured eight types of cereals and the cereals that has a higher number of calories in it serving are Great Grains Pecan and Post Nat. Raisin Bran with 120 kcal. Cereal that has lower calories is Bran Flakes (90 kcal).

v. Quaker Average of Calories

Row Labels

90

Quaker Cap'n'Crunch Honey Graham Ohs Life Puffed Rice Puffed Wheat Quaker Oat Squares

120 120 100 50 50 100

Grand Total

90

Quaker placed as a second lower for having a less average of calories in its cereals. Cap’n’Crunch and Honey Graham Ohs are cereals that produced by Quaker and has the most highest calories with 120 kcal. The cereals that has less calories produced by this manufacture are Puffed Rice and Puffed Wheat (50 kcal).

vi. Ralston Purina Row Labels

Average of Calories

Ralston Purina

103.3333333

Almond Delight Bran Chex Corn Chex Double Chex Rice Chex Wheat Chex Grand Total

110 90 110 100 110 100 103.3333333

Ralston Purina has an average of 103,33 kcal in total of its six cereals. The highest calories of cereals that this manufacture produced are Almond Delight, Corn Chex and Rice Chex (110kcal). In addition, the cereal with lowest calories produced by Ralston is Bran Chex with 90 kcal.

g) Measure of central tendency and shape of calories Measure of Central Tendencies Calories Statistics Mean 105.5223881 Median 110 Mode 110 Measure of Shape Calories Statistics 2.904213917 Kurtosis Skewness -0.806501802

Measure of central tendency is a measure that indicates the centre location of the distribution of a set of data. It shows the shape and nature of distribution. The there most common measures of central tendency are mean, median and mode. The table above shows the numbers obtained from the cereal data. The mean of calories is 105.52, the mean calculated by dividing the sum of all of the observationbs by the number of data values. Median is the middle value in calories data which is 110. Meanwhile, mode is the data in calories that occurs ofthen, hence 110 is the value. Skewness for calories is -0.81, it is negative, the data are negatively skewed or skewed left, meaning that the left tail is longer. The value of skewness is between −½ and +½, hence the distribution is approximately symmetric. The kurtosis of calories is 2.91, hence the data is widely spread around the mean. Compared to a normal distribution, its tails are shorter and thinner, and often its central peak is lower and broader.

4. Conclusion In this report, data analysis methods, PivotChart, PivotTable, basic excel functions and descriptive statistics have been presented. The cereal data is shown as non-numerical data and categorized as nominal data under qualitative. Followed by the introduction of how the data is presented and analysis of the data. The cereal data consist of 67 names of cereals, 6 manufacturers and other form of nutritions with its own data which is calories, fibre, sodium, carbs and sugars. The total number of manufactures in 3.a) indicates the amount of manufacturers involved in this data which are six. Next, 3.b) shows the number of cereals that are being produced by the manufacturer. Kellogg has the highest number of cereals (21). As for 3.c) it shows the list of cereals name for each manufacturers. This data reported the amount of calories contains in each cereals and the highest calories in data is 160 kcal and the lowest is 50 kcal. The amount of sugars in cereals are stated and based on the chart and table attached, the highest is 15 and the lowest is 0, means that there are nonsugary cereals. The average calories amounting to 105.52, produced by manufacturer implies the amount of calories which are majority include in the 67 cereals. Finally, the measure of descriptive statistics helps describe, show and summarize data in a meaningful way such that, for example, patterns might emerge from the data. (1375 words)...