Statistics BUS1033 Report: Analysis of Fuel Prices Across Canada

Verified

Added on 2022/09/11

AI Summary

This report presents a statistical analysis of fuel prices across various Canadian cities. The analysis includes data from April, May, and June 2019, with a focus on calculating key statistical measures such as mean, median, mode, variance, and standard deviation. The report utilizes frequency distribution tables, histograms, and frequency polygons to visualize the data and identify trends. The report also provides a cumulative analysis of fuel prices over the three-month period, comparing and contrasting price fluctuations across different geographic locations. The findings are presented with detailed tables, charts, and discussions, offering insights into the dynamics of fuel prices and their variations across Canada. The report also includes the analysis of July, August and September 2019 fuel prices.

Amandeep Ghotra (H10001974)
Ramandeep Kaur (H1000094)
Balraj Singh (H10001137)
Prabhjot Singh(H10001978)
Statistics
BUS1033

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

1. Apr-2019
1
Topic
Page number
Table of fuel prices 2
Analysis of April 2019 3
Analysis of May 2019 4
Analysis of June 2019 5
Cumulative Analysis 8
Analysis of Data 10
Conclusion 11
Discussion 12
Geography Apr-19 May-19 Jun-19
St. John's, Newfoundland and Labrador 136.8 138.3 129.3
Charlottetown and Summerside, Prince Edward Island 133.8 135.3 124.9
Halifax, Nova Scotia 122.9 123.2 111.4
Saint John, New Brunswick 134.4 135.3 126.1
Quebec, Quebec 129.2 131.4 126.5
Montreal, Quebec 128.7 130.1 126.6
Ottawa-Gatineau, Ontario part, Ontario/ Quebec 2 123.5 123.6 119.2
Toronto, Ontario 121.5 122.4 116.6
Thunder Bay, Ontario 122.6 124.2 120.5
Winnipeg, Manitoba 124.9 125.9 122
Regina, Saskatchewan 123.9 124.8 118.2
Saskatoon, Saskatchewan 124.8 126.7 123.6
Edmonton, Alberta 4 124 124.6 113.1
Calgary, Alberta 4 125.2 126.9 116.2
Vancouver, British Columbia 139 142.7 136.2
Victoria, British Columbia 137.1 141.1 133.7
Whitehorse, Yukon 140.4 137.5 135.9
Yellowknife, Northwest Territories 135.7 139.9 138.7

a. Frequency Distribution Table
b. Histogram and Frequency Polygon
c. Cumulative Frequency Polygon
Tally Chart Frequency Relative Frequency Cumulative Frequency
117-122 I 1 0.06 1
122-127 IIII I 8 0.44 9
127-132 II 2 0.11 11
132-137 IIII 4 0.22 15
137-142 III 3 0.17 18
18 1
117-122 122-127 127-132 132-137 137-142
0
2
4
6
8
10
12
14
16
18
20
Histogram And Polygon
Class
Frequency
2

117-122 122-127 127-132 132-137 137-142
0
2
4
6
8
10
12
14
16
18
20
Cumulative frequency Polygon
Class
Cumulative frequency
Mean ∑Xi/n 129.36
Median n+1/2 126.95
Mode The value with the
greatest frequency #N/A
Variance ∑×-x /n-1 42.11
Standard Deviation √variance 6.49
Q1 123.80
Q2 126.95
Q3 135.98
3

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

2. May-2019
a. Frequency Distribution Table
b. Histogram and Frequency Polygon
c. Cumulative Frequency Polygon
d.
May-19
Interval
s
Tally Chart Frequenc
y
Relative
Frequency
Cumulative
Frequency
120-125 IIII I 6 0.33 6
125-130 III 3 0.17 9
130-135 II 2 0.11 11
135-140 IIII 5 0.28 16
140-145 II 2 0.11 18
1
Mean ∑Xi/n 130.77
Median n+1/2 128.5
Mode The value with the greatest
frequency 135.3
Variance ∑×-x /n-1 54.12
Standard Deviation √variance 7.36
Q1 124.5
Q2 128.5
Q3 137.7
4

120-125 125-130 130-135 135-140 140-145
0
1
2
3
4
5
6
7
Histogram and Frequency Ploygon
Class
Frequency
1 2 3 4 5
0
2
4
6
8
10
12
14
16
18
20
Cumulative grequency polygon
Class
Cumulative frequency
5

3. Jun-2019
a. Frequency Distribution Table
b. Histogram and Frequency Polygon
c. Cumulative Frequency Polygon
Jun-19
Interval
s
Tally Chart Frequenc
y
Relative
Frequency
Cumulative
Frequency
110-116 II 2 0.11 2
116-122 IIII 5 0.28 7
122-128 IIII I 6 0.33 13
128-134 II 2 0.11 15
134-140 III 3 0.17 18
18
110-116 116-122 122-128 128-134 134-140
0
1
2
3
4
5
6
7
Histogram and Polygon
Class
Frequency
6

Paraphrase This Document

Need a fresh take? Get an instant paraphrase of this document with our AI Paraphraser

110-116 116-122 122-128 128-134 134-140
0
2
4
6
8
10
12
14
16
18
20
Cumulative frequency Polygon
Class
Cumulative frequency
Mean ∑Xi/n 124.31
Median n+1/2 124.25
Mode The value with the greatest
frequency N/A
Variance ∑×-x /n-1 57.85
Standard Deviation √variance 7.60
Q1
Q2
Q3
Analysis of the Data
7

April 2019
Mean: 129.36
Variance: 42.11
Standard Deviation: 6.49
May 2019
Mean: 128.5
Variance: 54.12
Standard Deviation: 7.46
June 2019
Mean: 124.31
Variance: 57.85
Standard Deviation: 7.60
8