Question

Part 1: V₂ Quantitative Data

Use the list of 100 numbers from Lab 1, column V₂ for this part of the lab. (Lab 1 data at the bottom)

Identify the name of the quantitative variable V₂ that you are using. __________________

B. Use Microsoft Excel to find

Mean ________________________

Median _______________________

Mode _________________________

            Standard Deviation _________________________

            Minimum Value          ________________________

            Maximum Value         ________________________

Q1 _____________________________

Q3 _____________________________

C.            Consider your values for mean, median and mode listed above. Which is the largest?

Discuss the similarities and differences among your three measures.

Which one of these measures of central tendency is most suitable for your data? Explain your choice.

D.           Using the appropriate numbers from B above, make a box-and-whisker plot for your data.

What does this plot tell you about your data?

Lab 1 Data

Row	Items	Sales	Card Type	Gender	Country	Age	Martial Status
1	19	$50.61	visa-electron	Male	China	35	2
2	14	$105.37	mastercard	Female	China	22	2
3	11	$90.21	maestro	Female	Russia	52	2
4	20	$280.84	visa	Male	China	38	1
5	18	$265.68	jcb	Male	China	44	1
6	19	$103.63	americanexpress	Female	Indonesia	56	2
7	17	$215.00	jcb	Male	Dominican Republic	51	1
8	20	$168.06	laser	Male	Czech Republic	25	1
9	3	$181.42	maestro	Female	China	41	1
10	11	$240.51	mastercard	Female	China	44	1
11	17	$260.56	jcb	Male	China	58	1
12	17	$170.56	jcb	Female	Belarus	28	2
13	14	$71.42	diners-club-carte-blanche	Male	Sweden	41	1
14	3	$242.23	diners-club-carte-blanche	Female	Indonesia	58	2
15	15	$250.44	visa-electron	Male	Latvia	41	2
16	4	$71.80	jcb	Male	New Zealand	20	2
17	6	$33.62	diners-club-us-ca	Male	United States	48	2
18	17	$81.35	diners-club-enroute	Female	Colombia	44	2
19	13	$67.09	maestro	Male	China	53	1
20	3	$262.41	jcb	Female	Lithuania	22	1
21	16	$204.28	jcb	Female	Indonesia	23	2
22	2	$289.74	jcb	Female	Vietnam	28	2
23	1	$33.45	china-unionpay	Male	China	29	2
24	19	$154.19	jcb	Female	Botswana	46	2
25	20	$43.29	diners-club-enroute	Male	Argentina	58	2
26	5	$96.97	jcb	Male	Russia	42	2
27	1	$46.62	jcb	Male	Ecuador	21	2
28	17	$241.04	jcb	Male	China	41	1
29	6	$251.64	switch	Female	Sudan	58	1
30	1	$115.24	visa-electron	Female	Canada	52	1
31	10	$263.42	jcb	Male	France	44	2
32	10	$274.67	jcb	Female	Italy	32	2
33	1	$69.59	jcb	Female	Switzerland	48	2
34	17	$136.30	china-unionpay	Male	China	44	2
35	7	$201.52	jcb	Male	Macedonia	26	2
36	8	$51.44	switch	Female	Papua New Guinea	51	1
37	11	$52.95	jcb	Male	Czech Republic	48	2
38	19	$162.89	china-unionpay	Female	China	36	2
39	5	$160.09	jcb	Female	China	38	1
40	6	$91.28	jcb	Female	Brazil	39	1
41	4	$140.53	mastercard	Female	Indonesia	26	2
42	15	$190.36	visa	Male	Greece	57	1
43	10	$181.57	americanexpress	Male	Philippines	46	2
44	1	$65.59	jcb	Female	China	31	1
45	3	$49.01	laser	Female	United States	49	2
46	16	$88.05	jcb	Female	France	54	2
47	9	$193.79	jcb	Male	Indonesia	38	1
48	5	$39.55	mastercard	Female	Indonesia	24	2
49	1	$32.56	jcb	Male	Japan	23	1
50	2	$54.52	china-unionpay	Male	Ireland	43	1
51	19	$161.89	jcb	Male	China	57	1
52	2	$59.63	maestro	Male	Cyprus	35	1
53	13	$257.81	bankcard	Male	China	38	1
54	15	$166.53	laser	Male	South Africa	50	1
55	15	$253.02	diners-club-carte-blanche	Female	Canada	39	2
56	16	$193.56	americanexpress	Female	China	30	2
57	18	$80.57	china-unionpay	Male	Brazil	30	1
58	18	$250.29	jcb	Male	Yemen	41	1
59	15	$46.79	jcb	Female	Japan	42	1
60	18	$276.56	laser	Male	Slovenia	32	2
61	14	$135.13	jcb	Male	Tanzania	31	1
62	14	$195.58	jcb	Female	China	42	1
63	15	$182.98	visa	Female	China	52	2
64	8	$221.03	jcb	Male	Zimbabwe	29	1
65	3	$128.11	jcb	Female	China	40	1
66	19	$76.60	diners-club-carte-blanche	Female	Indonesia	38	1
67	13	$27.07	jcb	Female	China	59	2
68	4	$109.20	diners-club-carte-blanche	Male	Russia	48	2
69	4	$276.85	jcb	Male	Uruguay	57	2
70	19	$195.10	jcb	Male	Sao Tome and Principe	25	1
71	5	$112.23	instapayment	Male	Zambia	41	1
72	15	$61.94	jcb	Female	Nigeria	41	1
73	4	$35.08	jcb	Female	China	35	2
74	20	$60.13	switch	Male	China	23	2
75	6	$277.11	visa-electron	Female	Portugal	54	2
76	5	$220.47	jcb	Female	Russia	37	2
77	14	$185.57	laser	Male	Russia	53	2
78	19	$295.96	diners-club-enroute	Male	Greece	51	1
79	12	$238.86	visa	Female	Indonesia	45	2
80	3	$275.81	visa-electron	Female	Indonesia	26	2
81	7	$77.07	visa	Female	Portugal	57	1
82	2	$252.58	mastercard	Female	Russia	45	2
83	4	$134.78	jcb	Male	Japan	29	1
84	3	$43.49	americanexpress	Male	Indonesia	48	2
85	1	$223.78	jcb	Male	Mexico	53	2
86	8	$238.74	jcb	Female	China	28	2
87	9	$291.30	americanexpress	Male	Togo	44	1
88	14	$79.46	jcb	Female	Finland	54	2
89	16	$193.73	jcb	Male	Indonesia	57	1
90	13	$224.23	visa-electron	Female	Pakistan	23	2
91	16	$247.43	mastercard	Female	Honduras	27	1
92	9	$186.11	jcb	Male	China	56	2
93	17	$58.48	jcb	Male	China	53	2
94	1	$281.40	jcb	Female	Philippines	46	2
95	10	$254.37	bankcard	Male	Brazil	42	1
96	8	$145.00	jcb	Female	Indonesia	50	2
97	20	$122.35	jcb	Female	Sweden	25	2
98	1	$210.77	jcb	Male	Portugal	50	1
99	7	$225.37	diners-club-carte-blanche	Female	South Africa	43	2
100	18	$87.98	maestro	Male	China	37	2
Note:
Marital Status 1 = Married
Marital Status 2 = Single

