376 Hw 5

Megan Lee a. Show in a TABLE (similar to the one we showed in class) the simple correlations between all 5 Variables. Indicate which correlations are significant with **. Do not provide duplicate correlations. Since you have 5 variables, how many correlations should be in the table? Use the N (N-1)/2 formula.

There should be 10 correlations in the table. What is the direction and correlation between "Would not attend Coachella if streamed" and "PL" ? Is it significant? -.965* There is a strong, negative correlation between “would not attend Coachella if streamed” and “PL”. It is significant due to the asterisk next to it.

b. Run a bivariate regression with "Purchase Likelihood (PL) " as the dependent variable and "Would NOT attend Coachella if Streamed" as the one independent variable. Report the F and sig values. Interpret the results. Is the regression significant? F = 2243.457 and sig = .000 Since the sig of .000 is less than 0.05, the regression is significant and we can conclude that “purchase likelihood” is dependent on “would NOT attend Coachella if streamed”. Report the overall regression R2 R2 =.932 Report the regression formula – PL = constant + coefficient (x1) Fill in the constant and coefficient with numbers from the table. PL = 12.963-.965(Streamed) Provide the tstat and sig for the coefficient. Indicate if the coefficient for x1 is significant. In words, indicate what this means. T= 72.543 and sig= .000 Since the sig = .000, which is less than 0.05, the coefficient for x1 is significant which mean that the variable “I would not attend Coachella if it was live streamed” is significant. c. Run a multiple regression with "PL" as the dependent variable and "Would not attend" "Beyonce is Important", "Age", and "Number of Children" as the independent variables. **Report the correct statistics and interpret if the the overall regression is significant.

(Hint - F stat and sig) Indicate how What is the

Important to

Probability you

your decision

will buy a

I would NOT

to attend is

ticket to

attend

Beyonce

Cochella in

Coachella if it

performing at

2019 ? PL 0 to

is live

Coachella in

10

streamed

2019?

AGE

Num_Child

Pearson Correlation

What is the Probability

1.000

you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend

-.965

1.000

.932

-.912

1.000

-.224

.204

-.179

1.000

.122

-.109

.116

-.136

1.000

.

.000

.000

.002

.058

.000

.

.000

.004

.082

.000

.000

.

.010

.068

AGE

.002

.004

.010

.

.040

Num_Child

.058

.082

.068

.040

.

What is the Probability

166

166

166

166

166

166

166

166

166

166

166

166

166

166

166

AGE

166

166

166

166

166

Num_Child

166

166

166

166

166

Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE Num_Child Sig. (1-tailed)

What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019?

N

you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019?

F = 747.56 and sig = .000

Since the sig=.000, which is less than 0.05, the overall regression is significant and that at least one of the independent variables is significant and we can conclude that “purchase likelihood” is dependent on at least one of the variables.

Report the overall regression R2 and adjusted R2 The overall R2= .949 and the adjusted R2=.948 Explain the meaning of R2. The R2 means that we are 94.8% of the variation in Purchase Likelihood is explained by the independent variables "Would not attend", "Beyonce is Important", "Age", and "Number of Children" Report each IV coefficient, the statistic and the sig value. Indicate how you decide if each is sig. Standardize d Coefficients

Unstandardized Coefficients Model 1 (Constant) I would NOT attend Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE Num_Child

B 8.484 -1.065

Std. Error .566 .069

.378

-.007 .027

Beta

95.0% Confidence Interval for B Lower Sig. Bound .000 7.365 .000 -1.200

-.677

t 14.976 -15.537

.053

.309

7.117

.000

.273

.004 .053

-.029 .009

-1.581 .504

.116 .615

-.015 -.078

“would not attend”= coefficient: -1.065, statistic: -15.537, sig: .000; significant “Beyonce is important”= coefficient: .378, statistic: 7.117, sig: .000; significant “age”= coefficient: -.007, statistic: -1.581, sig: .116; not significant “number of children”= coefficient: 0.27, statistic: .504, sig: .615; not significant To decide if each of the IV is significant, I look at the significance value. If it is above 0.05, the variable is not significant.

Report the regression formula with the numbers filled in. PL = constant + coefficient (x1) + coefficient (for each variable)…. PL= 8.484 – 1.065*(streamed)+.378*(beyonce)-.007(age)+.027(number of children) Include both significant and nonsignificant coefficients. Add a * by the coefficients number if significant. Which of the variable should be used in trying to predict Purchase Likelihood (PL)? “Would not attend Coachella if it is live streamed” and “Beyonce is important” should be used in trying to predict Purchase Likelihood as those are the two variables that are significant as per our regression output. CORRELATIONS /VARIABLES=Q4_4 Q4_5 AGE NUM_CHILD PL /PRINT=TWOTAIL NOSIG /STATISTICS DESCRIPTIVES /MISSING=PAIRWISE.

Correlations

Notes Output Created Comments Input

Missing Value Handling

20-FEB-2019 20:34:12 Data

/Users/megan/Downloads/3 76TurkPrime Social Media Data.sav Active Dataset DataSet1 Filter <none> Weight <none> Split File <none> N of Rows in Working Data 166 File Definition of Missing User-defined missing values are treated as missing.

