QUESTION 1

(a) If you roll a dice 12 times what is the probability that you will roll two 6s? Work out both by hand and using the EXCEL function for the Binomial distribution.

(b) If you roll a dice 12 times what is the probability that you will roll more than two 6s? Work out using the EXCEL function for the Binomial distribution only (that is, don’t worry about doing this calculation by hand).

(c) If you roll a dice 12 times what is the mean and the variance of the number of 6s you will throw? Please use the Binomial formulas (Mean = n.p, Variance = n.p.(1 – p)) to work these out and then check using EXCEL and the general formulas for the mean and variance of any probability distribution:

= i P(X i) and = (Xi – )2P(Xi)

(d) If you roll a dice 12 times what is the skewness and kurtosis of the number of 6s you will throw? Please just use EXCEL to work this out.

(2 marks)

QUESTION 2

It is often thought that the Australian share market takes its lead from America. To look at this you examine the monthly returns from the Australian and US share markets from 2007 to 2017. The data to be used for this question is in the Excel file ECON1095 Data Sem 1 2018.xls on Canvas.

(a) Using all of the available data for Share prices: Australia: S&P/ASX 200 (AUS) and the Share prices: United States: United States: S&P 500 (USA), examine the relationship between these two variables. To do this, graph the two variables against each other. You may do a number of graphs; that is, both as levels and as returns and as XY graphs and as line (time series) graphs. Does it look as though the variables are dependent or independent?

(b) As a further test calculate the correlation coefficient between the AUS and USA (tools, data analysis, correlation). Again, do this both for the levels and the returns. Please interpret this coefficient and offer a brief explanation for the result.

(c) Using the same data fill in the following table for the number of rises and falls .

AUS

USA

Rise No change Fall Total

Rise

No change

Fall

Total

(d) Calculate the joint probability distribution and the marginal probability distributions for the data.

(e) Using your previous answers as a guide, make a decision regarding whether the AUS and USA are dependent or independent?

(f) Due to the potential trade war between the US and China you expect the US share returns market to fall in the near future. Calculate the conditional probability distribution for AUS given that USA has decreased. Explain how this calculation could be used to guide your Australian investment decisions.

(3 marks)

QUESTION 3

You are considering moving additional funds into the Australian share market. To assist with this decision you analysis AUS from 2007 to 2017 in more detail (from the QUESTION 2 data set). I suggest using Excel’s Tools/Data Analysis/Descriptive Statistics on the continuous returns to answer these questions.

(a) Calculate the 95 % confidence interval for the AUS returns over this period. Please interpret this confidence interval.

(b) You decide that you are only prepared to put more money into Australian shares if you can confidently rule out negative returns. Therefore, the decision is to invest only if you believe that monthly returns will not go below zero. Average monthly returns for the sample period are below zero, therefore you would clearly not invest using this rule. However, you know that the early part of the sample period includes the Global Financial Crisis (GFC) and as you do not anticipate another GFC in the immediate future you decide to start the sample in 2009 (use a sample from 2009 to 2017 to answer the rest of this question). Using this smaller sample the average monthly returns should be just above zero. Therefore the question is, have monthly returns on the AUS been far enough above zero for you to be convinced that they will not go negative in the near future?’ Test to see whether the returns are less than or equal to zero using a level of significance of Would you invest?

(c) Test to see whether the AUS has a normal distribution using the Jarque-Bera test. This must be done in Excel, by calculating the Jarque-Bera statistic using the formulas from the notes and Excel’s Tools/Data Analysis/Descriptive Statistics. Using the results of this test, comment on the accuracy of the probabilities you calculated in parts (a) and (b) of this question.

(d) The AUS monthly returns over the sample period are negatively skewed. Explain why this is the case, and then explain the implications of this for your investment decision.

(e) Using the continuous returns on AUS, determine whether the rises and falls are independent using a runs test. What are the implications of your findings?

(2.5 marks)

QUESTION 4

An individual’s utility function is represented by:

Their budget constraint is:

