Question

How do you create a frequency distribution on excel using all 7 variables?

Customer	Type of Customer	Items	Net Sales	Method of Payment	Gender	Marital Status	Age
1	Regular	1	39.50	Discover	Male	Married	32
2	Promotional	1	102.40	Proprietary Card	Female	Married	36
3	Regular	1	22.50	Proprietary Card	Female	Married	32
4	Promotional	5	100.40	Proprietary Card	Female	Married	28
5	Regular	2	54.00	MasterCard	Female	Married	34
6	Regular	1	44.50	MasterCard	Female	Married	44
7	Promotional	2	78.00	Proprietary Card	Female	Married	30
8	Regular	1	22.50	Visa	Female	Married	40
9	Promotional	2	56.52	Proprietary Card	Female	Married	46
10	Regular	1	44.50	Proprietary Card	Female	Married	36
11	Regular	1	29.50	Proprietary Card	Female	Married	48
12	Promotional	1	31.60	Proprietary Card	Female	Married	40
13	Promotional	9	160.40	Visa	Female	Married	40
14	Promotional	2	64.50	Visa	Female	Married	46
15	Regular	1	49.50	Visa	Male	Single	24
16	Promotional	2	71.40	Proprietary Card	Male	Single	36
17	Promotional	3	94.00	Proprietary Card	Female	Single	22
18	Regular	3	54.50	Discover	Female	Married	40
19	Promotional	2	38.50	MasterCard	Female	Married	32

Answer 1

You create the frequency distribution by categories, not with the whole data set.

The frequency distributions are as follows:

Type of Customer
	frequency	percent
Regular	9	47.4
Promotional	10	52.6
	19	100.0

Items
	frequency	percent
1	9	47.4
2	6	31.6
3	2	10.5
5	1	5.3
9	1	5.3
	19	100.0

	Net Sales						cumulative
lower		upper	midpoint	width	frequency	percent	frequency	percent
20.0	<	39.9999	30.0	20.0	6	31.6	6	31.6
40.0	<	59.9999	50.0	20.0	6	31.6	12	63.2
60.0	<	79.9999	70.0	20.0	3	15.8	15	78.9
80.0	<	99.9999	90.0	20.0	1	5.3	16	84.2
100.0	<	119.9999	110.0	20.0	2	10.5	18	94.7
120.0	<	139.9999	130.0	20.0	0	0.0	18	94.7
140.0	<	159.9999	150.0	20.0	0	0.0	18	94.7
160.0	<	179.9999	170.0	20.0	1	5.3	19	100.0
					19	100.0

Method of Payment
	frequency	percent
Proprietary Card	10	52.6
Discover	2	10.5
MasterCard	3	15.8
Visa	4	21.1
	19	100.0

Gender
	frequency	percent
Male	3	15.8
Female	16	84.2
	19	100.0

Marital Status
	frequency	percent
Single	3	15.8
Married	16	84.2
	19	100.0

	Age						cumulative
lower		upper	midpoint	width	frequency	percent	frequency	percent
20	<	24.99	23	5	2	10.5	2	10.5
25	<	29.99	28	5	1	5.3	3	15.8
30	<	34.99	33	5	5	26.3	8	42.1
35	<	39.99	38	5	3	15.8	11	57.9
40	<	44.99	43	5	5	26.3	16	84.2
45	<	49.99	47	5	3	15.8	19	100.0
					19	100.0

Simply count the values and those will be your frequencies. And that's how you create the frequency distribution.