Answer 1

Identify the name of the quantitative variable V2 that you are using "SALES"

Mean	158.25
Median	164.71
Mode	#N/A ( No repeated values)
SD	83.75
Minimum	27.07
Maximum	295.96
Q1	76.95
Q3	239.27

Formulas in excel

Mean	=AVERAGE(A2:A101)
Median	=MEDIAN(A2:A101)
Mode	=MODE(A2:A101)
SD	=STDEV(A2:A101)
Minimum	=MIN(A2:A101)
Maximum	=MAX(A2:A101)
Q1	=QUARTILE(A2:A101,1)
Q3	=QUARTILE(A2:A101,3)

C.            Consider your values for mean, median and mode listed above. Which is the largest?

Median is the largest value . 164.71

Discuss the similarities and differences among your three measures.

Which one of these measures of central tendency is most suitable for your data? Explain your choice.

Mean, median and mode are all different terms of central tendency or the average but they are all different from each other. A comparison of the three is therefore necessary.

It is usually inappropriate to use the mean in such situations where your data is skewed. You would normally choose the median or mode, with the median usually preferred

The median is the middle score for a set of data that has been arranged in order of magnitude. The median is less affected by outliers and skewed data

As per our data set median is the central tendency

Using the appropriate numbers from B above, make a box-and-whisker plot for your data.

What does this plot tell you about your data?

A box and whisker plot is a way of summarizing a set of data measured on an interval scale. It is often used in explanatory data analysis. This type of graph is used to show the shape of the distribution, its central value, and its variability.

In a box and whisker plot:

• the ends of the box are the upper and lower quartiles, so the box spans the interquartile range
• the median is marked by a vertical line inside the box
• the whiskers are the two lines outside the box that extend to the highest and lowest observations

Formla reference:

STep-by step procedure to make boxplot

Select Boxplot lower, hidden and upper value and add 2ns stacked column. after that select switch row/colum option to bring all data into single stacked column

select top of the bar and add error bar through chart element. after adding choose "plus" option and add whisker top value