Decision making is based on understanding the flow from data to information to knowledge so that it will support improved Business Intelligence (BI) decisions. There are three basic sections of any BI structure. They are:

• Data sources (databases);
• The Database Management System and Enterprise Resource Planning (DBMS and ERP); and
• The Dashboard display

The final research paper is for you to describe the high-level design and interfaces necessary to create a usable Dashboard to support General Manager (GM)-level business decisions.

First, the final research paper must identify the necessary internal and likely external databases that would be needed to support the Dashboard (from data silos, data marts, data warehouses, etc.).

Additionally, the paper must include critical Entity Relationships (ER) across databases to ensure high level of information accuracy.

Second, the paper must describe the DBMS and ERP relationships in high-level terms that support the Extract, Transform, and Load (ETL) functions necessary to deliver information and formats (e.g., charts, etc.) to the dashboard.

Lastly, the dashboard (shown graphically in addition to the appropriate narrative) must contain no less than three and no more than four pieces of information that a Department Store GM would need. The dashboard must be described sufficiently in terms of data visualization options (e.g., charts, texts, timelines). Layout of the dashboard must be specified.

In this assignment, you are to assume the role of the Assistant Park Manager. You have been directed by the Park Manager to analyze the current financial situation of the park and propose an annual budget for the upcoming fiscal year. You will submit your analysis in the form of a memo addressed to the park manager.

Read Chapters 9 and 10 in Finkler et al. (2016).

1. Review the assignment rubric.
2. Read the Stratton Township Park Case.
3. Complete the Stratton Township Park Spreadsheet based on the information provided in the Stratton Township Park Case. Then formulate your responses to the Stratton Township Park Case questions applying the analysis from the completed spreadsheets and taking into account impact on citizens and important public interest and ethical values. NOTE: When you enter your calculations into your spreadsheet, you must use formulas – for example, do not simply use your calculator to do the calculations and then enter the results.
4. Write a 4-6 page memo addressed to the Park manager that includes explanations of your budget documents and analysis and addresses the questions from the case. Your responses to the questions should apply the financial analysis from your completed spreadsheet and take into account impact on citizens and important public interest and ethical values.The budgets you prepare and variance analysis you perform should be presented in a spreadsheet attached to your memo. Include your proposed annual program budget for the upcoming fiscal year and support why you believe this budget is appropriate. Submit the completed spreadsheets with your memo.
5. Include the spreadsheets you created in Step 1 as appendices. Place any other supportive information you choose to include in the appendix.
6. This assignment must be submitted to Turnitin.

Assume the role of an environmental safety expert who is presenting to a group of undergraduate college students about the application of toxicology in the field of environmental health and safety. Your presentation should address the following key points.

• Explain how dose-response data are utilized for risk assessment.
• Discuss the relationship between risk assessment and risk management.
• Identify and explain how at least three fields of toxicology contribute to areas of environmental safety and health.
• Research and discuss one current event (within the last six to eight months) that exemplified the relationship between toxicology and environmental safety and health.

The assignment should be completed as a PowerPoint presentation and should meet the following requirements:

1. The length should be at least eight slides, not including your title and reference slides.
2. Key points only should be entered on slides. Full paragraphs should not be included on presentation slides.
3. Voiceover or speaker notes should be included for details of the discussion. This should not be an exact replica of the slide information but an expansion of information to fill in the blanks and provide additional details to the audience.
4. Include least three visual aids and/or graphics.
5. A minimum of three credible sources should be used for this assignment, and the references should be properly cited in a reference list at the end of the PowerPoint. The CSU Online Library is a great place to find credible sources. If you need any assistance, we have a full staff of librarians available to help you get started with research. If you need any assistance creating your PowerPoint, click here for a Writing Center tutorial that covers best practices for creating effective PowerPoint presentations. All references and citations used must be in APA style.

Subject; Statistics

Title
Quantatative methods

Word Count
3 pages, 750 words

Reference Style
Harvard

No of References
0

ECON 1095 QUANTITATIVE METHODS IN FINANCE

INSTRUCTIONS

Please up load one (and one only) either word or pdf file with both your name and student number clearly printed on the first page. Use a file name that gives your identity.For the excel sections just take screen shots to show some of your workings then cut and paste into your document.For the maths sections, if you prefer, you can hand write and scan and add to your document.

QUESTION 1

In all parts of this question the dice that is referred to has a dodecahedron shape.

• If you roll this dice 12 times what is the probability that you will roll three 6s? Work out both by hand and using the EXCEL function for the Binomial distribution.
• If you roll this dice 12 times what is the probability that you will roll more than one 6? Work out both by hand and using the EXCEL function for the Binomial distribution.
• If you roll this 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:
• If you roll this dice 12 times what is the skewness and the kurtosis of the number of 6s you will throw? Please just use EXCEL to work this out.

m = _i P(X _i) and s² =(X_i – m)²P(X_i)

(2 marks)

QUESTION 2

As China is Australia’s largest trading partner it is possible that the share markets in the two countries are dependent.To look at this use data from ECON1095 Data Sem 2 2019.xls on the Int’l share price indices worksheet and examine the relationship between the monthly returns Australia: S&P/ASX 200 (AUS) and China: Shanghai A (CHINA) from 2009 to 2019.

