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.
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
Related questions
Question
question i,ii,iii,iv

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
This is a popular solution!
Step by step
Solved in 10 steps with 4 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman