Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
image text in transcribed
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

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

Elementary Linear Algebra

Authors: Ron Larson

8th Edition

1305877020, 9781305877023

More Books

Students also viewed these Mathematics questions

Question

The quality of the proposed ideas

Answered: 1 week ago

Question

The number of new ideas that emerge

Answered: 1 week ago