Answered step by step
Verified Expert Solution
Question
1 Approved Answer
$ 40,000.00 $ 35,000.00 $ 65,750.00 $ 25,000.00 43,678 $ 16,780.00 $ 80,000.00 $ 75,500.00 $ 99,199.00 $ 40,000.00 $ 60,450.00 $ 54,600.00 $ 10,760.00
$ 40,000.00 |
$ 35,000.00 |
$ 65,750.00 |
$ 25,000.00 |
43,678 |
$ 16,780.00 |
$ 80,000.00 |
$ 75,500.00 |
$ 99,199.00 |
$ 40,000.00 |
$ 60,450.00 |
$ 54,600.00 |
$ 10,760.00 |
$ 17,000.00 |
$ 99,998.00 |
Calculate the values below by hand. | |||||||||
Show your work below: | Answer: | ||||||||
Mean for your data | |||||||||
Median for your data | |||||||||
Mode for your data | |||||||||
Range for your data | |||||||||
Verify the statistics you computed above using Microsoft Excel formulas below. | |||||||||
Click on the video link for additional help: https://youtu.be/Da_RzJvdTmc | |||||||||
Mean for your data | |||||||||
Median for your data | |||||||||
Mode for your data | |||||||||
Range for your data | |||||||||
Now suppose you inherit a $1,000,000 home from a long lost relative. Using this additional home, recalculate the mean, median, mode and range using Microsoft Excel formulas below. | |||||||||
Mean for your data | |||||||||
Median for your data | |||||||||
Mode for your data | |||||||||
Range for your data | |||||||||
Review the sixteen home prices and determine if there are any unusual data values (like outliers). If there are, explain how they impact the mean, median, mode and range you calculated. | |||||||||
explain which statistic (mean, median, or mode) do you think is the best measure of center for the price of a house? Justify your answer. | |||||||||
describe the value of understanding mean, median and mode when making other large purchases such as land, cars, etc. Explain how this information will make you a better negotiator. | |||||||||
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