Cases Used

Statistics for each pair of variables are based on all the cases with valid data for that pair. CORRELATIONS /VARIABLES=Q4_4 Q4_5 AGE NUM_CHILD PL /PRINT=TWOTAIL NOSIG /STATISTICS DESCRIPTIVES /MISSING=PAIRWISE. 00:00:00.02 00:00:00.00

Syntax

Resources

Processor Time Elapsed Time

Descriptive Statistics Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? I would NOT attend Coachella if it is live streamed AGE Num_Child What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

Mean 4.37

Std. Deviation 2.555

N

4.80

1.986

166

39.6747 .73 4.78

13.44493 1.068 3.124

166 166 166

166

Correlations

Indicate how Important to your

Pearson Correlation

Indicate how Important to your decision to attend is I would NOT Beyonce attend performing Coachella if at Coachella it is live in 2019? streamed 1

AGE

What is the Probability you will buy a ticket to Cochella in Num_Chil 2019 ? PL 0 d to 10

decision to attend is Beyonce performing at Coachella in 2019? I would NOT attend Coachella if it is live streamed

Sig. (2-tailed) N

166

Pearson Correlation

Sig. (2-tailed) N AGE Pearson Correlation Sig. (2-tailed) N Num_Child Pearson Correlation Sig. (2-tailed) N What is the Probability Pearson you will buy a ticket to Correlation Cochella in 2019 ? PL Sig. (2-tailed) 0 to 10 N

-.912**

1

.000 166 -.179*

166 .204**

1

.021 166 .116

.008 166 -.109

166 -.136

1

.135 166 .932**

.164 166 -.965**

.080 166 -.224**

166 .122

1

.000 166

.000 166

.004 166

.116 166

166

**. Correlation is significant at the 0.01 level (2-tailed). *. Correlation is significant at the 0.05 level (2-tailed).

REGRESSION /DESCRIPTIVES MEAN STDDEV CORR SIG N /MISSING LISTWISE /STATISTICS COEFF OUTS CI(95) R ANOVA ZPP /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT PL /METHOD=ENTER Q4_5 /CASEWISE PLOT(ZRESID) OUTLIERS(3).

Regression

Notes Output Created Comments

20-FEB-2019 20:35:18

Input

Data

Missing Value Handling

Syntax

Resources

/Users/megan/Downloads/3 76TurkPrime Social Media Data.sav Active Dataset DataSet1 Filter <none> Weight <none> Split File <none> N of Rows in Working Data 166 File Definition of Missing User-defined missing values are treated as missing. Cases Used Statistics are based on cases with no missing values for any variable used. REGRESSION /DESCRIPTIVES MEAN STDDEV CORR SIG N /MISSING LISTWISE /STATISTICS COEFF OUTS CI(95) R ANOVA ZPP /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT PL /METHOD=ENTER Q4_5 /CASEWISE PLOT(ZRESID) OUTLIERS(3). Processor Time 00:00:00.03 Elapsed Time 00:00:00.00 Memory Required 3088 bytes Additional Memory 0 bytes Required for Residual Plots

Descriptive Statistics What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

Mean Std. Deviation 4.78 3.124

N 166

I would NOT attend Coachella if it is live streamed

4.80

1.986

166

Correlations

Pearson Correlation

Sig. (1-tailed)

N

What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend Coachella if it is live streamed What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend Coachella if it is live streamed What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend Coachella if it is live streamed

What is the Probability you will buy a ticket I would NOT to Cochella in attend 2019 ? PL 0 to Coachella if it is 10 live streamed 1.000 -.965

Variables Entered/Removeda Model 1

Variables Entered I would NOT attend Coachella if it is live streamedb

Variables Removed

Method . Enter

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 b. All requested variables entered.

-.965

1.000

.

.000

.000

.

166

166

166

166

Model Summaryb Model 1

R .965a

R Square .932

Adjusted R Std. Error of the Square Estimate .931 .818

a. Predictors: (Constant), I would NOT attend Coachella if it is live streamed b. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

ANOVAa Model 1

Regression Residual Total

Sum of Squares 1500.504 109.689 1610.193

df 1 164 165

Mean Square 1500.504 .669

F 2243.457

Sig. .000b

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 b. Predictors: (Constant), I would NOT attend Coachella if it is live streamed

Coefficientsa Unstandardized Coefficients Model 1 (Constant) I would NOT attend Coachella if it is live streamed

B 12.063 -1.518

Standardize d Coefficients

Std. Error .166 .032

Beta -.965

t 72.543 -47.365

95.0% Confidence Interval for B Lower Sig. Bound .000 11.735 .000 -1.581

Coefficientsa Model 1

95.0% Confidence Interval for B Upper Bound (Constant) 12.391 I would NOT attend Coachella if -1.455 it is live streamed

Zero-order

Correlations Partial

-.965

-.965

Part -.965

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

Residuals Statisticsa Predicted Value Residual Std. Predicted Value Std. Residual

