× Limited Time Offer ! FLAT 30-40% off - Grab Deal Before It’s Gone. Order Now
Connect With Us
Order Now

ACCT6005 Company Accounting Assessment 3 Case Study

Part A: This case study assignment help is designed to assess your understanding and application of knowledge using a practical case study to analyse and prepare relevant worksheet entries and financial statements for a Group.

Submission Instructions: Part A: • Submit Part A of the assessment document in a Word format and excel (see assessment question) including a coversheet. JPEG files or similar cannot be opened and will not be marked. • Submit via the Assessment link in the main navigation menu in ACCT6005 Company Accounting.



ACCT6005 Company accounting Assessment 3 Case study Part A

Assignment instructions: This assignment is to be completed using Microsoft word for the evaluation report (part a) and Excel for the entries, worksheet and Group financial statements (part b, c, d). Please use a separate sheet in excel for each separate part b, c and d.

Please ensure that your file name contains your student ID and your full name. Please ensure that you use the ‘Ref’ column in the worksheet to identify each separate consolidation entry. 

Case study:

PART A (100 Marks)

Grape Ltd acquired all the issued shares of Duck Ltd for $940 000 cash on 1 July 2020.

The following information is available at this acquisition date:

The equity of Duck Ltd is provided below:

Share capital

$495 000 00000

Retained earnings

280 000

General reserve

125 000


All the identifiable assets and liabilities of Duck Ltd were recorded at fair value in the statement of financial position. The company income tax rate is 30%.

The following transactions and events occurred during the year ended 30 June 2021:

1. During the year Grape Ltd sold inventory to Duck Ltd for $55,000 at cost plus 20%. Duck Ltd has sold 10% of these items externally as at 30 June 2021.

2. On 1 April 2021, Duck Ltd sold an item of inventory to Grape Ltd for $28,000. This inventory had cost Duck Ltd $20,000. Grape Ltd treated the item as plant and will depreciate it at 20% p.a.

3. Grape Ltd sold land to Duck Ltd for $25,000 which had originally cost $32,000.

4. Dividends: Duck Ltd paid $18 000 interim dividends in September 2020, and Grape Ltd declared $26 000 dividends in May 2021 (to be paid in October 2021).

5. On 1 July 2020, Grape Ltd provided an office for Duck Ltd’s administrative staff to use. Grape Ltd charges $700 per month. The last rental receipt received by Grape Ltd was on 30 April 2021.


Part (a) (36 marks)

Analyse the completed worksheet attached for the Grape group. Using the information provided in the worksheet, prepare an evaluation report in word, detailing each omission and error. For each error:

1. List the accounts and amounts, which are incorrect for each consolidation adjustment.

2. Explain WHY the entry is incorrect. Include formulas where possible in your explanation.



Part (b) Prepare the consolidation entries as at 30 June 2021 in excel using the template below. Include narrations for each entry: (28 marks)


















Part (c): Worksheet (24 marks)

Using excel, prepare the consolidation worksheet as at 30 June 2021, showing all entries including the corrected entries discussed in Part (a). Each entry needs to be entered as a separate amount and not entered as subtotals in the worksheet. Round your answers to zero decimal places. The worksheet template is provided below.

Part (d): Group financial statements (12 marks)

Using excel, prepare the Statement of Financial position for Grape Ltd as at 30 June 2021.


Part (a)

An acquisition can be defined as the difference between the price paid by the acquirer for purchasing another company and the original cost of the assets of the target company (Janice 2013).
Following entries or transaction is incorrect

Reference 1:

Adjustment in Share capital, general reserve, retained earning & BCVR is incorrect and not required.

Reference 2:

Sales revenue- The amount of $25,000 debited in the sales account and $ 22,000 credited in the cost of sales account is incorrect- because for unsold stock with Duck Ltd, to eliminate the unrealised profit of Grape Ltd. the sales should have been debited with $8250 and Inventories should have been credited with $8250

Reference 3:

