I went to the grocery store and compiled this Cereal Data, which contains information about common breakfast cereals. Column 1 contains the name of the cereal. Columns 2 through 10 contain nutritional information about the cereals. Column 11 contains a popularity rating that was determined by having a variety of other customers (not me) review and score the cereals. You can assume that the customer survey study was conducted properly, that all of the variables in this data set are continuous, that all data values are correct, etc. • Are any of these variables irrelevant with respect to the customer ratings? . I have developed a new cereal with the following profile. Will it achieve a higher popularity rating than that of Cheerios in the population at large? name calories protein fat NEWCEREAL 172 5 1 2 sodium fiber carbo sugars potass vitamins 107.5 10 1 6 41 0 My favorite cereal on this list is Frosted Mini-Wheats, but when I went to the grocery store, they were sold out. So, I had to settle for something similar. Which cereal did I buy instead? Hint: You were not given my preferences here, and my "favorite" is halfway down the list of rankings. That might be an indication that I am an outlier and have a large residual. Your regression model wasn't built on my data, so its results may not (will not) apply to me. A different sort of argument will be needed here...

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question

Need help with this Intro to Probability and Statistics homework problem. Below the homework problem is a picture of the Cereal Data in Excel that will be used for this problem. Make sure your handwriting is neat and readable.

 

I went to the grocery store and compiled this Cereal Data, which contains
information about common breakfast cereals. Column 1 contains the name of
the cereal. Columns 2 through 10 contain nutritional information about the
cereals. Column 11 contains a popularity rating that was determined by having
a variety of other customers (not me) review and score the cereals. You can
assume that the customer survey study was conducted properly, that all of the
variables in this data set are continuous, that all data values are correct, etc.
• Are any of these variables irrelevant with respect to the customer ratings?
• I have developed a new cereal with the following profile. Will it achieve a
higher popularity rating than that of Cheerios in the population at large?
name
calories protein fat
NEWCEREAL 172
5
1
2
119
sodium fiber carbo sugars potass vitamins
1
107.5
10
6
41
0
• My favorite cereal on this list is Frosted Mini-Wheats, but when I went
to the grocery store, they were sold out. So, I had to settle for something
similar. Which cereal did I buy instead? Hint: You were not given my
preferences here, and my "favorite" is halfway down the list of rankings.
That might be an indication that I am an outlier and have a large residual.
Your regression model wasn't built on my data, so its results may not (will
not) apply to me. A different sort of argument will be needed here...
Transcribed Image Text:I went to the grocery store and compiled this Cereal Data, which contains information about common breakfast cereals. Column 1 contains the name of the cereal. Columns 2 through 10 contain nutritional information about the cereals. Column 11 contains a popularity rating that was determined by having a variety of other customers (not me) review and score the cereals. You can assume that the customer survey study was conducted properly, that all of the variables in this data set are continuous, that all data values are correct, etc. • Are any of these variables irrelevant with respect to the customer ratings? • I have developed a new cereal with the following profile. Will it achieve a higher popularity rating than that of Cheerios in the population at large? name calories protein fat NEWCEREAL 172 5 1 2 119 sodium fiber carbo sugars potass vitamins 1 107.5 10 6 41 0 • My favorite cereal on this list is Frosted Mini-Wheats, but when I went to the grocery store, they were sold out. So, I had to settle for something similar. Which cereal did I buy instead? Hint: You were not given my preferences here, and my "favorite" is halfway down the list of rankings. That might be an indication that I am an outlier and have a large residual. Your regression model wasn't built on my data, so its results may not (will not) apply to me. A different sort of argument will be needed here...
A33
1
2 100% Brar
3 Apple Jack
4 Cap'n'Cru
5 Cocoa Pul
6 Cheerios
7 Cinnamor
8 Corn Flake
9 Froot Loo
10 Frosted Fla
11 Frosted M
12 Fruity Peb
13 Honey Nu
14 Rice Krispi
15 Special K
16 Trix
H
A
B
с
name calories protein
17 Wheaties
18 Lucky Cha
19 Multi-Grai
20 Puffed Wh
21 Quaker O
22 Raisin Bra
23
24
25
26
27
28
29
30
31
32
33
X
70
110
120
110
110
120
100
110
110
100
110
110
110
110
110
100
110
100
50
100
120
4
2
1
1
6
1
2
2
1
3
1
3
2
6
1
3
2
WUNNN
2
2
3
D
fat
1
0
2
1
2
3
0
1
0
0
1
1
0
0
1
1
1
1
0
2
1
E
sodium
130
125
220
180
290
210
290
125
200
0
135
250
290
230
140
200
180
220
0
0
210
F
fiber
10
1
0
0
ONO
2
0
1
1
1
3
0
1.5
0
1
0
3
mo
0
2175
G
carbs
SHZZTHIS
5
11
12
12
17
13
21
11
14
14
13
11.5
22
16
13
17
12
15
10
-1
14
H
I
sugars potassium vitamins
6 14 12 13
1
9
231
11
7
12
10
3
3
12
3
12
6
0
-1
12
rating
280 3.584322 68.40297
30 5.064149 33.17409
35 3.022168 18.04285
55 19.29149 22.73645
105 23.35564 50.765
45 8.383294 19.82357
35 20.07341 45.86332
30 5.098102 32.20758
25 1.370329 31.43597
100 10.28117 58.34514
25 14.30471 28.02577
90 10.01294 31.07222
35 12.61185 40.56016
55 7.694464 53.13132
25 0.42904 27.7533
110 6.46536 51.59219
55 2.862842 26.73452
90 15.11069 40.10597
50 7.013022 63.00565
110 9.116594 50.82839
240 3.942934 39.2592
L
M
N
O
P
Q
R
S
T
U
V
W
Transcribed Image Text:A33 1 2 100% Brar 3 Apple Jack 4 Cap'n'Cru 5 Cocoa Pul 6 Cheerios 7 Cinnamor 8 Corn Flake 9 Froot Loo 10 Frosted Fla 11 Frosted M 12 Fruity Peb 13 Honey Nu 14 Rice Krispi 15 Special K 16 Trix H A B с name calories protein 17 Wheaties 18 Lucky Cha 19 Multi-Grai 20 Puffed Wh 21 Quaker O 22 Raisin Bra 23 24 25 26 27 28 29 30 31 32 33 X 70 110 120 110 110 120 100 110 110 100 110 110 110 110 110 100 110 100 50 100 120 4 2 1 1 6 1 2 2 1 3 1 3 2 6 1 3 2 WUNNN 2 2 3 D fat 1 0 2 1 2 3 0 1 0 0 1 1 0 0 1 1 1 1 0 2 1 E sodium 130 125 220 180 290 210 290 125 200 0 135 250 290 230 140 200 180 220 0 0 210 F fiber 10 1 0 0 ONO 2 0 1 1 1 3 0 1.5 0 1 0 3 mo 0 2175 G carbs SHZZTHIS 5 11 12 12 17 13 21 11 14 14 13 11.5 22 16 13 17 12 15 10 -1 14 H I sugars potassium vitamins 6 14 12 13 1 9 231 11 7 12 10 3 3 12 3 12 6 0 -1 12 rating 280 3.584322 68.40297 30 5.064149 33.17409 35 3.022168 18.04285 55 19.29149 22.73645 105 23.35564 50.765 45 8.383294 19.82357 35 20.07341 45.86332 30 5.098102 32.20758 25 1.370329 31.43597 100 10.28117 58.34514 25 14.30471 28.02577 90 10.01294 31.07222 35 12.61185 40.56016 55 7.694464 53.13132 25 0.42904 27.7533 110 6.46536 51.59219 55 2.862842 26.73452 90 15.11069 40.10597 50 7.013022 63.00565 110 9.116594 50.82839 240 3.942934 39.2592 L M N O P Q R S T U V W
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON