InvoloeNo stookCode Desoription Guantity InvoloeDate UnitPrios CuctomeriD Country 6 0122010 826 6 O12/2010 826 8 o122010 826 6 O12/2010 826 6 0/12/2010 826 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 2.55 17850.0 Unted Kingdom 536365 71053 WHITE METAL LANTERN 3.39 17850.0 Unted Kingdom 536366 CREAM CUPID HEARTS COAT HANGER 2.75 17850.0 Unted Kingdom 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 3.39 17850.0 Unted Kingdom 536365 84029E RED WOOLLY HOTTE WHITE HEART. 3.39 17850.0 Unted Kingdom 536388 22469 HEART OF WICKER SMALL 12 0/12/2010 99 1.65 16250.0 Unted Kingdom 536388 22242 5 HOOK HANGER MAGIC TOADSTOCL 12 01/12/2010 9.5a 1.65 16250.0 Unted Kingdom 5 012/2010 10:03 8 o12/2010 10:03 536389 22941 CHRISTMAS LIGHTS 10 REINDEER 8.50 124310 Australa 21622 VINTAGE UNION JACK CUSHION COVER 4.95 12431.0 Australia 536389 21791 VINTAGE HEADS AND TAILS CARD GAME 12 0112/2010 1003 1.25 124310 Australa ws * 8 columns Datal.tail(200) InvoloeNo atookCode Decortption Quantity InvolceDate UnitPrios Cuctomerio Country 2 O9122011 1.55 4 O8122011 11.S6 22625 RED KITCHEN SCALES B.50 16625.0 United Kingdom 10 S81567 23355 HOT WATER BOTTLE KEEP CALM 4.95 16626.0 United Kingdom 21326 AGED GLASS SILVER TIGHT HOLDER 144 O9122011 11. 0.55 16626.0 Unted Kngdom 12 4 OS122011 11.56 3 OS122011 11.56 581567 21479 WHITE SKULL HOT WATER BOTTLE 4.25 16626.0 Unted Kngdom 581567 23356 LOVE HOT WATER BOTTLE 5.95 166260 Unted Kingdom 04 581587 22613 PACK OF 20 SPACEBOY NAPKINS 12 09/122011 12:50 12680.0 France 581587 22899 CHLDRENS APRON DOLLY GIRL 6 Da122011 12.50 2.10 12680.0 France
InvoloeNo stookCode Desoription Guantity InvoloeDate UnitPrios CuctomeriD Country 6 0122010 826 6 O12/2010 826 8 o122010 826 6 O12/2010 826 6 0/12/2010 826 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 2.55 17850.0 Unted Kingdom 536365 71053 WHITE METAL LANTERN 3.39 17850.0 Unted Kingdom 536366 CREAM CUPID HEARTS COAT HANGER 2.75 17850.0 Unted Kingdom 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 3.39 17850.0 Unted Kingdom 536365 84029E RED WOOLLY HOTTE WHITE HEART. 3.39 17850.0 Unted Kingdom 536388 22469 HEART OF WICKER SMALL 12 0/12/2010 99 1.65 16250.0 Unted Kingdom 536388 22242 5 HOOK HANGER MAGIC TOADSTOCL 12 01/12/2010 9.5a 1.65 16250.0 Unted Kingdom 5 012/2010 10:03 8 o12/2010 10:03 536389 22941 CHRISTMAS LIGHTS 10 REINDEER 8.50 124310 Australa 21622 VINTAGE UNION JACK CUSHION COVER 4.95 12431.0 Australia 536389 21791 VINTAGE HEADS AND TAILS CARD GAME 12 0112/2010 1003 1.25 124310 Australa ws * 8 columns Datal.tail(200) InvoloeNo atookCode Decortption Quantity InvolceDate UnitPrios Cuctomerio Country 2 O9122011 1.55 4 O8122011 11.S6 22625 RED KITCHEN SCALES B.50 16625.0 United Kingdom 10 S81567 23355 HOT WATER BOTTLE KEEP CALM 4.95 16626.0 United Kingdom 21326 AGED GLASS SILVER TIGHT HOLDER 144 O9122011 11. 0.55 16626.0 Unted Kngdom 12 4 OS122011 11.56 3 OS122011 11.56 581567 21479 WHITE SKULL HOT WATER BOTTLE 4.25 16626.0 Unted Kngdom 581567 23356 LOVE HOT WATER BOTTLE 5.95 166260 Unted Kingdom 04 581587 22613 PACK OF 20 SPACEBOY NAPKINS 12 09/122011 12:50 12680.0 France 581587 22899 CHLDRENS APRON DOLLY GIRL 6 Da122011 12.50 2.10 12680.0 France
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter3: Working With Large Worksheets, Charting, And What-if Analysis
Section: Chapter Questions
Problem 1.1EYK
Related questions
Question
![Task-5:
Company likes to find out overall average purchase-amount among all
transactions [ one transaction indicates one invoice number]. The expected
output is as follows:
Average purchase amount among all transactions
44.39.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0c1faf28-6598-4562-87ec-f26a5152e57c%2F505343cd-46a7-499a-8567-ae4f9febf804%2Fqqshvvo_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Task-5:
Company likes to find out overall average purchase-amount among all
transactions [ one transaction indicates one invoice number]. The expected
output is as follows:
Average purchase amount among all transactions
44.39.
![In (45):
1 Datal.head (200)
Out[45]:
InvoloeNo stookCode
Desoription Guantity
InvoloeDate UnitPrioe Cuctomerio
Country
536365
85123A
WHITE HANGING HEART T-LIGHT HOLDER
01/12/2010 826
2.55
17850.0 Untad Kingdom
536365
71063
WHITE METAL LANTERN
O1/12/2010 826
3.39
17850.0 United Kingdom
2
53636G
844068
CREAM CUPID HEARTS COAT HANGER
01/12/2010 826
2.75
17850.0 Unted Kingdom
536365
84029G KNITTED UNION FLAG HOT WATER BOTTLE
01/12/2010 8:26
3.39
17850.0 Untad Kingdom
4
536365
84029E
RED WOOLLY HOTTIE WHITE HEART.
01/12/2010 826
3.39
17800.0 United Kingdom
186
536388
22469
HEART OF WICKER SMALL
12 01/12/2010 9.50
1.65
16250.0 Unted Kingdom
188
536388
22242
5 HOCK HANGER MAGIC TOADSTOOL
12 01/12/2010 9.59
1.65
16250.0 Unted Kingdom
187
536389
22941
CHRISTMAS LIGHTS 10 REINDEER
6 01/12/2010 10:03
8.50
12431.0
Australia
188
536389
21622
VINTAGE UNION JACK CUSHION COVER
8 O112/2010 10.03
4.95
12431.0
Australia
188
536389
21701
VINTAGE HEADS AND TAILS CARD GAME
12 01/12/2010 10:03
1.25
12431.0
Australia
200 rows x 8 columns
In (49):
1 Datal.tail(200)
Out[49]:
InvoloeNo atookCode
Decoription Quantity
InvolceDate UnitPrioe Cuctomerio
Country
641700
581667
22625
RED KITCHEN SCALES
2 0812/2011 11.56
8.50
16626.0 Unted Kingdom
641710
581067
23356
HOT WATER BOTTLE KEEP CALM
4 O9122011 11:06
4.95
16626.0 Unted Kingdom
641711
581567
21326 AGED GLASS SILVER T-LIGHT HOLDER
144 09/122011 11.56
0.55
16626.0 Unted Kingdom
641712
581567
21479
WHITE SKULL HOT WATER BOTTLE
4 O9122011 11:56
4.25
16626.0 Unted Kingdom
641713
581567
23356
LOVE HOT WATER BOTTLE
3 Ce122011 11.56
5.95
16626.0 United Kingdom
641B04
581587
22613
PACK OF 20 SPACEBOY NAPKINS
12 D9/122011 12:50
O.85
12680.0
France
641805
581587
22899
CHLDRENS APRON DOLLY GIRL
6 D9/122011 12.50
2.10
12680.0
France
641808
581587
23254
CHILDRENS CUTLERY DOLLY GIRL
4 Da/122011 12.50
4.15
12680.0
France
641807
5815I7
23256 CHILDRENS CUTLERY CIRCUS PARADE
4 D9/122011 12:50
4.15
12680.0
France
641803
581587
22138
BAKING SET 9 PIECE RETROSPOT
3 D/122011 12.50
4.95
12680.0
France
200 rows x 8 columns](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0c1faf28-6598-4562-87ec-f26a5152e57c%2F505343cd-46a7-499a-8567-ae4f9febf804%2Fd8vm43c_processed.jpeg&w=3840&q=75)
Transcribed Image Text:In (45):
1 Datal.head (200)
Out[45]:
InvoloeNo stookCode
Desoription Guantity
InvoloeDate UnitPrioe Cuctomerio
Country
536365
85123A
WHITE HANGING HEART T-LIGHT HOLDER
01/12/2010 826
2.55
17850.0 Untad Kingdom
536365
71063
WHITE METAL LANTERN
O1/12/2010 826
3.39
17850.0 United Kingdom
2
53636G
844068
CREAM CUPID HEARTS COAT HANGER
01/12/2010 826
2.75
17850.0 Unted Kingdom
536365
84029G KNITTED UNION FLAG HOT WATER BOTTLE
01/12/2010 8:26
3.39
17850.0 Untad Kingdom
4
536365
84029E
RED WOOLLY HOTTIE WHITE HEART.
01/12/2010 826
3.39
17800.0 United Kingdom
186
536388
22469
HEART OF WICKER SMALL
12 01/12/2010 9.50
1.65
16250.0 Unted Kingdom
188
536388
22242
5 HOCK HANGER MAGIC TOADSTOOL
12 01/12/2010 9.59
1.65
16250.0 Unted Kingdom
187
536389
22941
CHRISTMAS LIGHTS 10 REINDEER
6 01/12/2010 10:03
8.50
12431.0
Australia
188
536389
21622
VINTAGE UNION JACK CUSHION COVER
8 O112/2010 10.03
4.95
12431.0
Australia
188
536389
21701
VINTAGE HEADS AND TAILS CARD GAME
12 01/12/2010 10:03
1.25
12431.0
Australia
200 rows x 8 columns
In (49):
1 Datal.tail(200)
Out[49]:
InvoloeNo atookCode
Decoription Quantity
InvolceDate UnitPrioe Cuctomerio
Country
641700
581667
22625
RED KITCHEN SCALES
2 0812/2011 11.56
8.50
16626.0 Unted Kingdom
641710
581067
23356
HOT WATER BOTTLE KEEP CALM
4 O9122011 11:06
4.95
16626.0 Unted Kingdom
641711
581567
21326 AGED GLASS SILVER T-LIGHT HOLDER
144 09/122011 11.56
0.55
16626.0 Unted Kingdom
641712
581567
21479
WHITE SKULL HOT WATER BOTTLE
4 O9122011 11:56
4.25
16626.0 Unted Kingdom
641713
581567
23356
LOVE HOT WATER BOTTLE
3 Ce122011 11.56
5.95
16626.0 United Kingdom
641B04
581587
22613
PACK OF 20 SPACEBOY NAPKINS
12 D9/122011 12:50
O.85
12680.0
France
641805
581587
22899
CHLDRENS APRON DOLLY GIRL
6 D9/122011 12.50
2.10
12680.0
France
641808
581587
23254
CHILDRENS CUTLERY DOLLY GIRL
4 Da/122011 12.50
4.15
12680.0
France
641807
5815I7
23256 CHILDRENS CUTLERY CIRCUS PARADE
4 D9/122011 12:50
4.15
12680.0
France
641803
581587
22138
BAKING SET 9 PIECE RETROSPOT
3 D/122011 12.50
4.95
12680.0
France
200 rows x 8 columns
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
![Programming with Microsoft Visual Basic 2017](https://www.bartleby.com/isbn_cover_images/9781337102124/9781337102124_smallCoverImage.gif)
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:
9781337102124
Author:
Diane Zak
Publisher:
Cengage Learning