Statistics Assignment ( Only Question 2)

StatsS2BAssignmentspreadsheetforstudents2017-2018v.xlsx

Home >Mathematics homework help >Statistics homework help >Statistics Assignment ( Only Question 2)

Q1 2017-2018

(a) Rock 'n' Roll
Salary (£ per week)	Number of employees	Mid point	fx	fxx	Cumulative frequency	Cumulative %
250 but under 400	15
300 but under 350	13
350 but under 400	12
400 but under 450	8
450 but under 500	4
500 but under 550	2
550 but under 600	2

Q2 2017-2018

Covers for Stargazer Hotel
Year	Q1	Q2	Q3	Q4
2013		60	78	70
2014	58	62	82	72
2015	60	65	85	72
2016	61	67	87	76
2017	68
Year	Quarter	Data	Trend
2013	2	60
	3	78
	4	70	66.75
2014	1	58	67.5
	2	62	68.25
	3	82	68.75
	4	72	69.375
2015	1	60	70.125
	2	65	70.5
	3	85	70.625
	4	72	71
2016	1	61	71.5
	2	67	72.25
	3	87	73.625
	4	76
2017	1	68
	2
	3
	4

Covers for Stargazer Hotel

Data 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 2013 2014 2015 2016 2017 60 78 70 58 62 82 72 60 65 85 72 61 67 87 76 68 Trend 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 1 2 3 4 2013 2014 2015 2016 2017 66.75 67.5 68.25 68.75 69.375 70.125 70.5 70.625 71 71.5 72.25 73.625

Year / Quarter

Percentage of covers

Graphs for Q2 (d)

2016	Families	Groups	Other
Q1	250	65	52
Q2	405	130	95
Q3	575	145	106
Q4	290	105	80