The following is a tabulation of the number of emails received in the year 2021, from January to December. The management has asked you to present the data in a more descriptive manner using graphs and provide some simple statistics that are easily understood. E A B C D 1 No. emails received by day for each month 2 3 4 Jan 5 Feb 6 Mar 7 Apr 8 May Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 Total You are required to: (i) (ii) (iii) (iv) Mon 570 520 562 568 555 549 562 586 596 569 562 567 6766 Tues 539 480 588 516 562 576 553 567 577 550 519 553 6580 Wed 580 510 502 550 548 560 575 509 Fri 563 497 500 490 516 540 562 556 548 546 498 554 539 531 529 587 574 555 580 557 558 563 569 530 560 524 501 550 6558 6399 6554 F Thur G D M M F KU> Present the data using Grouped Bar Chart Describe the data using a Line graph Use the Data Analysis Tool in Excel to Display Descriptive Statistics Format the above as a Table using colour of your choice and display Header Row, Banded Rows, Banded Columns, and Filter Button.

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
question i,ii,iii,iv
The following is a tabulation of the number of emails received in the year 2021, from January to
December. The management has asked you to present the data in a more descriptive manner using
graphs and provide some simple statistics that are easily understood.
E
A
B
D
1 No. emails received by day for each month
MGAWN.
2
3
4 Jan
5 Feb
6 Mar
7 Apr
8 May
9 Jun
10 Jul
11 Aug
12 Sep
13 Oct
14 Nov
15 Dec
16 Total
AT
You are required to:
(i)
(ii)
(iii)
(iv)
Mon
570
520
562
568
555
549
562
586
596
569
562
567
6766
Tues
539
480
588
516
562
576
553
567
577
550
519
553
6580
Wed
580
510
502
550
548
560
Fri
563 497
500
490
516 540
562
556
548 546
498 554
575
539
531
509
529
587
574
555 580
557
558 563
569
530
560
524
501 550
6558 6399 6554
F
Thur
G
D
M
2 KU
M
S
Present the data using Grouped Bar Chart
Describe the data using a Line graph
Use the Data Analysis Tool in Excel to Display Descriptive Statistics
Format the above as a Table using colour of your choice and display Header Row,
Banded Rows, Banded Columns, and Filter Button.
Transcribed Image Text:The following is a tabulation of the number of emails received in the year 2021, from January to December. The management has asked you to present the data in a more descriptive manner using graphs and provide some simple statistics that are easily understood. E A B D 1 No. emails received by day for each month MGAWN. 2 3 4 Jan 5 Feb 6 Mar 7 Apr 8 May 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 Total AT You are required to: (i) (ii) (iii) (iv) Mon 570 520 562 568 555 549 562 586 596 569 562 567 6766 Tues 539 480 588 516 562 576 553 567 577 550 519 553 6580 Wed 580 510 502 550 548 560 Fri 563 497 500 490 516 540 562 556 548 546 498 554 575 539 531 509 529 587 574 555 580 557 558 563 569 530 560 524 501 550 6558 6399 6554 F Thur G D M 2 KU M S Present the data using Grouped Bar Chart Describe the data using a Line graph Use the Data Analysis Tool in Excel to Display Descriptive Statistics Format the above as a Table using colour of your choice and display Header Row, Banded Rows, Banded Columns, and Filter Button.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 10 steps with 4 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