A recent study found that American consumers are making average monthly debt payments of around $1,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A recent study found that American consumers are making average monthly debt payments of around $1,000 (Source: Experian.com, November 11, 2010). However, the study of 26 metropolitan areas reveals quite a bit of variation in debt payments, depending on where the consumer lives. For instance, in Washington DC, residents pay the most ($1,285 per month), while Pittsburgh residents pay the least ($763 per month). Madelyn Davis, an economist in a large bank, believes that income differences between cities are the primary reason for the disparate debt payments. For example, Washington DC's high incomes have likely contributed to it placement on the list. She is also unsure about the likely effect of unemployment rate on consumer debt payments. In order to analyze the relationship between income, unemployment rate, and consumer debt payments, Madelyn collected data from the same 26 metropolitan cities used in the earlier debt payment study. Specifically, she gathered each area's 2010 - 2011 median household income (recorded in thousands of dollars) as well as the monthly unemployment rate and average consumer debt for August 2010. The Excel file Debt_Payments.xlsx has the data. A1 A x v fx Metropolitan area Debt Income Unemployment 6.3 1 Metropolitan area 2 Washington, D.C. 3 Seattle 103.5 1,285 81.7 8.5 1,135 82.2 8.1 1,133 4 Baltimore 5 Boston 1,133 1,104 1,098 89.5 7.6 75.9 8.1 6 Denver 7 San Francisco 93.4 9.3 75.5 10.6 1,076 8 San Diego 9 Sacramento 73.1 12.4 1,045 68.2 12.9 1,024 10 Los Angeles 11 Chicago 12 Philadelphia 13 Minneapolis 14 New York 1,017 1,011 75.1 9.7 78.3 9.2 84 7 1,011 78.3 9.3 989 15 Atlanta 71.8 10.3 986 16 Dallas 68.3 8.4 970 66.6 9.1 957 17 Phoenix 18 Portland 71.2 10.2 948 19 Cincinnati 69.5 9.3 920 20 Houston 65.1 8.7 889 21 Columbus 22 St. Louis 23 Miami 68.6 8.3 888 68.3 9.9 886 60.2 14.5 867 24 Detroit 69.8 15.7 832 25 Cleveland 26 Tampa 27 Pittsburgh 64.8 9.6 812 59.4 12.6 791 63 8.3 763 28 29 Apply the statistical methods to answer both research questions a. Follow all steps required to conduct a complete analysis and validation of methods, including assumption checks Presentation of the results and their interpretations a. If using multiple models, perform a comparison to select the best one. Justify your choice. Final conclusions, decision-making and recommendations based on the results to the economist A recent study found that American consumers are making average monthly debt payments of around $1,000 (Source: Experian.com, November 11, 2010). However, the study of 26 metropolitan areas reveals quite a bit of variation in debt payments, depending on where the consumer lives. For instance, in Washington DC, residents pay the most ($1,285 per month), while Pittsburgh residents pay the least ($763 per month). Madelyn Davis, an economist in a large bank, believes that income differences between cities are the primary reason for the disparate debt payments. For example, Washington DC's high incomes have likely contributed to it placement on the list. She is also unsure about the likely effect of unemployment rate on consumer debt payments. In order to analyze the relationship between income, unemployment rate, and consumer debt payments, Madelyn collected data from the same 26 metropolitan cities used in the earlier debt payment study. Specifically, she gathered each area's 2010 - 2011 median household income (recorded in thousands of dollars) as well as the monthly unemployment rate and average consumer debt for August 2010. The Excel file Debt_Payments.xlsx has the data. A1 A x v fx Metropolitan area Debt Income Unemployment 6.3 1 Metropolitan area 2 Washington, D.C. 3 Seattle 103.5 1,285 81.7 8.5 1,135 82.2 8.1 1,133 4 Baltimore 5 Boston 1,133 1,104 1,098 89.5 7.6 75.9 8.1 6 Denver 7 San Francisco 93.4 9.3 75.5 10.6 1,076 8 San Diego 9 Sacramento 73.1 12.4 1,045 68.2 12.9 1,024 10 Los Angeles 11 Chicago 12 Philadelphia 13 Minneapolis 14 New York 1,017 1,011 75.1 9.7 78.3 9.2 84 7 1,011 78.3 9.3 989 15 Atlanta 71.8 10.3 986 16 Dallas 68.3 8.4 970 66.6 9.1 957 17 Phoenix 18 Portland 71.2 10.2 948 19 Cincinnati 69.5 9.3 920 20 Houston 65.1 8.7 889 21 Columbus 22 St. Louis 23 Miami 68.6 8.3 888 68.3 9.9 886 60.2 14.5 867 24 Detroit 69.8 15.7 832 25 Cleveland 26 Tampa 27 Pittsburgh 64.8 9.6 812 59.4 12.6 791 63 8.3 763 28 29 Apply the statistical methods to answer both research questions a. Follow all steps required to conduct a complete analysis and validation of methods, including assumption checks Presentation of the results and their interpretations a. If using multiple models, perform a comparison to select the best one. Justify your choice. Final conclusions, decision-making and recommendations based on the results to the economist
Expert Answer:
Answer rating: 100% (QA)
Solution a Describe the problem background and purpose of the study understand the relationships bet... View the full answer
Related Book For
Essentials of Business Statistics Communicating With Numbers
ISBN: 978-0078020544
1st edition
Authors: Sanjiv Jaggia, Alison Kelly
Posted Date:
Students also viewed these accounting questions
-
A recent study found that 19% of people (ages 16 and older) in the United States own an e-reader. You randomly select four people (ages 16 and older) and ask them whether they own an e-reader....
-
A recent study found that the price elasticity of demand for medical care is 2.3 [Kowalski, 2009]. If this estimate is correct, what does the existence of a coinsurance rate of 20 percent do for an...
-
A recent study found that the demand and supply schedules for Frisbees are as follows a. What are the equilibrium price and quantity of Frisbees? b. Frisbee manufacturers persuade the government that...
-
11) Wayland Manufacturing uses a normal cost system and had the following data available for 2010: Direct materials purchased on account Direct materials requisitioned 82,000 Direct labor cost...
-
In the Excel file Restaurant Sales, determine if the variance of weekday sales is the same as that of weekend sales for each of the three variables (lunch, dinner, and delivery).
-
A Caesar Cipher is a simple way of encrypting a message by replacing each letter with a letter a certain number of spaces up the alphabet. For example, if shifting the message by 13 an A would become...
-
Zeds Manufacturing incurred the following costs in acquiring land, making land improvements, and constructing and furnishing a new building. Zeds Manufacturing depreciates buildings over 50 years,...
-
The entity theory of equity implies that there should be no need for financial statements to distinguish between debt and equity. Alternatively, proprietary theory implies that such a distinction is...
-
Revenue and expense data for Tribal Technologies Co. are as follows: 2018 2017 Sales $429,000 $365,000 Cost of goods sold 253,110 197,100 Selling expenses 68,640 65,700 Administrative expenses 77,220...
-
Analyze, Forecast, and Interpret Income Statement and Balance Sheet Following are the income statement and balance sheet of ADP Inc. Note: Complete the entire question using the following Excel...
-
How do Freudian and Jungian approaches to symbolism illuminate the psychoanalytic dimensions of literary texts, uncovering unconscious desires, fears, and complexes encoded within symbolic imagery...
-
Why a system of pulleys is used for lifting load ?
-
Describe the trends in wages and employment implied by the cobweb model for the engineering market. What would happen to the cobwebs if a consulting firm sold information on the history of wages and...
-
What is the velocity ratio of the first system of pulleys ?
-
What is the velocity ratio of the second system of pulleys ?
-
Show how the minimum wage creates unemployment in a competitive market.
-
Bill ordered an airplane from Fullerton Aircraft for his own personal use. Bill took delivery of the aircraft and flew it for several months before determining that it caused him joint pain due to...
-
Use the T account for Cash below to record the portion of each of the following transactions, if any that affect cash. How do these transactions affect the companys liquidity? Jan. 2 Provided...
-
A worker at a landscape design center uses a machine to ill bags with potting soil. Assume that the quantity put in each bag follows the continuous uniform distribution with low and high filling...
-
The manager of a diner wants to reevaluate his staffing needs depending on variations in customer traffic during the day. He collects data on the number of customers served along with four dummy...
-
Newscasters wish to estimate the proportion of registered voters who support the incumbent candidate in the mayoralelection. In an earlier poll of 240 registered voters,110 had supported the...
-
On July 31, 2020, Magnus's Muffins paid \(\$ 18,000\) for business insurance for the next year. Record the entries for the purchase of the insurance by recording it as an expense and then making a...
-
On November 1, 2020, Freya Albatter's orthodontic office received a \(\$ 2,500\) prepayment from a client for dental work to be performed on November 22. The appointment got postponed until January...
-
On April 1, 2020, you prepaid three months of rent for a total of \(\$ 18,000\). Give your adjusting entry to record rent expense at April 30, 2020. Include the date of the entry and an explanation....
Study smarter with the SolutionInn App