Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited. Data Set: Cereals The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g). Exercise 1: A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market). N = Nabisco, K = Kellog’s, Q = Quaker Oats company, P = Post Holding Inc., K = Kaishi, G = General Mills, R = Ralston Purina B. Construct an ungrouped frequency distribution and histogram for the grams of protein. Include the relative frequencies. Find the descriptive statistics for this variable using the data analysis tool. Describe the shape of the distribution. Interpret your findings in detail. C. Create a scatterplot and explore (discuss) the correlation between the sugar, x and caloric content, y in breakfast cereals. Find and interpret correlation coefficient and the simple linear regression equation (interpret the slope).
Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited. Data Set: Cereals The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g). Exercise 1: A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market). N = Nabisco, K = Kellog’s, Q = Quaker Oats company, P = Post Holding Inc., K = Kaishi, G = General Mills, R = Ralston Purina B. Construct an ungrouped frequency distribution and histogram for the grams of protein. Include the relative frequencies. Find the descriptive statistics for this variable using the data analysis tool. Describe the shape of the distribution. Interpret your findings in detail. C. Create a scatterplot and explore (discuss) the correlation between the sugar, x and caloric content, y in breakfast cereals. Find and interpret correlation coefficient and the simple linear regression equation (interpret the slope).
MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
Related questions
Question
Part 2. Refer to the Excel file Cereal data set to complete the following tasks. All results and explanations need to be reported within this Word document after each question. Make sure to use complete sentences when explaining your results. Your results should be formatted and edited.
Data Set: Cereals
The data set shows the name of different brands of cereals, the manufacturers, the total calories, proteins, sugar, fat, potassium, sodium, location of the shelf in the supermarket, etc. The amount of sugar, protein, etc., is measured in grams (g).
Exercise 1:
A. Construct a frequency distribution and a bar graph for the cereal manufactures (mfr). Include the relative frequencies. Edit and format the graph and include appropriate labels for the horizontal and vertical axes. Describe your findings in the context of the problem (Include which manufacturer produces the most cereals and least number of cereals in the cereal market).
N = Nabisco, K = Kellog’s, Q = Quaker Oats company, P = Post Holding Inc., K = Kaishi, G = General Mills, R = Ralston Purina
B. Construct an ungrouped frequency distribution and histogram for the grams of protein. Include the relative frequencies. Find the descriptive statistics for this variable using the data analysis tool. Describe the shape of the distribution. Interpret your findings in detail.
C. Create a scatterplot and explore (discuss) the correlation between the sugar, x and caloric content, y in breakfast cereals. Find and interpret correlation coefficient and the simple linear regression equation (interpret the slope).
Transcribed Image Text:1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
100% Bran
100% Natural Bran
Name
A
All-Bran
All-Bran with Extra Fiber
Almond Delight.
Annle Cinnamon Cheerios
Annle Jacks
Basic 4
Bran Chexi
Bran Flakes.
Can'n'Crunch
Cheerios
Cinnamon Toast Crunch.
Clusters
Cocoa Puffs
Corn Chex
Corn Flakes
Comn Pons.
Count Chocula
Cracklin' Oat Bran
Cream of Wheat (Quick).
Crisnix
Crisny Wheat & Raisins
Double Chex
Froot Loons
Frosted Flakes.
Frosted Mini-Wheats
Fruit & Fibre Dates. Walnuts. and Oats
Fruitful Bran
Fruity Pebbles.
Golden Crisn
Golden Grahams
Grane-Nuts
Grane Nuts Flakes
Great Grains Pecan.
Honev-comb
Honey Graham Ohs
Honey Nut Cheerios
Kix
Life
Just Right Crunchy Nuggets
Just Right Fruit & Nut
Lucky Charms
Muesli Raisins Dates & Almonds.
Muesli Raisins Peaches & Pecans.
Mueslix Crisny Blend
Multi-Grain Cheerios
Nut&Honey Crunch.
Nutri-Grain Almond-Raisin
Nutri-grain Wheat
Oatmeal Raisin Crisn.
Post Nat. Raisin Bran
Product 19.
Puffed Rice
Puffed Wheat
Quaker Oat Sanares.
Ouaker Oatmeal.
Raisin Bran
Raisin Nut Bran
Raisin Sanares
Rice Chex
Rice Krisnies
Shredded Wheat
Shredded Wheat 'n'Bran
Shredded Wheat snoon size.
Smacks
Special K
Strawberry Fruit Wheats
Total Corn Flakes
Total Raisin Bran.
Total Whole Grain
Trinles
Trix
Wheat Chexi
Wheaties
Wheaties Honey_Gold
mfr
N
0
K
K
R
G
K
G
R
P
0
G
G
G
G
R
K
K
K
N
K
R
K
K
K
P
K
P
P
P
P
P
P
0
G
K
K
G
0
G
R
R
K
K
K
K
P
K
0
0
0
0
K
G
K
R
K
N
N
N
K
K
N
G
G
G
G
G
R
G
G
70
50
110
110
110
130
90
90
120
calories sugars (g) carbo (g) protein (g) fat (mg) sodium (mg) fiber (g) potassium (mg)
70
6
5
4
1
130
10
280
120
8
8
5
15
2
135
5
7
1
260
320
8
140
330
200
180
110
120
110
110
110
100
110
110
110
100
110
100
100
110
110
100
120
120
110
100
110
110
100
120
110
120
110
110
140
110
100
110
150
150
160
100
120
140
90
130
120
100
50
50
100
100
120
100
90
110
110
80
90
90
110
110
90
110.
140
100
110
110
100
100
110
0
8
10
14
8
6
5
12
1
9
7
13
3
2
12
13.
7
0
3
10
5
13
11
7
10
12
12
15
9
3
5
4
11
11
10
6
9
3
6
D
12
11
11
13
6
9
7
2
10
14
3
0
0
6
0
12
8
6
2
3
0
0
0
15
3
5
3
14
3
3
12
3
3
8
14
10.5.
11
18
15
13
12
17
13
13
12
22
21
12
10
21
21
11
18
11
14
14
12
14
13
11
15
17
15
13
14
12
11.5
17
20
21
12
12
16
16
17
15
15
21
18
13.5
11
20
13
10
14
18
14
10.5
15
23
22
16
19
20
9
16
15
21
15
16
21
13
17
17
16
3
4
4
2
2
2
3
2
3
1
6
1
3
1
2
2
1
1
3
3
2
2
2
2
1
3
3
3
1
2
1
3
3
3
1
1
3
2
3
2
4
2
4
4
3
2
2
3
3
3
3
3
1
2
4
5
3
3
2
1
2
2
3
3
2
6
2
2
3
3
2
1
3
3
2
0
2
2
0
2
1
0
2
2
3
2
1
0
0
0
1
3
0
0
1
0
1
0
0
2
0
1
0
1
0
1
3
0
2
1
1
1
1
2
1
3
3
2
1
1
2
0
2
1
0
0
0
1
2
1
2
0
0
0
0
0
0
1
0
0
1
1
1
1
1
1
1
1
125
210
200
210
220
290
210
140
180
280
290
90
180
140
80
220
140
190
125
200
0
160
240
135
45
280
170
140
75
180
220
250
170
170
260
150
180
95
150
150
220
190
220
170
170
200
320
0
0
135
0
210
140
0
240
290
0
0
0
70
230
15
200
190
200
250
140
230
H
200
200
9
14
1
1.5
1
2
4
5
0
2
0
2
0
0
1
1
0
4
1
1
2
1
1
1
3
5
5
0
0
0
3
3
3
0
1
1.5
1
2
0
2
0
3
3
3
2
0
3
3
1.5
6
1
0
1
2
27
5
2.5
2
0
0
3
4
3
1
1
3
0
4
3
0
0
3
3
1
70
30
100
125
190
35
105
45
105
55
25
35
20
65
160
30
120
80
30
25
100
200
190
25
40
45
90
85
100
35
45
90
60
95
40
95
55
170
170
160
90
40
130
90
120
260
45
15
50
110
110
240
140
110
30
35
95
140
120
40
55
90
35
230
110
60
25
115
110
60
shelf
3
3
3
3
3
1
2
3
1
3
2
1
2
3
2
1
1
2
2
2
3
3
3
2
1
2
3
3
2
1
2
3
3
1
2
1
3
3
2
2
2
3
3
3
1
2
3
3
3
3
3
3
3
1
2
3
3
1
1
1
1
1
2
1
2
3
3
3
3
2
1
1
1
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 5 images
Recommended textbooks for you
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman