OrderQuantity 186 Quantity Ordered 2452 From ToPrice per Roll 3492 130$215 4191 3160$195 5356 61120$175 6148 121and up$155 7342 8382 9276 10118 11464 12188 1325 14427 1530 16111 17161 18314 19442 20429 21451 2232 23181 24163 25336 26240 2768 28317 29435 30211 3176 32374 33415 34408 35196 36302 37312 3831 39317 40394 41348 4249 43500 44490 4594 46285 47237 48101 4953 50257 51273 52415 53346 54133 55287 56431 57113 58197 596 60328 61114 62207 63273 64257 65113 66400 67324 68500 6960 70117 71466 72370 73293 74164 7563 76252 77394 78109 79233 80340 81430 82210 83363 84120 85429 86113 87391 88375 89487 9011 91264 9214 93177 94193 95427 96320 97347 9864 99430 100282 10166 102457 103377 10415 105333 10623 107230 108378 109136 110250 111377 112388 113256 114337 115419 116171 117278 118184 119357 120368 121409 122100 123154 124160 125239 126186 127383 128156 129217 130452 131111 132208 133317 13460 135185 136383 13752 138282 139188 14052 141106 142346 143277 144484 145208 146229 147311 148450 149304 150379 15115 15299 153324 154151 155179 156460 157441 158309 15937 160305 161348 16285 163135 164288 165454 166238 16738 168451 169374 170437 171184 172455 Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size:Quantity OrderedFromТоPrice per Roll30$2153160$19561120$175121and up$155Click on the datafile logo to reference the data.DATA file(a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders.(b) Use the COUNTIF function to determine the number of orders in each price bin.FromТоPrice per RollNumber ofOrders130$21583160$19561120$175121and up$155172

Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 120 $175 121 and up $155…

Answered: Quantity Ordered From То Price per Roll…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Related questions

Question

100%






Order	Quantity
1	86	Quantity Ordered
2	452	From	To	Price per Roll
3	492	1	30	$215
4	191	31	60	$195
5	356	61	120	$175
6	148	121	and up	$155
7	342
8	382
9	276
10	118
11	464
12	188
13	25
14	427
15	30
16	111
17	161
18	314
19	442
20	429
21	451
22	32
23	181
24	163
25	336
26	240
27	68
28	317
29	435
30	211
31	76
32	374
33	415
34	408
35	196
36	302
37	312
38	31
39	317
40	394
41	348
42	49
43	500
44	490
45	94
46	285
47	237
48	101
49	53
50	257
51	273
52	415
53	346
54	133
55	287
56	431
57	113
58	197
59	6
60	328
61	114
62	207
63	273
64	257
65	113
66	400
67	324
68	500
69	60
70	117
71	466
72	370
73	293
74	164
75	63
76	252
77	394
78	109
79	233
80	340
81	430
82	210
83	363
84	120
85	429
86	113
87	391
88	375
89	487
90	11
91	264
92	14
93	177
94	193
95	427
96	320
97	347
98	64
99	430
100	282
101	66
102	457
103	377
104	15
105	333
106	23
107	230
108	378
109	136
110	250
111	377
112	388
113	256
114	337
115	419
116	171
117	278
118	184
119	357
120	368
121	409
122	100
123	154
124	160
125	239
126	186
127	383
128	156
129	217
130	452
131	111
132	208
133	317
134	60
135	185
136	383
137	52
138	282
139	188
140	52
141	106
142	346
143	277
144	484
145	208
146	229
147	311
148	450
149	304
150	379
151	15
152	99
153	324
154	151
155	179
156	460
157	441
158	309
159	37
160	305
161	348
162	85
163	135
164	288
165	454
166	238
167	38
168	451
169	374
170	437
171	184
172	455

Transcribed Image Text:Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From То Price per Roll 30 $215 31 60 $195 61 120 $175 121 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From То Price per Roll Number of Orders 1 30 $215 8 31 60 $195 61 120 $175 121 and up $155 172

Expert Solution