Hotel Occupancy A Small Hotel Has Recorded the Number of Rooms Occupied

question 196

Essay

Hotel Occupancy
A small hotel has recorded the number of rooms occupied during weekdays over a period of four weeks as is shown in the table below:

-{Hotel Occupancy Narrative} Calculate the seasonal indexes,based on the regression trend line developed in the previous question.

---

Definitions:

Make-table Query

A type of database query that creates a new table and populates it with data selected from one or more existing tables.

Append Query

A database query that adds the results of a selection to an existing dataset, rather than creating a new one.

Records

An item or collection of data.

Validation Rules

Criteria that are set up in a database or input form to ensure that only valid data is entered.