Statistics for Business

Computer Assignment # 1

The data for this problem is located in the Excel file on Isidore under Computer Assignment #1 and it corresponds to Case Problem 1 (Pelican Stores) on p. 102 -103 in your text.

Please answer the following questions within your Excel file. Please label your work so that it may be easily found within your file.

1. Using the pivot table tool, create a crosstabulation of type of customer (regular or promotional) versus net sales. Place this pivot table in a new worksheet labeled “Pivot Table.” Use good formatting practices when constructing this table as shown in class.

2. Based upon the summarized information from the pivot table you created in question 1, which type of customer tends to spend larger amounts on their purchases?

3. Based upon the summarized information from the pivot table you created in question 1, which type of customer comprises most of the sales for this sample?

4. Create a scatter diagram to explore the relationship between net sales and customer age. Put this scatter diagram in a new worksheet labeled “Scatter Diagram.” Before creating your scatter diagram, carefully consider which variable is most appropriate to put on the y-axis of your graph. Be sure to label your axes appropriately and create a meaningful title for your graph.

5. Based upon your scatter diagram from question 4, does there appear to be a relationship between the customer’s age and the net sales?

>&UnStack

&

Data

Indices

&DataCopy

&GraphData

&WorkArea

&Miscel_Area

Data

Married

3 Regular 1

Proprietary Card Female Married 32

4 Promotional 5

Proprietary Card Female Married

5 Regular 2

.00

Female Married

6 Regular 1

.50

MasterCard Female Married 44

Promotional 2

.00

Proprietary Card Female Married

8 Regular 1 22.50

Female Married 40

9 Promotional 2

Proprietary Card Female Married

10 Regular 1

Proprietary Card Female Married

Regular 1

.50

Proprietary Card Female Married

Promotional 1

Proprietary Card Female Married 40

Promotional 9

0.40

Visa Female Married 40

Promotional 2

.50

Visa Female Married 46

Regular 1

.50

Visa Male

16 Promotional 2

.40

Proprietary Card Male Single 36

Promotional 3

.00

Proprietary Card Female Single 22

Regular 3

Discover Female Married 40

Promotional 2

.50

MasterCard Female Married 32

Promotional 6

Proprietary Card Female Married 56

Promotional 1

Proprietary Card Female Single

22 Promotional 4

Proprietary Card Female Married 38

Promotional 7

6.00

Female Married 50

24 Regular 2

.00

Proprietary Card Female Married

Promotional 2

.50

Visa Male Married 48

26 Promotional 1

Proprietary Card Female Married 60

Regular 1 44.50 Proprietary Card Female Married 54

28 Promotional 5

.80

Proprietary Card Female Single 42

29 Promotional 3

Proprietary Card Female Married 32

30 Promotional 1

Proprietary Card Female Married 70

31 Promotional 2

.20

MasterCard Female Married 28

32 Regular 1

.00

Proprietary Card Female Married 52

Promotional 3 63.20 Proprietary Card Female Married 44

34 Regular 1

Proprietary Card Female Married 34

Promotional 5

MasterCard Female Married 56

36 Regular 1

MasterCard Male Single 36

Regular 2

Visa Female Single 42

38 Promotional 6

Proprietary Card Female Married 50

39 Promotional 5

Proprietary Card Female Married 44

40 Regular 2

Proprietary Card Female Married

Promotional 13

.80

Proprietary Card Female Married 42

42 Promotional 4

Visa Female Married 46

Regular 2

Proprietary Card Female Married 48

44 Promotional 1

.40

Proprietary Card Female Married 54

Promotional 2

Proprietary Card Female Married 38

46 Promotional 2

Proprietary Card Female Married 60

Regular 1

MasterCard Female Married 46

48 Promotional 3

Proprietary Card Female Married 30

49 Promotional 1

Proprietary Card Female Married 32

50 Promotional 9

MasterCard Female Married 46

Promotional 6

.62

Proprietary Card Female Married 38

52 Promotional 5

Proprietary Card Male Married

Regular 1

Discover Female Single 78

54 Regular 2 74.00 Visa Female Single 20

Regular 2

