Question

note: please make sure to properly format your answers. all dollar figures in the answers need to include the dollar sign and any amount over 1,000 should include the comma ($2,354.67). all percentage values in the answers need to include a percentage sign (%). for all items without specific rounding instructions, round your answers to two decimal places, show both decimal places (5.06).
seaquola river cruises offers a 7 - day travel package. the prices vary based on the room class booked, as indicated in the following spreadsheet:

a	b	c	d	e	f
1	standard	$4,750	10	0.1	10	0.1
2	premium	$4,920	10	0.1	20	0.2
3	standard	$5,200	15	0.15	35	0.35
4	deluxe	$5,850	20	0.2	55	0.55
5	premium deluxe	$6,962	20	0.2	75	0.75
6	deluxe luxury	$7,362	15	0.15	90	0.9
7	premium luxury	$10,162	10	0.1	100	1
8	penthouse balcony
9	total	100

write the spreadsheet formulas for the indicated cells.
a. c9
b. d3
c. d7
d. e4
e. f5

Explanation:

Step1: Calculate total number of rooms in C9

=SUM(C2:C8)

Step2: Calculate relative frequency in D3

=C3/SUM($C$2:$C$8)

Step3: Calculate relative frequency in D7

=C7/SUM($C$2:$C$8)

Step4: Calculate cumulative frequency in E4

=E3+C4

Step5: Calculate relative cumulative frequency in F5

=E5/SUM($C$2:$C$8)

Answer:

a. =SUM(C2:C8)
b. =C3/SUM($C$2:$C$8)
c. =C7/SUM($C$2:$C$8)
d. =E3+C4
e. =E5/SUM($C$2:$C$8)