$1.$ You are given the following data for outbound travel from Hawaii to eight

destinations. For each destination the figures represent information about travelers from

Hawaii to the destination for the month of September $2022.$

Destination No$.$ Travelers Avg. Daily

Expend$/$person

Avg. Length of

stay

Avg. party size

New York $12,110$ $$3057$ days $1\mathrm{.}5$

Hong Kong $15,843$ $$2625$ days $1\mathrm{.}8$

San Francisco $21,153$ $$1946$ days $3\mathrm{.}1$

Singapore $12,347$ $$1625$ days $2\mathrm{.}8$

Bali, Indonesia $8,980$ $ $849$ days $2\mathrm{.}0$

New Zealand $9,140$ $$11314$ days $2\mathrm{.}2$

Los Angeles $17,211$ $$1795$ days $2\mathrm{.}3$

Las Vegas $22,385$ $$2228$ days $3\mathrm{.}6$

$2.$ Create new columns as follows:

$$ Number of visitor$-$days spent in each destination by visitors from Hawaii

$$ Average spending per party in each destination

$$ Percentage of international visitors to Singapore coming from Hawaii $($you

will have to research to find the Singapore statistics$).$ Please note your

source.

$3.$ You are also told the following facts:

$$ Assume there are $3$ flights per day to the domestic destinations and $2$ per day to

the foreign destinations.

$$ assume that each aircraft has $300$ seats on board

$$ assume that $30\%$ of travelers to foreign destinations are business travelers and

$55\%$ of travelers to domestic destinations are business travelers.

$4.$ CALCULATE the following statistics in your spreadsheet for each destination.

Use a formula in each case so that the spreadsheet calculates the numbers for you:

a$.$ the number of business travelers to each destination.

b$.$ the average load factor for flights to each