The file S02_35.xlsx contains (fictional) data from a survey of 500 randomly selected households. a. Indicate the

Question:

The file S02_35.xlsx contains (fictional) data from a survey of 500 randomly selected households.
a. Indicate the type of data for each of the variables included in the survey.
b. For each of the categorical variables in the survey, indicate whether the variable is nominal or ordinal. Explain your reasoning in each case.
c. Create a histogram for each of the numerical variables in this data set. Indicate whether each of these distributions is approximately symmetric or skewed. Which, if any, of these distributions are skewed to the right? Which, if any, are skewed to the left?
d. Find the maximum and minimum debt levels for the households in this sample.
e. Find the indebtedness levels at each of the 25th, 50th, and 75th percentiles.
f. Find and interpret the inter-quartile range for the indebtedness levels of these selected households.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 43% (16 reviews)

Answered By

Asim farooq

I have done MS finance and expertise in the field of Accounting, finance, cost accounting, security analysis and portfolio management and management, MS office is at my fingertips, I want my client to take advantage of my practical knowledge. I have been mentoring my client on a freelancer website from last two years, Currently I am working in Telecom company as a financial analyst and before that working as an accountant with Pepsi for one year. I also join a nonprofit organization as a finance assistant to my job duties are making payment to client after tax calculation, I have started my professional career from teaching I was teaching to a master's level student for two years in the evening. My Expert Service Financial accounting, Financial management, Cost accounting, Human resource management, Business communication and report writing. Financial accounting : • Journal entries • Financial statements including balance sheet, Profit & Loss account, Cash flow statement • Adjustment entries • Ratio analysis • Accounting concepts • Single entry accounting • Double entry accounting • Bills of exchange • Bank reconciliation statements Cost accounting : • Budgeting • Job order costing • Process costing • Cost of goods sold Financial management : • Capital budgeting • Net Present Value (NPV) • Internal Rate of Return (IRR) • Payback period • Discounted cash flows • Financial analysis • Capital assets pricing model • Simple interest, Compound interest & annuities

4.40+ 65+ Reviews 86+ Question Solved

Related Book For book-img-for-question