CA 2 - Using Excel
in BUS 110
Practice analyzing datasets while exploring Microsoft Excel
Download the dataset from google spreadsheet or
Copy and save the following data set into an empty text (.txt) file.
Id,Gender,Age,Height (in),# of Flowers,Flower Type, Flowers Cost ,Flower Color,# of Chocolates, Chocolate Cost ,Chocolate Type,Date Asked,Asked,Valentine,Gift Rejected?
1,F,25,65,2,Carnation,2,Pink,5,5,Dark,43509,Yes,Spouse,N
2,M,15,59,14,Tulip,14,Purple,6,12,White,43497,Yes,Friend,N
3,M,13,60,25,Rose,13.5,Red,5,5,Milk,43498,Yes,Friend,N
4,M,14,61,10,Rose,20,White,4,8,Milk,43495,Yes,Friend,Y
5,M,15,62,5,Rose,2.5,White,4,8,Dark,43506,Yes,Friend,N
6,M,60,63,5,Rose,2.5,Red,4,5,Milk,43509,No,Relative,N
7,F,15,63,3,Orchid,10,White,10,15,Dark,43510,No,Friend,Y
8,M,17,63,10,Rose,8.99,Red,10,20,Dark,43500,No,Friend,Y
9,F,56,62,4,Rose,4,Red,3,5,Milk,43509,No,Relative,N
10,F,21,64,4,Rose,4.25,Red,0,0,,43508,No,Spouse,N
11,M,15,65,25,Mixed,10,Red,5,7.99,Milk,43510,No,Friend,Y
12,F,22,64,1,Rose,1,Red,10,5.99,Milk,43505,No,Spouse,N
13,F,24,65,1,Rose,1.99,Red,25,15.99,Milk,43505,No,Spouse,N
14,F,16,64,1,Rose,1,White,18,18,Milk,43504,Yes,Friend,N
15,M,14,66,20,Mixed,29.95,White,0,0,,43490,Yes,Friend,N
16,M,14,67,15,Tulip,21.96,Yellow,0,0,,43510,No,Friend,Y
17,M,15,66,9,Orchid,8.5,White,3,9,Dark,43504,Yes,Friend,N
18,F,16,66,2,Daisy,1,White,10,25,White,43501,Yes,Friend,N
19,M,25,68,8,Carnation,8,Pink,4,3,White,43510,No,Spouse,N
20,F,20,68,2,Carnation,2,Pink,30,50,Dark,43480,Yes,Friend,N
21,M,58,69,5,Tulip,5.5,Pink,10,25,White,43510,No,Relative,N
22,M,50,69,5,Rose,6.99,Pink,10,19.99,Dark,43494,Yes,Friend,N
23,F,61,67,10,Daisy,5,White,25,15.99,Milk,43510,No,Friend,Y
24,F,22,70,2,Sunflower,5,Yellow,10,10,Milk,43510,No,Spouse,N
25,F,20,65,1,Sunflower,2.5,Yellow,15,8.5,Milk,43510,No,Spouse,N