MasterCard Female Married 32

56 Promotional 3

Proprietary Card Female Married 38

Promotional 6

Proprietary Card Female Married 54

58 Promotional 2

Proprietary Card Female Married 48

Promotional 4

.20

MasterCard Female Married 46

60 Promotional 4

Proprietary Card Female Single 50

Promotional 1

Proprietary Card Female Married 46

62 Promotional 3

Proprietary Card Female Single 30

63 Promotional 5

Proprietary Card Female Married 54

64 Promotional 1 31.60 Proprietary Card Female Single 42
65 Promotional 2 49.50 Proprietary Card Female Married 48

Promotional 1 39.60 Proprietary Card Female Married 62

Promotional 2

Proprietary Card Female Married 34

68 Promotional 5

Proprietary Card Female Married 28

Promotional 2

Proprietary Card Male Married 46

70 Promotional 8

.05

Proprietary Card Female Married 54

71 Promotional 5

Proprietary Card Female Married 30

Promotional 4 58.00 MasterCard Female Married 32

Regular 1

Proprietary Card Female Single 22

74 Promotional 2

Proprietary Card Female Married 32

75 Promotional 2

Proprietary Card Female Married 74

76 Promotional 4

.74

Proprietary Card Female Married 62

Regular 2

Proprietary Card Female Married 42

78 Promotional 4

Proprietary Card Female Married 28

Promotional 3

.80

Proprietary Card Female Married 38

80 Regular 2

.00

Discover Female Married 54

Promotional 2

MasterCard Female Married 68

82 Promotional 6

Proprietary Card Female Single 30

Promotional 4

Visa Female Married 36

84 Promotional 3

Proprietary Card Female Married 44

Regular 2

Visa Female Married 44

86 Promotional 1

Proprietary Card Female Married 62

Regular 6

MasterCard Female Single 48

Regular 4

Proprietary Card Female Married 36

89 Promotional 1 31.60 Proprietary Card Female Single 20

Promotional 6

Proprietary Card Female Married 42

91 Promotional 4

Proprietary Card Female Married 54

92 Promotional 1

Proprietary Card Female Married 54

Regular 5

Proprietary Card Female Married 72

94 Promotional 17

Proprietary Card Female Married 30

95 Regular 3

American Express Female Married 46

Regular 1

MasterCard Female Married 44

Promotional 9

Proprietary Card Female Married 30

98 Promotional 10

Proprietary Card Female Married 52

Promotional 2

Proprietary Card Female Married 30

100 Promotional 1

Proprietary Card Female Married 44

Customer	Type of Customer	Items	Net Sales	Method of Payment	Gender	Marital Status	Age
																	1	Regular		3		9		5	Discover	Male		Married	32
																			Promotional		10		4				Proprietary Card			Female	3	6
				22				50
	100					40	2		8
									54						MasterCard	34
								44
	7			78							30
									Visa
			56			52						46
	44.50						36
11		29							48
12			31			60
	13		16
14		64
15		49											Single	24
	71
	17		94
18	54.50
19							38
		20	44.	80
21		31.60					28
		70	82
23		26		American Express
			74							42
25		39
30.02
27
1	92
71.20
18.00
		63
	75
33
40.00
35	105.50
29.50
37	102.50
117.50
13.23
52.50		58
41	1	98
19.50
43	123.50
				62
45	23.80
	39.60
47	25.00
63.64
14.82
145.20
51	1	76
118.80			68
53		58.00
55		49.50
141.60
57	123.10
80.40
59		65
113.00
61	108.80
59.	91
53.60
66
67	59.50
146.80
69	47.20
	95
155.32
	72
73	69.00
46.50
45.22
	84
77	39.00
111.14
79		86
	89
81	78.00
53.20
83	58.50
46.00
85	37.50
20.80
87	144.00
88	107.00
90	57.60
95.20
22.42
93	159.75
229.50
66.00
96	39.50
97	253.00
287.59
99	47.60
28.44

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Statistics for Business ”

Get high-quality paper

Guarantee! All work is written by expert writers!

Still stressed from student homework?

Get quality assistance from academic writers!

Order now