Essay COMM121: Business Report Writing – Communication Assignment Help

Assignment Task:

PART 1

Calculate the Mean, 95% population mean confidence intervals, Median, Standard Deviation, Coefficient of Variation, and Skewness for property prices of Houses based on the following grouping:

• Proximity of the property to CBD 

Note: Calculate above statistics for both “Up to 5KM” and “Between 5KM and 10KM”

• Number of bedrooms 

Note: Calculate above statistics for “One bedroom”, “Two bedrooms” and “Three bedrooms or more”

• Number of bathrooms 

Note: Calculate above statistics for “One bathroom”, “Two bathrooms”, “Three bathrooms or more”)

Note: In total, you need to show your results for 8 different categories. Provide all results in one table (see the sample table at the end of this document).

What conclusions can you draw from these analyses? Write a conclusion for this part. Also comment on the shape of distributions using Skewness values for each category. 

PART 2

Calculate the Mean, 95% population mean confidence intervals, Median, Standard Deviation, Coefficient of Variation, and Skewness for property prices of Units based on the following grouping:

• Proximity of the property to CBD 

Note: Calculate above statistics for both “Up to 5KM” and “Between 5KM and 10KM”

• Number of bedrooms 

Note: Calculate above statistics for “One bedroom”, “Two bedrooms” and “Three bedrooms or more”

• Number of bathrooms Note: Calculate above statistics for “One bathroom”, “Two bathrooms”, “Three bathrooms or more”)

Note: In total, you need to show your results for 8 different categories. Provide all results in one table (see the sample table at the end of this document).

What conclusions can you draw from these analyses? Write a conclusion for this part. Also comment on the shape of distributions using Skewness values for each category. 

PART 3

 Answer the following hypothesis testing questions:

1. Determine if average prices of units “within 5KM of the CBD” exceed average prices of units “located within 5 to 10KM from the CBD”.
2. Determine if average prices for House within 5 to 10KM of the CBD exceeds the average price of Unit within 5KM of the CBD.
3. Determine if average prices for “Houses with three bed rooms within 5 to 10KM of the CBD” exceeds the average price of “Units within 5KM of the CBD”.
4. Test the difference between population means of houses of the following groups: prices for “One bedroom”, “Two bedrooms” and “Three bedrooms (or more)” properties.
5. Test the difference between population means of units of the following groups: prices for “One bathroom”, “Two bathrooms”, “Three bathrooms (or more)” properties.

Show your tested hypotheses for each questions, decision rules and then provide both statistical and managerial conclusions for each part.

Then, provide an overall conclusion which combines all of the above findings (Parts 1-3).

Be clear in the conclusion that you draw from your analysis, and provide useful suggestions to the company’s CEO. Conclusions must be based on the findings of your analysis only.