hmw10

profileSam321
310homework10data.xlsx

#1 Data

Student Midterm Final
1 72 70
2 95 100
3 83 88
4 85 75
5 65 73
6 82 86
7 84 85
8 74 69
9 74 76
10 82 73
11 81 71
12 75 80
13 78 72
14 78 83
15 72 68
16 73 83
17 75 76
18 79 69
19 72 76
20 75 79
21 77 74
22 71 80
23 78 70
24 83 93
25 84 78
26 71 81
27 81 73
28 82 88
29 79 83
30 71 69
31 73 77
32 89 87
33 74 74
34 75 78
35 93 96
36 74 84
37 88 90
38 83 89
39 90 100
40 82 82
41 79 85
42 62 60
43 73 70
44 88 88
45 76 80
46 76 86
47 76 68
48 80 84
49 84 92
50 84 74
51 91 98
52 70 64
53 76 78
54 74 79
55 68 76
56 80 88
57 87 94
58 92 86
59 84 87
60 79 75
61 80 75
62 91 84
63 74 77
64 69 62
65 88 92
66 84 79
67 83 82
68 87 81
69 82 89
70 72 63
71 97 87
72 88 91
73 70 71
74 83 78
75 92 97
76 94 92
77 63 56
78 83 91
79 81 78
80 84 94
81 78 71
82 84 93
83 91 88
84 78 88
85 71 76
86 77 79
87 78 78
88 70 74
89 86 89
90 79 85
91 70 60
92 75 78
93 80 84
94 75 66
95 77 80
96 74 65

This data is from an actual finance course, but the students' names have been omitted.

#2 Data

Month Contracts Sold Average ContractPrice Advertising Expenditures Personal Selling Expenditures
1 2,000 $2,600 $19,800 $34,000
2 2,000 $2,700 $20,300 $32,000
3 3,000 $2,700 $29,800 $45,000
4 1,250 $2,900 $12,300 $26,000
5 1,750 $3,000 $17,400 $33,000
6 2,750 $3,200 $28,200 $40,000
7 2,500 $3,200 $18,400 $41,000
8 1,000 $3,200 $10,400 $26,000
9 1,500 $3,500 $15,300 $34,000
10 1,750 $3,600 $17,400 $35,000
11 2,250 $3,700 $23,500 $39,000
12 2,500 $3,800 $26,800 $43,000

This is fictitious data.

#3 Data

Package Cost of Shipment Package Weight Distance Shipped
1 $3.30 4.10 95
2 $2.00 0.30 160
3 $11.00 5.10 240
4 $2.60 5.90 47
5 $1.90 4.50 53
6 $8.00 3.50 250
7 $15.50 7.00 260
8 $5.00 2.40 209
9 $1.00 0.60 100
10 $4.40 0.75 280
11 $6.00 6.20 115
12 $1.70 1.10 90
13 $14.50 6.50 240
14 $14.00 7.50 190
15 $9.20 6.60 160
16 $1.10 2.70 45
17 $12.10 8.10 160
18 $1.50 0.70 80
19 $8.00 4.40 202
20 $3.90 3.20 145

This is fictitious data.