9.
Using the Excel file Weddings, apply the Excel Regression tool using the wedding
cost as the dependent variable and attendance as the independent variable.
a. Interpret all key regression results, hypothesis tests, and confidence intervals in
the output.
1. Descriptive Statistics
Descriptive Statistics
Std.
Mean Deviation N
Wedding $25,848.000 $13,239.402 25
cost 0 05
Attendance 184.00 74.610 25
2. Correlations
Correlations
Wedding Attendan
cost ce
Pearson Wedding 1.000 .733
Correlation cost
Attendance .733 1.000
Sig. (1-tailed) Wedding . .000
cost
Attendance .000 .
N Wedding 25 25
cost
Attendance 25 25
3. R Square
Model Summary
Std. Error
R Adjusted R of the
Model R Square Square Estimate
1 .733a .538 .518 $9,195.2455
5
a. Predictors: (Constant), Attendance
R2 (Adjusted R2) = 0.518
Moderate fit
51.8% of the variation in Wedding cost is explained by Attendance
4. ANOVA
Wedding cost = Beta0 + Beta1*Attendance
H0: Beta1 = 0 ( No regression line)
H1: At least 1 coefficient is different from 0 Regression line
ANOVAa
Sum of
Model Squares df Mean Square F Sig.
1 Regression 2262053964.37 1 2262053964.37 26.75 .000b
1 1 3
Residual 1944708435.62 23 84552540.680
9
Total 4206762400.00 24
0
a. Dependent Variable: Wedding cost
b. Predictors: (Constant), Attendance
F = 26.753, p<0.05 Accept H1
There is a regression line.
5. Coefficient
Coefficientsa
Standardiz
Unstandardized ed
Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 1905.689 4980.846 .383 .706
Attendanc 130.121 25.157 .733 5.172 .000
e
a. Dependent Variable: Wedding cost
*Constant: t=0.383, p>0.05 Beta0 = 0
*Attendance: t=5.172, p<0.001
Coefficient is significant.
Assessment of the Coefficient
- Using unstandardized Coefficient
WC = 130.121*A
If A = 100 WC = 13012.1$
- Using the standardized Coefficient
WC = 0.733*A
Relationship
Attendance has positive impactor on Wedding cost
d. If a couple is planning a wedding for 175 guests, how much should they budget?
WC = 130.121*A WC = 130.121*175 = ~22,771$
Their budget should be around 22,771$
10. Using the Excel file Weddings, apply the Excel Regression tool using the
wedding cost as the dependent variable and the couple’s income as the
independent variable, only for those weddings paid for by the bride and
groom.
a. Interpret all key regression results, hypothesis tests, and confidence intervals in
the output.
1. Descriptive Statistics
Descriptive Statisticsa,b
Std.
Mean Deviation N
Wedding cost $27,611.111 $12,820.339 9
1 74
Couple's 72666.67 21667.949 9
Income
a. Payor = Bride & Groom
b. Selecting only cases for which Payor = Bride &
Groom
2. Correlations
Correlationsa,b
Wedding Couple's
cost Income
Pearson Wedding cost 1.000 .631
Correlation
Couple's .631 1.000
Income
Sig. (1-tailed) Wedding cost . .034
Couple's .034 .
Income
N Wedding cost 9 9
Couple's 9 9
Income
a. Payor = Bride & Groom
b. Selecting only cases for which Payor = Bride & Groom
3. R Square
Model Summarya
R
Payor =
Bride & Std. Error
Groom R Adjusted R of the
Model (Selected) Square Square Estimate
1 .631b .398 .312 $10,632.270
72
a. Payor = Bride & Groom
b. Predictors: (Constant), Couple's Income
R2 (Adjusted R2) = 0.312
Weak fit
31.2% of the variation in Wedding cost is explained by the Couple’s income
4. ANOVA
Wedding cost = Beta0 + Beta1*CI
H0: Beta1 = 0 ( No regression line)
H1: At least 1 coefficient is different from 0 Regression line
ANOVAa,b,c
Mean
Model Sum of Squares df Square F Sig.
1 Regression 523572624.541 1 523572624. 4.632 .068d
541
Residual 791316264.347 7 113045180.
621
Total 1314888888.889 8
a. Payor = Bride & Groom
b. Dependent Variable: Wedding cost
c. Selecting only cases for which Payor = Bride & Groom
d. Predictors: (Constant), Couple's Income
F = 4.632, p>0.05 Accept H0
There is no regression line.
5. Coefficient
Coefficientsa,b,c
Standardiz
Unstandardized ed
Coefficients Coefficients
Model B Std. Error Beta t Sig.
1 (Constant) 480.417 13095.316 .037 .972
Couple's .373 .173 .631 2.152 .068
Income
a. Payor = Bride & Groom
b. Dependent Variable: Wedding cost
c. Selecting only cases for which Payor = Bride & Groom
*Constant: t=0.037, p>0.05 Beta0 = 0
*Couple’s Income: t=2.152, p>0.05
Coefficient is not significant.
Couple’s Income has no impactor on Wedding cost
d. If a couple makes $70,000 together, how much would they probably budget for
the wedding?
Can’t calculate because Couple’s Income has no impactor on Wedding cost.
