Question

Couple's Income	Bride's age	Payor	Wedding cost	Attendance	Value Rating
$130,000	22	Bride's Parents	$60,700.00	300	3
$157,000	23	Bride's Parents	$52,000.00	350	1
$98,000	27	Bride & Groom	$47,000.00	150	3
$72,000	29	Bride & Groom	$42,000.00	200	5
$86,000	25	Bride's Parents	$34,000.00	250	3
$90,000	28	Bride & Groom	$30,500.00	150	3
$43,000	19	Bride & Groom	$30,000.00	250	3
$100,000	30	Bride & Groom	$30,000.00	300	3
$65,000	24	Bride's Parents	$28,000.00	250	3
$78,000	35	Bride & Groom	$26,000.00	200	5
$73,000	25	Bride's Parents	$25,000.00	150	5
$75,000	27	Bride & Groom	$24,000.00	200	5
$64,000	25	Bride's Parents	$24,000.00	200	1
$67,000	27	Groom's Parents	$22,000.00	200	5
$75,000	25	Bride's Parents	$20,000.00	200	5
$67,000	30	Bride's Parents	$20,000.00	200	5
$62,000	21	Groom's Parents	$20,000.00	100	1
$75,000	19	Bride's Parents	$19,000.00	150	3
$52,000	23	Bride's Parents	$19,000.00	200	1
$64,000	22	Bride's Parents	$18,000.00	150	1
$55,000	28	Bride's Parents	$16,000.00	100	5
$53,000	31	Bride & Groom	$14,000.00	100	1
$62,000	24	Bride's Parents	$13,000.00	150	1
$40,000	26	Bride's Parents	$7,000.00	50	3
$45,000	32	Bride & Groom	$5,000.00	50	5

Consider the Weddings Data file.

For every variable in the file identify the following:

1. Calculate and construct Frequency distribution, relative frequency distribution and cumulative relative frequency distributing for the field (variable), Payor.
2. Plot each of the distributions using appropriate chart type.
3. Calculate the first quartile. What does it mean?
4. Can we calculate first Quartile? Why or why not?
5. How about 90^th percentile?

Note: Use Excel countif() and Data Analysis for calculations as needed.

please, I need your help to solve this problem by Excel!!

Answer 1