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).

	july	aug	sept	oct	nov	dec	average
dining out	120	150	300	80	100	150	b.
fuel (car)	200	240	320	300	280	220	c.
cell phone	104	108	126	140	120	104	d.
land line phone	80	90	60	80	100	88	e.
electricity	140	160	120	90	140	160	f.
water	52	58	62	48	48	62	g.

the shahs decided they would not use the september amounts, when they were on vacation, nor the december amounts, when cousins stayed with them. assume the chart is a spreadsheet with row 1 as the month labels and column a as the expense categories. (please put \=\ sign if required in answers)

a. write a spreadsheet formula to calculate the adjusted average for food.
b. what is the adjusted average for food?
c. write a spreadsheet formula to calculate the adjusted average for electricity.
d. what is the adjusted average for electricity?

Explanation:

a.

Step1: Identify relevant months

We exclude September (Sept) and December (Dec) for food. So use July, Aug, Oct, Nov. Their cells (assuming July=B2, Aug=C2, Oct=E2, Nov=F2).

Step2: Write average formula

In spreadsheet, average of B2, C2, E2, F2 is =AVERAGE(B2,C2,E2,F2)

Step1: Sum the values

July=740, Aug=800, Oct=820, Nov=820. Sum: 740 + 800 + 820 + 820 = 3180

Step2: Divide by number of months

Number of months = 4. Average: 3180 / 4 = 795.00

Step1: Identify relevant months for electricity

Exclude Sept (D7) and Dec (G7). Use July (B7), Aug (C7), Oct (E7), Nov (F7).

Step2: Write average formula

Spreadsheet formula: =AVERAGE(B7,C7,E7,F7)

Answer:

=AVERAGE(B2,C2,E2,F2)

b.