Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Apply the following approaches to analyze the Weddings survey data. For each step write down your conclusion in 1-2 sentences. a. Use a PivotTable to
Apply the following approaches to analyze the Weddings survey data. For each step write down your conclusion in 1-2 sentences. 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
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