Adjustment entry done in Proceeds from sales of equipment and carrying amount of sold equipment, the related depreciation & entry done in equipment ledger in asset side is incorrect. Since Duck has treated Inventory and sold to Grape for $28,000 which cost Duck ltd $20,000 Therefore, the sales account of Duck should have been debited to a tune of $8000 and Depreciation account needs to be credited by $8000*20%= $1600 (which is excess on account of group sales) and the carrying amount of the equipment plant) needs to be reduced by net $6400 to eliminate the effect of the sales.

Reference 4:

All the adjustment relating to reference 4 needs to be removed since the dividend entry has already been correctly recorded no further adjustment required. Since Duke ltd (subsidiary of Grape Limited) pays interim dividend so its post-acquisition profit so it should be recorded in the profit and loss of Grape Limited and the same has been correctly recorded (AASB 2021)

Reference 5:

The adjustment for service expenses of $90,000 is incorrect as we need to just eliminate the outstanding and payable rent expenses which are for 2 months @$700 per month. Thus the correct adjustment should be debiting other payables account and crediting other receivables account to the tune of $1400

Reference 6:

Sales of land by Grape Ltd to Duck Ltd. for $25,000 cost $32,000. Thus, the unrealised loss of $7000 needs to be eliminated.

Herein the application of AASB 10 is observed because it develops the principles for preparation, as well as presentation of the consolidated financial statement when the entity has a control over one or more than one entities (AASB 2021)

Part b)

Part c)


Part d)

 Consolidated Financial Statement of Duck Ltd


AASB. (2021) AASB Standard. Retrieved from https://www.aasb.gov.au/admin/file/content105/c9/AASB10_08-11.pdf

Janice, L. (2013). Understanding Australian Accounting Standards. Milton, Qld.: John Wiley and Sons. Retrieved from https://lesa.on.worldcat.org/oclc/807180288

Potter, B., Howieson, B., & Chapple, E. (2019). Accounting standards setting. Emerald Publishing Limited. Retrieved from https://lesa.on.worldcat.org/oclc/1113886538

Read More

ACCT6004 Management Accounting Assessment 2 Sample

Assignment Brief

Length - (1,800 words +/- 10%)

Learning Outcomes

a) Identify and analyses ethical and organizational issues confronting contemporary management accountants.

b) Categories and identify the nature of various types of costs, cost objects and cost behaviours and use cost estimation techniques to develop cost functions.

c) Apply cost accounting techniques to calculate the cost of a range of cost objects, as well as analyse costs.

d) Apply cost information to planning, control and decision-making.

e) Critically evaluate the relevance of both quantitative and qualitative costing information to management decision making.

Submission - by 11:55pm AEST/AEDT Sunday of Module 5.1 (week 9)
Weighting - 30%
Total Marks -100 marks 


The purpose of this assessment is to establish the skills needed in the workplace for costing products and services using the appropriate processes and tools and applying analytical processes to construct accounting systems and models using workplace tools. Each question uses realistic data and the professional practices
similar to that found in workplaces.

Submission Instruction

Due Date/Time: 11:55pm Sydney time (AEST/AEDT) on Sunday 18th April 2021 Please aim to complete this assignment a few days prior to the due date to allow for any unforeseen circumstances such as illness, holidays, family issues, work commitments etc. You may submit the assignment early if you have other commitments around the due date.

All times listed are local (Sydney) times. For assignment help Please ensure you factor in any time difference between Sydney and your location when submitting your assignment, to avoid incurring any late submission penalties.

Please note the following important instructions relating to the assignment format and Submission:

• Note that this is an individual piece of assessment. You will need to work individually to prepare a response to ALL of the questions listed in the assessment.

• You must submit your assessment in one Excel file. Any submissions in any other file formats will not be accepted.

• Each question (including all sub-questions) should be presented in a single worksheet. As there are 5 questions in this assessment, your Excel file should contain 5 worksheets in total.

• You cannot scan handwritten responses and submit. All answers must be typed in Excel.

• Your assessment needs to be submitted though the submission links available on the Blackboard. Assignments submitted via e-mail (or any other method) will NOT be accepted.

• Make sure that you upload the correct file. If you discover (after the due date) that you have uploaded a draft version or the wrong file completely, you will not be allowed to submit a second file.

