1. Correlation analysis Calculate the Pearson's correlation coefficient between Sales and Potential. Complete the following using Evans (1996) to quantify the strength of correlation:

A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
icon
Related questions
Question
The Question.
Fullparts PLC sells products across the UK which they divide up into 23 sales territories which are coded A-
W. You have been asked to perform a regression analysis to predict the sales (£) of a particular product in
each territory from the market potential (estimated total industry sales (£) for the sales territory). The plot
below displays the data which was collected from the previous financial year.
Sales (Pounds)
8000
7000
0009
5000
4000
3000
2000
O
20000
O
O
o
O
30000
O
O
0 0
O
O
O
40000
O
50000
Market potential (Pounds)
O
O
O
which is a Soloot
60000
Data and transfer check
Download the data and transfer it into SPSS.
Check that your data transfer has been successful by obtaining the Std. Error of the means for the numeric
variables in your data which should appear in SPSS output as:
Sales 429.756
70000
Potential 3181.853
If you do not have these exact values, then you may have not transferred your data from the Excel file to
SPSS correctly. Do not continue with the test until your value agrees as otherwise you may not have correct
answers.
Unless otherwise directed you should report all numeric values to the accuracy displayed in the SPSS output
that is supplied when your data has been transferred correctly.
1. Correlation analysis
Calculate the Pearson's correlation coefficient between Sales and Potential.
Complete the following using Evans (1996) to quantify the strength of correlation:
correlation
Saloot
Transcribed Image Text:The Question. Fullparts PLC sells products across the UK which they divide up into 23 sales territories which are coded A- W. You have been asked to perform a regression analysis to predict the sales (£) of a particular product in each territory from the market potential (estimated total industry sales (£) for the sales territory). The plot below displays the data which was collected from the previous financial year. Sales (Pounds) 8000 7000 0009 5000 4000 3000 2000 O 20000 O O o O 30000 O O 0 0 O O O 40000 O 50000 Market potential (Pounds) O O O which is a Soloot 60000 Data and transfer check Download the data and transfer it into SPSS. Check that your data transfer has been successful by obtaining the Std. Error of the means for the numeric variables in your data which should appear in SPSS output as: Sales 429.756 70000 Potential 3181.853 If you do not have these exact values, then you may have not transferred your data from the Excel file to SPSS correctly. Do not continue with the test until your value agrees as otherwise you may not have correct answers. Unless otherwise directed you should report all numeric values to the accuracy displayed in the SPSS output that is supplied when your data has been transferred correctly. 1. Correlation analysis Calculate the Pearson's correlation coefficient between Sales and Potential. Complete the following using Evans (1996) to quantify the strength of correlation: correlation Saloot
15:24 Fri, 28 Apr
File
1
2
3
Home Insert Draw
A
B
4
с
5
D
6
E
7
F
8
G
9
H
10
|
11 J
12
K
13 L
14 M
15 N
16 O
17 P
18 Q
19 R
20 S
21 T
22 U
23
24 W
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
+
A
B
Territory Sales
龈
Read Only - To make changes, save a copy of this file into a Microsoft Office file
format.
fx
in
с
Potential
2625
24300
7269
58400
4517
36000
4977
35900
5168
26900
2656
21300
6675
39300
3865
23500
6299
34400
5813
57700
7416
64300
3674
20400
3378
34000
1909
25300
5353
21000
1803
37000
4627
23600
7927
58900
2901
23200
8443 68100
6939
52000
3426
37500
8026 45900
123
|||
D
contents-1 - Read-only
Formulas Data Review
E
Σ 48
TI
F
View
G
H
I
<
0.5
Sensitivity
Save a copy
J
K
** || 91%
Dismiss
L
FF
Transcribed Image Text:15:24 Fri, 28 Apr File 1 2 3 Home Insert Draw A B 4 с 5 D 6 E 7 F 8 G 9 H 10 | 11 J 12 K 13 L 14 M 15 N 16 O 17 P 18 Q 19 R 20 S 21 T 22 U 23 24 W 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 + A B Territory Sales 龈 Read Only - To make changes, save a copy of this file into a Microsoft Office file format. fx in с Potential 2625 24300 7269 58400 4517 36000 4977 35900 5168 26900 2656 21300 6675 39300 3865 23500 6299 34400 5813 57700 7416 64300 3674 20400 3378 34000 1909 25300 5353 21000 1803 37000 4627 23600 7927 58900 2901 23200 8443 68100 6939 52000 3426 37500 8026 45900 123 ||| D contents-1 - Read-only Formulas Data Review E Σ 48 TI F View G H I < 0.5 Sensitivity Save a copy J K ** || 91% Dismiss L FF
Expert Solution
steps

Step by step

Solved in 4 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON