Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a) Use excel to produce a Descriptive Statistics table for your sample Sold Price data and paste into your MS Word assignment document. Please watch
a) Use excel to produce a Descriptive Statistics table for your sample "Sold Price" data and paste into your MS Word assignment document. Please watch the Descriptive statistics table video which clearly demonstrates how to do this task Descriptive Statistics Table - Sold Price Mean 695.0733 Standard Error 63.17099 Median 620 Mode 445 Standard Deviation 423.7639 Sample Variance 179575.8 Kurtosis 10.1749 Skewness 2.672295 Range 2518 Minimum 132 Maximum 2650 Sum 31278.3 Count 45 b) Determine the IFLL and IFUL by using the formulae. IFUL: = Q3 + 1.5xIQR = 858 + 1.5x426 = 858 +213 = 1071 IFLL: = Q1 -1.5xIQR = 432 -1.5x426 =432 - 213 - 213 c) On the basis of parts a & b above, which measure of central tendency would be considered most appropriate for your sample "Sold Price" data set. Provide reasoning. d) On the basis of parts a & b above, which measure of dispersion would be considered most appropriate for your sample "Sold Price" data set. Provide reasoning
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