Homework # 1
1. Chapter 1 - Discussion Question 10 (p.24)
2. Chapter 2 - Discussion Question: 6 (p.49); Problems 7 & 8 (p.50)
3. Chapter 4 (Reference Textbook) Problems (pp. 166-167):
4-24. Find the mean, median, and midrange for the data in the Excel file Automobile Quality using the appropriate Excel functions or formulas.
4-27. Consider the data in the Excel file Home Market Value as a population of homeowners on this street, computer the mean, variance, and standard deviation for each of the variables using a spreadsheet and formulas (4.4), (4.7), and (4.9). Verify your calculations using the appropriate Excel function.
4-28. Consider the data in the Excel file Home Market Value
as a sample of homeowners on this street, compute the mean, variance,
and standard deviation for each of the variables using formulas (4.5),
(4.8), and (4.10). Verify calculations using the appropriate Excel
function.
4-34. Compute the coefficient of variation for each variable in the Excel file Home Market Value. Which has the least and greatest relative dispersion?
Please Note:
a) Please use WORD for discussion questions, which should be submitted via your Blackboard account.
b) For all problems, please submit the EXCEL file via your Blackboard
account in order to enhance your EXCEL skills.
c) Please make sure you attached all the files before click the submit button.