Data Analysis and Business Intelligence

Running head: DATA ANALYSIS AND BUSINESS INTELLIGENCE
Data Analysis and Business Intelligence
Name of the Student:
Name of the University:
Author Note:

DATA ANALYSIS AND BUSINESS INTELLIGENCE1
Table of Contents
Introduction....................................................................................................................2
Action Plan and Hypothesis Testing..............................................................................2
Action Plan for 1st Issue.............................................................................................2
Action Plan for 2nd Issue and Hypothesis Testing......................................................3
Action Plan for 3rd Issue and Hypothesis Testing......................................................3
Action Plan for 4th Issue and Hypothesis Testing......................................................4
Action Plan for 5th Issue and Hypothesis Testing......................................................4
Conclusion......................................................................................................................5
Reference and Bibliography...........................................................................................6
Appendices.....................................................................................................................7
Appendix 1: Price of accommodation brands................................................................7
Appendix 2: Price of accommodation brands by State..................................................7
Appendix 3: Price of accommodation brands by location.............................................7
Appendix 4: One-way ANOVA test for difference in prices across brands..................8
Appendix 5: Two-way ANOVA test for difference in brand prices across state...........9
Appendix 6: Two-way ANOVA test for difference in brand prices across location...10
Appendix 7: Two-way ANOVA test for difference in brand prices while there is
comfort if there is competition.....................................................................................11

DATA ANALYSIS AND BUSINESS INTELLIGENCE2
Introduction
The aim of the report is to answer the question that has been requested by Mr
Oscar on 5 issues. The 5 issues are as mentioned below:
1. The current price of the accommodation brands by state and by location.
2. Is there any difference in prices across brands (Resort, Cottage and Classic)?
3. Is there any difference in prices across brands by state (NSW, QLD, VIC)?
4. Is there any difference in prices across brands by location (Metropolitan Cities
and Regional Cities)?
5. Is there any difference in prices across brands while there is comfort if there is
competition?
Action Plan and Hypothesis Testing
Action Plan for 1st Issue
A table is created using pivot table option of MS Excel for the price of
accommodation across brands by state and location. These tables present the average
price and the standard deviation of price.
The average price of Resort, Cottage and Classic is 201.46, 202.66 and 200.27
respectively.
The average price of Resorts in NSW, QLD and VIC are 199.27, 201.23 and
200.31 respectively. The average price of Cottage in NSW, QLD and VIC are 202.09,
203.78 and 202.10 respectively. The average price of Classic in NSW, QLD and VIC
are 201.71, 201.58 and 201.10 respectively.
The average price of Classic in Metropolitan and Regional cities are 201.46
and 202.31 respectively. The average price of Cottage in Metropolitan and Regional

DATA ANALYSIS AND BUSINESS INTELLIGENCE3
cities are 202.25 and 203.06 respectively. The average price of Resort in Metropolitan
and Regional cities are 200.11 and 200.43 respectively.
Action Plan for 2nd Issue and Hypothesis Testing
The data on price is sorted by brand and reorganized into separate columns for
each brand. To find out the result using statistical tool, the hypothesis is developed
which is presented below:
Null Hypothesis, H0 : The mean price of all brands are equal.
Alternate Hypothesis, H1 :At least one mean brand price is different.
The level of significance is set at 0.05. The one-way ANOVA test is
performed (Jaggia et al., 2016). The result shows that the p-value of the test statistic is
less than 0.05. This indicates that the alternative hypothesis is accepted at 0.05
significance level.
Action Plan for 3rd Issue and Hypothesis Testing
The data on price is sorted by brand first and reorganized into separate
columns for each brand. Then these columns are sorted by state. To find out the result
using statistical tool, the hypothesis is developed which is presented below:
Null Hypothesis, H0 1 : The mean price across all states are equal.
H0 2 :The mean price of all brands are equal.
H0 3 :The mean price of all brands across all states are equal.
Alternate Hypothesis, H1 :At least one mean brand price is different.
The level of significance is set at 0.05. The two-way ANOVA test is
performed (George & Mallery, 2016). The result shows that the p-value of the test