Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started