Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Use a PivotTable to construct a frequency distribution and histogram of wedding costs. b Describe any ratio variable from your dataset using mean, median,

a. Use a PivotTable to construct a frequency distribution and histogram of wedding costs. b Describe any ratio variable from your dataset using mean, median, mode, range, variance, standard deviation, and other summary statistics using the Descriptive Statistics tool c Find proportions for various attributes of at least one categorical variable in the dataset. For example, analyze the average wedding cost by type of payor and value rating d Use a PivotTable for any variables to show cross-tabulation. e. Find an explain a correlation between any two variables. f Use Z-scores or IQR to examine the data for potential mild outliers. g What would you tell a newly engaged couple about what range of costs to expect? Weddings Couple's Income Bride's age Payor Wedding cost Attendance Value Rating $130,000 22 Bride's Parents $60,700.00 300 3 $157,000 23 Bride's Parents $52,000.00 350 1 $98,000 27 Bride & Groom $47,000.00 150 3 $72,000 29 Bride & Groom $42,000.00 200 5 $86,000 25 Bride's Parents $34,000.00 250 3 $90,000 28 Bride & Groom $30,500.00 150 3 $43,000 19 Bride & Groom $30,000.00 250 3 $100,000 30 Bride & Groom $30,000.00 300 3 $65,000 24 Bride's Parents $28,000.00 250 3 $78,000 35 Bride & Groom $26,000.00 200 5 $73,000 25 Bride's Parents $25,000.00 150 5 $75,000 27 Bride & Groom $24,000.00 200 5 $64,000 25 Bride's Parents $24,000.00 200 1 $67,000 27 Groom's Parents $22,000.00 200 5 $75,000 25 Bride's Parents $20,000.00 200

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

A Survey Of Mathematics With Applications

Authors: Allen R. Angel, Christine D. Abbott, Dennis Runde

11th Edition

0135740460, 978-0135740460

More Books

Students also viewed these Mathematics questions

Question

What are some of the limitations of regression analysis?

Answered: 1 week ago