• Using all the available data for AUS and CHINA examine the relationship between these two variables using graphs. You may do a few graphs; that is, both as levels and as returns and as XY and line (time series) graphs. Does it look as though the variables are dependent or independent?
• Calculate the correlation coefficient between the AUS and CHINA (data analysis, correlation). Again, do this both for the levels and returns. Please interpret the coefficient and offer a brief explanation for the result.
• Using the same data fill in the following table for the number of rises and falls^[1].
• Calculate the joint probability distribution and the marginal probability distributions for the data.
• Using your previous answers as a guide, decide whether AUS and CHINA are dependent or independent?
• Due to the trade war between the US and China you expect Chinese share market returns to fall soon. Calculate the conditional probability distribution for AUS given that CHINA has decreased. Explain how this calculation could be used to guide your Australian investment decisions.

AUS CHINA
		Rise	No change	Fall	Total
	Rise
	No change
	Fall
	Total

(3 marks)

QUESTION 3

An individual’s utility function is represented by:U = 100(X₁^0.4).(X₂^0.6)

Their budget constraint is:

That is, their total budget is $10,000 and the price of X₁ is $2 and the price of X₂ is $5. Use the Lagrangian function to find the optimal values of X₁ and X₂ that maximises utility subject to the budget constraint^[2]. What is the value of l and what is its interpretation?

Check your answer using EXCEL. To do this open a new spread sheet and insert names for X₁ and X₂ in cells B2 and C2 and the starting values for these variables of 1 in both cells B3 and C3 and name these cells Xone and Xtwo. In cell B6 type the formula for the utility function, = 100* (Xone^0.4)*(Xtwo^0.6) 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 l.

(3 marks)

QUESTION 4 (using excel)

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 2 2019.xls and the Int’l share price indices worksheet and the entire sample from 2009 to 2019 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.

(5 marks)

QUESTION 5[3]

Using your results from QUESTION 4 and the risk-free rate of return of return given in QUESTION 2 of Assignment 1 obtain the equation for the Capital Market line (CML).Next graph the CML against the efficient frontier you calculated in the previous question.Briefly describe the relationship presented in this graph, including an explanation of the meaning and use of the CML.

(2 marks)

QUESTION 6

Again, using the data in ECON1095 Data Sem 1 2018.xlsx the Int’l share price indices worksheet use regression to look at the relationship between returns on Australia: S&P/ASX 200 (AUS) and China: Shanghai A (CHINA) from 2009 to 2019. That is, estimate AUS_t = b₀ + b₁CHINA_t. This should be done using the three approaches used in the example on Canvas (sample regression example.xlsx).All three approaches should yield the same answer.That is:

• Use the solver to find the values of b₀ and b₁ that minimize e_i².
• Ensure that the values of b₀ and b₁ satisfy the normal equations.
• Use Excel’s regression function to confirm your results in parts (a) and (b).
• Next, evaluate your results by:

• Interpreting the coefficient of determination and the F-statistic.
• Conduct a t-test on the slope coefficient.[4]
• Examine and graph the residuals, then comment.
• Briefly comment on the implications of your findings.
• Interpret the coefficient of determination and the F-statistic.
• Use t-tests to identify the variables that do and do not have a significant impact on Y_t.
• Examine and graph the residuals, then comment.
• Briefly comment on your regression findings.

(4 marks)

QUESTION 7

You are trying to find the main drivers of future returns on the Australian share market using information from 2013 to 2019. The data is in ECON1095 Data Sem 2 2019.xls on the Aust share mkt worksheet and the returns on China: Shanghai A from the Int’l share price indices worksheet. This will be used to construct a one period ahead forecasting model of the form:

Y_t = b₀ + b₁X_{1 t-1} + b₂X_{2 t-1} + …… +b_nX_{n t-1}

Where Y_t are the returns on Share price indices: S&P/ASX 200 and the X_{n t-1’}s are the nine other variables in the worksheet as well as the returns on the Chinese share market from the other worksheet. That is, initially you need to consider ten independent variables.Please use returns for all the market indexes and levels for the other variables.That is, use returns for all variables other than for Dividend yield, Price/Earnings ratio, Market capitalization and Average daily turnover of equities – which all should be in levels.

• Calculate the matrix correlation coefficients between the dependent and independent variables, then briefly interpret.
• Estimate the complete multiple regression equation, then:
• Using data from 2013 until the end of 2018 only and an iterative approach construct the best model you can to forecast Y_t.That is, develop a model that only includes the relevant independent variables.
• Use the model you constructed in part (c) to forecast for 2019 and compare your forecasts with the actual values.Please show in both in a table and on a graph.
• Briefly comment on all of your QUESTION 7 findings.

---

[1] You will find the IF function in EXCEL very useful when filling in this table.

^[2] There is no need to check the second order conditions.

[3] There are instructions on how to do this in the Mathematical Programming notes.

[4] Use a level of significance of a = 0.05 for this and all other tests.