Reference no: EM133532027

Business Analytics

Learning Outcome 1: Apply quantitative reasoning skills to analyse business problems.
Learning Outcome 2: Create data-driven/fact-based solutions to complex business scenarios.
Learning Outcome 3: Analyse business performance by implementing contemporary data analysis tools.
Learning Outcome 4: Interpret findings and effectively communicate solutions to business problems

Description

This assignment requires you to analyse a data set (including performing a multiple regression analysis), interpret, and draw conclusions from your analysis. You are required to explain the Summary Output from your multiple regression analysis in a written report, which must also include TWO recommendations to the City of Greater Geelong Endangered Bat Project.

Context/Scenario: Endangered Bat Population Analysis

The Grey-headed Flying-fox, a vulnerable (endangered) species, is one of the most efficient pollinators and seed dispersers of native Australian trees. Large colonies of grey-headed flying-foxes live in the City of Greater Geelong (CoGG). The population of Geelong's grey-headed flying fox colony is in decline. The CoGG Parks and Gardens team have observed that grey-headed flying-foxes can experience dehydration, hyperthermia, and death during major heat events. To address this issue,

CoGG's Parks and Gardens team has monitored the bat population, tree coverage, and weather details in the Geelong region. Following consultation with native animal experts the CoGG Parks and Gardens team have installed new technology including specialist sprinkler systems that spray a fine mist over large bat colonies to cool grey-headed flying-foxes during major heat events. The CoGG Council has requested a series of reports on the project to protect grey-headed flying-foxes in the Geelong area.

Assume that you are a business analyst and you have received an email from Rizwan, the City Intelligence Analyst. Your response will be used as part of a report to the Council. Rizwan's email together with guidelines (shown in blue) are presented below:

Email from Rizwan

To: You

From: Rizwan, City Intelligence Analyst, CoGG

Subject: Analysis of the endangered bat population dataset

1. Hypothesis Testing

It has been suggested to the Council that the average Bat Population is not 100 bats per location regardless of Tree Health. Does the Endangered Bat Population sample data confirm this hypothesis?

2. Multiple Linear Regression Modelling (consider α = 5%)

Bat Population is the key outcome for the Endangered Bat Project. Build a multiple regression model to predict Bat Population. Your model should provide insights into which factors have a significant influence on Bat Population, as well as the ability to predict Bat Population for various scenarios.

Assignment instructions

The assignment consists of two parts.

Part 1: Data Analysis

Your data analysis must be performed on the Assignment 3 Excel file. The file includes tabs (spreadsheets) for:
• Data Description
• Endangered Bat Population Project data set
• Analysis for Hypothesis Testing
• Correlation, which includes:
o creating Dummy variables,

o creating a correlation table,

o eliminating uncorrelated Independent Variables (IVs), and

o eliminating IVs where multi-collinearity is present

• Regression Model - building the regression model, including multiple iterations, and
o reporting the Summary Output of the final regression model,

o identifying the final equation, and explaining/interpreting the final equation, and

o calculating and explaining the Point Estimate, Prediction Interval, and Confidence Interval for the scenario provided.

The only worksheets in the Excel file provided by Rizwan that will be marked are Hypothesis Testing, Correlation, and Regression Model.

Follow the steps (in blue) in Rizwan's email for what to include in the reporting sections that will be marked (e.g. Output and Conclusion sections in the Hypothesis Testing worksheet). There should be no need to create additional worksheets.

When conducting the hypothesis tests, you need to apply techniques and perform calculations as outlined in the lectures and seminars including, as appropriate, descriptive analytics and summary measures, pivot (and other) tables, and visualisations (charts/diagrams). You will also need to draft appropriate conclusions.

Use the Output section to perform your hypothesis test as directed in Rizwan's email, which supports your response to his questions (which you will write in the Conclusion section). Analysis in the Output section will be marked, please make sure your analysis is complete, clear, and easy to follow.

In the Conclusion section of the Hypothesis Testing worksheet there is space allocated for you to write a succinct response to the hypothesis posed in Rizwan's email (above). When drafting your Conclusion, make sure that you directly answer the questions asked. Cite (state) the important features of the analysis in your Output section. Responses in the Conclusion section will be marked (use technical language here).

Part 2: Report

Your report is to be addressed to Rizwan. The report is to be split into two sections.

In the first section it is expected that you will use very limited technical terms (only if these cannot be avoided).

Please assume that Rizwan will send Section 2 of your report directly to the City of Greater Geelong Council (i.e. the readers will have no sight of your Excel file, or Section 1 of your report in the Word document). Your language must be appropriate for a professional audience that has no formal training in business analytics. This means that you must use plain, straight-forward, and easily understood language.

Section 1

(about 450 words)

Section 1 will only be read by Rizwan.

Having completed the hypothesis test and your regression analysis of the Endangered Bat Project data set and created your final regression model, the first section of your report requires an explanation of your findings, including (but not limited to) the different values in the Regression Statistics and the regression coefficients of the significant variables. Include an overall practical interpretation of the Summary Output (a geometric or algebraic interpretation is not required).

Section 2

(about 450 words)

Make TWO (2) recommendations that the City of Greater Geelong Endangered Bat Project team could consider to maximise the bat population in locations across the city.

Your recommendations can be based on analysis in this assignment, analysis from previous assignments and any other analysis that you consider is relevant and adds impact to your recommendations.

Thoughts to consider in framing your recommendations include:

• Specific actions the Endangered Bat Project could take to maximise Bat Population based on the outcomes of your regression model,

• Specific actions the Endangered Bat Project team could take to maximise Bat Population based on the outcomes of your analysis from Assignment 1 and Assignment 2,

• Specific actions the Endangered Bat Project team could take to maximise Bat Population based on the outcomes of any additional analysis you perform,

• The combination of Habitat, Weather and Other characteristics that maximises Bat Population,

• The combination of Habitat, Weather and Other characteristics that do not maximise Bat Population,

• Other factors that it is important for the CoGG Council and Endangered Bat Project team to understand about your analysis of the data.

Make sure that all your recommendations are directly informed by your data analysis. Do not include any commentary that is not supported by your data analysis.

in Section 1. While you must not refer to Assignment #1 or Assignment #2, your work in previous assignments might provide relevant insight when drafting your answer to Section 2. It is useful to produce both numerical and graphical statistical summaries. Sometimes something is revealed in one that is not obvious in the other.

The word limit for your report is 1,000 words (900 to 1,100 words). This includes Introduction, Section 1 and Section 2 and Conclusion. Remember you should use font size 11 and leave margins of 2.54 cm. A template is provided for your convenience.

Carefully consider the following points:

• Your report is to be written as a stand-alone document. Assume that your Excel file is for Rizwan's use only and that Rizwan will only pass (Section 2 of) your written report directly to the Council.

• The goal, especially in Section 2, is to keep the English simple and the explanations clear. Avoid the use of technical statistical jargon. Your task is to express your analysis into plain, simple, easy to understand language.

• Follow the format of the template when writing your report. Delete the report template instructions (in purple) when drafting your report.

Attachment:- Business Analytics.rar