That is, their total budget is $10,000 and the price of X1 is $2 and the price of X2 is $5. Use the Lagrangian function to find the optimal values of X1 and X2 that maximises utility subject to the budget constraint . What is the value of and what is its interpretation?

Check your answer using EXCEL. To do this open a new spread sheet and insert names for X1 and X2 in cells B2 and C2 and the starting values for these variables of 1 in both cells B3 and C3. Use the Insert, Name, Define commands to name cells B3 and C3. In cell B6 type the formula for the utility function, = (Xone^0.9)*(Xtwo^0.1) and name this UU. In cell B9 type the formula for the budget, =2*Xone+5*Xtwo and name this BB. Next, go to the solver and set target cell UU equal to maximum by changing Xone and Xtwo. Then add the constraint that BB = 10,000, then solve. When given the solver results ask for the sensitivity report as this gives .

(2 marks)

QUESTION 5

Using the following matrices:

(a) State the dimensions of A, B and C.

(b) Find A.B

(c) Find B.C

(d) Find A.C’

(e) Using excel find C-1, then multiply C-1 by C to find I.

Do (b), (c), (d) and (e) using excel.

(2.5 marks)

QUESTION 6 (please use EXCEL for this question).

You are trying to diversify your investments across different share markets around the world and so want to construct an efficient frontier. Follow the instructions presented below to construct the efficient frontier for the proportions of your funds that need to be allocated to the various markets (there are additional instructions in the Mathematical Programming notes).

Using the file ECON1095 Data Sem 1 2018.xls and the entire sample from 2007 to 2018 as a guide, an investor would like to allocate their funds across the shares markets of USA, Japan, Euro area, UK, New Zealand, Hong Kong, Taiwan, Korea, China and Australia in an optimal way by finding the various efficient allocations. An efficient allocation of funds is one in which expected risk is minimised for a given level of expected return. A graph of the possible optimal values of the returns and risk is called the efficient frontier.

Calculate the average continuous monthly returns, then convert the average monthly returns to yearly returns by multiplying each by 12. Transpose this block of cells and name the average returns Ret. Use the covariance command from EXCEL’s Data Analysis Tools to find the variance-covariance matrix for these monthly returns. This matrix is symmetrical, so the missing elements can be easily filled in. Name this matrix Mvac. Convert Mvac into the variance-covariance matrix for yearly returns by highlighting the cells and entering =12*Mvac [Ctrl]+[Shft]+[Enter]. Name this block Vac. Enter the initial guesses for the optimal weights for the shares and name this block of cells Wts. Transpose these weights and name this block Twts. Find the expected return for the portfolio using =MMULT (Wts, Ret) [Ctrl]+[Shft]+[Enter]. Call this cell Pret. Finding the variance of portfolio returns requires three stages. First, highlight the appropriate cells and enter =MMULT (Wts,Vac) [Ctrl]+[Shft]+[Enter]. Name this block Tvac. Second, highlight a single cell and enter =MMULT (Tvac, Twts) [Ctrl]+[Shft]+[Enter]. Call this cell Pvar. Next, find the portfolio risk, or square root of the portfolio variance and name this cell Prsk. To ensure that the portfolio weights sum to one, enter ten 1’s and name this block Unit. To find the expression for the sum of the weights by entering =MMULT (Unit, Twts) [Ctrl]+[Shft]+[Enter]. Name this cell Wtcn.

Using this work sheet and the EXCEL Solver Tool find the minimum risk for the funds allocations for the various expected returns (I suggest performing the exercise for about ten different expected returns, chosen to ensure a solution can be found). In each case you must constrain the weights so they are non-negative and sum to one. Use these values to graph the Efficient Frontier with risk on the horizontal axis and returns on the vertical axis.

Write a brief report explaining how your portfolio changes as you try different expected returns.

(8 marks)

QUESTION 7

The data to be used for this question is in the Excel file ECON1095 Data Sem 1 2018.xlsx on Canvas. Using all of the available data for returns on Share prices: Australia: S&P/ASX 200 (RAUSt) and the returns for Share prices: United States: S&P 500 (RUSAt); examine the relationship between these two variables via regression. That is, use regression analysis to estimate RAUSt = 0 + 1RUSAt. This should be done using the three approaches used in the example on the Canvas (sample regression example.xlsx). All three approaches should yield the same answer. That is:

(a) Use the solver to find the values of 0 and 1 that minimize ei2.

(b) Ensure that the values of 0 and 1 satisfy the normal equations.

(c) Use Excel’s regression function to confirm your results in parts (a) and (b).

(d) Next, it is often thought that the Australian economy is driven by what happens in both America (US) and China. Test this by estimating a multiple regression where returns on Australian shares are a function of returns on both the US and Chinese share (China: Shanghai A), but do this using excel and the matrix formula = (XX)-1Xy , then check your results using the regression function in excel. Interpret your results.\

Housekeeping is a procedure of influencing a place or association to spotless and clean . There is particular division in lodging which is called housekeeping office . This office is dependable to clean the inn rooms and normal region . This office is administer by a housekeeping director and help by a right hand supervisor. In this procedure , exercises, for example, cleaning filthy surface , tidying , vacuuming and refuse arranging are done routinely . So as to clean , apparatuses, for example, floor brush , wipe , vacuum machine , and cleanser are utilized . Housekeeping office additionally assumes a vital part in lodging line since it makes a charming impression . Point: TRAINING AND DEVELOPMENT IN HOUSEKEEPING What are three essential territories housekeeping workers ought to get preparing? Rundown the components found in every region and the significance of natural and wellbeing concerns. Give great and poor cases. ROOM http://img4.realsimple.com/pictures/home-sorting out/cleaning/0604/family-room_300.jpg Room is the essential territory for a housekeeping staff to get preparing . Room is the principle wellspring of wage for the inn preface . Room ought to be kept clean with the goal that it would make a decent impression to the visitor consequently making a trust in them . anyway to get a spotless room , housekeeping staff should Clean the room altogether without raising dust, utilizing a clammy wipe , Routinely perfect and sanitize hardware and furniture in clients room , Commode, Empty and sterilize the sputum mug much of the time if the client is utilizing it , Empty and clean the waste-paper container every day or when fundamental , keep windows open to advance ventilation and utilize air-refreshing shower if there is a smell left in the room . The class of the room in the inn for the most part relies upon the structure of the lodging itself. The characterization of the lodging rooms is regularly utilized less for the sign of solace, with respect to the impression of the quantity of beds. You can securely say that the general standard for the worldwide inn business today is a solitary room. Traveler, remaining in it, can depend on the different washroom, closet, TV set. WI-FI association with the Internet is a default alternative essentially in every one of the rooms of new hotels.Depending on the host nation and the status of the inn a standard room can have extra capacities and highlights. For instance, in numerous lodgings in Britain washstands with the different fixture for chilly and boiling water can be found. In Chine the standard set for the washroom incorporates a hairbrush, a toothbrush and glue. Subsequently the standard set for the washroom on the planet inn industry incorporates cleanser, towels for body and hands and, recently, a shower gel.In expansion to the standard room, the world arrangement recognizes in excess of 30 unique kinds of rooms. The sort of the inn room can rely upon the view from the window, the number and the span of rooms, the nature of furniture, the substance of smaller than usual bar and the accessibility of office hardware. Notwithstanding the order of rooms there is a grouping of convenience. There are likewise a ton of alternatives: from a twofold room, where at least three individuals can stay, to settlement with kids or in the different lodge on the region of the inn. Both the room composes and the convenience writes have alphabetic acronyms, essentially in English. For instance, BO remains for bed just and implies that dinners are excluded. A shortened form SV (ocean see) in the portrayal of the room implies that you will have the capacity to watch the ocean through your window.These are the kinds of room Exclusive Exclusive rooms - a standout amongst the most costly rooms in the inn. Special (De luxury) - the word is from the French dialect, truly can be high class Standard Standard or single room - is a great of inn business. A solitary room in any inn assumes its very own part money. Suite Suite - is an inn stay with an enhanced plan. Suites are frequently comparative in size to a standard room, however the nature of configuration stays great Lodging LOBBY http://www.empresshotels.com/img/ruler lodging lobby.jpg Lodging anteroom assumes a vital part in housekeeping since that is the primary spot visitor will find in the passage of the inn . Other than that , visitor can really rest while holding up their reservation to be proceses . The hall ought to be kept clean consistently , the seats and table ought to be wiped and the floor ought to be wiped . Entryway likewise can be called as anteroom or passageway corridor . Numerous office structures, inns and high rises put forth an admirable attempt to embellish their entryways to make the correct impression. Since the mid 1980s there has been a developing pattern to consider campaigns something beyond approaches to get from the way to the lift, yet rather as social spaces and places of trade. Some exploration has even been done to create scales to gauge campaign climate with a specific end goal to enhance lodging entryway outline. Numerous spots that offer open administrations, for example, a specialist's office, utilize their entryways as to a greater degree a sitting tight space for the general population sitting tight for a specific administration. In these sorts of halls usually for there to be agreeable furniture, for example, sofas and parlor seats, with the goal that the client will have the capacity to hold up in comfort. Additionally, there might be TVs, books, and additionally magazines to enable the client to take a break as they hold up to be served . At last the entryway ought to be kept clean to get more pay . Inn WASHROOM http://s3.amazonaws.com/atimg/82961/HazeltonHotel_rect540.jpg Inn washroom ought to be kept clean with the goal that it would make a decent impression to the client . The housekeeping office is dependable to guarantee that these place are kept perfect and clean .a washroom can be a solitary unit including a can and hand bowl for hand washing. washroom can likewise be bigger offices, which may incorporate showering offices or showers, changing rooms and child facilities.washroom might be remain solitary structures or establishments, or be contained inside structures, for example, railroad stations, schools, bars, restaurants,nightclubs or filling stations. washroom can likewise be found on some open transport vehicles, for use by travelers. washroom are generally settled offices, yet can likewise allude to littler open compact toilets, or bigger open versatile toilets built as convenient buildings.washroom are ordinarily isolated by sexual orientation into male and female offices, albeit some can be unisex, especially the littler or single inhabitance writes. Both male and female toilets may fuse can work spaces, while numerous male toilets likewise highlight urinals. Progressively, open toilets consolidate available toilets and highlights to cook for individuals with disabilities.washroom might be unattended or be staffed by a janitor (potentially with a different room), or specialist, gave by the neighborhood expert or the proprietor of the bigger building. In numerous societies it is standard to tip the chaperon, while other open toilets may charge a little expense for entrance, once in a while through utilization of a coin worked entryway . QUESTION 2 Subject: HOTEL AMMENITIES What civilities would you highlight in a spending lodging property? In an average sized property? In an extravagance property? Spending HOTEL http://www.hotelbeursstraat.nl/pictures/budget_hotel_amsterdam.jpg Spending inn gives a modest yet an agreeable place to stay . I would favor courtesies, for example, sustenance and drink benefit and incorporate with shops which offers fundamental utensils and nourishment . Other than that Air molding must be accessible. There ought to be exceptional inability adjusted rooms accessible. The cordial gathering is open 24 hours to give any data required, including cash trade, safe store boxes and web association . More youthful visitors can likewise have some good times in the play area. At night, visitors can appreciate music at the pool bar, and additionally the principle bar and incessant gathering evenings to keep spirits high. Grill and kaoreke ought to be given . Moderate sized HOTEL http://www.greenfieldhotel.com/en/pictures/Hotel%20new.jpg Moderate sized lodging more often than not is 3 or 4 star inn . As I would see it nourishment and drink particularly the eatery ought to have assortment of dishes and offices . Visitors can unwind by the swimming pool with refreshments from the pool bar, open from at a young hour early in the day until late during the evening and other relaxation offices, for example, the pool table, water polo and the diversion room , this offices must be incorporated into average sized property . Other than that , Spa , Jacuzzi , wifi and satellite television ought to be given .>

GET ANSWER