Use the Data Analysis Tool in Excel to Display Descriptive Statistics. explain in step by step

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

Use the Data Analysis Tool in Excel to Display Descriptive Statistics.

explain in step by step

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
9 Jun
10 Jul
11 Aug
12 Sep
13 Oct
14 Nov
15 Dec
16 Total
17
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
E
TI
F
Wed Thur Fri
580
563
497
510
500
490
502
516
540
550
562
556
548
548
546
560
498
554
575
539
531
509
529 587
574
555
580
557
558 563
569
530
560
524
501 550
6558 6399 6554
Transcribed Image Text: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 9 Jun 10 Jul 11 Aug 12 Sep 13 Oct 14 Nov 15 Dec 16 Total 17 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 E TI F Wed Thur Fri 580 563 497 510 500 490 502 516 540 550 562 556 548 548 546 560 498 554 575 539 531 509 529 587 574 555 580 557 558 563 569 530 560 524 501 550 6558 6399 6554
Expert Solution
Step 1

Here we have to use the Data Analysis Tool in Excel to Display Descriptive Statistics. Please find the explanation below. Thank you.

 

steps

Step by step

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