Minimum 1.44 -1.508 -1.110 -1.845

Maximum 10.54 1.564 1.911 1.913

Mean Std. Deviation 4.78 3.016 .000 .815 .000 1.000 .000 .997

N 166 166 166 166

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

REGRESSION /DESCRIPTIVES MEAN STDDEV CORR SIG N /MISSING LISTWISE /STATISTICS COEFF OUTS CI(95) R ANOVA ZPP /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT PL /METHOD=ENTER Q4_5 Q4_4 AGE NUM_CHILD /CASEWISE PLOT(ZRESID) OUTLIERS(3).

Regression

Notes Output Created Comments Input

20-FEB-2019 20:38:40 Data

/Users/megan/Downloads/3 76TurkPrime Social Media Data.sav Active Dataset DataSet1 Filter <none> Weight <none> Split File <none> N of Rows in Working Data 166 File

Missing Value Handling

Definition of Missing

Cases Used

Syntax

Resources

Processor Time Elapsed Time Memory Required Additional Memory Required for Residual Plots

User-defined missing values are treated as missing. Statistics are based on cases with no missing values for any variable used. REGRESSION /DESCRIPTIVES MEAN STDDEV CORR SIG N /MISSING LISTWISE /STATISTICS COEFF OUTS CI(95) R ANOVA ZPP /CRITERIA=PIN(.05) POUT(.10) /NOORIGIN /DEPENDENT PL /METHOD=ENTER Q4_5 Q4_4 AGE NUM_CHILD /CASEWISE PLOT(ZRESID) OUTLIERS(3). 00:00:00.02 00:00:00.00 4672 bytes 0 bytes

Descriptive Statistics What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE Num_Child

Mean 4.78

Std. Deviation 3.124

N

4.80

1.986

166

4.37

2.555

166

39.6747 .73

13.44493 1.068

166 166

166

Correlations

Pearson Correlation

Sig. (1-tailed)

N

Indicate how Important to What is the your Probability decision to you will buy I would NOT attend is a ticket to attend Beyonce Cochella in Coachella if performing 2019 ? PL 0 it is live at Coachella to 10 streamed in 2019? What is the Probability 1.000 you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend -.965 1.000 Coachella if it is live streamed Indicate how .932 -.912 1.000 Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE -.224 .204 -.179 Num_Child .122 -.109 .116 What is the Probability . .000 .000 you will buy a ticket to Cochella in 2019 ? PL 0 to 10 I would NOT attend .000 . .000 Coachella if it is live streamed Indicate how .000 .000 . Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE .002 .004 .010 Num_Child .058 .082 .068 What is the Probability 166 166 166 you will buy a ticket to Cochella in 2019 ? PL 0 to 10

AGE

Num_Chil d

1.000 -.136 .002

1.000 .058

.004

.082

.010

.068

. .040 166

.040 . 166

I would NOT attend Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE Num_Child

166

166

166

166

166

166

166

166

166

166

166 166

166 166

166 166

166 166

166 166

Variables Entered/Removeda Model 1

Variables Entered Num_Child, I would NOT attend Coachella if it is live streamed, AGE, Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019?b

Variables Removed

Method . Enter

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 b. All requested variables entered.

Model Summaryb Model 1

R .974a

R Square .949

Adjusted R Std. Error of the Square Estimate .948 .715

a. Predictors: (Constant), Num_Child, I would NOT attend Coachella if it is live streamed, AGE, Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? b. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

ANOVAa Model 1

Regression Residual Total

Sum of Squares 1527.925 82.268 1610.193

df 4 161 165

Mean Square 381.981 .511

F 747.546

Sig. .000b

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10 b. Predictors: (Constant), Num_Child, I would NOT attend Coachella if it is live streamed, AGE, Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019?

Coefficientsa Standardize d Coefficients

Unstandardized Coefficients Model 1 (Constant) I would NOT attend Coachella if it is live streamed Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE Num_Child

B 8.484 -1.065

Std. Error .566 .069

.378

-.007 .027

Beta

95.0% Confidence Interval for B Lower Sig. Bound .000 7.365 .000 -1.200

-.677

t 14.976 -15.537

.053

.309

7.117

.000

.273

.004 .053

-.029 .009

-1.581 .504

.116 .615

-.015 -.078

Coefficientsa Model 1

95.0% Confidence Interval for B Upper Bound (Constant) 9.602 I would NOT attend Coachella if -.929 it is live streamed

Zero-order

Correlations Partial

-.965

-.775

Part -.277

Indicate how Important to your decision to attend is Beyonce performing at Coachella in 2019? AGE Num_Child

.482

.932

.489

.127

.002 .131

-.224 .122

-.124 .040

-.028 .009

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10

Residuals Statisticsa Predicted Value Residual Std. Predicted Value Std. Residual

Minimum .99 -1.779 -1.246 -2.488

Maximum 9.95 1.637 1.697 2.290

Mean Std. Deviation 4.78 3.043 .000 .706 .000 1.000 .000 .988

N 166 166 166 166

a. Dependent Variable: What is the Probability you will buy a ticket to Cochella in 2019 ? PL 0 to 10