You could use your knowledge of profit and MS Excel to indicate when the local mask provider will achieve a profit of around £10.000. You could assume linearity or non-linearity when calculating profit."

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

"You could use your knowledge of profit and MS Excel to indicate when the local mask provider will achieve a profit of around £10.000. You could assume linearity or non-linearity when calculating profit." 

 

AutoSave
On
MN1105 Assignment 20-21 dataset (4) - Last Modified: Yesterday at 21:03 -
MATHUSHQan slk
不
File
Home
Insert
Page Layout
Formulas
Data
Review
View
Help
A Share
O Comments
AInsert v
Σ
Calibri
v 11
A^ A
General
bX Delete
Paste
Conditional Format as
Cell
Sort & Find &
Analyze
Sensitivity
B IU v
% 9 58 8
Format ♥
Formatting
Table v
Styles v
Filter v Select ♥
Data
Clipboard
Font
Alignment
Number
Styles
Cells
Editing
Analysis
Sensitivity
M4
fx
A
В
D
E
G
H
J
K
L
M
N
P
R
S
U
V
W
MASK
NEW
2
USAGE
CASES
3
430
NEW CASES
y = -0.2788x + 375.72
-0.70782
20
345
R? = 0.501
500
5
40
365
450
6
60
365
80
440
400
.........
8
100
325
350
............ .................
9
120
320
300
10
140
330
250
11
160
200
200
12
180
299
150
13
200
300
100
14
220
288
50
15
240
368
16
260
310
100
200
300
400
500
600
17
280
320
18
300
310
19
320
330
20
340
290
21
360
255
22
380
245
23
400
287
24
420
260
25
440
278
26
460
239
27
480
221
Sheet1
DATASET
Sheet3
Sheet2
Sheet4
Sheet5
Ready
囲
+
80%
17:29
O Type here to search
Rain...
») ENG
PDF
09/12/2021
14
Transcribed Image Text:AutoSave On MN1105 Assignment 20-21 dataset (4) - Last Modified: Yesterday at 21:03 - MATHUSHQan slk 不 File Home Insert Page Layout Formulas Data Review View Help A Share O Comments AInsert v Σ Calibri v 11 A^ A General bX Delete Paste Conditional Format as Cell Sort & Find & Analyze Sensitivity B IU v % 9 58 8 Format ♥ Formatting Table v Styles v Filter v Select ♥ Data Clipboard Font Alignment Number Styles Cells Editing Analysis Sensitivity M4 fx A В D E G H J K L M N P R S U V W MASK NEW 2 USAGE CASES 3 430 NEW CASES y = -0.2788x + 375.72 -0.70782 20 345 R? = 0.501 500 5 40 365 450 6 60 365 80 440 400 ......... 8 100 325 350 ............ ................. 9 120 320 300 10 140 330 250 11 160 200 200 12 180 299 150 13 200 300 100 14 220 288 50 15 240 368 16 260 310 100 200 300 400 500 600 17 280 320 18 300 310 19 320 330 20 340 290 21 360 255 22 380 245 23 400 287 24 420 260 25 440 278 26 460 239 27 480 221 Sheet1 DATASET Sheet3 Sheet2 Sheet4 Sheet5 Ready 囲 + 80% 17:29 O Type here to search Rain... ») ENG PDF 09/12/2021 14
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
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 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…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
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
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman