alculate and interpret the following using Excel for the winning teams’ points, losing teams’ points and the total number of points: Mean Median Mode Variance Standard Deviation

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

Required

  1. Calculate and interpret the following using Excel for the winning teams’ points, losing teams’ points and the total number of points:
  2. Mean
  3. Median
  4. Mode
  5. Variance
  6. Standard Deviation

Pls calculate using excel

Paste
K8
A
1
2
8
File
3
4
5
6
7
8
9
10
Cut
E Copy
A
Ready
A
+
Clipboard
15
18 16
19
20
Home
Game #
1
2
3
4
5
6
7
8
11 9
12 10 SOUTH AFRICA 7S
13
11
14
12
15
13.
16
14
17
17
18
19
20
21
22
23 21
24
22
25
23
26
24
27
>
Format Painter
B
Insert Page Layout
Winner Team
SOUTH AFRICA 7S
FUJI 75
ARGENTINA 7S
SAMOA 7S
IRELAND 7S
NEW ZEALAND 7S
USA 7S
AUSTRALIA 7S
ARGENTINA 75
FIJI 7S
JAPAN 7S
X
FRANCE 7S
TONGA 7S
0
Calibri
Sheet1
BIU H.
с
21
26
USA 7S
14
NEW ZEALAND 75
21
SOUTH AFRICA 75 17
FIJI 75
CANADA 7S
USA 7S
22
12
28
26
FRANCE 7S
IRELAND 7S
33
AUSTRALIA 7S
36
NEW ZEALAND 7S
19
Points
34
26
20
31.
14
45
40
28
29
19
21
24
fx
Font
D
E
Hamilton Sevens 2023 Results
Points
Losing Team
CANADA 7S
5
FRANCE 7S
10
SPAIN 7S
5
KENYA 7S
5
12
0
12
14
14
SPAIN 7S
KENYA 7S
Formulas
11
URUGUAY 7S
TONGA 7S
JAPAN
GREAT BRITAIN 7S
CANADA 7S
SAMOA 7S
SPAIN 7S
Type here to search
URUGUAY 7S
SAMOA 7S
GREAT BRITAIN 7S
IRELAND 75
AUSTRALIA 7S
ARGENTINA 75
URUGUAY 7S
KENYA 7S
JAPAN 7S
TONGA 7S
GREAT BRITAIN 7S
* Α Α
A
- A
N
12
7
19
10
21
14
19
14
12
5
12
21
12
7
12
A
Data
Review
F
25
36
26
45
52
42
43
31
28
43
Total Points In The Match
39
36
31
47
28
40
31
34
17
40
47
45
43
31
View
Alignment
[
ab Wrap Text
G
Copy of ECN810 ASSIGNMENT 1_1675312143 - Excel
Tell me what you want to do
Help
Merge & Center ▾
DAY 1
H
T
F
General
$ % 9
J
Number
X
K
0 .00
.00 .0
Cell
Conditional Format as
Formatting Table Styles
Styles
L
M
4
N
O
LU
←
H
Insert Delete Format
▼
P
11
Cells
Q
Σ AutoSum
Fill
Clear-
R
Sign in
Rain to stop
S
A.
E
Sort & Find &
Filter Select
Editing
T
4x
U
0 X
Share
V
A
19
V
A
19 new notifications
4:42 PM
2/2/2023
Transcribed Image Text:Paste K8 A 1 2 8 File 3 4 5 6 7 8 9 10 Cut E Copy A Ready A + Clipboard 15 18 16 19 20 Home Game # 1 2 3 4 5 6 7 8 11 9 12 10 SOUTH AFRICA 7S 13 11 14 12 15 13. 16 14 17 17 18 19 20 21 22 23 21 24 22 25 23 26 24 27 > Format Painter B Insert Page Layout Winner Team SOUTH AFRICA 7S FUJI 75 ARGENTINA 7S SAMOA 7S IRELAND 7S NEW ZEALAND 7S USA 7S AUSTRALIA 7S ARGENTINA 75 FIJI 7S JAPAN 7S X FRANCE 7S TONGA 7S 0 Calibri Sheet1 BIU H. с 21 26 USA 7S 14 NEW ZEALAND 75 21 SOUTH AFRICA 75 17 FIJI 75 CANADA 7S USA 7S 22 12 28 26 FRANCE 7S IRELAND 7S 33 AUSTRALIA 7S 36 NEW ZEALAND 7S 19 Points 34 26 20 31. 14 45 40 28 29 19 21 24 fx Font D E Hamilton Sevens 2023 Results Points Losing Team CANADA 7S 5 FRANCE 7S 10 SPAIN 7S 5 KENYA 7S 5 12 0 12 14 14 SPAIN 7S KENYA 7S Formulas 11 URUGUAY 7S TONGA 7S JAPAN GREAT BRITAIN 7S CANADA 7S SAMOA 7S SPAIN 7S Type here to search URUGUAY 7S SAMOA 7S GREAT BRITAIN 7S IRELAND 75 AUSTRALIA 7S ARGENTINA 75 URUGUAY 7S KENYA 7S JAPAN 7S TONGA 7S GREAT BRITAIN 7S * Α Α A - A N 12 7 19 10 21 14 19 14 12 5 12 21 12 7 12 A Data Review F 25 36 26 45 52 42 43 31 28 43 Total Points In The Match 39 36 31 47 28 40 31 34 17 40 47 45 43 31 View Alignment [ ab Wrap Text G Copy of ECN810 ASSIGNMENT 1_1675312143 - Excel Tell me what you want to do Help Merge & Center ▾ DAY 1 H T F General $ % 9 J Number X K 0 .00 .00 .0 Cell Conditional Format as Formatting Table Styles Styles L M 4 N O LU ← H Insert Delete Format ▼ P 11 Cells Q Σ AutoSum Fill Clear- R Sign in Rain to stop S A. E Sort & Find & Filter Select Editing T 4x U 0 X Share V A 19 V A 19 new notifications 4:42 PM 2/2/2023
8.
File
Paste
K8
A
27
Ready
A
+
Home
Cut
Ee Copy
A
Clipboard
Insert Page Layout
Format Painter
B
X
28
25
29 26
30 27
31
28
32
29
33 30
34
31
35
32
36 33 CANADA 7S
37
34
38
35
39
36
40
37
41 38
42 39
43 40
44
41
45
42
46 43
47
44
48
45
49
Calibri
KENYA 7S
SAMOA 7S
GREAT BRITAIN 7S
TONGA 7S
FRANCE 7S
ARGENTINA 7S
USA 7S
NEW ZEALAND 7S
BIU
Sheet1
SPAIN 7S
KENYA 7S
SAMOA 7S
IRELAND 7S
AUSTRALIA 7S
NEW ZEALAND 7S
ARGENTINA 7S
SPAIN 7S
SAMOA 7S
AUSTRALIA 7S
USA 7S
ARGENTINA 7S
fxx
Type here to search
C
B.
Font
Formulas
11
* Α Α
A
D
CANADA 7S
SPAIN 75
JAPAN 7S
21
24
24
12
22
19
28
10
21
21
JAPAN 7S
33
TONGA 7S
24
GREAT BRITAIN 7S
21
26
SOUTH AFRICA 7S
FIJI 7S
38 FRANCE 7S
USA 7S
CANADA 7S
KENYA 7S
24
24
26
26
15
14
IRELANDS 7S
FRANCE 7S
NEW ZEALAND 7S
URUGUAY 7S
SOUTH AFRICA 7S
FIJI 7S
AUSTRALIA 7S
IRELANDS 7S
URUGUAY 7S
N
Data Review
F
A
E
5
21
12
7
17
10
14
5
17
17
19
14
14
19
0
14
14
5
17
14
12
View
Alignment
F
Copy of ECN810 ASSIGNMENT 1_1675312143 - Excel
Tell me what you want to do
ab Wrap Text
26
45
36
19
39
29
42
15
38
38
52
38
35
45
38
38
38
31
43
29
26
Help
Merge & Center
G
DAY 2
General
$ % 9
H
Number
I
B
0 00
.00 .0
Conditional Format as Cell
Formatting Table Styles
Styles
J
K
4
L
LU
←
H
Insert Delete Format
▼
M
11
Cells
N
Σ AutoSum
Fill
Clear
O
Sign in
Rain to stop
P
A.
Editing
W
Sort & Find &
Filter Select
Q
4x
0 X
R
4:42 PM
2/2/2023
Share
A
19
V
▼
100%
Transcribed Image Text:8. File Paste K8 A 27 Ready A + Home Cut Ee Copy A Clipboard Insert Page Layout Format Painter B X 28 25 29 26 30 27 31 28 32 29 33 30 34 31 35 32 36 33 CANADA 7S 37 34 38 35 39 36 40 37 41 38 42 39 43 40 44 41 45 42 46 43 47 44 48 45 49 Calibri KENYA 7S SAMOA 7S GREAT BRITAIN 7S TONGA 7S FRANCE 7S ARGENTINA 7S USA 7S NEW ZEALAND 7S BIU Sheet1 SPAIN 7S KENYA 7S SAMOA 7S IRELAND 7S AUSTRALIA 7S NEW ZEALAND 7S ARGENTINA 7S SPAIN 7S SAMOA 7S AUSTRALIA 7S USA 7S ARGENTINA 7S fxx Type here to search C B. Font Formulas 11 * Α Α A D CANADA 7S SPAIN 75 JAPAN 7S 21 24 24 12 22 19 28 10 21 21 JAPAN 7S 33 TONGA 7S 24 GREAT BRITAIN 7S 21 26 SOUTH AFRICA 7S FIJI 7S 38 FRANCE 7S USA 7S CANADA 7S KENYA 7S 24 24 26 26 15 14 IRELANDS 7S FRANCE 7S NEW ZEALAND 7S URUGUAY 7S SOUTH AFRICA 7S FIJI 7S AUSTRALIA 7S IRELANDS 7S URUGUAY 7S N Data Review F A E 5 21 12 7 17 10 14 5 17 17 19 14 14 19 0 14 14 5 17 14 12 View Alignment F Copy of ECN810 ASSIGNMENT 1_1675312143 - Excel Tell me what you want to do ab Wrap Text 26 45 36 19 39 29 42 15 38 38 52 38 35 45 38 38 38 31 43 29 26 Help Merge & Center G DAY 2 General $ % 9 H Number I B 0 00 .00 .0 Conditional Format as Cell Formatting Table Styles Styles J K 4 L LU ← H Insert Delete Format ▼ M 11 Cells N Σ AutoSum Fill Clear O Sign in Rain to stop P A. Editing W Sort & Find & Filter Select Q 4x 0 X R 4:42 PM 2/2/2023 Share A 19 V ▼ 100%
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Kindly advise the purpose of each below for this particular event/game as how and why its important to calculate these in this particular event/game:

  1. Mean
  2. Median
  3. Mode
  4. Variance
  5. Standard Deviation
Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

Pleaze provide interpretations of the answers provided for each category listed below in the context of data provided 

  1. Mean
  2. Median
  3. Mode
  4. Variance
  5. Standard Deviation
Solution
Bartleby Expert
SEE SOLUTION
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