GET GUARANTEED SATISFACTION OR MONEY BACK UNDER BUS708 STATISTICS AND DATA ANALYSIS ASSIGNMENT HELP SERVICES OF EXPERTSMINDS.COM  ORDER TODAY NEW COPY OF THIS ASSIGNMENT!
BUS708 Statistics and Data Analysis  Kings Own Institute
Section 1: Introduction
a. Give a brief introduction about the assignment and search a related article and write a paragraph of summary which should be a support for your report.
The major objective of this study is to determine the factors that influence the price of the petrol in Australia. For the purpose of the study, the data was taken from the Australian Government Open Data and a total of 57670 records were collected for the statistical analysis. This data collection is an example of secondary data collection technique as the data was extracted from reliable Australian government source.
Give a short description about this dataset. Is this primary or secondary data?
b. Dataset 1
For the purpose of the study, the data was taken from the Australian Government Open Data and a total of 57670 records were collected for the statistical analysis. This data collection is an example of secondary data collection technique as the data was extracted from reliable Australian government source
Explain how you collect the data and discuss its limitation
c.Dataset 2
The second dataset is an example of primary data collection technique as the data is collected in the form of survey technique. A random sample of 30 KOI students were selected and the details regarding the petrol station they prefer to buy petrol was recorded and thus, it is an example of primary data collection technique
24/7 AVAILABILITY OF TRUSTED BUS708 STATISTICS AND DATA ANALYSIS ASSIGNMENT WRITERS! ORDER ASSIGNMENTS FOR BETTER RESULTS!
Section 2: Analysis of single variable in Dataset
a. What is the shape of the distribution of the variable Price?
Summary Statistics
Statistics 
Value 
Sample Size
Mean
Standard Deviation
Minimum
Q1
Median
Q3

57670
140.054
13.315
65.9
130.900
139.500
148.900

The descriptive statistics for the variable Price is given below
The mean price of the fuel is 140.054 ± 13.315 Australian cents with the recorded median fuel price is 139.5 Australian cents and the recorded minimum and maximum fuel price is 65.9 Australian cents and 179.9 Australian cents respectively. Going through the histogram, we see that the distribution of fuel price approximately has equal tail width on left and right side of the normal curve, indicating that the distribution of fuel price is normally distributed
b. Is the average price of petrol is in all service station in September 2016 is more than 115 Australian cents?
Here, we are interested in determining whether the mean petrol price differ significantly from 115 Australian cents we perform single mean z test
Null Hypothesis: H_{0}: µ = 115
That is, the mean petrol price do not differ significantly from 115 Australian cents
Alternate Hypothesis: H_{1}: µ > 115
That is, the mean petrol price is significantly more than 115 Australian cents
Level of Significance
Let the level of significance be α = 0.05
T Test: One Sample















SUMMARY


Alpha

0.05




Count

Mean

Std Dev

Std Err

t

df

Cohen d

Effect r

57670

140.0537

13.31467

0.055444

451.874

57669

1.881665

0.883046









T TEST



Hyp Mean

115





pvalue

tcrit

lower

upper

sig



One Tail

0

1.64488



yes



Two Tail

0

1.960005

139.9451

140.1624

yes



Here, the t test value is 451.874 and its corresponding p  value is 0.000 < 0.05, indicating that we need to reject the null hypothesis at 5% level of significance. Therefore, there is statistical evidence to say that the mean price of the petrol is more than 115 Australian cents
Conclusion
Here, the p  value of t test statistic is less than 0.05, indicating that there is statistical evidence to conclude that the mean price of the petrol is more than 115 Australian cents
DO YOU WANT TO EXCEL IN BUS708 STATISTICS AND DATA ANALYSIS ASSIGNMENT  ORDER AT EXPERTSMINDS!
Section 3: Analysis of two variables in Dataset
Section 3:
Give numerical summary and appropriate graphical display for comparing the price of petrol of those four major Brands.
a.

7  Eleven

Caltex

Caltex Woolworths

Coles Express

Mean

140.39

141.93

141.36

148.03

Standard Error

0.12

0.13

0.13

0.23

Median

139.95

141.4

141.35

146.9

Mode

147.9

139.9

139.9

139.9

Standard Deviation

12.65

13.40

13.04

12.97

Sample Variance

160.06

179.57

169.94

168.33

Kurtosis

2.75

4.38

3.89

0.01

Skewness

0.49

0.99

0.88

0.01

Range

95.1

105

99

86

Minimum

72.8

65.9

72.9

86.9

Maximum

167.9

170.9

171.9

172.9

Sum

1511407

1528063

1521867

473857

Count

10766

10766

10766

3201