- The typo in Question 2-part C has been rectified in this version.

Question 1: Support Department cost allocation

Diamond Trust Bank has two support departments: The Human Resources Department and the Computing Department. The bank also has two operation departments that service customers directly: The Deposits Department and the Loan Department. The usage of the two support departments' output is provided below:



The costs in the support departments and operation departments for the is presented below:




a) Report the total costs of operation departments (the Deposits Department and the Loan Department) after the support departments' (the Human Resources Department and the Computing Departments) costs have been allocated using each of the following methods:

i) Direct Method
ii) Step Down Method (The bank allocates the costs of the Human Resources Department first.)
iii) Reciprocal Method

b) Diamond Trust Bank evaluates the performance of the operation department managers on the basis of how well they manage their total costs, including allocated costs. As the manager of the Loan Department, which allocation method would you prefer? Why?

Question 2: Job Costing

ACT Manufacturing Ltd. is highly automated company that uses computers to control manufacturing operations. The company uses a job-order costing system and applies manufacturing overhead cost to products on the basis of computer-hours. The following estimates were used in preparing the predetermined overhead rate at the beginning of the year:



The company’s cost records revealed the following actual cost and operating data for the year:




a) What is ACT Manufacturing Ltd.’s predetermined overhead rate for the year?

b) Calculate the company’s under applied or over applied overhead for the year.

c) Assume that overapplied or underapplied overhead allocated on a pro rata basis to the ending balances in work in process, finished goods and cost of sales. The ending balance of these accounts are reported below. Prepare journal entries to show the allocation.


d) How much higher or lower will net operating income be for the year if the underapplied or overapplied overhead is allocated on a pro rata basis rather than closed directly to Cost of Goods Sold? Explain the reason for this difference.

Question 3: Process Costing System

Techsafe Company manufactures car seats. Each car seat passes through the assembly department and testing department. When the assembly department finishes work on each car seat, it is immediately transferred to testing department. The process-costing system at Techsafe Company has a single direct-cost category (direct materials) and a single indirect-cost category (conversion costs). Direct materials are added at the beginning of the process. Conversion costs are added evenly during the process.

The table below shows the relevant data for the assembly department for July 2020.

Physical Units
(Car Seats)
Direct Material Costs
Conversion Costs
Work in process, 1July2020(*)

(*) Degree of completion: 100% for direct materials and 60% for conversion cost (**) Degree of completion: 100% for direct materials and 70% for conversion cost


a) Determine the cost per equivalent unit for the Techsafe Company’s direct materials and conversion costs, and the total unit cost for the current period, under the FIFO method. Show all workings.

Determine the cost per equivalent unit for the Techsafe Company’s direct materials and conversion costs, and the total unit cost for the current period, under the Weighted Average method. Show all workings

Question 4: Cost Volume and Profit (CVP) analysis

Veritas Software is a leading Australian based accounting software manufacturer. It develops software packages for accounting firms located in Australia and overseas. Veritas is planning to release an upgraded version of their software soon. The company divides its clients into two groups: Local firms (those firms that operate in Australia) and Global firms (those firms that operate in overseas). Although the same physical product is provided to each client group, significant differences exist in selling prices and variable marketing costs: 


The fixed costs of Veritas Software are $16,500,000. The planned sales mix for the upgraded software in units is 60% Local firms and 40% Global firms.


a) What is the break-even point in units for Veritas Software’s upgraded software if the planned sales mix is attained?
b) If the planned sales mix is attained, what will be the operating income when 180,000 units are sold?
c) If Veritas Software wants to generate operating income of 5,500,000, how many units do they need to sell to Local and Global firms each? Assume that the planned sales mix is attained.

Question 5 Activity Based Costing

MaxPak is a designer of high-quality backpacks and purses. Each design is made in small batches. Each summer, MaxPak comes out with new designs for the backpack and for the purse. The company uses these designs for a year, and then moves on to the next trend. The bags are all made on the same fabrication equipment that is expected to operate at capacity. The equipment must be switched over to a new design and set up to prepare for the production of each new batch of products. When completed, each batch of products is immediately shipped to a wholesaler. Shipping costs vary with the number of shipments. Budgeted information for the year is as follows:

Budget forcostsandActivities
For theYearEnded30June2020

 Other Budget information follows:



a) Identify the cost hierarchy level for each cost category.
b) Identify the most appropriate cost driver for each cost category. Explain briefly your choice of cost driver.
c) Calculate the budgeted cost per unit of cost driver for each cost category.
d) Calculate the budgeted total costs and cost per unit for each product line.
e) Explain how you could use the information in requirement 4 to reduce costs.


Answer 1

Part a

ii) Step down method
In step down method the cost of Human resource department shall be allocated first to
Cost of Human resource department is $ 72000

After allocation of Human resource then the second will be computing department
Cost of Computing department= 120000+14400 = $ 1,34,400.00

Part iii

In Reciprocal method the cost of computing allocated to Human resource shall be distribute again So, in this case $26880 allocated to Human resource from computing will be distributed again till it reduces to zero.

Part B

As a Manager we would always choose that method which provides most accurate measure of cost. Thus by evaluating all the three methods above it can be seen that Reciprocal method gives the most accurate evaluation of cost and thus will provide the most accurate performance evaluation

Answer 2

Part a

Part b

Part c

Part d

The company profit has got reduced due to over applied overhead. The cost of goods sold will increase and thus the profit margin will get reduce, thus the company should ignore over application of overhead cost

Answer 3


Answer 4

Part a

Part b

Part c

Answer 5


Part a

he cost hierarchy level of each cost category:
Direct Material
Direct Manufacturing cost
Plant Utilities and administrative

Part b

Part c

Part d


Part e

Use of ABC activity based costing gives the true view of cost allocation on the basis of cost driver and thus it eliminated traditional approach of cost allocation


Read More

STAT6003 Statistics for Financial Decisions Assignment Sample

Task 1:

Selecting your Random Sample and Creating your Sample Data File ( 8 Marks)

In order to select the sample data that will form the basis of your assignment you will need to make use of the random number table provided with this assignment help. The provided table of random numbers is, as the title suggests, a sequence of randomly generated numerical digits (0 to 9). These digits are arranged in a table with one hundred rows numbered 01 to 00 and twenty columns spread over two pages. The entries in each column of each row consist of five single digits.

The property data from which you will select your sample data consists of 400 IDs each with an identifying property number (PN) ranging from 1 (or 001) to 400.

Your first task is to select 50 three digit random (property) numbers ranging from 001 to 400 from the provided table of random numbers. We will ask you to select 50 numbers, to begin with, just to cover the distinct possibility that you may select the same three digit number more than once. The type of simple random sampling that we will be engaged in here is termed “without replacement” because we specifically do not want to allow a property identification number to be selected more than once.

In order to select your 50 random property identification numbers you will need to first go to a starting position row and column in the random number table. Defined by the last three digits of your Torrens University student identification number. The last two digits of your Torrens ID number identifies the row and the third last digit identifies the column of your (relatively) “unique” starting position. For the demonstration last three digits of 312, reading across row 12 from left to right starting at column 3 as instructed, you would encounter the following three digit numbers; 293 313 381 349 656 985 295

You need to record these first three acceptable ID numbers, 293, 313, 381 and 349 into the first column of an Excel spread-sheet and then continue this process until fifty valid three-digit personal identification numbers selected.

Task 2:

1. Provide the complete summary statistics for Market Price ($000) and Age of house (years). (5 Marks)

2. Describe the shape of the distributions for Market Price ($000) and Age of house (years). (5 Marks)

3. Test whether the population’s average Market Price ($000) is different from 777. (5 Marks)

4. Construct a 95% confidence interval for the Market Price ($000), also Interpret the confidence interval. (4 Marks)

5. Provide an introduction section on the rationale of your model , sample size, and the dependent and independent variables (including their unit of measurement) in this model. (4 Marks)

