Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the Excel file weddings, use the excel regression tool using the wedding cost as the dependent variable and the couples income as the independent

Using the Excel file weddings, use the excel regression tool using the wedding cost as the dependent variable and the couples income as the independent variable, only for those weddings paid for by the bride and groom.
a. interpret all key regression results.
b. if a couple makes $70,000 together, how much would they probably budget for the wedding?
image text in transcribed
B 29 5 3 5 A C D E F 1 Weddings 2 3 Couple's Income Bride's age Payor Wedding cost Attendance Value Rati 4 $130,000 22 Bride's Parents $60,700.00 300 3 5 $157,000 23 Bride's Parents $52,000.00 350 1 6 $98,000 27 Bride & Groom $47,000.00 150 3 7 $72,000 Bride & Groom $42,000.00 200 5 8 $86,000 25 Bride's Parents $34,000.00 250 3 9 $90,000 28 Bride & Groom $30,500.00 150 3 10 $43,000 19 Bride & Groom $30,000.00 250 3 11 $100,000 30 Bride & Groom $30,000.00 300 3 12 $65,000 24 Bride's Parents $28,000.00 250 3 13 $78,000 35 Bride & Groom $26,000.00 200 5 14 $73,000 25 Bride's Parents $25,000.00 150 5 15 $75,000 27 Bride & Groom $24,000.00 200 5 16 $64,000 25 Bride's Parents $24,000.00 200 1 17 $67,000 27 Groom's Parents $22,000.00 200 5 18 $75,000 25 Bride's Parents $20,000.00 200 5 19 $67,000 30 Bride's Parents $20,000.00 200 5 20 $62,000 21 Groom's Parents $20,000.00 100 1 21 $75,000 19 Bride's Parents $19,000.00 150 3 22 $52,000 23 Bride's Parents $19,000.00 200 1 23 $64,000 22 Bride's Parents $18,000.00 150 1 24 $55,000 28 Bride's Parents $16,000.00 100 25 $53,000 31 Bride & Groom $14,000.00 100 1 26 $62,000 24 Bride's Parents $13,000.00 150 1 27 $40,000 26 Bride's Parents $7,000.00 50 3 28 $45,000 32 Bride & Groom $5,000.00 50 5 29 5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Fraud Investigation A Step By Step Guide

Authors: Tracy Coenen

1st Edition

0470387963, 978-0470387962

More Books

Students also viewed these Accounting questions

Question

5. Identify and describe nine social and cultural identities.

Answered: 1 week ago

Question

2. Define identity.

Answered: 1 week ago

Question

4. Describe phases of majority identity development.

Answered: 1 week ago