Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, this is a SPSS Assignment question, please utilize the dataset provided at end to answer below questions: Correlation Select 3 variables to explore their
Hello, this is a SPSS Assignment question, please utilize the dataset provided at end to answer below questions:
Correlation
- Select 3 variables to explore their relationship. Develop a brief rationalization for variable selection.
- Run a correlation on these variables.
- Explain the results of each possible relationship among the 3 variables. Include notation if results are significant and comment on the strength of the relationship.
Regression
- Develop a research question that includes a Dependent Variable and at least 2 Independent Variables.
- What are the Independent and Dependent Variables?
- Run Assumption tests for Linearity, Normality and Homoscedasticity. How does each look?
- Run a Linear Regression and report on the following:
- What are the results of the ANOVA table? What does it mean?
- What are the results of the Model Summary Table? What does this mean?
- What are the results of the Coefficients table? What is the final result? (Hint: use notation).
Adverts (Advertsing Budget (Thousands of Pounds) | Sales(Album Sales (Thousands)) | Airplay(No. of plays on Radio) | Attract (Attractiveness of Band) |
10.26 | 330 | 43 | 10 |
985.69 | 120 | 28 | 7 |
1445.56 | 360 | 35 | 7 |
1188.19 | 270 | 33 | 7 |
574.51 | 220 | 44 | 5 |
568.95 | 170 | 19 | 5 |
471.81 | 70 | 20 | 1 |
537.35 | 210 | 22 | 9 |
514.07 | 200 | 21 | 7 |
174.09 | 300 | 40 | 7 |
1720.81 | 290 | 32 | 7 |
611.48 | 70 | 20 | 2 |
251.19 | 150 | 24 | 8 |
97.97 | 190 | 38 | 6 |
406.81 | 240 | 24 | 7 |
265.40 | 100 | 25 | 5 |
1323.29 | 250 | 35 | 5 |
196.65 | 210 | 36 | 8 |
1326.60 | 280 | 27 | 8 |
1380.69 | 230 | 33 | 8 |
792.35 | 210 | 33 | 7 |
957.17 | 230 | 28 | 6 |
1789.66 | 320 | 30 | 9 |
656.14 | 210 | 34 | 7 |
613.70 | 230 | 49 | 7 |
313.36 | 250 | 40 | 8 |
336.51 | 60 | 20 | 4 |
1544.90 | 330 | 42 | 7 |
68.95 | 150 | 35 | 8 |
785.69 | 150 | 8 | 6 |
125.63 | 180 | 49 | 7 |
377.93 | 80 | 19 | 8 |
217.99 | 180 | 42 | 6 |
759.86 | 130 | 6 | 7 |
1163.44 | 320 | 36 | 6 |
842.96 | 280 | 32 | 7 |
125.18 | 200 | 28 | 6 |
236.60 | 130 | 25 | 8 |
669.81 | 190 | 34 | 8 |
612.23 | 150 | 21 | 6 |
922.02 | 230 | 34 | 7 |
50.00 | 310 | 63 | 7 |
2000.00 | 340 | 31 | 7 |
1054.03 | 240 | 25 | 7 |
385.05 | 180 | 42 | 7 |
1507.97 | 220 | 37 | 7 |
102.57 | 40 | 25 | 8 |
204.57 | 190 | 26 | 7 |
1170.92 | 290 | 39 | 7 |
689.55 | 340 | 46 | 7 |
784.22 | 250 | 36 | 6 |
405.91 | 190 | 12 | 4 |
179.78 | 120 | 2 | 8 |
607.26 | 230 | 29 | 8 |
1542.33 | 190 | 33 | 8 |
1112.47 | 210 | 28 | 7 |
856.99 | 170 | 10 | 6 |
836.33 | 310 | 38 | 7 |
236.91 | 90 | 19 | 4 |
1077.86 | 140 | 13 | 6 |
579.32 | 300 | 30 | 7 |
1500.00 | 340 | 38 | 8 |
731.36 | 170 | 22 | 8 |
25.69 | 100 | 23 | 6 |
391.75 | 200 | 22 | 9 |
234.00 | 80 | 20 | 7 |
275.70 | 100 | 18 | 6 |
56.90 | 70 | 37 | 7 |
255.12 | 50 | 16 | 8 |
566.50 | 240 | 32 | 8 |
102.57 | 160 | 26 | 5 |
250.57 | 290 | 53 | 9 |
68.59 | 140 | 28 | 7 |
642.79 | 210 | 32 | 7 |
1500.00 | 300 | 24 | 7 |
102.56 | 230 | 37 | 6 |
756.98 | 280 | 30 | 8 |
51.23 | 160 | 19 | 7 |
644.15 | 200 | 47 | 6 |
15.31 | 110 | 22 | 5 |
243.24 | 110 | 10 | 8 |
256.89 | 70 | 1 | 4 |
22.46 | 100 | 1 | 6 |
45.69 | 190 | 39 | 6 |
724.94 | 70 | 8 | 5 |
1126.46 | 360 | 38 | 7 |
1985.12 | 360 | 35 | 5 |
1837.52 | 300 | 40 | 5 |
135.99 | 120 | 22 | 7 |
237.70 | 150 | 27 | 8 |
976.64 | 220 | 31 | 6 |
1452.69 | 280 | 19 | 7 |
1600.00 | 300 | 24 | 9 |
268.60 | 140 | 1 | 7 |
900.89 | 290 | 38 | 8 |
982.06 | 180 | 26 | 6 |
201.36 | 140 | 11 | 6 |
746.02 | 210 | 34 | 6 |
1132.88 | 250 | 55 | 7 |
1000.00 | 250 | 5 | 7 |
75.90 | 120 | 34 | 6 |
1351.25 | 290 | 37 | 9 |
202.71 | 60 | 13 | 8 |
365.99 | 140 | 23 | 6 |
305.27 | 290 | 54 | 6 |
263.27 | 160 | 18 | 7 |
513.69 | 100 | 2 | 7 |
152.61 | 160 | 11 | 6 |
35.99 | 150 | 30 | 8 |
102.57 | 140 | 22 | 7 |
215.37 | 230 | 36 | 6 |
426.78 | 230 | 37 | 8 |
507.77 | 30 | 9 | 3 |
233.29 | 80 | 2 | 7 |
1035.43 | 190 | 12 | 8 |
102.64 | 90 | 5 | 9 |
526.14 | 120 | 14 | 7 |
624.54 | 150 | 20 | 5 |
912.35 | 230 | 57 | 6 |
215.99 | 150 | 19 | 8 |
561.96 | 210 | 35 | 7 |
474.76 | 180 | 22 | 5 |
231.52 | 140 | 16 | 7 |
678.60 | 360 | 53 | 7 |
70.92 | 10 | 4 | 6 |
1567.55 | 240 | 29 | 6 |
263.60 | 270 | 43 | 7 |
1423.57 | 290 | 26 | 7 |
715.68 | 220 | 28 | 7 |
777.24 | 230 | 37 | 8 |
509.43 | 220 | 32 | 5 |
964.11 | 240 | 34 | 7 |
583.63 | 260 | 30 | 7 |
923.37 | 170 | 15 | 7 |
344.39 | 130 | 23 | 7 |
1095.58 | 270 | 31 | 8 |
100.03 | 140 | 21 | 5 |
30.43 | 60 | 28 | 1 |
1080.34 | 210 | 18 | 7 |
799.90 | 210 | 28 | 7 |
1071.75 | 240 | 37 | 8 |
893.36 | 210 | 26 | 6 |
283.16 | 200 | 30 | 8 |
917.02 | 140 | 10 | 7 |
234.57 | 90 | 21 | 7 |
456.90 | 120 | 18 | 9 |
206.97 | 100 | 14 | 7 |
1294.10 | 360 | 38 | 7 |
826.86 | 180 | 36 | 6 |
564.16 | 150 | 32 | 7 |
192.61 | 110 | 9 | 5 |
10.65 | 90 | 39 | 5 |
45.69 | 160 | 24 | 7 |
42.57 | 230 | 45 | 7 |
20.46 | 40 | 13 | 8 |
635.19 | 60 | 17 | 6 |
1002.27 | 230 | 32 | 7 |
1177.05 | 230 | 23 | 6 |
507.64 | 120 | 0 | 6 |
215.69 | 150 | 35 | 5 |
526.48 | 120 | 26 | 6 |
26.90 | 60 | 19 | 6 |
883.88 | 280 | 26 | 7 |
9.10 | 120 | 53 | 8 |
103.57 | 230 | 29 | 8 |
169.58 | 230 | 28 | 7 |
429.50 | 40 | 17 | 6 |
223.64 | 140 | 26 | 8 |
145.59 | 360 | 42 | 8 |
985.97 | 210 | 17 | 6 |
500.92 | 260 | 36 | 8 |
226.65 | 250 | 45 | 7 |
1051.17 | 200 | 20 | 7 |
68.09 | 150 | 15 | 7 |
1547.16 | 250 | 28 | 8 |
393.77 | 100 | 27 | 6 |
804.28 | 260 | 17 | 8 |
801.58 | 210 | 32 | 8 |
450.56 | 290 | 46 | 9 |
26.60 | 220 | 47 | 8 |
179.06 | 70 | 19 | 1 |
345.69 | 110 | 22 | 8 |
295.84 | 250 | 55 | 9 |
2271.86 | 320 | 31 | 5 |
1134.58 | 300 | 39 | 8 |
601.43 | 180 | 21 | 6 |
45.30 | 180 | 36 | 6 |
759.52 | 200 | 21 | 7 |
832.87 | 320 | 44 | 7 |
56.89 | 140 | 27 | 7 |
709.40 | 100 | 16 | 6 |
56.90 | 120 | 33 | 6 |
767.13 | 230 | 33 | 8 |
503.17 | 150 | 21 | 7 |
700.93 | 250 | 35 | 9 |
910.85 | 190 | 26 | 7 |
888.57 | 240 | 14 | 6 |
800.62 | 250 | 34 | 6 |
1500.00 | 230 | 11 | 8 |
785.69 | 110 | 20 | 9 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started