hmw9

profileSam321
310homework9data.xlsx

#1 Data

Plan A Plan B Plan C Plan D
36 39 44 31
40 45 43 43
32 54 38 46
44 53 40 43
35 46 41 36
41 42 35 49
44 35 37 46
42 39 37 48

#2 Data

Customer Payment Type Bill
1 Other $93
2 CashCheck $89
3 Other $117
4 CashCheck $74
5 MC_VISA $104
6 AmerExpress $138
7 Other $98
8 CashCheck $70
9 AmerExpress $86
10 CashCheck $82
11 AmerExpress $109
12 Other $100
13 MC_VISA $140
14 CashCheck $72
15 AmerExpress $103
16 AmerExpress $106
17 AmerExpress $75
18 AmerExpress $122
19 AmerExpress $157
20 Other $94
21 Other $90
22 CashCheck $60
23 MC_VISA $127
24 Other $90
25 CashCheck $73
26 AmerExpress $112
27 CashCheck $70
28 Other $86
29 MC_VISA $120
30 CashCheck $100
31 CashCheck $59
32 Other $81
33 AmerExpress $117
34 Other $95
35 AmerExpress $114
36 Other $65
37 CashCheck $104
38 MC_VISA $132
39 AmerExpress $94
40 Other $122
41 MC_VISA $147
42 Other $88
43 CashCheck $75
44 AmerExpress $73
45 CashCheck $85
46 AmerExpress $145
47 MC_VISA $147
48 MC_VISA $156
49 MC_VISA $139
50 MC_VISA $123
51 MC_VISA $136
52 MC_VISA $145
53 AmerExpress $121
54 Other $111
55 CashCheck $77
56 AmerExpress $123
57 Other $131
58 MC_VISA $115
59 Other $123
60 AmerExpress $116
61 CashCheck $71
62 Other $102
63 MC_VISA $124
64 MC_VISA $127
65 MC_VISA $119
66 AmerExpress $133
67 MC_VISA $117
68 AmerExpress $108
69 AmerExpress $102
70 Other $96
71 CashCheck $116
72 AmerExpress $103
73 Other $103
74 MC_VISA $134
75 Other $101
76 AmerExpress $124
77 Other $91
78 MC_VISA $134
79 CashCheck $88
80 CashCheck $91
81 CashCheck $75
82 CashCheck $122
83 Other $88
84 CashCheck $88
85 MC_VISA $123
86 AmerExpress $110
87 Other $80
88 CashCheck $84
89 AmerExpress $120
90 CashCheck $98
91 MC_VISA $133
92 MC_VISA $120
93 Other $127
94 Other $103
95 AmerExpress $110
96 MC_VISA $128
97 MC_VISA $106
98 MC_VISA $150
99 MC_VISA $103
100 MC_VISA $124
101 AmerExpress $103
102 Other $97
103 CashCheck $93
104 AmerExpress $104
105 Other $104
106 MC_VISA $135
107 Other $102
108 AmerExpress $100
109 CashCheck $87
110 CashCheck $75
111 AmerExpress $102
112 AmerExpress $105
113 AmerExpress $73
114 Other $109
115 AmerExpress $153

#3 Data

Accounting Marketing Finance Management
$31,450 $28,350 $29,325 $27,320
$35,650 $27,845 $29,550 $26,450
$32,630 $28,430 $31,640 $30,135
$37,110 $27,645 $32,760 $27,340
$29,440 $28,635 $30,550 $28,635
$37,330 $29,875
$30,835 $28,890
$31,650