The file HW_09.xlsx contains data from a survey of 105 randomly selected households (once you click cell C1, “Ownership,” you can see what 0 and 1 stand for).

a. In an effort to explain the variation in the size of the monthly home mortgage or rent payment, estimate a multiple regression equation that includes all of the potential household independent variables.

b. Interpret the ANOVA table for this model. In particular, does this set of independent variables provide at least some power in explaining the variation in the dependent variable? Report the F ratio statistics and p- value for this hypothesis test.

c. Interpret coefficients of independent variables in the model.

d. Using the regression output, determine which of the independent variables should be excluded from the regression equation. Justify your choices.

e. Do you obtain substantially different results if you combine First Income and Second Income into a Total income variable and then use the latter as the only income independent variable?

Consider the following time series:

Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr₁ = 1 if quarter 1, 0 otherwise; Qtr₂ = 1 if quarter 2, 0 otherwise; Qtr₃ = 1 if quarter 3, 0 otherwise. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)

Question 1: Preparation and Presentation of the Balance Sheet/Statement of Financial Position
Upside-Down Trading Limited, a company listed on the Music Stock Exchange, is a trading and investment
entity. The company trades exclusively in steel and aluminium component, and also has an investing arm.
Upside-Down Trading Limited have just engaged you as their finance director to assist in the preparation
of the entity’s 2021 financial statements. The financial period of the company is from September 1 to
August 31.
The company has provided you the following list of accounts, and the trial balance totals per each account,
as at end of their current final year:
Account Name Trial Balance Figure
11% Debentures $50,000,000
7% Bonds (Due in Less than 12 Months) $5,000,000
Accounts Payable $15,890,000
Accounts Receivables $14,500,000
Cash and Cash Equivalents $11,950,000
Copyright and R&D $4,100,000
Cost of Goods Sold $56,100,390
Current Tax Liabilities $6,900,000
Employee Benefit Obligations $8,100,000
Finance Expenses $4,502,000
Goodwill $18,540,000
Inventory $75,650,000
Loans Due in Less than 12 Months $16,850,000
Long-Term Investments $196,000,000
Long-Term Loans $215,580,000
Loss on Sale of Equipment $5,100,450
Other Payables $1,830,000
Other Receivables (Due in more than 12 Months) $1,520,000
Paid-Up Capital $218,702,000
Plant and Equipment $168,221,000
Prepaid Expenses $5,020,000
Property $312,512,000
Reserves $150,072,000
Retained Earnings $122,589,000
Sales Revenue $158,900,000
Short-Term Investments $6,500,000
Additional Information:
1. During the year, Upside-Down Trading Limited purchased $7,000,000 worth of machine
equipment that has yet to be added to the relevant non-current asset account.
2. For the period ended August 31, 2021, Upside-Down Global Trading Limited recorded a loss of
$7,500,000. This amount has already been closed to the Retained Earnings balance as per the trial
balance.

Page | 2
3. The internal auditor found from a recent review that $4,000,000 of loans listed as being payable in
next 12 months are not due till 2026.
4. All prepaid expenses are expected to be consumed by the end of December 31, 2021.
5. Upside Down Trading Limited has been offered $15,000,000 to sell its properties. The transaction
would – if accepted – be accepted in June 2028.
6. In 2019 the company sold property valued at $19,000,000 for $26,000,000. The company is of the
opinion that in 2024 it will purchase property to the value of $11,000,000.
7. The value of the Inventory as shown in the trial balance is the net realizable value. The value of
inventory at cost is $65,650,000.
Required:
Using the information supplied, prepare a balance sheet/statement of financial position for Upside-Down
Trading Limited for the end of 2025 that conforms with IFRS IAS 1 recommendations and requirements of
the course.

justify your answer with all steps clearly please (NOT HAND WRITING ) thanks

If C is the part of the circle (x2)2+(y2)2=1(x2)2+(y2)2=1 in the first quadrant, find the following line integral with respect to arc length.

∫C(8x−6y)ds

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided. 3.1 Use the least squares method to estimate the regression coefficients b0 and b1 3.2 State the regression equation 3.3 Plot on the same graph, the scatter diagram and the regression line 3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%) Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem.Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel

Prove series 2, (-1/2), (2/9), (-1/8) is convergent by the alternating series test and find the number of terms required to estimate the sum of the series with an error of less than 0.05

Calculate the correlation coefficient for the following data:

X=0, -1, -2, -3, -2, -2, 0, 1, 2, 3, 2, 1

Y=3, 2, 1, 0, -1, -2, -3, -2, -1, 0, 1, 2

Find through Excel.

Let x3 be the following vector: x3 <- c(0, 1, 1, 2, 2, 2, 3, 3, 4) Imagine what a histogram of x3 would look like. Assume that the histogram has a bin width of 1. How many bars will the histogram have? Where will they appear? How high will each be? When you are done, plot a histogram of x3 with bin width = 1, and see if you are right.

I need code help R programming

Forecasting labour costs is a key aspect of hotel revenue management that enables hoteliers to appropriately allocate hotel resources and fix pricing strategies. Mary, the President of Hellenic Hoteliers Federation (HHF) is interested in investigating how labour costs (variable L_COST) relate to the number of rooms in a hotel (variable Total_Rooms). Suppose that HHF has hired you as a business analyst to develop a linear model to predict hotel labour costs based on the total number of rooms per hotel using the data provided. 3.1 Use the least squares method to estimate the regression coefficients b0 and b1 3.2 State the regression equation 3.3 Plot on the same graph, the scatter diagram and the regression line3.4 Give the interpretation of the regression coefficients b0 and b1 as well as the result of the t-test on the individual variables (assume a significance level of 5%) Determine the correlation coefficient of the two variables and provide an interpretation of its meaning in the context of this problem 3.6 Check statistically, at the 0.05 level of significance whether there is any evidence of a linear relationship between labour cost and total number of rooms per hotel