Scribd
Upload
39 views4 pages

Week 5 Data File QUAL and Lecture Examples

The document provides data from a survey of branches of a large retail chain. It includes information on the gross takings, floorspace, location type (shopping precinct or street), and number of staff for each branch. The data is presented in a table with 4 columns: takings, floorspace, location, and staff.

Uploaded by

Afeera Musa
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
39 views4 pages

Week 5 Data File QUAL and Lecture Examples

The document provides data from a survey of branches of a large retail chain. It includes information on the gross takings, floorspace, location type (shopping precinct or street), and number of staff for each branch. The data is presented in a table with 4 columns: takings, floorspace, location, and staff.

Uploaded by

Afeera Musa
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
You are on page 1/ 4

QUAL.XLS gives the results of a survey of branches of a large retail chain.

COLUMN 1 contains the gross takings of the branch for the past month.
COLUMN 2 contains the number of square metres of floorspace in the branch.
COLUMN 3 indicates whether the branch is in a shopping precinct (1) or on a street (2)
COLUMN 4 shows the number of sales staff employed at the branch.

TAKINGS FLSPACE OCATION STAFF


209431 771 1 19
267297 810 1 27
212305 856 1 28
317124 845 1 25
216779 775 1 22
275279 806 1 26
403668 846 1 26
93625 740 2 21
280606 770 1 25
243457 796 1 21
179635 778 1 24
229782 772 1 23
338700 806 2 22
330226 771 1 21
273949 784 1 25
278142 819 1 25
170681 781 2 22
271957 775 1 22
243745 799 2 24
149119 792 1 26
193628 821 1 27
252825 789 1 23
250631 839 2 27
196430 769 2 24
222404 769 1 22
265866 852 1 27
310762 805 1 27
242973 766 1 22
199044 757 1 23
350925 807 1 25
233305 804 1 22
321406 856 2 26
183442 790 1 23
275947 776 1 25
271927 830 1 25
115231 762 1 22
191681 719 2 18
231794 772 1 24
260211 787 1 22
228235 835 2 26
278770 801 1 23
220343 788 1 26
204712 824 1 26
221527 764 1 23
250328 774 1 21
225747 830 1 26
144386 753 2 22
226268 814 1 26
271584 815 1 23
135813 804 1 23
209637 776 2 24
210600 815 1 29
175543 799 1 24
214170 795 1 23
260796 837 1 28
364151 811 1 24
149025 821 1 25
254657 815 1 20
148220 753 1 23
239287 840 1 27
248540 817 1 25
255657 804 1 22
190954 791 1 24
216852 809 1 20
Outlets visited Sales
40 5700
47 9000
51 11000
56 11000
64 12600
60 14000
68 15000
75 17000
81 17000
45 6900

=correl(a2:a11,b2:b11) 0.965599229246997
Salary (X) Holiday Price (Y)

23 450
30 870
27 690
19 380
21 520

You might also like