Determine the following using Microsoft Excel: A. Mean B. Median C. Mode D. Range E. Standard deviation F. Variance

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

number 2 table only

The records are kept as below.
1. Heights of plants in cm
77
74 75 1 60 72 75
71
93
NIL LAGUNA
76
85
53
68
83
71
53
85
62
71
95
69
60
75
62
75
EGGS
No of
days
85
53
71
83
68
63
85
76
3
63
78
462
98
85
90
480
75
75
2. Weights of goats in kg
77
62
No. of
goats
3. Number of laid eggs
93
Weight 118-126 127-135
(Kg)
5
68
75
498
55
75 4 75 85 88 75
94
60
75
82
81
73
10
87
75
61
136-144
516
42
97
57
89
85
82
75
56
58
145-153
12
75
87
88
76
89
45
56
36
534
30
154-162 163-171
5
сл
79
87
61
66
96
79
65
86
552
21
570
25
4
588
11
4. Delivery time of milk
Time in minutes 90-99
No. of days
9
172-180
2
606
6
624
2
80-89
32
ACTIVITY 4
70-79
43
60-69
21
50-59
11
40-49
3
30-39
1
Transcribed Image Text:The records are kept as below. 1. Heights of plants in cm 77 74 75 1 60 72 75 71 93 NIL LAGUNA 76 85 53 68 83 71 53 85 62 71 95 69 60 75 62 75 EGGS No of days 85 53 71 83 68 63 85 76 3 63 78 462 98 85 90 480 75 75 2. Weights of goats in kg 77 62 No. of goats 3. Number of laid eggs 93 Weight 118-126 127-135 (Kg) 5 68 75 498 55 75 4 75 85 88 75 94 60 75 82 81 73 10 87 75 61 136-144 516 42 97 57 89 85 82 75 56 58 145-153 12 75 87 88 76 89 45 56 36 534 30 154-162 163-171 5 сл 79 87 61 66 96 79 65 86 552 21 570 25 4 588 11 4. Delivery time of milk Time in minutes 90-99 No. of days 9 172-180 2 606 6 624 2 80-89 32 ACTIVITY 4 70-79 43 60-69 21 50-59 11 40-49 3 30-39 1
Determine the following using Microsoft Excel:
A. Mean
B. Median
C. Mode
D. Range
E. Standard deviation
F. Variance
Transcribed Image Text:Determine the following using Microsoft Excel: A. Mean B. Median C. Mode D. Range E. Standard deviation F. Variance
Expert Solution
steps

Step by step

Solved in 9 steps with 14 images

Blurred answer
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