Question: 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
Get step-by-step solutions from verified subject matter experts