6. Plotthe dependent variable against each independent variable using scatter plot/dotfunction in Excel. Examine these scatter plots and correctly assess the strength and the nature of the
relationship between the dependent and the independent variables? (6 Marks)

7. Present the multiple regression model with complete regression summary output in your assignment. (6 Marks)

8. Provide the simple linear regression data analysis for the market price as the response variable and the Land size in Square meters as the explanatory variable. Write down the least square regression equation and correctly interpret the equation. (6 Marks)

9. Write a clear interpretation of the slope of the regression line from question 8. You must refer to the variables of interest. (4 Marks)

10. What is the value of the coefficient of determination for the relationship between the dependent and independent variable from question 8. Interpret this value accurately and ina meaningful way. (4 Marks)

11. State the 95% confidence interval for the slope coefficient and interpret this interval from question 8. (5 Marks)

12. Compare the multiple regression model (question 7) and simple linear regression model (question 8) and evaluate the goodness of fit between these two modelling techniques.(8 Marks)

13. Predict the market price of a house (in $) with a building area of 300 square meters. Explain why your answer is valid.(4 Marks)

14. By performing an appropriate hypothesis test what decision and conclusion would you draw about the hypothesis that the Land size in Square meters useful in predicting the market price of a house (in $)? Use the data provided to justify your answer, as appropriate.When answering this research question. (8 Marks)

15. For statistical analysis involving hypothesis testing in this assignment, you are required to:
• Formulate the null and alternative hypotheses for full model.
• State your statistical decision using significant value (α) of 5% for this test.
• State your conclusion in this context.


Summary statistics is used to summarise data and get information from it. The summary statistics table comprises the values of central tendency which are obtained in the form of mean, median and mode along with measures of dispersion is obtained in the form of standard deviation and sample variance. In addition to this, distribution of data can be understood by calculating skewness, kurtosis and range (Cooksey 2020). Hence, from this table one can understand where the mean lies and how data is distributed around the mean value. The summary statistics of market price ($000) is shown in table 1. Similarly, the summary statistics of age of house that is measured in years is shown in table 2.

Table 1: Summary Statistics of Market Price ($000):

From the table, it is observed that average market price is $772.19 (‘000). Moreover, the standard deviation is 70.61 which implies that market prices of houses do not deviate largely from the mean value. The minimum market price of house in the collected sample file is $599.39 (‘000). Moreover, the maximum market price of house in the collected sample file is $ 892.71(‘000).

Table 2: Summary Statistics of Age of house (years)

From the table, it is observed that average age of house is 18.63 years. Moreover, the standard deviation is 12.03 which implies that age of houses deviates largely from the mean value. The minimum age of house in the collected sample file is 0.5 year. Moreover, the maximum age of house in the collected sample file is 53.12 years.


In statistics, skewness measures how a data set is distributed. A data set can be either symmetric or symmetric in nature. The main reason of measuring skewness is that it informs whether ata has larger extreme values or lower extreme values. As per the “Rule of Thumbs”, the skewness varies between -0.5 to 0.5 is known as symmetrical (Orcan 2020). The skewness of Market Price ($000) is -0.46 which lies within the boundary. Hence, it indicates that the distributions for this variable is almost symmetric. The shape of the distribution is also called a bimodal distribution.

On the other side, the skewness of Age of house (years) is 0.67 which lies between 0.5 and 1. Hence, it indicates that the distribution of data is moderately skewed towards the right direction. In other words, the distribution is positively skewed where mean value is higher than median.
The distributions of Market Price ($000) data as well as the same for Age of house (years) are demonstrated below by histograms.


Figure 1: Distribution of Market Price ($000)

Figure 2: Distribution of Age of house (years)


To understand if the average Market Price ($’000) of target population differs from 777 or not, one sample t-test (two-tailed) is conducted. Here, n is 50. However, population standard deviation is unknown. Hence, z-test cannot be applied.

Here, average Market Price ($ ‘000) is µ

Therefore, the null hypothesis is:

H0: the average Market Price ($’000) of the population is equal to 777
µ = 777
The alternative hypothesis is:
H1: the average Market Price ($’000) of target population is different from 777
µ ≠ 777
The outcome obtained from MS Excel is:

Table 3: One sample t-test (two-tailed test)

Here, the t statistics is 77.32 which is higher than t Critical two-tail value, which is 2. Hence, here, the null hypothesis is rejected. Moreover, the P-value in two-tail test is 0.00 which is less than 0.05 at 5% significance level (Xu et al. 2017). Hence, again the null-hypothesis is rejected. Thus, it implies that average Market Price ($’000) of the target population is not equal to 777.


As per the outcome obtained from Excel, the value of Confidence Level at 95% is 20.07
Thus, the lower interval is (mean – confidence level) = 752.12
the upper interval is (mean + confidence level) = 792.26
Here, confidence interval represents actual upper and lower values. It implies that the 95% of the time, the researcher can expect that the real mean will fall between 752.12 and 792.26.


The model of regression analysis is selected to forecast the dependent variable by independent variable(s). The regression model is categorised depending on the number of independent variables. Hence, to determine dependent variable with one independent variable, linear regression model is applied. Moreover, to determine dependent variable with more than one independent variable, multiple regression model is applied (Montgomery, Peck and Vining 2021). The sample size in this study is 50, which are selected by applying simple random sampling technique without replacement. The four variables are market price ($000), Sydney price Index, total number of square meters and age of house (years). In regression model, market price ($000) is considered as dependent variable while others are considered as independent variables. The scatter plots are also made to measure the strength of association between independent and dependent variable.


A scatter plot is a form of statistical diagram that shows values for two variables and measure a relationship between them. Hence, this plot is used to show the relationship visually to understand the strength type of the relationship between these two variables. In general, this plot is of 3 types, which are positive, negative and no correlation (Akoglu 2018). The relationship of the dependent variable with each independent variable is shown by scatter plots.

Figure 3: Scatter Plot Diagram between Sydney Price Index and Market Price ($000)

Figure 3 represents a scatter plot diagram to show relationship between independent variable Sydney Price Index and dependent variable Market Price ($000). From the figure, it is seen that these two variables do not have any relationship with each other. In other words, the diagram indicates that Sydney Price Index does not relate with Market Price ($000). Hence, variation in Sydney Price Index cannot tend the Market price to variation in same or opposite direction specifically.

Figure 4: Scatter Plot Diagram between Total number of square meters and Market Price ($000)

Figure 4 represents a scatter plot diagram to show relationship between independent variable Total number of square meters and dependent variable Market Price ($000). From the figure, it is seen that these two variables have strong and positive correlation. In other words, the diagram indicates that there if Sydney Price Index increases, Market Price ($000) price also increases and vice versa.

Figure 5: Scatter Plot Diagram between Age of house (years) and Market Price ($000)

Figure 5 represents a scatter plot diagram to show relationship between independent variable Age of house (years) and dependent variable Market Price ($000). From the figure, it is seen that these two variables do not have any relationship with each other. In other words, the diagram indicates that there is no relationship between Age of house (years) and Market Price ($000). Hence, age of house cannot tend the Market price to change in same or opposite direction specifically.


The following table represents summary outcome of multiple regression model:

Table 4: Calculation of Multiple Regression

From table 4, the following equation of multiple regression is obtained:
Market Price ($000) = 406.38 + 0.02 Sydney Price Index + 1.75 Total number of square meters + 0.1 Age of house (years)

In this equation, 406.38 is the intercept of regression equation. Moreover, 0.02, 1.75 and 0.1 are beta coefficients. Beta coefficient of an independent variable implies the magnitude of change in the dependent variable when this independent variable changes by 1 unit.

If Sydney price index increases by 1%, the market price of houses will increase by $ 0.02 (‘000). If total number of land size increases by 1,75 square meters, then market price of house will increase by $1.75 (‘000). If age of houses increases by 1year, then market price of that house will increase by $0.1 (‘000). Hence, from the equation, it is seen that each independent variable has positive influence on the market price of house.


Table 5: Calculation of Simple Linear Regression

The obtained Simple linear regression equation is:
Market Price ($000) = 410.42 + 1.75 total number of square meters
According to the above equation, market price of a house can be high even if land size in square meters of the house is unavailable.


From the multiple regression equation of question 8, the slopes are described below.
The slope of the regression line is the beta coefficient of total number of square meters. It implies that if land size increases by 1 square meters, the market price will increase by $1.75 (‘000).


The value of R-square is 0.99 which means independent variable can define 99% of variation of the dependent variable.


At 95% confidence interval, the slope coefficients are: lower limit: 1.712 and upper limit: 1.789. For intercept, the lower limit is 402.392 and upper limit is 418.456.


The value of R-square in question 7 is 0.99 while that in question 8 is 0.9 as well. Hence, it is observed that the value of R-square in both models are almost equal to 1. Moreover, the value of the coefficient of determination or adjusted R-square for the association between dependent and autonomous variables is 0.99 as per table 4. It implies that independent variables can predict almost 99% of variation of the dependent variable. Hence, it indicates a strong and positive correlation between dependent and independent variables.
Hence, models fit the data perfectly.


From simple linear regression equation, obtained in question 8, the market price of house (in $) can be obtained when a building is given as 300 square meters.

Market Price ($) = 410.42 + 1.75 * 300
Market Price ($) = 410.42 + 525
Market Price ($) = 935.42

Here, the answer is valid as the obtained relationship is statistically significant as significance F value of the equation is 0.00 at 5% significant level and hence it is less than 0.05.


The null hypothesis states no association between market price and land size which is measured in terms of square meters:

H0: b1 ≠ 0

The alternative hypothesis states an association between market price and land size which is measured in terms of square meters:

H1: b1 = 0

The hypothesis is tested at 95% significant level when α = 0.05

At 5% significant level, p-value is 0.00, which is lower than 0.05. Hence it implies that the alternative hypothesis is true and the equation is statistically significant. In other words, it can be said that there is a positive linear relationship between market price ($000) and land size in square meters.


The full model is the multiple regression model.

In this model, the null hypothesis is:

H0: Each independent variable is statistically insignificant

The alternative hypothesis is:

H1: At least one of the autonomous variables is statistically significant

The hypothesis is tested at 95% significant level when α = 0.05

In table 4, the p-value for Sydney price index and age of house (years) are 0.48 and 0.14 which are greater than 0.05 at 95% confidence interval. This means the null hypothesis is true which means these two autonomous variables are not important in explaining market price of the houses in thousand dollars.

On the other side, the p-value for total number of square meters and age if house (years) is 0.00 which is less than 0.05 at 95% confidence interval. This means the null hypothesis is rejected as the independent variable is significant in measuring and predicting market price of the houses in thousand dollars.

Moreover, the significance F is 0.00 which is less than 0.05 at 5% significant level. It accepts the alternative hypothesis that at least one of the autonomous variables is significant.

In conclusion, it can be said that market price of houses can be determined properly by land size of houses in square meters. On the contrary, Sydney price index and age of house (years) cannot measure market price of houses correctly. Thus, to determine market price of house, it is better to consider land size of it in terms of square meters. The significant relationship between autonomous variable and dependent variable is understood by the linear regression model. The P-value is used to determine whether the relationship is significant or not.


Akoglu, H., 2018. User's guide to correlation coefficients. Turkish journal of emergency medicine, 18(3), pp.91-93.

Cooksey, R.W., 2020. Descriptive Statistics for Summarising Data. In Illustrating Statistical Procedures: Finding Meaning in Quantitative Data (pp. 61-139). Springer, Singapore.

Montgomery, D.C., Peck, E.A. and Vining, G.G., 2021. Introduction to linear regression analysis. John Wiley & Sons.

Orcan, F., 2020. Parametric or non-parametric: Skewness to test normality for mean comparison. International Journal of Assessment Tools in Education, 7(2), pp.255-265.

Xu, M., Fralick, D., Zheng, J.Z., Wang, B., Tu, X.M. and Feng, C., 2017. The differences and similarities between two-sample t-test and paired t-test. Shanghai archives of psychiatry, 29(3), p.184.

Read More

Sample Category

Assignment Services