Description
please see attach files for instructions. For the lab you need my name First name is Anderson and Last name is Best
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
lab three
Market Shares of Major Phone Providers in the United States
Verizon
ATT
All-Tel
Sprint
T-Mobile
Yearly Sales
Max
Min
Average
Q1 2008
213,554
323,154
402,513
186,545
152,231
1277997
402,513
152,231
255,599
Cellular Phones Sales During Five Years
Q1 2009
Q1 2010
Q1 2011
Q1 2012
655,487
754,665
884,657
922,354
421,325
512,312
554,654
864,458
521,325
521,145
564,879
587,546
199,844
256,455
384,564
584,654
251,325
321,123
564,458
654,854
2049306
2365700
2953212
3613866
655,487
754,665
884,657
922,354
199,844
256,455
384,564
584,654
409,861
473,140
590,642
722,773
Total Sales
$ 3,430,717.00
$ 2,675,903.00
$ 2,597,408.00
$ 1,612,062.00
$ 1,943,991.00
3,430,717
1,612,062
2,452,016
Cellular Phone Sales During Five Years
1,000,000
900,000
800,000
Sales in Dollars
700,000
600,000
500,000
400,000
300,000
200,000
100,000
-
Q1 2008
Q1 2009
Verizon
Q1 2010
ATT
All-Tel
Sprint
Q1 2011
T-Mobile
Q1 2012
Overall Performance
16%
28%
13%
Verizon
ATT
All-Tel
Sprint
T-Mobile
22%
21%
lab five
ID
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
Nation
FR
FR
FR
FR
FR
FR
FR
FR
FR
FR
FR
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
EG
Employee
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Vickie
Richard
James
Fred
Mohamed
Omar
Taha
Samy
Moustafa
Ali
Mohamed
Alaa
Magda
Khalid
Amani
Mona
Esmat
Shaker
Mohamed
Omar
Taha
Samy
Moustafa
Ali
Mohamed
Alaa
Magda
Khalid
Amani
Mona
Esmat
Shaker
Taha
Taher
Hossam
Hassan
City
Leon
Leon
Leon
Leon
Leon
Leon
Leon
Leon
Leon
Leon
Leon
Alexandria
Alexandria
Alexandria
Alexandria
Alexandria
Alexandria
Alexandria
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Cairo
Tanta
Tanta
Tanta
Tanta
Tanta
Tanta
Sales Value
112456
3654
25487
3654
95446
654
32654
32254
8644
2115
2154
214465
215544
24554
21445
532241
6423
214465
211544
321154
2144
564542
2114
254
21445
21145
54458
2144
564542
2114
254
21445
21145
54458
584252
112456
3654
25487
3654
95446
654
32654
32254
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
John
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Vickie
Richard
James
Fred
John
John
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Vickie
Richard
James
Fred
John
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Vickie
Richard
James
Fred
John
John
Jane
Sam
Counter
Mine
Smith
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
8644
2115
2154
214465
215544
24554
21445
532241
6423
214465
211544
321154
2144
564542
2114
254
21445
21145
54458
21445
532241
6423
214465
211544
321154
2144
564542
2114
254
21445
21145
54458
584252
112456
3654
25487
3654
95446
654
32654
32254
8644
2115
2154
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
CA
Edwards
Nick
Vickie
Richard
James
Fred
John
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Vickie
Richard
James
Fred
John
John
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Vickie
Richard
James
Fred
Adam
Adam
Adam
Adam
Adam
John
Jane
Sam
Counter
Mine
Smith
Edwards
Nick
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
Toronto
214465
215544
24554
21445
532241
6423
214465
211544
321154
2144
564542
2114
254
21445
21145
54458
2444.31
3192.65
818.4
1151.4
1503
392.2
946
4180
112456
3654
25487
3654
95446
654
32654
32254
8644
2115
2154
214465
215544
24554
21445
532241
6423
214465
211544
321154
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164...