Question: Using the Weddings data given in the data file and the Correlation function from the Data Analysis tool pack, find the correlation between Wedding Cost
Using the Weddings data given in the data file and the Correlation function from the Data Analysis tool pack, find the correlation between Wedding Cost and Attendance. Copy paste the correlation generated and format it to 4 decimals. Any correlation greater than 70% is considered as high correlation for this data. Write a comment if these two variables have high correlation or not? Do they move in the same direction or opposite direction?

A C D F Couple's Income 2 $130,000 3 $157,000 Bride's age Wedding cost Value Rating Payor Attendance 1 $60,700.00 $52,000.00 22 Bride's Parents 300 3 23 Bride's Parents 350 $98,000 27 Bride & Groom 150 $47,000.00 3 4 $72,000 Bride & Groom 29 $42,000.00 200 $86,000 25 Bride's Parents $34,000.00 250 3 $90,000 Bride & Groom 28 $30,500.00 150 3 $43,000 Bride & Groom 19 $30,000.00 250 3 $100,000 Bride & Groom 300 30 $30,000.00 10 $65,000 11 $78,000 12 $73,000 13 $75,000 24 Bride's Parents $28,000.00 250 3 Bride & Groom 35 $26,000.00 200 5 25 Bride's Parents $25,000.00 150 5 Bride & Groom 27 $24,000.00 200 5 14 $64,000 25 Bride's Parents $24,000.00 200 1 15 $67,000 Groom's Parents 27 $22,000,00 200 5 Bride's Parents 16 $75,000 25 $20,000.00 200 17 $67,000 30 Bride's Parents $20,000.00 200 5 18 $62,000 19 $75,000 20 $52,000 21 $64,000 Groom's Parents 21 $20,000.00 100 19 Bride's Parents $19,000.00 150 23 Bride's Parents $19,000.00 200 22 Bride's Parents $18,000.00 150 22 $55,000 23 $53,000 28 Bride's Parents $16,000.00 100 5 Bride & Groom 31 $14,000.00 100 1 24 $62,000 24 Bride's Parents $13,000.00 150 1 25 $40,000 26 Bride's Parents $7,000.00 50 3 Bride & Groom 26 $45,000 32 $5,000.00 50 A C D F Couple's Income 2 $130,000 3 $157,000 Bride's age Wedding cost Value Rating Payor Attendance 1 $60,700.00 $52,000.00 22 Bride's Parents 300 3 23 Bride's Parents 350 $98,000 27 Bride & Groom 150 $47,000.00 3 4 $72,000 Bride & Groom 29 $42,000.00 200 $86,000 25 Bride's Parents $34,000.00 250 3 $90,000 Bride & Groom 28 $30,500.00 150 3 $43,000 Bride & Groom 19 $30,000.00 250 3 $100,000 Bride & Groom 300 30 $30,000.00 10 $65,000 11 $78,000 12 $73,000 13 $75,000 24 Bride's Parents $28,000.00 250 3 Bride & Groom 35 $26,000.00 200 5 25 Bride's Parents $25,000.00 150 5 Bride & Groom 27 $24,000.00 200 5 14 $64,000 25 Bride's Parents $24,000.00 200 1 15 $67,000 Groom's Parents 27 $22,000,00 200 5 Bride's Parents 16 $75,000 25 $20,000.00 200 17 $67,000 30 Bride's Parents $20,000.00 200 5 18 $62,000 19 $75,000 20 $52,000 21 $64,000 Groom's Parents 21 $20,000.00 100 19 Bride's Parents $19,000.00 150 23 Bride's Parents $19,000.00 200 22 Bride's Parents $18,000.00 150 22 $55,000 23 $53,000 28 Bride's Parents $16,000.00 100 5 Bride & Groom 31 $14,000.00 100 1 24 $62,000 24 Bride's Parents $13,000.00 150 1 25 $40,000 26 Bride's Parents $7,000.00 50 3 Bride & Groom 26 $45,000 32 $5,000.00 50
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
