Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In the Excel file Weddings, determine the correlation between the wedding costs and attendance. begin{tabular}{|c|c|c|c|c|c|c|} hline & A & B & c & D &

In the Excel file Weddings, determine the correlation between the wedding costs and attendance.image text in transcribed

\begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & c & D & E & F \\ \hline 1 & Weddings & & & & & \\ \hline 2 & & & & & & \\ \hline 3 & Couple's Income & Bride's age & Payor & Wedding cost & Attendance & Value Rating \\ \hline 4 & $130,000 & 22 & Bride's Parents & $60,700.00 & 300 & 3 \\ \hline 5 & $157,000 & 23 & Bride's Parents & $52,000.00 & 350 & 1 \\ \hline 6 & $98,000 & 27 & Bride \& Groom & $47,000.00 & 150 & 3 \\ \hline 7 & $72,000 & 29 & Bride \& Groom & $42,000.00 & 200 & 5 \\ \hline 8 & $86,000 & 25 & Bride's Parents & $34,000.00 & 250 & 3 \\ \hline 9 & $90,000 & 28 & Bride \& Groom & $30,500.00 & 150 & 3 \\ \hline 10 & $43,000 & 19 & Bride \& Groom & $30,000.00 & 250 & 3 \\ \hline 11 & $100,000 & 30 & Bride \& Groom & $30,000.00 & 300 & 3 \\ \hline 12 & $65,000 & 24 & Bride's Parents & $28,000.00 & 250 & 3 \\ \hline 13 & $78,000 & 35 & Bride \& Groom & $26,000.00 & 200 & 5 \\ \hline 14 & $73,000 & 25 & Bride's Parents & $25,000.00 & 150 & 5 \\ \hline 15 & $75,000 & 27 & Bride \& Groom & $24,000.00 & 200 & 5 \\ \hline 16 & $64,000 & 25 & Bride's Parents & $24,000.00 & 200 & 1 \\ \hline 17 & $67,000 & 27 & Groom's Parents & $22,000.00 & 200 & 5 \\ \hline 18 & $75,000 & 25 & Bride's Parents & $20,000.00 & 200 & 5 \\ \hline 19 & $67,000 & 30 & Bride's Parents & $20,000.00 & 200 & 5 \\ \hline 20 & $62,000 & 21 & Groom's Parents & $20,000.00 & 100 & 1 \\ \hline 21 & $75,000 & 19 & Bride's Parents & $19,000.00 & 150 & 3 \\ \hline 22 & $52,000 & 23 & Bride's Parents & $19,000.00 & 200 & 1 \\ \hline 23 & $64,000 & 22 & Bride's Parents & $18,000.00 & 150 & 1 \\ \hline 24 & $55,000 & 28 & Bride's Parents & $16,000.00 & 100 & 5 \\ \hline 25 & $53,000 & 31 & Bride \& Groom & $14,000.00 & 100 & 1 \\ \hline 26 & $62,000 & 24 & Bride's Parents & $13,000.00 & 150 & 1 \\ \hline 27 & $40,000 & 26 & Bride's Parents & $7,000.00 & 50 & 3 \\ \hline 28 & $45,000 & 32 & Bride \& Groom & $5,000.00 & 50 & 5 \\ \hline \multicolumn{7}{|l|}{29} \\ \hline 30 & & & & Correlation: & & \\ \hline 31 & & & & & & \\ \hline \end{tabular}

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

Financial Management In The Sport Industry

Authors: Matthew T. Brown, Daniel A. Rascher, Mark S. Nagel, Chad D. McEvoy

3rd Edition

0367321211, 978-0367321215

More Books

Students also viewed these Finance questions