Perform a suitable hypothesis test at a 5% level of significance to test whether there a price difference among these four major Brands.
b.
Here, we are interested in determining the mean petrol price differ significantly from 115 Australian cents we perform single mean z test
Null Hypothesis: H0: µ1 = µ2 = µ3 = µ4
That is, the mean petrol price do not differ significantly between Caltex, Caltex Woolworths, Coles Express and 7  Eleven
Alternate Hypothesis: H1: µi ≠ µj
That is, the mean petrol price differ significantly between Caltex, Caltex Woolworths, Coles Express and 7  Eleven
Level of Significance
Let the level of significance be α = 0.05
Anova: Single Factor
Groups

Count

Sum

Average

Variance



7  Eleven

10766

1511407

140.387

160.0598



Caltex

12768

1811151

141.8508

173.3717



Caltex Woolworths

11849

1674538

141.3231

165.6719



Coles Express

3201

473857

148.0341

168.3281










ANOVA







Source of Variation

SS

df

MS

F

Pvalue

F crit

Between Groups

148622.2

3

49540.74

296.8746

1.5E190

2.605139

Within Groups

6438011

38580

166.8743











Total

6586633

38583





The value of f test value is 296.9 and its corresponding p  value is 0.000 < 0.05, indicating that we reject null hypothesis at 5% level of significance. Therefore, we say that the mean price of the petrol differ significantly between Caltex, Caltex Woolworths, Coles Express and 7  Eleven
write an accurate information of the petrol price. Your answer should contain that whether there is price differences and if there is, try to find which Brand price is lowest.
c.
Conclusion
Here, the p  value of t test statistic is less than 0.05, indicating that there is statistical evidence to conclude that the mean petrol differ significantly between Caltex, Caltex Woolworths, Coles Express and 7  Eleven
GET ASSURED A++ GRADE IN EACH BUS708 STATISTICS AND DATA ANALYSIS ASSIGNMENT ORDER  ORDER FOR ORIGINALLY WRITTEN SOLUTIONS!
Section 4: Collect and analysis Dataset
Section 4
a. Write an executive summary by combining all of your finding in the previous sections which must be a valuable for NRMA to report to media
The brand choice of the 30 randomly selected KOI students information is given below
Brand

Frequency

Percentage

7Eleven

2

6.7%

BP

4

13.3%

Budget

1

3.3%

Caltex

5

16.7%

Caltex Woolworths

2

6.7%

Independent

4

13.3%

Metro Fuel

6

20.0%

Mobil

1

3.3%

Speedway

2

6.7%

United

3

10.0%

Total

30


About 20% of the KOI students prefer to use Metro Fuel brand, 16.7% of the students prefer to buy petrol in Caltex brand and 13.3% of the KOI students prefer to buy petrol in Independent shops
Discussion and conclusion
The major objective of this study is to determine the factors that influence the price of the petrol in Australia. For the purpose of the study, the data was taken from the Australian Government Open Data and a total of 57670 records were collected for the statistical analysis. This data collection is an example of secondary data collection technique as the data was extracted from reliable Australian government source
The mean price of the fuel is 140.054 ± 13.315 Australian cents with the recorded median fuel price is 139.5 Australian cents and the recorded minimum and maximum fuel price is 65.9 Australian cents and 179.9 Australian cents respectively. Going through the histogram, we see that the distribution of fuel price width was approximately equal on both left and right sides of the normal curve, indicating that the distribution of fuel price is normally distributed
Here, we are interested in determining whether the mean price of the petrol is more than 115 Australian cents, single mean z test was performed. The study findings say that the mean price of the petrol is more than 115 Australian cents. In order to determine whether there is a significant difference in the mean petrol prices among Caltex, Caltex Woolworths, Coles Express and 7  Eleven brands, one way ANOVA was performed. The study findings suggest that there is statistical evidence to conclude that the mean price of the petrol differ significantly between Caltex, Caltex Woolworths, Coles Express and 7  Eleven
GET READYMADE BUS708 STATISTICS AND DATA ANALYSIS ASSIGNMENT SOLUTIONS  100% PLAGIARISM FREE WORK DOCUMENT AT NOMINAL CHARGES!
Get our Kings Own Institute Assignment Help services for below mentioned courses like:
 BUS709 Communication in Business Assignment Help
 ACC705 Corporate Accounting and Reporting Assignment Help
 BUS710 Research Project Assignment Help
 ACC706 Accounting Theory and Issues Assignment Help
 ACC700 Principles of Accounting Assignment Help
 ACC703 Accounting Information Systems Assignment Help
 ACC708 Taxation Law Assignment Help
 BUS700 Economics Assignment Help
 ACC707 Auditing and Assurance Assignment Help
 BUS702 Business Law Assignment Help
 ACC702 Managerial Accounting Assignment Help