A B с 1 OrderDate Region Manager SalesMan D Item F G H Units Unit price Sale_amt 2 1/6/18 East Martha Alexander Television 95 1,198.00 113,810.00 3 1/23/18 Central Hermann Shelli Home Theater 50 500.00 25,000.00 4 2/9/18 Central Hermann Luis Television 36 1,198.00 43,128.00 5 2/26/18 Central Timothy David Cell Phone 27 225.00 6,075.00 6 3/15/18 West Timothy Stephen Television 56 1,198.00 67,088.00 7 4/1/18 East Martha Alexander Home Theater 60 500.00 30,000.00 B 4/18/18 Central Martha Steven Television 75 1,198.00 89,850.00 9 5/5/18 Central Hermann Luis Television 90 1,198.00 107,820.00 10 5/22/18 West Douglas Michael Television 32 1,198.00 38,336.00 11 6/8/18 East Martha Alexander Home Theater 60 500.00 30,000.00 12 6/25/18 Central Hermann Sigal Television 90 1,198.00 107,820.00 13 7/12/18 East Martha Diana Home Theater 29 500.00 14,500.00 14 7/29/18 East Douglas Karen Home Theater 81 500.00 40,500.00 15 8/15/18 East Martha Alexander Television 35 1,198.00 41,930.00 16 9/1/18 Central Douglas John Desk 2 125.00 250.00 17 9/18/18 East Martha Alexander Video Games 16 58.50 936.00 18 10/5/18 Central Hermann Sigal Home Theater 28 500.00 14,000.00 19 10/22/18 East Martha Alexander Cell Phone 64 225.00 14,400.00 20 11/8/18 East Douglas Karen Cell Phone 15 225.00 3,375.00 21 11/25/18 Central Hermann Shelli Video Games 96 58.50 5,616.00 22 12/12/18 Central Douglas John Television 67 1,198.00 80,265.00 23 12/29/18 East Douglas Karen Video Games 74 58.50 4,329.00 24 1/15/19 Central Timothy David Home Theater 46 500.00 23,000.00 25 2/1/19 Central Douglas John Home Theater 87 500.00 43,500.00 26 2/18/19 East Martha Alexander Home Theater 4 500.00 2,000.00 27 3/7/19 West Timothy Stephen Home Theater 7 500.00 3,500.00 28 3/24/19 Central Hermann Luis Video Games 50 58.50 2,925.00 29 4/10/19 Central Martha Steven Television 66 1,198.00 79,068.00 30 4/27/19 East Martha Diana Cell Phone 96 225.00 21,600.00 31 5/14/19 Central Timothy David Television 53 1,198.00 63,494.00 32 5/31/19 Central Timothy David Home Theater 80 500.00 40,000.00 33 6/17/19 Central Hermann Shelli Desk 5 125.00 625.00 34 7/4/19 East Martha Alexander Video Games 62 58.50 3,627.00 35 7/21/19 Central Hermann Sigal Video Games 55 58.50 3,217.50 36 8/7/19 Central Hermann Shelli Video Games 42 58.50 2,457.00 37 8/24/19 West Timothy Stephen Desk 3 125.00 375.00 38 9/10/19 Central Timothy David Television 7 1,198.00 8,386.00 9/27/19 West Timothy Stephen Cell Phone 76 225.00 17,100.00 40 10/14/19 West Douglas Michael Home Theater 57 500.00 28,500.00 41 10/31/19 Central Martha Steven Television 14 1,198.00 16,772.00 42 11/17/19 Central Hermann Luis Home Theater 11 500.00 5,500.00 43 12/4/19 Central Hermann Luis Home Theater 94 500.00 47,000.00 44 12/21/19 Central Martha Steven Home Theater 28 500.00 14,000.00 45 Region Manager SalesMan Item OrderDate Manager Ho. Tel... Vid... Cell Phone Desk 400 300 200 100 0 Alexander David Steven Karen Stephen Michael + 100 00 Units 75 75 50 M 25 0 Jan 6, 2018 Martha Herm... Douglas Timothy Units Sales See d... May 16, 2018 Sep 23, 2018 Jan 31, 2019 Mar 12, 2018 Jun 10, 2019 Jul 20, 2018 Nov 27, 2018 Apr 6, 2019 Aug 14, 2019 Oct 18, 2019 Home Theater Television Video Games Cell Phone Desk Home Theater Cell Phone Television Video Games Desk 800 600 400 200 0 0 200 400 600 800 Home Theater Video Games Desk Television Cell Phone Sale_amt 1,305,675.5

Fundamentals of Information Systems
9th Edition
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter4: Networks And Cloud Computing
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question
100%

Analyze the charts and introduce each charts by describing each. Identify the patterns in the given data. And determine how are the data points are related.

 

Refer to the raw data (table):

A
B
с
1
OrderDate Region Manager
SalesMan
D
Item
F
G
H
Units
Unit price Sale_amt
2
1/6/18 East
Martha
Alexander
Television
95
1,198.00
113,810.00
3
1/23/18 Central
Hermann
Shelli
Home Theater
50
500.00
25,000.00
4
2/9/18 Central
Hermann
Luis
Television
36
1,198.00
43,128.00
5
2/26/18 Central
Timothy
David
Cell Phone
27
225.00
6,075.00
6
3/15/18 West
Timothy
Stephen
Television
56
1,198.00
67,088.00
7
4/1/18 East
Martha
Alexander
Home Theater
60
500.00
30,000.00
B
4/18/18 Central
Martha
Steven
Television
75
1,198.00
89,850.00
9
5/5/18 Central
Hermann
Luis
Television
90
1,198.00
107,820.00
10
5/22/18 West
Douglas
Michael
Television
32
1,198.00
38,336.00
11
6/8/18 East
Martha
Alexander
Home Theater
60
500.00
30,000.00
12
6/25/18 Central
Hermann
Sigal
Television
90
1,198.00
107,820.00
13
7/12/18 East
Martha
Diana
Home Theater
29
500.00
14,500.00
14
7/29/18 East
Douglas
Karen
Home Theater
81
500.00
40,500.00
15
8/15/18 East
Martha
Alexander
Television
35
1,198.00
41,930.00
16
9/1/18 Central
Douglas
John
Desk
2
125.00
250.00
17
9/18/18 East
Martha
Alexander
Video Games
16
58.50
936.00
18
10/5/18 Central
Hermann
Sigal
Home Theater
28
500.00
14,000.00
19
10/22/18 East
Martha
Alexander
Cell Phone
64
225.00
14,400.00
20
11/8/18 East
Douglas
Karen
Cell Phone
15
225.00
3,375.00
21
11/25/18 Central
Hermann
Shelli
Video Games
96
58.50
5,616.00
22
12/12/18 Central
Douglas
John
Television
67
1,198.00
80,265.00
23
12/29/18 East
Douglas
Karen
Video Games
74
58.50
4,329.00
24
1/15/19 Central
Timothy
David
Home Theater
46
500.00
23,000.00
25
2/1/19 Central
Douglas
John
Home Theater
87
500.00
43,500.00
26
2/18/19 East
Martha
Alexander
Home Theater
4
500.00
2,000.00
27
3/7/19 West
Timothy
Stephen
Home Theater
7
500.00
3,500.00
28
3/24/19 Central
Hermann
Luis
Video Games
50
58.50
2,925.00
29
4/10/19 Central
Martha
Steven
Television
66
1,198.00
79,068.00
30
4/27/19 East
Martha
Diana
Cell Phone
96
225.00
21,600.00
31
5/14/19 Central
Timothy
David
Television
53
1,198.00
63,494.00
32
5/31/19 Central
Timothy
David
Home Theater
80
500.00
40,000.00
33
6/17/19 Central
Hermann
Shelli
Desk
5
125.00
625.00
34
7/4/19 East
Martha
Alexander
Video Games
62
58.50
3,627.00
35
7/21/19 Central
Hermann
Sigal
Video Games
55
58.50
3,217.50
36
8/7/19 Central
Hermann
Shelli
Video Games
42
58.50
2,457.00
37
8/24/19 West
Timothy
Stephen
Desk
3
125.00
375.00
38
9/10/19 Central
Timothy
David
Television
7
1,198.00
8,386.00
9/27/19 West
Timothy
Stephen
Cell Phone
76
225.00
17,100.00
40
10/14/19 West
Douglas
Michael
Home Theater
57
500.00
28,500.00
41
10/31/19 Central
Martha
Steven
Television
14
1,198.00
16,772.00
42
11/17/19 Central
Hermann
Luis
Home Theater
11
500.00
5,500.00
43
12/4/19 Central
Hermann
Luis
Home Theater
94
500.00
47,000.00
44 12/21/19 Central
Martha
Steven
Home Theater
28
500.00
14,000.00
45
Transcribed Image Text:A B с 1 OrderDate Region Manager SalesMan D Item F G H Units Unit price Sale_amt 2 1/6/18 East Martha Alexander Television 95 1,198.00 113,810.00 3 1/23/18 Central Hermann Shelli Home Theater 50 500.00 25,000.00 4 2/9/18 Central Hermann Luis Television 36 1,198.00 43,128.00 5 2/26/18 Central Timothy David Cell Phone 27 225.00 6,075.00 6 3/15/18 West Timothy Stephen Television 56 1,198.00 67,088.00 7 4/1/18 East Martha Alexander Home Theater 60 500.00 30,000.00 B 4/18/18 Central Martha Steven Television 75 1,198.00 89,850.00 9 5/5/18 Central Hermann Luis Television 90 1,198.00 107,820.00 10 5/22/18 West Douglas Michael Television 32 1,198.00 38,336.00 11 6/8/18 East Martha Alexander Home Theater 60 500.00 30,000.00 12 6/25/18 Central Hermann Sigal Television 90 1,198.00 107,820.00 13 7/12/18 East Martha Diana Home Theater 29 500.00 14,500.00 14 7/29/18 East Douglas Karen Home Theater 81 500.00 40,500.00 15 8/15/18 East Martha Alexander Television 35 1,198.00 41,930.00 16 9/1/18 Central Douglas John Desk 2 125.00 250.00 17 9/18/18 East Martha Alexander Video Games 16 58.50 936.00 18 10/5/18 Central Hermann Sigal Home Theater 28 500.00 14,000.00 19 10/22/18 East Martha Alexander Cell Phone 64 225.00 14,400.00 20 11/8/18 East Douglas Karen Cell Phone 15 225.00 3,375.00 21 11/25/18 Central Hermann Shelli Video Games 96 58.50 5,616.00 22 12/12/18 Central Douglas John Television 67 1,198.00 80,265.00 23 12/29/18 East Douglas Karen Video Games 74 58.50 4,329.00 24 1/15/19 Central Timothy David Home Theater 46 500.00 23,000.00 25 2/1/19 Central Douglas John Home Theater 87 500.00 43,500.00 26 2/18/19 East Martha Alexander Home Theater 4 500.00 2,000.00 27 3/7/19 West Timothy Stephen Home Theater 7 500.00 3,500.00 28 3/24/19 Central Hermann Luis Video Games 50 58.50 2,925.00 29 4/10/19 Central Martha Steven Television 66 1,198.00 79,068.00 30 4/27/19 East Martha Diana Cell Phone 96 225.00 21,600.00 31 5/14/19 Central Timothy David Television 53 1,198.00 63,494.00 32 5/31/19 Central Timothy David Home Theater 80 500.00 40,000.00 33 6/17/19 Central Hermann Shelli Desk 5 125.00 625.00 34 7/4/19 East Martha Alexander Video Games 62 58.50 3,627.00 35 7/21/19 Central Hermann Sigal Video Games 55 58.50 3,217.50 36 8/7/19 Central Hermann Shelli Video Games 42 58.50 2,457.00 37 8/24/19 West Timothy Stephen Desk 3 125.00 375.00 38 9/10/19 Central Timothy David Television 7 1,198.00 8,386.00 9/27/19 West Timothy Stephen Cell Phone 76 225.00 17,100.00 40 10/14/19 West Douglas Michael Home Theater 57 500.00 28,500.00 41 10/31/19 Central Martha Steven Television 14 1,198.00 16,772.00 42 11/17/19 Central Hermann Luis Home Theater 11 500.00 5,500.00 43 12/4/19 Central Hermann Luis Home Theater 94 500.00 47,000.00 44 12/21/19 Central Martha Steven Home Theater 28 500.00 14,000.00 45
Region
Manager
SalesMan
Item
OrderDate
Manager
Ho.
Tel...
Vid...
Cell Phone
Desk
400
300
200
100
0
Alexander
David
Steven
Karen
Stephen
Michael
+
100
00
Units
75
75
50
M
25
0
Jan 6, 2018
Martha
Herm...
Douglas
Timothy
Units Sales
See d...
May 16, 2018
Sep 23, 2018
Jan 31, 2019
Mar 12, 2018
Jun 10, 2019
Jul 20, 2018
Nov 27, 2018
Apr 6, 2019
Aug 14, 2019
Oct 18, 2019
Home Theater
Television
Video Games
Cell Phone
Desk
Home Theater
Cell Phone
Television
Video Games
Desk
800
600
400
200
0
0
200
400
600
800
Home Theater
Video Games
Desk
Television
Cell Phone
Sale_amt
1,305,675.5
Transcribed Image Text:Region Manager SalesMan Item OrderDate Manager Ho. Tel... Vid... Cell Phone Desk 400 300 200 100 0 Alexander David Steven Karen Stephen Michael + 100 00 Units 75 75 50 M 25 0 Jan 6, 2018 Martha Herm... Douglas Timothy Units Sales See d... May 16, 2018 Sep 23, 2018 Jan 31, 2019 Mar 12, 2018 Jun 10, 2019 Jul 20, 2018 Nov 27, 2018 Apr 6, 2019 Aug 14, 2019 Oct 18, 2019 Home Theater Television Video Games Cell Phone Desk Home Theater Cell Phone Television Video Games Desk 800 600 400 200 0 0 200 400 600 800 Home Theater Video Games Desk Television Cell Phone Sale_amt 1,305,675.5
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781337097536
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
New Perspectives on HTML5, CSS3, and JavaScript
New Perspectives on HTML5, CSS3, and JavaScript
Computer Science
ISBN:
9781305503922
Author:
Patrick M. Carey
Publisher:
Cengage Learning
Fundamentals of Information Systems
Fundamentals of Information Systems
Computer Science
ISBN:
9781305082168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
MIS
MIS
Computer Science
ISBN:
9781337681919
Author:
BIDGOLI
Publisher:
Cengage