The file Home Price Index.xlsx contains an index of home prices and a seasonally adjusted (SA) version of this index for several large U.S. cities. It also contains a condo price index for several large cities and a national index. Use the tools in this chapter to make sense out of these data, and write a report of your findings. Some important questions you can answer are the following: Are there trends over time? Are there differences across cities? Are there differences across months? Do condo prices mirror home prices? Why are seasonally adjusted indexes published?
Answer to relevant QuestionsThe file S02_01.xlsx indicates the gender and nationality of the MBA incoming class in two successive years at the Kelley School of Business at Indiana University.a. For each year separately, recode Nationality so that all ...In the smoking/drinking example in this section, we used the function COUNTIFS function (new to Excel 2007) to find the counts of the joint categories. Without using this function (or pivot tables), devise another way to get ...The file S03_22.xlsx lists financial data on movies released since 1980 with budgets at least $20 million.a. Reduce the size of this data set by deleting all movies with a budget of more than $100 million. Also, delete all ...The file S03_30.xlsx contains monthly data on exchange rates of various currencies versus the U.S. dollar. It is of interest to financial analysts and economists to see whether exchange rates move together through time. You ...Solve problem 9 with pivot tables and create corresponding pivot charts. However, find only means and standard deviations, not medians.
Post your question