Computer Exercises Econometrics

From the above output, we can see that the p-value is 0.000186, which is smaller than 0.05 (if we select a 0.05 significance level).

Record in data table 1. Calculate the average heat (q) by averaging trials 1 and 2. Record in data table 1.

For problems requiring computations, please ensure that your Excel file includes the associated cell computations and/or statistics output; this information is needed in order to receive full credit on these problems.

(c) The mean of the sample and the value of Z with an area of 5% in the left tail.

| if maritalStatus = ‘M’ taxRate = MARRIED_RATEif maritalStatus = ‘S’ taxRate = SINGLE_RATEif maritalStatus = ‘D’ taxRate = DIVORCED_RATEif maritalStatus = ‘W’ taxRate = WIDOWED_RATEIf hoursWorked <= 40 grossPay = hoursWorked * hourlyRateElse regularPay = (40 * hourlyRate) overtimePay = ((hoursWorked-40) * (hourlyRate * 1.5)) grossPay = regularPay + overtimePaytaxAmount = grossPay * taxRatenetPay = grossPay - taxAmount

(1) TIME ALLOWED – 3 Hours (2) TOTAL NUMBER OF QUESTIONS – 6 (3) ANSWER ALL QUESTIONS (4) THE QUESTIONS ARE OF EQUAL VALUE (5) THIS PAPER MAY NOT BE RETAINED BY THE CANDIDATE (6) ONLY CALCULATORS WITH AN AFFIXED “UNSW APPROVED” STICKER MAY BE USED (7) STATISTICAL FORMULAE ARE ATTACHED AT END OF PAPER STATISTICAL TABLES ARE ATTACHED AT END OF

Using SQL and avoiding over complicating my code helped me to easily trace the code as mathematical equations was a big part of the assignment and each mean, variance (standard deviation) and normal distribution function had to be recalculated by hand to ensure that no logical or mathematical errors existed. Thus making my overall approach to the assignment much more

3) The performance of personal and business investments is measured as a percentage, return on investment. What

S= 74.0, X= 35.7, r = 8.03%, d1 = 1.60119, d2 = 0.376449, N (d1) = 0.945333, N (d2) = 0.646708

The statistical test that was done for table 3 was the geometric mean in order to compare

Initially I felt confident approaching question 16, because I enjoy interpreting data and using algorithms to determine median. However, this changed as I had no prior schemes of leaf and stem tables therefore, I struggled to interpret the key 5|2 = 52. Eventually, I interpreted the key and identified the vertical line as separating the 10s and units and was able to read the table. I applied the key to the table and extracted the relevant mathematical facts (Step 1-2). To confirm I was approaching the question correctly I counted the number of data entries on the table (Step 2).

This will be used, as it will provide me with a set of figures that a mean and standard deviation can be taken from in order to produce more accurate results.

The data in Column A of the provided spreadsheet was split at the semi-colon, with the number to the left of the semi-colon representing U and the number to the left representing V. V values were entered by hand into a newly created column and were deleted from Column A. Both columns were summed, and sum totals were divided by 116 (the number of data points) to achieve means. Columns were also created for U^2 and U*V; the sum function was also used to total these columns and means were derived by dividing the sum by 116. a was calculated as 1094.04 using the following formula:

I have placed the results from our experiment in form of a table and will use the average results to form a graph. I have also prepared a graph to show the results throughout the exercise.

0.18 0.23 0.23 0.27 0.28 0.3 0.3 0.31 0.31 0.34 0.35 0.39 0.42 0.45 0 0.1 0.2 0.3 0.4 0.5