create the scatter chart and construct a formula that can be used for planning cleaning costs at different levels of occupancy based on the following requirements:

Columns B and C in the Hotel Costs worksheet contain occupancy and cleaning cost data for 12 months. Create a scatter chart that shows just the plot points (Scatter with only Markers) for the occupancy and cleaning costs for each month on this worksheet. The chart should be embedded in the Hotel Costs worksheet and should include the appropriate formatting techniques covered in this chapter.

Adjust the scale of the X and Y axes so the minimum value is 2000.

Add a linear trendline to the chart and show the equation.

Use the trendline equation to enter a formula in cell C19 that calculates the estimated cleaning costs based on the occupancy level that is typed into cell C18.

Show work in Excel please.

Hotel Occupancy and Cleaning Costs for Last Year
Month	Actual Occupancy	Cleaning Expenses
January	4,371	$ 5,595
February	3,715	$ 4,246
March	2,062	$ 4,053
April	3,351	$ 4,566
May	4,124	$ 5,413
June	5,413	$ 5,986
July	4,219	$ 5,259
August	4,640	$ 5,542
September	3,866	$ 4,426
October	2,513	$ 4,267
November	2,513	$ 4,104
December	5,142	$ 5,877
	Planned Occupancy	5,000
	Cleaning Costs